0xHaM-dTHALA-LP Farming
Updated 2024-12-05
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
›
⌄
with stakeEvent as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
SENDER,
EVENT_DATA,
EVENT_DATA:amount/1e8 as staked_amount,
t0.symbol as symbol_0,
t1.symbol as symbol_1,
split(split(EVENT_DATA:stake_coin, ', ')[0], '<')[1] as token_0,
split(EVENT_DATA:stake_coin, ', ')[1] as token_1,
FROM aptos.core.fact_events event
JOIN aptos.core.fact_transactions tx using(BLOCK_TIMESTAMP,TX_HASH)
LEFT JOIN aptos.core.dim_tokens t0 on split(split(EVENT_DATA:stake_coin, ', ')[0], '<')[1] = t0.TOKEN_ADDRESS
LEFT JOIN aptos.core.dim_tokens t1 on split(EVENT_DATA:stake_coin, ', ')[1] = t1.TOKEN_ADDRESS
WHERE event_address in (
'0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' -- ThalaFarming
)
AND EVENT_RESOURCE ilike 'StakeEvent'
AND SUCCESS = TRUE
AND TX_TYPE = 'user_transaction'
)
, UnstakeEvent as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
SENDER,
EVENT_DATA,
EVENT_DATA:amount/1e8 as Unstaked_amount,
t0.symbol as symbol_0,
t1.symbol as symbol_1,
split(split(EVENT_DATA:stake_coin, ', ')[0], '<')[1] as token1,
split(EVENT_DATA:stake_coin, ', ')[1] as token2,
FROM aptos.core.fact_events event
JOIN aptos.core.fact_transactions using(BLOCK_TIMESTAMP,TX_HASH)
LEFT JOIN aptos.core.dim_tokens t0 on split(split(EVENT_DATA:stake_coin, ', ')[0], '<')[1] = t0.TOKEN_ADDRESS
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived