emirprince95LUNA Anchor Liquidations
    Updated 2022-07-07
    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