potmoPool Popularity
Updated 2022-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
--and tx_hash = '0x516c3537d534415e5d00845b6b718d93d5f2066e1f9aa795931177b21b5bf5b0'
--select block_timestamp::date as date
with base as (
select pool_address, count(*) as count
from (
select from_address,
concat('0x',( ltrim(substr(input_data,267,64)::string, '0')))as pool_address
from optimism.core.fact_transactions
where to_address = '0x09236cff45047dbee6b921e00704bed6d6b8cf7e'
and origin_function_signature = '0x7ac09bf7')
group by 1
order by 2 desc
)
select c.symbol , b.count, b.pool_address
from base b
left join
optimism.core.dim_contracts c
on b.pool_address = c.address
order by 2 desc
Run a query to Download Data