Mrfti2024-03-23 03:58 PM copy
    Updated 2025-01-03
    -- forked from 2024-03-23 03:58 PM @ https://flipsidecrypto.xyz/studio/queries/02b30087-a01a-4c97-893a-0d66d6028da9

    with tbl AS (
    select
    Block_timestamp as "Date",
    'Buy' as "Buy/Sell",
    TX_HASH as "Transaction hash",
    trader as "Trader address",
    PLATFORM as "Platform",
    AMOUNT_Out_USD as "Trade volume (USD)"
    from
    crosschain.defi.ez_dex_swaps
    where
    token_in = lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1')
    and blockchain = 'avalanche'
    UNION ALL
    select
    Block_timestamp as "Date",
    'Sell' as "Buy/Sell",
    TX_HASH as "Transaction hash",
    trader as "Trader address",
    PLATFORM as "Platform",
    AMOUNT_In_USD as "Trade volume (USD)"
    from
    crosschain.defi.ez_dex_swaps
    where
    token_out = lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1')
    and blockchain = 'avalanche')
    select
    sum ("Trade volume (USD)") as "Total trading volume (USD)",
    count (DISTINCT "Trader address") as "Total unique traders",
    count (DISTINCT "Transaction hash") as "Total trades"
    from tbl

    Last run: 3 months agoAuto-refreshes every 12 hours
    Total trading volume (USD)
    Total unique traders
    Total trades
    1
    231685272.7938763322086
    1
    29B
    28s