RATIO | LOCK_DURATION_DAYS | CNT_WALLETS | BONK_AMOUNT | |
|---|---|---|---|---|
1 | 2 | 180 | 1656 | 37571166191.964 |
2 | 3.2 | 360 | 3595 | 51458303638.4762 |
3 | 1.4 | 90 | 1430 | 36483682132.0784 |
4 | 1 | 30 | 34145 | 469208605549.485 |
Ariobonkrewards pie chart of rewards copy
Updated 2025-02-09
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
›
⌄
-- forked from 0xsloane / bonkrewards pie chart of rewards @ https://flipsidecrypto.xyz/0xsloane/q/EI7C1ARlwhEM/bonkrewards-pie-chart-of-rewards
WITH tab1 AS (
SELECT
tx_id,
div0(mint_amount , power(10, 4)) as wl
FROM solana.defi.fact_token_mint_actions
WHERE mint LIKE 'FYUjeMAFjbTzdMG91RSW5P4HT2sT7qzJQgDPiPG9ez9o'
AND block_timestamp >= current_date - 30
), tab2 as (
SELECT
a.tx_id,
block_timestamp,
wl,
amount,
ROUND(div0(wl , amount), 1) as ratio,
CASE
WHEN ratio = 1 THEN DATEADD(day, 30, block_timestamp)
WHEN ratio = 1.4 THEN DATEADD(day, 90, block_timestamp)
WHEN ratio = 2 THEN DATEADD(day, 180, block_timestamp)
WHEN ratio = 3.2 THEN DATEADD(day, 360, block_timestamp)
END as unlock_date,
CASE
WHEN ratio = 1 THEN 30
WHEN ratio = 1.4 THEN 90
WHEN ratio = 2 THEN 180
When ratio = 3.2 then 360
END as lock_duration_days,
tx_from
FROM solana.core.fact_transfers as a
LEFT OUTER JOIN tab1
ON a.tx_id = tab1.tx_id
WHERE a.tx_id IN (SELECT tx_id FROM tab1)
AND mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
AND tx_to LIKE '9AdEE8AAm1XgJrPEs4zkTPozr3o4U5iGbgvPwkNdLDJ3'
AND block_timestamp > current_date - 30
Last run: about 2 months ago
4
123B
324s