SocioCryptoSquid - Daily Number of Bridgers
Updated 2023-08-20
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
›
⌄
-- 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 date_trunc('day',block_timestamp) as date,
--destination_chain as target,
--source_chain as source,
count(DISTINCT sender) as n_users,
sum(n_users)over(order by date) as cum_of_users
from axelar.core.EZ_SQUID
WHERE destination_chain in ('juno','regen','umee','kujira','secret','evmos','comdex', 'assetmantle','terra2', 'crescent', 'agoric', 'osmosis', 'stargaze')
AND date >= '2023-02-23'
group by 1
--select distinct destination_chain from axelar.core.EZ_SQUID where source_chain = 'polygon'
Run a query to Download Data