flipside

    3
    ML63
    Updated 2022-10-31
    select 'NEAR',count(*),date_trunc('month', mdate) as mmonth from( select min(block_timestamp::date) as mdate , pool_id from near.core.ez_dex_swaps
    group by pool_id)
    group by mmonth

    UNION

    select 'ETHEREUM',count(*),date_trunc('month', mdate) as mmonth from( select min(block_timestamp::date) as mdate , pool_name from ethereum.core.ez_dex_swaps
    group by pool_name)
    group by mmonth
    Run a query to Download Data