flipside

    Mints Daily n Ethereum
    nitsMints Daily n Ethereum
    Updated 2022-06-16
    SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs ,sum(total_txs) over (order by day) as cumulative_total_txs
    from ethereum.nft_events
    where event_type = 'mint' and day >= CURRENT_DATE -120
    GROUP by 1
    limit 150
    Run a query to Download Data