forgashNVG8
Updated 2022-09-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with
nvg as (
select
block_timestamp,
tx_hash,
event_inputs:from::string as from_adr,
event_inputs:to::string as to_adr,
event_inputs:value::number / pow(10,18) as amount
from polygon.core.fact_event_logs
where contract_address = '0x3eae98a7984794a99acc550a197039abf4c6c9d5'
and event_name = 'Transfer'
)
select to_adr, sum(amount) from nvg group by 1 order by 2 desc
Run a query to Download Data