Ali3NUntitled Query
Updated 2022-09-24Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select block_timestamp::date as date,
count (distinct tx_hash),
count (distinct origin_from_address)
from optimism.core.fact_event_logs
where origin_to_address in ('0x998ef16ea4111094eb5ee72fc2c6f4e6e8647666',
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70',
'0xe5c7b4865d7f2b08faadf3f6d392e6d6fa7b903c',
'0x829b1c7b9d024a3915215b8abf5244a4bfc28db4',
'0x20975da6eb930d592b9d78f451a9156db5e4c77b',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6')
group by 1
order by 1
Run a query to Download Data