Mrfti2023-06-30 12:18 AM
Updated 2023-07-29
99
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
›
⌄
(
select
'After KYC announcemt' kyc,
'Kucoin to Arbitrum' path,
date_trunc(hour, block_timestamp) as "Date",
count(distinct tx_hash) as "Total transfers",
count(distinct from_address) as "Total users",
sum(raw_amount) as "Total volume"
from
avalanche.core.fact_token_transfers
inner join avalanche.core.dim_labels on from_address = address
where
address_name like '%kucoin%'
and block_timestamp > '2023-06-28 14:00:00.000'
GROUP by
3
order by
3
)
union all
(
select
'Before KYC announcemt' kyc,
'Kucoin to Arbitrum' path,
date_trunc(hour, block_timestamp) as "Date",
count(distinct tx_hash) as "Total transfers",
count(distinct from_address) as "Total users",
sum(raw_amount) as "Total volume"
from
avalanche.core.fact_token_transfers
inner join avalanche.core.dim_labels on from_address = address
where
address_name like '%kucoin%'
and block_timestamp between '2023-06-20 14:00:00.000' and '2023-06-28 14:00:00.000'
GROUP by
3
Run a query to Download Data