nsa2000osm3
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
---credit to jackguy
SELECT
--*
date_trunc('month', block_timestamp) as month,
CASE WHEN sender LIKE 'juno%' THEN 'JUNO'
WHEN SENDER LIKE 'stars%' THEN 'STARS'
WHEN SENDER LIKE 'axelar%' THEN 'AXL'
WHEN SENDER LIKE 'evmos%' THEN 'EVMOS'
WHEN SENDER LIKE 'cosmos%' THEN 'ATOM'
WHEN SENDER LIKE 'stride%' THEN 'stride'
WHEN SENDER LIKE 'terra%' THEN 'Terra'
ELSE 'Other Chain' END,
COUNT(DISTINCT tx_id) as transfers,
sum(amount/power(10, decimal)) as volume
FROM osmosis.core.fact_transfers
WHERE RECEIVER LIKE 'osmo%'
AND not SENDER LIKE 'osmo%'
--LIMIT 1000
GROUP BY 1,2
Run a query to Download Data