pine_samiweekly swappers
    Updated 2023-06-07
    select 'swappers from TRIAS' as type, count(distinct ORIGIN_FROM_ADDRESS) as swapper,
    date_trunc('{{date_range}}', block_timestamp) as date
    from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'TRIAS'
    and EVENT_NAME='Swap'
    group by 3
    UNION ALL
    select 'swappers to TRIAS', count(distinct ORIGIN_FROM_ADDRESS),
    date_trunc('{{date_range}}', block_timestamp)
    from ethereum.core.ez_dex_swaps
    where SYMBOL_OUT = 'TRIAS'
    and EVENT_NAME='Swap'
    group by 3

    Run a query to Download Data