Commodity Backed Stables on Avalanche 3

jackguyCommodity Backed Stables on Avalanche 3

Updated 2023-05-10

select --*,

count(distinct tx_hash) as swaps,

count(distinct origin_from_address) as users,

sum(AMOUNT_IN_USD) as volume,

avg(AMOUNT_IN_USD) as avg_swap_usd

from avalanche.core.ez_dex_swaps

--where ( token_in in ('0x13e7bcefddde72492e656f3fa58bae6029708e673', '0x68327a91e79f87f501bc8522fc333fb7a72393cb')

--or token_out in ('0x13e7bcefddde72492e656f3fa58bae6029708e673', '0x68327a91e79f87f501bc8522fc333fb7a72393cb') )

--WHERE token_in LIKE lower('0x13E7bceFddE72492E656f3fa58baE6029708e673')

WHERE (symbol_out in ('AUX', 'AGX')

or symbol_in in ('AUX', 'AGX'))

and platform like '%trader-joe%'

--group by 1--,2

--LIMIT 100

Run a query to Download Data

flipside