HosseinUntitled Query
    Updated 2023-01-18
    select
    count(distinct tx_id) as txns_count,
    count(distinct trader) as traders_count,
    txns_count / traders_count as txns_per_trader,
    sum(from_amount / pow(10, 6)) as volume_usd,
    sum(to_amount / pow(10, 6)) as volume_luna
    from terra.core.ez_swaps
    where from_currency = 'uluna'
    and block_timestamp >= '2022-12-01'
    and to_currency in (
    'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4', --axlUSDT
    'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' --axlUSDC
    )
    Run a query to Download Data