jackguyaxlUSDC: Soon to be forgotten?
Updated 2023-01-27Copy 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
›
⌄
SELECT
--*
date_trunc('day', block_timestamp) as day,
CASE WHEN receiver LIKE 'juno%' THEN 'JUNO'
WHEN receiver LIKE 'stars%' THEN 'STARS'
WHEN receiver LIKE 'axelar%' THEN 'AXL'
WHEN receiver LIKE 'evmos%' THEN 'EVMOS'
WHEN receiver LIKE 'cosmos%' THEN 'ATOM'
WHEN receiver LIKE 'stride%' THEN 'stride'
WHEN receiver 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 SENDER LIKE 'osmo%'
AND currency LIKE 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
AND not receiver LIKE 'osmo%'
--LIMIT 1000
GROUP BY 1,2
Run a query to Download Data