barbodthe number of defly swaps in tinyman
Updated 2022-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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