LittlerDatafees por dia
Updated 2022-07-31
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('day',block_timestamp) as day,
count(*) as sales,
to_address
from polygon.core.fact_token_transfers
left join polygon.core.dim_labels on polygon.core.dim_labels.address = polygon.core.fact_token_transfers.contract_address
where to_address in ('0x8de9c5a032463c561423387a9648c5c7bcc5bc90', '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
and contract_address in ('0x2791bca1f2de4661ed88a30c99a7a9449aa84174','0x8f3cf7ad23cd3cadbd9735aff958023239c6a063','0x7ceb23fd6bc0add59e62ac25578270cff1b9f619')
group by 1, 3
Run a query to Download Data