c2ctrader03 - Top 10 Wallets
    Updated 2022-05-31
    with first_transaction as (
    SELECT *
    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
    )
    select from_address "Wallet Address", count(*) "Number of Transaction" from flipside_prod_db.polygon.transactions
    where from_address in (select from_address from first_transaction) and SUCCESS=TRUE
    group by from_address order by "Number of Transaction" DESC
    limit 10

    Run a query to Download Data