freemartianDaily Sale Count
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select count(distinct tx_hash) as sale_count,
date_trunc('day', block_timestamp::date) as TIME
from optimism.core.fact_event_logs
where origin_to_address in (
'0x20975da6eb930d592b9d78f451a9156db5e4c77b',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')
and event_name = 'Transfer'
and event_inputs:tokenId is not null
group by TIME
Run a query to Download Data