connorh1-inch Pools/LP Tokens
Updated 2021-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
event_inputs:mooniswap::STRING AS pool_address,
event_inputs:token1::STRING AS token1,
event_inputs:token2::STRING AS token2,
tx_id AS creation_tx,
block_timestamp AS block_timestamp
FROM
ethereum.events_emitted
WHERE contract_address IN (
'0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643') -- 1 inch factory address
AND block_timestamp >= CURRENT_DATE - 360 AND event_name = 'Deployed'
Run a query to Download Data