SocioAnalytica Interchain transfers activities
Updated 2024-10-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
27
28
29
30
31
32
›
⌄
-- forked from SocioCrypto / Interchain transfers activities @ https://flipsidecrypto.xyz/SocioCrypto/q/UNxNRGuLfPGp/interchain-transfers-activities
-- forked from Interchain transfers activities copy @ https://flipsidecrypto.xyz/edit/queries/600e73fa-edb2-416d-bf7b-627dc5190b33
SELECT
'Squid' as platform,
date_trunc('{{interval}}', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txs,
count(DISTINCT sender) as n_user,
sum(n_txs)over (ORDER BY date) as cum_n_txs,
sum(n_user)over (ORDER BY date) as cum_n_users
FROM axelar.defi.ez_bridge_squid
--WHERE token_symbol = 'axlUSDC'
GROUP BY date
UNION
SELECT
'Satellite' as platform,
date_trunc('{{interval}}', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txs,
count(DISTINCT sender) as n_user,
sum(n_txs)over (ORDER BY date) as cum_n_txs,
sum(n_user)over (ORDER BY date) as cum_n_users
FROM axelar.defi.ez_bridge_satellite
--WHERE token_symbol in ('USDC.axl','axlUSDC')
GROUP BY date
ORDER BY date DESC , platform
QueryRunArchived: QueryRun has been archived