icampsBeefy Gauge Distribution hyUSD/eUSD
Updated 2024-03-28
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
›
⌄
-- Beefy launch date (Base): 2023-08-09 00:00:00.000
-- hyUSD/eUSD Vault Contract: 0xB62F13126fCD0dD49dE8fF811406554197Bd0E11
-- hyUSD/eUSD Strategy Contract: 0x8f354b767810d9ec20db6438d636ce7d96b7c0af
-- hyUSD/eUSD Gauge Address: 0x025137c819298654162de2609f407514De4bb027
WITH dates AS (
SELECT
DATE(date_day) AS date_day
FROM crosschain.core.dim_dates
WHERE date_day between '2023-08-09' and current_date()
),
deposits as (
SELECT
block_timestamp,
(TO_NUMBER(DECODED_LOG:amount::string) / POW(10,18)) as deposited_amount,
ORIGIN_FROM_ADDRESS as user,
CONTRACT_ADDRESS AS gauge_address,
tx_hash
FROM base.core.ez_decoded_event_logs
WHERE gauge_address IN (
lower('0x025137c819298654162de2609f407514De4bb027')
)
AND EVENT_NAME IN (
'Deposit'
)
AND user NOT IN (
lower('0x8f354b767810d9ec20db6438d636ce7d96b7c0af')
)
),
withdrawals as (
SELECT
block_timestamp,
(TO_NUMBER(DECODED_LOG:amount::string) / POW(10,18)) as withdrawn_amount,
ORIGIN_FROM_ADDRESS as user,