Untitled Query

NavidUntitled Query

Updated 2022-08-04

-- with contracts as (

-- select

-- address_name,

-- project_name,

-- address

-- from

-- optimism.core.dim_labels

-- )

-- select * from optimism.core.dim_labels where address='0xffd74ef185989bff8752c818a53a47fc45388f08'

select * from optimism.core.dim_labels where address='0x392cd35284ab599597c3f9cc41bcd0c38a92f058'

-- select * from optimism.core.dim_contracts where address='0x86f03c6e26b0488b6e39b34d7f10d843ae8e3d1b'

-- select

-- distinct BLOCK_NUMBER,BLOCK_TIMESTAMP,CONTRACT_ADDRESS,CONTRACT_NAME,EVENT_INPUTS,EVENT_NAME,EVENT_REMOVED,ORIGIN_FROM_ADDRESS,ORIGIN_FUNCTION_SIGNATURE,ORIGIN_TO_ADDRESS,TOPICS,TX_HASH,TX_STATUS --, c.raw_amount, c.to_address, c.from_address --distinct event_name --project_name, EVENT_INPUTS

-- from optimism.core.fact_event_logs a -- a join optimism.core.dim_labels b on a.contract_address=b.address

-- --join optimism.core.fact_token_transfers c on a.tx_hash = c.tx_hash

-- -- where a.contract_address='0x3c8b650257cfb5f272f799f5e2b4e65093a11a05' and --event_name='Transfer' AND tx_status='SUCCESS' and label_type='dex'

-- -- a.tx_hash='0x8e717db5070f4568bc45fb0200dace9e15390ca2c5f95a5019d7a59c4337c1c7'

-- -- order by event_index

-- limit 100

-- select * from optimism.core.fact_token_transfers

-- where contract_address='0x3c8b650257cfb5f272f799f5e2b4e65093a11a05' and --event_name='Transfer' AND tx_status='SUCCESS' and label_type='dex'

-- tx_hash='0x8e717db5070f4568bc45fb0200dace9e15390ca2c5f95a5019d7a59c4337c1c7' AND

-- from_address='0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' and to_address='0x0da8bd679b83d19957c880a9a8c119d3ae53de55'

-- select distinct event_name from optimism.core.fact_event_logs

-- select

-- date(block_timestamp) as day,

-- count(*) as "Daily Count",

-- sum("Daily Count") over (order by day asc) as "Cumulative Daily Count",

Run a query to Download Data

flipside

flipside