SELECT

block_timestamp,

date_trunc('day',block_timestamp) as date,

sender,

tx_id,

case

WHEN OFFER_CURRENCY = 'uusd' THEN 'BUY'

ELSE 'SELL'

END as buy_sell,

CASE

WHEN OFFER_CURRENCY = 'uusd' THEN OFFER_AMOUNT

ELSE RETURN_AMOUNT

END as USD_Amount,

CASE

WHEN OFFER_CURRENCY = 'uusd' THEN RETURN_AMOUNT

ELSE OFFER_AMOUNT

END as Token_Amount,

CASE

WHEN OFFER_CURRENCY = 'uusd' THEN OFFER_AMOUNT/RETURN_AMOUNT

ELSE RETURN_AMOUNT/OFFER_AMOUNT

END as price

FROM astroport.swaps

WHERE pool_address = 'terra1l7xu2rl3c7qmtx3r5sd2tz25glf6jh8ul7aag7' AND block_timestamp >= date_trunc('day',current_date - 15) -- enter pool address and date filter for data here

Order by block_timestamp DESC)

SELECT

BLOCK_TIMESTAMP,

DATE,

SENDER,

TX_ID,

BUY_SELL,

USD_AMOUNT,

TOKEN_AMOUNT,

PRICE,

CASE