BLOCK_TIMESTAMP | TYPE | TX_ID | WALLET | ATOM_AMOUNT | $amount | AVG_PRICE | |
|---|---|---|---|---|---|---|---|
1 | 2023-12-31 23:42:20.900 | Positive Redelegate | 9C23079BEFF6C3CAF732EB818D0EC6045DA673B5AA3C65E7063DCE791ECCD895 | cosmos1mlw39grjhrqe5lmulq9v5layzz2aw2vj5rkd8m | 51 | 549.678 | 10.778 |
Salehtest456
Updated 2024-02-16
999
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
›
⌄
-- forked from PRYZM_RAW_2024_01_part1 @ https://flipsidecrypto.xyz/edit/queries/35a870e6-eac5-4dd2-bb67-2dadac62bf5b
with lst_ATOM_price_week as (
with lst_all as (
select
TO_TIMESTAMP(value[0]::string)::date as date
, 'ATOM' as token
, value[1] as avg_price
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/cosmos/market_chart?vs_currency=usd&days=600&interval=daily&precision=3') as resp
)
,LATERAL FLATTEN (input => resp:data:prices)
)
select
date_trunc(week,date) as week_date
,avg(avg_price) as week_price
from lst_all
group by 1
)
,atom_day as (
select
TO_TIMESTAMP(value[0]::string)::date as date
,'ATOM' as token
, value[1] as avg_price
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/cosmos/market_chart?vs_currency=usd&days=600&interval=daily&precision=3') as resp
)
,LATERAL FLATTEN (input => resp:data:prices)
)
,lst_all_delegate as (
with lst_amount_delegate as (
select
tx_id
Last run: over 1 year ago
1
184B
63s