princefarzamCounting MINE-UST swap transactions
    Updated 2022-02-10
    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;
    Run a query to Download Data