NavidUntitled Query
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
distinct l.address_name
-- initcap(l.PROJECT_NAME, ' ') as type,
-- ORIGIN_FROM_ADDRESS as user_count,
-- tx_hash as transactions_count
from
optimism.core.fact_event_logs
JOIN optimism.core.dim_labels l ON ADDRESS=ORIGIN_TO_ADDRESS
where
contract_address='0x4200000000000000000000000000000000000042' and
TX_STATUS = 'SUCCESS' and l.PROJECT_NAME ilike '%optimism%'
-- limit 10
Run a query to Download Data