abaNumber of transactions and sum of fees in "AlgoFi" by day - Query
    Updated 2022-07-12
    -- number of transactions and sum of fees in algofi by day
    SELECT date(BLOCK_TIMESTAMP) date, COUNT(TX_ID) as number_of_transactions, sum(FEE) as sum_of_fee
    FROM flipside_prod_db.algorand.application_call_transaction
    where APP_ID in (705663269,705657303,674527132,661247364,661207804,661204747,661199805,661193019,661192413,659678644,659677335,658337046,658336870,647785804,647785158,641500474,641499935,639747739,639747119,611869320,553866305,482625868,465814222,465814065,674526408,637795072,637793356,635866213,635864509,635863793,635860537,635813909,635812850,611867642,611804624,611801333,605753404,553869413,482608867,465818260,465814318,465814278,465814149,465814103)
    or TX_GROUP_ID in (select TX_GROUP_ID from flipside_prod_db.algorand.application_call_transaction
    where APP_ID in (705663269,705657303,674527132,661247364,661207804,661204747,661199805,661193019,661192413,659678644,659677335,658337046,658336870,647785804,647785158,641500474,641499935,639747739,639747119,611869320,553866305,482625868,465814222,465814065,674526408,637795072,637793356,635866213,635864509,635863793,635860537,635813909,635812850,611867642,611804624,611801333,605753404,553869413,482608867,465818260,465814318,465814278,465814149,465814103))
    group by date
    order by date
    Run a query to Download Data