roketCopy of Copy of Copy of pool
Updated 2022-12-05
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
›
⌄
--creator :: https://app.flipsidecrypto.com/velocity/queries/47962ef8-7eb9-4c33-b9d2-790b1df8ce15
--Tnx Dear 0xHaM☰d
with priceTb as (
select
recorded_at::date as p_date,
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
where symbol != 'IOV'
group by 1,2,3
union all
select
recorded_at::date as p_date,
'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address1,
'stOSMO' as symbol1,
avg(price) as usd_price
from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name
where symbol = 'OSMO'
group by 1,2,3
union all
select
recorded_at::date as p_date,
'ibc/92BE0717F4678905E53F4E45B2DED18BC0CB97BF1F8B6A25AFEDF3D5A879B4D5' as address1,
'IST' as symbol1,
'1' as usd_price
from osmosis.core.dim_prices
group by 1,2,3
union all
select
Run a query to Download Data