KaskoazulMarinade NFT - TVL and Mints over time
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select block_timestamp::date as fecha,
count (tx_id) as daily_minted_NFT,
sum (daily_minted_NFT) over (order by fecha) as total_minted_NFT,
sum (amount) as MNDE_locked_per_day,
sum (MNDE_locked_per_day) over (order by fecha) as total_locked_MNDE
from solana.fact_transfers
--where tx_id = '5QE64TvWwCimfDNYNrUcGi9wDmDv3xSY4ne24X189tyVjPCUa4m5swBuunhRKxxD31PLLHnPJ8DGmzVNXKkNWc9R'
--or tx_id = 'FhmsCLomiZw9cKceqQpVU3c4dZ6BCES7VTzNyMQCyJoApQ7TV4jwSqQhAKu7SZJnvgmSYcnPAW3Pc52T4HbDtcg'
where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and index = 1
and fecha >= '2022-04-04' and fecha <= '2022-04-18'
and amount >= 1000
group by fecha
order by fecha desc
Run a query to Download Data