rajsUntitled Query
Updated 2022-09-12
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
distinct block_timestamp::date as date
from optimism.core.fact_token_transfers
-- where tx_hash = '0x5ef691d76af11a553870b8e71aeb6af4b088f6500c47ce0b84029f5ba5c32193'
where origin_to_address = '0x4200000000000000000000000000000000000010'
and to_address = '0x0000000000000000000000000000000000000000'
and contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
-- and block_timestamp::date >= CURRENT_DATE - interval '30 days'
Run a query to Download Data