adambalaSaber Locked Over Time
Updated 2022-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
count(distinct TX_ID) as unlock_id
, date_trunc('day',block_timestamp) as date,
count(distinct SIGNER) as unlockers
FROM solana.fact_gov_actions
WHERE --lower(SIGNER) = lower('LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw')
(mint) = ('Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1')
and block_timestamp>'2022-01-01' and action='EXIT'
group by 2--,3
order by DATE
Run a query to Download Data