flipside

    ALGORAND Fees part 2
    ArioALGORAND Fees part 2
    Updated 2022-07-07
    select
    count(TX_ID) AS N_of_TX,
    SENDER as wallet_address
    from
    flipside_prod_db.algorand.transactions
    where
    BLOCK_TIMESTAMP >= '2022-01-01'
    /*AND
    sender not in ('ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754',-- PLANET Project
    'C7RYOGEWDT7HZM3HKPSMU7QGWTRWR3EPOQTJ2OHXGYLARD3X62DNWELS34',-- LC RAPID Ranking
    'AACCDJTFPQR5UQJZ337NFR56CC44T776EWBGVJG5NY2QFTQWBWTALTEN4A' --Yieldly
    ) */
    group by wallet_address
    order by N_of_TX DESC
    limit 10
    Run a query to Download Data