jackguy2023-10-20 03:35 PM
Updated 2023-12-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (
SELECT currency from sei.core.dim_tokens where symbol LIKE '%USD%'
)
select
BLOCK_TIMESTAMP::date as date,
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)
GROUP BY 1
Run a query to Download Data