select
date_trunc('day', block_timestamp) AS day,
COUNT(TX_ID) AS TX_NUMBERS
from terra.msg_events
where EVENT_ATTRIBUTES:ask_asset='terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy'
AND event_attributes:"0_action" = 'swap'
AND day::DATE >= CURRENT_DATE -INTERVAL'90 days'
GROUP BY 1
ORDER BY 1;