Eman-RazTotal Number of Swaps & Traders Based on Token Pairs
    Updated 2024-07-12
    select split_part(token_in_contract,'.',3) || '➡' || split_part(token_out_contract,'.',3) as "Token Pair", count(distinct tx_id) as "Swap Count",
    count(distinct trader) as "Trader Count"
    from flow.defi.ez_swaps
    where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
    and (token_in_contract='A.1654653399040a61.FlowToken' or token_out_contract='A.1654653399040a61.FlowToken')
    group by 1
    order by 2 desc
    QueryRunArchived: QueryRun has been archived