AlishGetting your feet wet1
    Updated 2022-03-07
    WITH Tran_count AS (SELECT
    to_date(block_timestamp) AS block_day,
    COUNT (tx_id) Tran_count
    FROM terra.swaps
    WHERE --swap_from_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    block_day=current_date-91
    AND TX_STATUS='SUCCEEDED'
    --AND swap_program LIKE '%jupiter%'
    GROUP by block_day
    ORDER BY block_day ASC)
    SELECT*
    FROM Tran_count

    Run a query to Download Data