MLDZMNstable1
Updated 2023-09-10
999
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with final as (SELECT
tx_hash,
block_timestamp,
receiver_id AS token_contract,
BLOCK_ID,
try_cast(args:amount::string AS bigint) AS raw_amount,
raw_amount / power(10, b.decimals) AS amount,
signer_id AS sender,
args:receiver_id::string AS receiver
FROM near.core.fact_actions_events_function_call a
left join near.core.dim_token_labels b on a.receiver_id=b.TOKEN_CONTRACT
WHERE block_timestamp >= '2022-01-01'
and symbol ilike '%usdc%'
AND method_name IN ('ft_transfer', 'ft_transfer_call')
AND raw_amount > 0
)
select
'SEI' as chain,
count(distinct tx_id) as no_transfers,
count(distinct SENDER) as no_senders,
count(distinct RECEIVER) as no_receivers,
sum(AMOUNT/1e6) as volume_usd,
avg(AMOUNT/1e6) as avg_volume,
median(AMOUNT/1e6) as median_volume,
no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day,
no_receivers/count(distinct date_trunc(day, block_timestamp)) as average_receiver_day,
volume_usd/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,
volume_usd/count(distinct BLOCK_ID) as average_volume_block
from sei.core.fact_transfers
where CURRENCY in ('factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' --usdcet
,'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' --usdcar
,'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu' --usdcop
Run a query to Download Data