mariyaNumber of Transaction on Tinyman
    Updated 2022-05-18
    SELECT
    date_trunc('day', block_timestamp) AS "Date",
    COUNT(tx_group_id) AS "Number of Swaps on Tinyman"
    FROM algorand.swaps
    WHERE swap_from_amount > '0'
    AND date_trunc('day', block_timestamp) >= '2022-01-01'
    AND swap_program ILIKE '%tinyman%'
    GROUP BY "Date"
    ORDER BY "Date"
    Run a query to Download Data