SEASON | POOL_START | BANANA_CK | BANANA_BURNT | BANANA_POOL | FINAL_PRIZE | |
---|---|---|---|---|---|---|
1 | 65 | 10000 | 259.2 | 1036.8 | 1296 | 11296 |
2 | 64 | 5000 | 1121.64 | 4486.56 | 5608.2 | 10608.2 |
3 | 63 | 15000 | 1963.64 | 7854.56 | 9818.2 | 24818.2 |
4 | 62 | 10000 | 1563.52 | 6254.08 | 7817.6 | 17817.6 |
5 | 61 | 5000 | 989.80025 | 3959.201 | 4949.00125 | 9949.00125 |
6 | 60 | 5000 | 1156.09 | 4624.36 | 5780.45 | 10780.45 |
7 | 59 | 5000 | 1755.68 | 7022.72 | 8778.4 | 13778.4 |
8 | 58 | 15000 | 2521.8 | 10087.2 | 12609 | 27609 |
9 | 57 | 10000 | 1403.24 | 5612.96 | 7016.2 | 17016.2 |
10 | 56 | 5000 | 1368.72 | 5474.88 | 6843.6 | 11843.6 |
11 | 55 | 15000 | 928.64 | 3714.56 | 4643.2 | 19643.2 |
12 | 54 | 15000 | 1764.64 | 7058.56 | 8823.2 | 23823.2 |
13 | 53 | 5000 | 1666.76 | 6667.04 | 8333.8 | 13333.8 |
14 | 52 | 20000 | 2575.36 | 10301.44 | 12876.8 | 32876.8 |
15 | 51 | 20000 | 3778.28 | 15113.12 | 18891.4 | 38891.4 |
16 | 50 | 10000 | 7332.8 | 29331.2 | 36664 | 46664 |
17 | 49 | 20000 | 9188.68 | 36754.72 | 45943.4 | 65943.4 |
18 | 48 | 15000 | 7202.56 | 28810.24 | 36012.8 | 51012.8 |
19 | 47 | 20000 | 11878.12 | 47512.48 | 59390.6 | 79390.6 |
20 | 46 | 10000 | 7289.72 | 29158.88 | 36448.6 | 46448.6 |
banterlyticspnk-banana
Updated 2024-02-17
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
›
⌄
with boundaries as
(select
ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[0])::integer as season,
ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[1])/((pow(10,18))) as prize,
block_timestamp,
COALESCE(LEAD(block_timestamp) OVER (ORDER BY block_timestamp),to_timestamp(100000000000)) as next_timestamp
from polygon.core.fact_event_logs
where block_timestamp::date BETWEEN '2022-03-14 16:40:20.000' and '2024-01-06 06:52:00.000'
and contract_address = '0x70c575588b98c1f46b1382c706adaf398a874e3e'
and topics[0]::string = '0x9b492ca62dd845faf66276dbd14ed82e0d819d8b172cb51433ffe4268ab3dd9e')
SELECT boundaries.season,
avg(boundaries.prize) as pool_start,
sum(ftt.raw_amount/pow(10,18))*0.25 as Banana_CK,
sum(ftt.raw_amount/pow(10,18)) as Banana_burnt,
sum(ftt.raw_amount/pow(10,18))*1.25 as Banana_pool,
avg(boundaries.prize)+(sum(ftt.raw_amount/pow(10,18))*1.25) as final_prize
FROM polygon.core.fact_token_transfers ftt
LEFT OUTER JOIN boundaries ON
ftt.block_timestamp >= boundaries.block_timestamp AND
ftt.block_timestamp < boundaries.next_timestamp
where ftt.block_timestamp::date BETWEEN '2022-03-14 16:40:20.000' and '2024-01-06 06:52:00.000'
AND contract_address = lower('0xbC91347e80886453F3f8bBd6d7aC07C122D87735')
AND to_address = lower('0x000000000000000000000000000000000000dead')
group by 1
order by 1 desc
Last run: about 1 year ago
65
3KB
100s