freemartianUntitled Query
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
sum(raw_amount)/pow(10,18) as sale_volume,
count(distinct from_address) as buyer,
count(DISTINCT to_address) as seller,
date_trunc('day', block_timestamp::date) as TIME,
origin_to_address
from optimism.core.fact_token_transfers
where origin_to_address in (
'0x20975da6eb930d592b9d78f451a9156db5e4c77b',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
group by TIME, origin_to_address
Run a query to Download Data