datavortexdull-ivory
Updated 2024-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
/*
SELECT
pool_address,
platform,
pool_name,
SUM(CAST(tokens :liquidity_amount_usd AS FLOAT)) AS total_liquidity_usd
FROM
polygon.defi.dim_dex_liquidity_pools
GROUP BY
pool_address, platform, pool_name
ORDER BY
total_liquidity_usd DESC
LIMIT 10;
*/
SELECT DISTINCT
event_name
FROM
polygon.core.ez_decoded_event_logs
LIMIT 10;