jackguyCommodity Backed Stables on Avalanche 2
Updated 2023-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select --*,
-- date_trunc('day', block_timestamp) as day,
case
when symbol_out like 'AGX'
or symbol_in like 'AGX'
then 'agx_silver_commodity_token'
else 'aux_gold_commodity_token'
end as token,
count(distinct tx_hash) as swaps,
count(distinct origin_from_address) as users,
sum(AMOUNT_IN_USD) as volume
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