jfoUntitled Query
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week', block_timestamp) as date,
to_address as Participant,
sum(raw_amount/pow(10,18)) as xMETRIC
from
polygon.core.fact_token_transfers
where block_timestamp::date > '2022-07-10'::date
and contract_address = lower('0x15848C9672e99be386807b9101f83A16EB017bb5')
and to_address != lower('0x4b8923746a1D9943bbd408F477572762801efE4d')
group by date,2
Run a query to Download Data