amelia-leeUntitled Query
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('week', block_timestamp) as date,
MONTH_NAME,
count(DISTINCT tx_id) as tx_cnt,
count(DISTINCT from_address) as user_cnt,
sum(AMOUNT) as eth_amt,
sum(AMOUNT_USD) as usd_amt
from polygon.udm_events a join ethereum.core.dim_dates c on a.block_timestamp::date = c.DATE_DAY
where to_address in ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073','0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d','0x0eb9198b6375d5deb55101dc7b82ad6654d3301b')
and symbol = 'WETH'
and event_name = 'transfer'
group by 1, 2
--0xHaM☰d
Run a query to Download Data