anc_liquidations AS(

SELECT

date(block_timestamp) AS block_date,

COUNT(*) AS liquidations

FROM anchor.liquidations

WHERE date(block_timestamp) BETWEEN '2021-01-01' AND '2021-12-31'

GROUP BY 1),

luna_price AS(

SELECT

date(block_timestamp) AS block_date,

avg(price_usd) AS price

FROM terra.oracle_prices

WHERE symbol = 'LUNA'

AND date(block_timestamp) BETWEEN '2021-01-01' AND '2021-12-31'

GROUP BY 1)

SELECT

anc_liquidations.block_date AS "Block date",

anc_liquidations.liquidations AS "Anchor liquidations",

luna_price.price AS "LUNA price"

FROM anc_liquidations

JOIN luna_price

ON anc_liquidations.block_date = luna_price.block_date;