flipside

    Tx and Wallets Count
    IacomusTx and Wallets Count
    Updated 2022-07-09
    -- SELECT MIN(BLOCK_TIMESTAMP) FROM flipside_prod_db.polygon.transactions
    -- SELECT MIN(BLOCK_TIMESTAMP) FROM polygon.core.fact_transactions

    SELECT
    COUNT(*) Tx, COUNT(DISTINCT FROM_ADDRESS) UNIQUE_WALLETS
    FROM polygon.core.fact_transactions
    WHERE DATE_TRUNC('days', BLOCK_TIMESTAMP) >= '2022-07-01'
    -- AND DATE_TRUNC('days', BLOCK_TIMESTAMP) <> CURRENT_DATE
    AND STATUS = 'SUCCESS'

    Run a query to Download Data