SalehTerra - 6. New Year, New LUNA?LUNA volume sold-destinations
    Updated 2023-01-10
    select
    LABEL as destination
    ,count(DISTINCT trader) as traders
    ,sum(FROM_AMOUNT/pow(10,from_decimal)) as volume
    ,avg(FROM_AMOUNT/pow(10,from_decimal)) as avg_volume
    from terra.core.ez_swaps
    join terra.core.dim_address_labels on TO_CURRENCY=ADDRESS
    where block_timestamp::date>='2022-12-25' and block_timestamp::date<='2022-12-31'
    and TX_SUCCEEDED=true
    and FROM_CURRENCY='uluna'
    and DESTINATION!='luna'
    group by 1



    Run a query to Download Data