BitDB Fountainhead
Switch to Bitsocket View Tabular Documentation
{ "v": 3, "q": {"aggregate": [{"$match": {"$and": [{"out.i": {"$gte":7,"$lte":9}},{"blk.t": {"$gte": 1568505600,"$lte": 1569214800}}]}}, {"$project": {"out.e.v": 1,"blk.t": 1}}, {"$limit": 5000}],"limit": 5000}, "r": { "f": "[ .[] |select((.out[4].e.v==.out[3].e.v) and (.out[3].e.v==.out[2].e.v) and (.out[2].e.v==.out[1].e.v) and (.out[1].e.v==.out[0].e.v) and (.in.i = 4))| {t : .blk.t, count: .out[0].e.v } ] | group_by(.t) | map({time: .[0].t, Count:length, Sum: map(.count*5/100000000) |add })" } }
API endpoint
Unconfirmed
Loading data…
Confirmed
Loading data…