Elprognerd10 - luna <-> swaps
    Updated 2023-01-17
    select
    'Others -> LUNA' as type,
    --date_trunc('hour',block_timestamp) as date,
    count(distinct tx_id) as "Number of TXs",
    count(distinct trader) as "Number of Swappers"
    from terra.core.ez_swaps
    where block_timestamp >= '2023-01-08' and to_currency ='uluna'
    GROUP by 1

    union

    select
    'LUNA -> Others' as type,
    --date_trunc('hour',block_timestamp) as date,
    count(distinct tx_id) as "Number of TXs",
    count(distinct trader) as "Number of Swappers"
    from terra.core.ez_swaps
    where block_timestamp >= '2023-01-08' and from_currency ='uluna'
    GROUP by 1
    Run a query to Download Data