hessTotal Daily Volume per Chains
Updated 2022-07-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
with token as ( select case when INSTRUCTION:accounts[1]::string = '2iLTifF3JDP65AjFKZ3t4mgfJdQVSmVCiM8Zca3TgvpU' then 'Polygon' -- from Polygon
when INSTRUCTION:accounts[1]::string = 'HZr3bF8YEJWMV75Wi3aFEHEyLLk61VyQduXtunWtXNVQ' then 'BNB'
when INSTRUCTION:accounts[1]::string = '57k3vNmCivSYn7EwQNjcNFcCWAdohZ9xACfMhJGwKiBq' then 'BNB'
when INSTRUCTION:accounts[1]::string = 'J5ifGexAQTg76TresJhJSqTPJLT6BNxrV5rwNJTTz4Cx' then 'Fantom'
when INSTRUCTION:accounts[1]::string = 'H7BkMwbJfLiWE9sSDATHTqXykm1xBjeRzzLDatW2QdEt' then 'Fantom'
when INSTRUCTION:accounts[1]::string = '4XPDxtGbcM7bAPKZxALd2s862n3WoG4xPPvyCPVULKAb' then 'Aurora' -- usdt
when INSTRUCTION:accounts[1]::string = '23CU3bqMJoRTpvyti84CmPbkAyNJDnTZE7DYj6MnhGdK' then 'Aurora' -- usdt
when INSTRUCTION:accounts[1]::string = '3eXCU7YoiCq3rZ6787pPFJE7TXBsKuTZ49wH2kFnuTeF' then 'Aurora' -- USN
when INSTRUCTION:accounts[1]::string = '9dowtd9EbAtC9iKyXWaC5TBmHTivDfdQ6JbeTvHiCK6p' then 'Aurora' -- USN
when INSTRUCTION:accounts[1]::string = '4XPDxtGbcM7bAPKZxALd2s862n3WoG4xPPvyCPVULKAb' then 'Aurora' -- Aurora
when INSTRUCTION:accounts[1]::string = '5rwvDmUbcnZTwZ4Zywev2wnDbyDDD2vcsGU2Xmy7aRNS' then 'Avaax' -- Avaax
when INSTRUCTION:accounts[1]::string = 'DKwsWeqHrB8R1u2DFMHKtq4iqaQNgPgUbHTJyXPqkTzK' then 'Avaax' -- Avaax
when INSTRUCTION:accounts[1]::string = '2x7MjgopLXd3qETGLpY19cyZjHvVnGkrwVjTkJnBza4A' then 'BNB' --
when INSTRUCTION:accounts[1]::string = '3uxBU3fRZzp3V7v9MTNZiDmjxDkKh3rZutLwFtnjJ2pQ' then 'Polygon' -- from Polygon
when INSTRUCTION:accounts[1]::string = '8YYBkTNhpY9mFdCdZWM6mHNf8J6A9hGfimb33LEiiZ3x' then 'BNB' else 'other' end as token, tx_id as tx
from solana.core.fact_events
where program_id = 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs'
)
,
amounts as ( select date(block_timestamp) as date , tx_id , token , program_id , INSTRUCTION:parsed:info:amount as amount
from solana.core.fact_events a join token b on a.tx_id = b.tx
where program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
)
,
final as ( select date, token ,tx_id, case when token in ( 'USDC' , 'USDT') then amount/pow(10,6)
when token in ( 'GST' , 'GMT' ) then amount/pow(10,8) else amount/pow(10,6) end as total
from amounts )
select date , token, count(DISTINCT(tx_id)) as total_tx , sum(total) as amounts
from final
where date >= '2022-03-08'
group by 1,2
Run a query to Download Data