flipside

    Wallets and Fees
    IacomusWallets and Fees
    Updated 2022-07-09
    -- SELECT MIN(BLOCK_TIMESTAMP) FROM flipside_prod_db.polygon.transactions
    -- SELECT MIN(BLOCK_TIMESTAMP) FROM polygon.core.fact_transactions

    SELECT DATE_TRUNC('days', BLOCK_TIMESTAMP) "DAY",
    COUNT(*) Tx, COUNT(DISTINCT FROM_ADDRESS) UNIQUE_WALLETS,
    COUNT(DISTINCT TO_ADDRESS) UNIQUE_RECEIVERS,
    ROUND(SUM(TX_FEE)) FEES, AVG(TX_FEE) AVG_FEES,
    AVG(GAS_PRICE) AVG_GAS_PRICE
    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'
    GROUP BY 1
    Run a query to Download Data