c2ctraderNumber of Mints and Burns of Tinyman Pools (alternative code)
Updated 2022-06-09
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
›
⌄
select asset_id ,price_usd from algorand.prices_swap
where
asset_id in (
select asset_id from
(
select asset_id,max(block_hour) from algorand.prices_swap group by asset_id
)
)
-- --determine pool_name and pool_address from labels table
-- WITH pool as (
-- select address pool_address, address_name pool_name from flipside_prod_db.algorand.labels
-- where label = 'tinyman'
-- ),
-- asset_info as (
-- select creator_address, asset_id lp_id, asset_name
-- from flipside_prod_db.algorand.asset where creator_address in (SELECT pool_address from pool)
-- ),
-- asset_price as (
-- select asset_id ,price_usd from algorand.prices_swap s join asset_info i on s.asset_id=i.lp_id
-- where block_hour >=CURRENT_DATE
-- ),
-- burn_info as (
-- SELECT
-- case
-- when asset_sender in (SELECT pool_address from pool) then asset_sender
-- when tx_sender in (SELECT pool_address from pool) then tx_sender
-- END as pool_address,
-- asset_id, amount
-- FROM flipside_prod_db.algorand.transfers t
-- WHERE asset_sender in (SELECT pool_address from pool)
-- or
-- tx_sender in (SELECT pool_address from pool)
Run a query to Download Data