flipside

    Free Square Question
    eferFree Square Question
    Updated 2022-07-05
    WITH bsc AS (
    SELECT
    BLOCK_TIMESTAMP AS datetime,
    CAST(BLOCK_TIMESTAMP AS DATE) AS date
    FROM bsc.core.fact_transactions
    WHERE datetime > CURRENT_DATE - 1
    GROUP BY datetime
    ORDER BY datetime DESC
    )

    SELECT
    *
    FROM bsc
    ORDER BY DATETIME DESC
    Run a query to Download Data