DAY | LOCKER_NAME | LP_DEPOSITED | BGT_CLAIMED | CUMULATIVE_LP_DEPOSITED | CUMULATIVE_BGT_CLAIMED | |
|---|---|---|---|---|---|---|
1 | 2025-02-01 00:00:00.000 | LP Maxi + Foundational | 0 | 0.050996 | 130.119495 | 0.263442 |
2 | 2025-01-30 00:00:00.000 | LP Maxi + Foundational | 0 | 0.01817 | 130.119495 | 0.212446 |
3 | 2025-01-30 00:00:00.000 | BGT Maxi + Foundational | 0 | 0.023608 | 130.12 | 0.311469 |
4 | 2025-01-29 00:00:00.000 | LP Maxi + Foundational | 0 | 0.172824 | 130.119495 | 0.194276 |
5 | 2025-01-29 00:00:00.000 | BGT Maxi + Foundational | 0 | 0.184071 | 130.12 | 0.287861 |
6 | 2025-01-22 00:00:00.000 | LP Maxi + Foundational | 0 | 0.016684 | 130.119495 | 0.021452 |
7 | 2025-01-21 00:00:00.000 | BGT Maxi + Foundational | 0 | 0.10379 | 130.12 | 0.10379 |
8 | 2025-01-21 00:00:00.000 | LP Maxi + Foundational | 0 | 0.004768 | 130.119495 | 0.004768 |
9 | 2025-01-14 00:00:00.000 | BGT Maxi + Foundational | 130.12 | 0 | 130.12 | 0 |
10 | 2025-01-14 00:00:00.000 | LP Maxi + Foundational | 130.119495 | 0 | 130.119495 | 0 |
The Honey JarS&F foundational
Updated 2025-02-18
999
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
›
⌄
with locker as (
SELECT
locker_name,
address
FROM
(
VALUES
(
'LP Maxi + Foundational',
'0x5911b25ae5f02ac9f3160dc5068678390e59e311'
),
(
'BGT Maxi + Foundational',
'0xd6e3ea1297da3fe86e6c80e2febd361da98899ef'
)
) AS X(locker_name, address)
),
lp_deposits as (
select
day,
locker_name,
amount as lp_deposited,
sum(amount) over (
partition by contract_address
order by
day
) as cumulative_lp_deposited
from
(
select
date_trunc('day', BLOCK_TIMESTAMP) as day,
contract_address,
sum(
(utils.udf_hex_to_int(substr(data, 3, 64)) :: int) / 1e18
) as amount
from
Last run: 2 months ago
10
812B
39s