headitmanagera2pool
Updated 2022-12-03
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
›
⌄
with LP833_volume_in as (select sum(amount/pow(10,decimal)) as volume_in , to_date(block_timestamp::date) as date_in
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_joined' and pool_id = 833 and date_in >= '2022-11-11'
group by date_in)
,LP833_volume_out as (select sum(amount/pow(10,decimal)) as volume_out , to_date(block_timestamp::date) as date_out
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_exited' and pool_id = 833 and date_out >= '2022-11-11'
group by date_out)
, LP837_volume_in as (select sum(amount/pow(10,decimal)) as volume_in , to_date(block_timestamp::date) as date_in
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_joined' and pool_id = 837 and date_in >= '2022-11-15'
group by date_in)
,LP837_volume_out as (select sum(amount/pow(10,decimal)) as volume_out , to_date(block_timestamp::date) as date_out
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_exited' and pool_id = 837 and date_out >= '2022-11-15'
group by date_out)
, LP840_volume_in as (select sum(amount/pow(10,decimal)) as volume_in , to_date(block_timestamp::date) as date_in
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_joined' and pool_id = 840 and date_in >= '2022-11-22'
group by date_in)
,LP840_volume_out as (select sum(amount/pow(10,decimal)) as volume_out , to_date(block_timestamp::date) as date_out
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_exited' and pool_id = 840 and date_out >= '2022-11-22'
group by date_out)
, LP634_volume_in as (select sum(amount/pow(10,decimal)) as volume_in , to_date(block_timestamp::date) as date_in
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_joined' and pool_id = 634 and date_in >= '2022-11-29'
group by date_in)
,LP634_volume_out as (select sum(amount/pow(10,decimal)) as volume_out , to_date(block_timestamp::date) as date_out
from osmosis.core.fact_liquidity_provider_actions
where action ilike 'pool_exited' and pool_id = 634 and date_out >= '2022-11-29'
group by date_out)
Run a query to Download Data