nitsShroom Mints
    Updated 2022-07-02
    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