nitsDaily Amount Swapped
    Updated 2022-07-04
    SELECT date(block_timestamp) as day,sum(event_inputs:amount1)/pow(10,9) as vol, sum(vol) over (order by day) as cum_vol,
    count(DISTINCT tx_hash) as total_txs, sum(total_txs) over (order by day) as cum_txs,
    avg(event_inputs:liquidity)/pow(10,18) as avg_liquidity
    from ethereum.core.fact_event_logs
    WHERE contract_address = '0xb386c1d831eed803f5e8f274a59c91c4c22eeac0' and event_name = 'Swap' and origin_function_signature = '0xa94e78ef'
    GROUP by 1
    -- LIMIT 100
    Run a query to Download Data