flipside

    price data
    garlicprice data
    Updated 2024-07-25
    SELECT TO_CHAR(block_timestamp, 'YYYY-MM-DD') AS date_only,
    count(DISTINCT from_address)
    FROM blast.core.fact_transactions
    GROUP BY TO_CHAR(block_timestamp, 'YYYY-MM-DD')
    ORDER BY TO_CHAR(block_timestamp, 'YYYY-MM-DD') DESC

    QueryRunArchived: QueryRun has been archived