Monad Metrics Guildselective-lime
Updated 2025-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
creation_tx,
f.value,
symbols
from base.defi.dim_dex_liquidity_pools
,lateral flatten (input => tokens) f
where 1=1
-- and creation_time >= '2025-01-12'
and creation_tx = '0x3be80ea73a7f5ba9fcf2e6e4a6f6c50fa9923c05f03702cd164a114a56278041'
limit 10
select *
from base.defi.dim_dex_liquidity_pools
where 1=1
and creation_time >= '2025-01-12'
and (tokens:token0 = '0x0e85599e2c2c9a0b00cc280065e65f44e08a98c9' or tokens:token1 = '0x0e85599e2c2c9a0b00cc280065e65f44e08a98c9')
-- infra coins & agent coins
-- tvl over time, sum + individual?
-- 1d change, 7d change, 1m change in total tvl
-- % price change since inception for these tokens
-- compare agent tvl vs infra tvl?
-- plan: first get all of the pool addresses for every token,
-- join the pool address with transfer table on pool address, group by day, sum inflows and outflows to pools, then sum over
with
-- agent_tokens --
, flattened_pools as (
select
pool_address as pool
, token.value as token
from base.defi.dim_dex_liquidity_pools
QueryRunArchived: QueryRun has been archived