scottincryptoUniswap V2 Pairs
Updated 2022-08-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select
-- -- date_trunc('month', block_timestamp) as month
-- -- , count(*) as count
-- from ethereum.core.fact_event_logs
-- where contract_address = '0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f'
-- and event_name = 'PairCreated'
-- group by month
-- order by 1
select
block_timestamp
, tx_hash
, event_inputs:"3"::numeric as pool_id
from ethereum.core.fact_event_logs
where contract_address = '0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f'
-- and event_name = 'PairCreated'
-- and event_arg_type = 'uint256'
-- and block_timestamp > '2022-08-01'
-- limit 20
order by pool_id
Run a query to Download Data