barbodthe number of defly swaps in tinyman
    Updated 2022-02-20
    with tinyman_group_ids as (
    select TX_GROUP_ID
    from algorand.application_call_transaction
    where app_id = 552635992 -- tinyman
    ),
    defly_group_ids as (
    select algorand.asset_transfer_transaction.TX_GROUP_ID ,(asset_amount/1e6) as amount
    from tinyman_group_ids INNER join algorand.asset_transfer_transaction
    on algorand.asset_transfer_transaction.TX_GROUP_ID = tinyman_group_ids.TX_GROUP_ID
    where ASSET_ID = 470842789 --defly
    GROUP by 1,2
    ),
    defly_transactions as (
    select date_trunc('day',block_timestamp) as daily , count(DISTINCT algorand.transactions.TX_GROUP_ID) as number_of_Defly_Swaps
    from algorand.transactions INNER join defly_group_ids
    on algorand.transactions.TX_GROUP_ID = defly_group_ids.TX_GROUP_ID
    GROUP by 1
    )
    select * from defly_transactions

    Run a query to Download Data