TOTAL_USERS | TOTAL_USD_AMOUNT | |
|---|---|---|
1 | 41678 | 1776553626.02116 |
par_rnNEW 6
Updated 2025-01-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 price AS (
SELECT
hour :: DATE AS DATEE,
TOKEN_ADDRESS,
AVG(PRICE) AS USDPRICE
FROM
aptos.price.ez_prices_hourly
GROUP BY
1,
2
)
SELECT
COUNT(DISTINCT ACCOUNT_ADDRESS) AS TOTAL_USERS,
SUM(AMOUNT / POW(10, DECIMALS) * USDPRICE) AS TOTAL_USD_AMOUNT
FROM
aptos.core.fact_transfers A
JOIN aptos.core.fact_events USING(TX_HASH)
JOIN price P ON BLOCK_TIMESTAMP :: DATE = DATEE
AND A.TOKEN_ADDRESS = P.TOKEN_ADDRESS
LEFT JOIN aptos.core.dim_tokens T ON A.TOKEN_ADDRESS = T.TOKEN_ADDRESS
where
payload_function in ('0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::withdraw','0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::withdraw_fa')
and event_resource='WithdrawEvent'
and event_module='lending'
and transfer_event = 'DepositEvent'
Last run: 3 months ago
1
26B
27s