SocioCryptoSquid - Source Data copy copy copy
Updated 2023-08-20Copy Reference Fork
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
›
⌄
-- forked from Squid - Source Data copy copy @ https://flipsidecrypto.xyz/edit/queries/34151285-00d2-4b2f-9d99-e4cc144a2c3f
-- forked from Squid - Source Data copy @ https://flipsidecrypto.xyz/edit/queries/ccda319a-38d1-4b1c-915c-6cf303937550
-- forked from Squid - Source Data @ https://flipsidecrypto.xyz/edit/queries/f451f2cc-62d0-429c-b9f5-59a81ab5881a
-- forked from f67eecb0-b314-4825-95ac-21fa52ccabf9
select
destination_chain as target,
source_chain as source,
count(DISTINCT sender) as n_users,
sum(amount) as size,
count(DISTINCT tx_hash) as n_swaps
from axelar.core.EZ_SQUID
WHERE destination_chain in ('juno','regen','umee','kujira','secret','evmos','comdex', 'assetmantle','terra2', 'crescent', 'agoric', 'osmosis', 'stargaze')
AND date_trunc('day',block_timestamp) >= '2023-02-23'
group by 1,2
--select distinct destination_chain from axelar.core.EZ_SQUID where source_chain = 'polygon'
Run a query to Download Data