flipside

    HIELO MACHINE - Daily interactions
    piperHIELO MACHINE - Daily interactions
    Updated 2024-10-20
    /*
    FREEZERVERSE
    -- https://www.freezerverse.com/
    -- https://polygonscan.com/txs?a=0x4576D7C2cCee17A022da1aAB3872ac689108D1f9
    -- HIELO: 0xa54392D13f319dDDEcCb1dAae9BEa285C403DAe1
    -- HIELO MACHINE: 0x4576D7C2cCee17A022da1aAB3872ac689108D1f9
    */

    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT(TX_HASH)) AS DailyInteractions
    FROM
    polygon.core.fact_transactions
    WHERE
    TO_ADDRESS = lower('0x4576D7C2cCee17A022da1aAB3872ac689108D1f9')
    GROUP BY date
    ORDER BY date ASC
    QueryRunArchived: QueryRun has been archived