nitsShroom Mints
Updated 2022-07-02
9
1
2
3
4
5
6
7
›
⌄
SELECT date(block_timestamp) as day,status, count(DISTINCT tx_hash) as total_txs,
sum(total_txs) over (partition by status order by day) as cumulative_txs,
sum(tx_fee) as total_fee_paid,
sum(total_fee_paid) over (partition by status order by day) as cumulative_fee_paid
from ethereum.core.fact_transactions
WHERE to_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146' and origin_function_signature= '0x2b1ccc9a'
GROUP by 1,2
Run a query to Download Data