emirprince95LUNA Anchor Liquidations
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with liquidations as (select date_trunc('HOUR', block_timestamp) as block_timestamp, sum(liquidated_amount_usd) as liquidated_amount_usd
from anchor.liquidations
where liquidated_currency = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'
group by date_trunc('HOUR', block_timestamp), liquidated_currency)
, luna_price as (
select block_timestamp, price_usd as luna_price from terra.oracle_prices
where symbol = 'LUNA'
)
select li.*, lp.luna_price from liquidations li join luna_price lp on li.block_timestamp=lp.block_timestamp
Run a query to Download Data