germancopiada y funciona, pool 833
Updated 2022-12-07
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
›
⌄
⌄
⌄
/*Track LP volume in AND out of these pools based on the following dates:
11/11/22 Pool 833 - stOSMO / OSMO
11/15/22 Pool 837 - IST / OSMO
11/22/22 Pool 840 - BNB / OSMO
11/29/22 Pool 634 - wETH.grv / OSMO.*/
SELECT
block_timestamp::date as date,
currency,
sum(amount/ pow(10,decimal))
FROM osmosis.core.fact_liquidity_provider_actions a
--JOIN prices c on a.currency = c.address
-- AND a.block_timestamp::date = c.day
WHERE pool_id = '840'
AND block_timestamp >= '2022-11-10'
AND action in ('pool_joined')
GROUP BY 1,2
ORDER BY 1
/*WITH prices as (
SELECT
recorded_at::date as day,
address,
symbol,
avg(price) as USD_price
FROM osmosis.core.dim_prices a
JOIN osmosis.core.dim_labels b on a.symbol = b.project_name
GROUP BY 1,2,3),
pool as (
SELECT
liquidity_provider_address as new_provider,
min(block_timestamp) as first_date
Run a query to Download Data