jackguy2023-10-20 03:35 PM copy
Updated 2023-12-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from 2023-10-20 03:35 PM @ https://flipsidecrypto.xyz/edit/queries/05181f5c-d70d-4ddc-bd35-ecb19d50964e
with tab1 as (
SELECT currency from sei.core.dim_tokens where symbol LIKE '%USD%'
)
select
count(distinct tx_id) as txs,
sum(AMOUNT/power(10, DECIMALS)) as volume,
count(DISTINCT SENDER) as users
from sei.core.fact_transfers as a
left outer JOIN sei.core.dim_tokens as b
on a.CURRENCY = b.CURRENCY
where a.CURRENCY in (SELECT * from tab1)
Run a query to Download Data