MetiocreLiquidity Added to DaoSol Pool Per Day
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
block_timestamp::date as date,
sum(inner_instruction:instructions[0]:parsed:info:amount / power(10,9)) as "Total DaoSol Deposited" ,
sum(inner_instruction:instructions[1]:parsed:info:amount / power(10,9)) as "Total Sol Deposited" ,
sum(inner_instruction:instructions[2]:parsed:info:amount / power(10,9)) as "Total DaoSol-Sol Minted"
FROM solana.events
WHERE
date >= '2022-02-01' and
inner_instruction:instructions[2]:parsed:info:mintAuthority = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' and
inner_instruction:instructions[2]:parsed:info:mint = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z' and
index = '4'
group by 1
order by 1 desc
Run a query to Download Data