c2ctrader01 - Number of New Wallets for Each Day
    Updated 2023-04-13
    SELECT date_trunc('day',BLOCK_TIMESTAMP) date, count(FROM_ADDRESS) "Number of Unique Wallet"
    FROM flipside_prod_db.polygon.transactions t
    INNER JOIN
    (
    SELECT FROM_ADDRESS wallet, MIN(BLOCK_TIMESTAMP) As first_occurence
    FROM flipside_prod_db.polygon.transactions
    where --block_timestamp>='2022-01-01 00:00:00.000' and
    SUCCESS=TRUE
    GROUP BY FROM_ADDRESS
    ) X
    ON t.FROM_ADDRESS = X.wallet AND t.BLOCK_TIMESTAMP = x.first_occurence
    group by date order by date
    --limit 10

    Run a query to Download Data