theericstonelp_actions
Updated 2022-10-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
⌄
select label_subtype, count(*) from optimism.core.dim_labels
where
--lower(project_name) like any ('aave','%velodrom%','%sushi%','%uniswap%')
project_name = 'uniswap'
--and label_subtype in ('general_contract','token_contract')
group by 1;
select * from optimism.core.fact_event_logs WHERE
block_timestamp > current_date - 2
and lower(event_name) like '%tick%'
limit 100;
Run a query to Download Data