saber-jl monthly total top swap pairs on flow network
    Updated 2022-11-19
    select
    distinct CONTRACT_NAME,
    date_trunc('month',block_timestamp) as date,
    count(distinct tx_id) as total_tx,
    count(distinct trader) as uniqe_trader,
    sum(TOKEN_IN_AMOUNT) as total_volume
    FROM flow.core.ez_dex_swaps ds JOIN flow.core.dim_contract_labels cl
    on ds.swap_contract = cl.event_contract
    group by 1,2
    Run a query to Download Data