CryptoIcicleALGO-3. Tinyman Assets -N_Swaps
Updated 2022-01-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Before the Tinyman hack, what were the most popular assets to swap with Algo in the
-- Tinyman Dex[App ID 350338509]?
-- Does the average amount of algo swapped changed based on the asset that it was swapped for?
with assets as (
(
select
asset_id,
asset_name
from
algorand.asset
)
union
select
0,
'Algo'
),
tinyman_group_ids as (
select
distinct(tx_group_id) as tx_group_id
from
algorand.application_call_transaction
where
app_id = '350338509'
),
tinyman_txns as (
select
rank() over (
partition by tx_group_id
order by
intra desc
) as rank,
a.asset_name as asset_name,
t.*
from
algorand.transactions t
Run a query to Download Data