MajorM111split AM liquitidy pool
Updated 2024-10-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from 2024-02-17 10:48 AM @ https://flipsidecrypto.xyz/studio/queries/d7fc989d-f33f-4253-aef5-92a46b1d76cd
SELECT *
FROM avalanche.defi.dim_dex_liquidity_pools lp
WHERE lp.platform = 'trader-joe-v1'
AND lp.creation_time > '2022-12-01 01:01:01.000'
AND lp.pool_address IN (
LOWER('0x0368780d62d7d6f75f943ecbccaa7bdbace57e49') -- coq
--LOWER('0x0368780d62d7d6f75f943ecbccaa7bdbace57e49'), -- wang
--LOWER('0xf419fd326e733b191b7f604f8126f3c67792720b') -- sonic
)
ORDER BY lp.creation_block DESC
QueryRunArchived: QueryRun has been archived