brennavelodrome
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
from_velodrome as
(select
address_name,
count(distinct tx_hash) as tx
from optimism.core.fact_event_logs
full outer join optimism.core.dim_labels on contract_address = address
where origin_to_address = lower('0xa132DAB612dB5cB9fC9Ac426A0Cc215A3423F9c9')
and (event_inputs:from) =( origin_from_address)
and event_name ='Transfer'
group by 1
order by 2 DESC
limit 10),
to_velodrome as (
select
address_name,
count(distinct tx_hash) as tx
from optimism.core.fact_event_logs
full outer join optimism.core.dim_labels on contract_address = address
where origin_to_address = lower('0xa132DAB612dB5cB9fC9Ac426A0Cc215A3423F9c9')
and (event_inputs:to) =( origin_from_address)
and event_name ='Transfer'
group by 1
order by 2 DESC
limit 10
) ,
from_inch as (select
address_name,
count(distinct tx_hash) as tx
from optimism.core.fact_event_logs
full outer join optimism.core.dim_labels on contract_address = address
where origin_to_address = lower('0x1111111254760F7ab3F16433eea9304126DCd199')
and (event_inputs:from) =( origin_from_address)
and event_name ='Transfer'
group by 1
Run a query to Download Data