Heminanchor bond tabel
Updated 2022-05-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
block_timestamp::date as date,
count(sender) as wallets,
sum(wallets) over (order by date asc rows between unbounded preceding and current row) as all_wallets,
-- COUNT(BONDED_AMOUNT_USD),
sum(BONDED_AMOUNT_USD)as AMOUNT,
sum(AMOUNT) over (order by date asc rows between unbounded preceding and current row) as all_AMOUNT,
CASE
WHEN BONDED_AMOUNT_USD >= 1000000 AND BONDED_AMOUNT_USD <= 10000000 THEN '>1m'
WHEN BONDED_AMOUNT_USD > 10000000 AND BONDED_AMOUNT_USD <= 100000000 THEN '>10m'
WHEN BONDED_AMOUNT_USD > 100000000 AND BONDED_AMOUNT_USD <= 1000000000 THEN '>100m'
WHEN BONDED_AMOUNT_USD > 1000000000 THEN '>1b'
END AS status
FROM
anchor.bonds
WHERE
BONDED_AMOUNT_USD >= 1000000
GROUP by date,status
Run a query to Download Data