MLDZMNANKA9
Updated 2023-03-14
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
›
⌄
with t1 as (select
BLOCK_TIMESTAMP::date as date,
symbol as token,
count(distinct tx_hash) as no_txn,
count(distinct FROM_ADDRESS) as no_sender,
sum(AMOUNT_USD) as volume_usd,
avg(AMOUNT_USD) as average_volume,
Median(AMOUNT_USD) as median_volume,
avg(average_volume) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
sum(no_sender) over (order by date) as total_users,
sum(no_txn) over (order by date) as total_donate,
sum(volume_usd) over (order by date) as total_volume
from ethereum.core.ez_token_transfers
where TO_ADDRESS in (
lower('0xce4d5b5933b369e9c937ffcfbb9e3aeb3d2c265b'), -- ANKA relief
lower('0xbe4cde5eeeed1f0a97a9457f6ef5b71eae108652'), -- ihtiyac haritasi
lower('0xEd67922e36eD2422d391306f6f6ECC19d58EAa4f'), -- refikanadol
lower('0xe1935271D1993434A1a59fE08f24891Dc5F398Cd'), -- Ahbap
lower('0x64A994CC850a56e87331d880A23A69b16dbFC8ea'), -- AFAD
lower('0x9b40f98ccc326beaa0bfb94cfa8bfc6383a267e5'), -- Community Volunteers Foundation
lower('0x9842453c14f3d0eda2073259a258ee2bdee827a8'), -- Support To Life
lower('0x17517d7e79543750983735B0Fe3Ec6aff8eFD55f'), -- Support To Life
lower('0xf4016873Cca7c516CE2e5659Ccbb55b2E7AC58c9'), -- Basic Needs Association
lower('0x1fc82b7a62c0414163A332693Ec66EC91f4cd1dE'), -- KIZILAY
lower('0x3b816b03B9b6b46376D5423C62aFBb311ff9218F'), -- AKUT
lower('0x25d1A1F25aF8340Ab45dB7f1686F5A225BF9e07E') -- NEF
)
and block_timestamp>='2023-02-06'
group by 1,2 having VOLUME_USD is not null
union all
select
BLOCK_TIMESTAMP::date as date,
'ETH' as token,
count(distinct tx_hash) as no_txn,
count(distinct ETH_FROM_ADDRESS) as no_sender,
sum(AMOUNT_USD) as volume_usd,
Run a query to Download Data