par_rnTotal swap Volume (USD)
    Updated 2022-12-24
    select
    'last 1-month' AS Time,
    'PAXG' AS Symbol,
    sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
    count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
    count(*) AS "Swaps number",
    avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
    Volume/"swappers number" AS "Average Volume/swapper"
    from ethereum.core.ez_dex_swaps
    where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
    and BLOCK_TIMESTAMP::Date >= dateadd('month',-1,CURRENT_DATE)
    union ALL
    select
    'last 3-month' AS Time,
    'PAXG' AS Symbol,
    sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
    count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
    count(*) AS "Swaps number",
    avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
    Volume/"swappers number" AS "Average Volume/swapper"
    from ethereum.core.ez_dex_swaps
    where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
    and BLOCK_TIMESTAMP::Date >= dateadd('month',-3,CURRENT_DATE)
    union ALL
    select
    'last 6-month' AS Time,
    'PAXG' AS Symbol,
    sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
    count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
    count(*) AS "Swaps number",
    avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
    Volume/"swappers number" AS "Average Volume/swapper"
    from ethereum.core.ez_dex_swaps
    where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
    and BLOCK_TIMESTAMP::Date >= dateadd('month',-6,CURRENT_DATE)
    union ALL
    Run a query to Download Data