latsan2023-04-24 11:06 PM copy copy
Updated 2023-04-29
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 2023-04-24 11:06 PM copy @ https://flipsidecrypto.xyz/edit/queries/b90fe71e-daa1-4bd1-8da4-e9ec1bf19da7
with cum_txn as (
SELECT BLOCK_TIMESTAMP,
tx_hash as hash,
source_chain,
sender,
destination_chain,
concat(source_chain,'-',destination_chain) as route,
RECEIVER,
token_address,
token_symbol,
amount
FROM axelar.core.ez_squid
WHERE trunc(BLOCK_TIMESTAMP,'day') > '2023-02-23'
)
SELECT --route,
--token_symbol,
count(DISTINCT hash) as hash,
count(DISTINCT sender) as user,
sum(amount) as amt
FROM cum_txn
--GROUP BY 1,2
Run a query to Download Data