PapasotYieldly daily staking (volume)
Updated 2023-01-02
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
›
⌄
-- original analyst adriaparcerisas
-- https://app.flipsidecrypto.com/dashboard/yieldly-staking-pool-GHNNQX
-- The SQL query was adjusted for another bounty submission about YDLY staking
with
add_liquidity as (
select
block_id,
sum(asset_amount/1e6) as liquidity_in from algorand.asset_transfer_transaction where asset_receiver='FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY' and asset_transferred ='226701642' and asset_amount<1e11 and asset_amount is not null
group by 1
),
remove_liquidity as (
select
block_id,
sum(asset_amount/1e6) as liquidity_out from algorand.asset_transfer_transaction where sender='FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY' and asset_transferred ='226701642' and asset_amount<1e11 and asset_amount is not null
group by 1
),
datetimes as (
SELECT
block_timestamp,
block_id
from algorand.block
),
total_liquidity as (
select
block_timestamp,
liquidity_in as liqin,
liquidity_out as liqout
from add_liquidity x
left outer join remove_liquidity y on x.block_id = y.block_id
left outer join datetimes z on x.block_id = z.block_id
)
SELECT
trunc(block_timestamp,'day') as date,
sum(liqin) as liquidity_in,
Run a query to Download Data