DEPOSITOR | TOTAL_DEPOSITED_USD | |
|---|---|---|
1 | 0xcf827c20619052d3a45293730443d68ec8a67c5ef2831919ea3882a79a800b7 | 18158878.7556763 |
2 | 0xd0bd436da267b489073377d463144f5e85426db763f138e0c173b39eb616f25d | 14174798.3627517 |
3 | 0xb75be51bcaa549e5e2425c21a5dcb1c04d0d384e49af268e561631c6b504a8a9 | 10216870.0089636 |
4 | 0xe4d5c370475fa6e7b9bd873d5002fe407324fa2e0caf593cefd050688140aef4 | 7900538.40822098 |
5 | 0xf1f7d7a9f8aebef30702b39751216a7f208bad0f86e7e18b2a729a6c1b7e341 | 7032827.80573632 |
6 | 0x408f3c9b976700e75be117ff05f177dd22d9df4b0bff65dc2d51969054855e4b | 3907369.86251367 |
7 | 0x805c7ecf9fa1e44f87292e38b08114ea33ad7c53575c1b6173fa1878ec888c7a | 3233748.35232499 |
8 | 0x737cb9aa6f9b1bdc5c227efd3efa874f6f6e222f156172e2800a460085fa991c | 2174516.30277764 |
9 | 0xf0246be16c8aa7d788325b94ed8b750fc1aa7d0d1527440b3769077e9db9e4d7 | 1774350.67593688 |
10 | 0xd3a40691a998cfaf00a6f69c4776df67317bbcc246488c1186adbe7d6ea3d51e | 1681083.33333333 |
11 | 0xdc8cd4bc4c2256f432f0bf87ee198d1348aa2b94d61da4af619af2bcf01ad02 | 1564155.5783725 |
12 | 0xcd3b2ad13b4d5709e48ac93620628b24ee54faba33539588fcbf58ee212b7dbd | 1437881.66139448 |
13 | 0x3d752a7e576bff26d3d1d59483b009d93e83a3c403bf31ba828e32a2fe752ded | 1410661.04490706 |
14 | 0xdd015f43bad341eba0ff4ce8e53b692982aae5b09a34698cd9cbd9216483f630 | 1005949.53589912 |
15 | 0x5eb42332a941641c87778ec072acba28b7078dcf8ab5b99c194226d3e5bfb9f6 | 1001492.788125 |
16 | 0xf5263ef12d4997333389b0a2224064d8aab4f1ef7509f1369b5f6c3012ae8ba5 | 893361.194073504 |
17 | 0x9880280ec1bc551ecba1cce6bc9a1672fd0fba5e8d6a77673404c37c508b2b0 | 846429.308520354 |
18 | 0x601e9ecc476b5feaeead2a58af0554f39cf1c7b6aa36aeeee3a0cc72e0fd4fd9 | 842996.77928369 |
19 | 0xd4a828cd0f3e60a64b5a681590c39bc3acc2b5acab7622c5c08f1ebba68070a3 | 775720.117384643 |
20 | 0x74b47f2a64656b5d20feac242abad11b3425ae645a34aa5a4727471c7302ea00 | 753423.457297637 |
par_rnEchelon 02
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
27
28
29
30
31
32
33
34
35
36
›
⌄
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
account_address AS depositor,
SUM(amount / POW(10, decimals) * usdprice) AS total_deposited_usd
FROM
aptos.core.fact_transfers AS transfers
JOIN
aptos.core.fact_transactions AS transactions
USING (tx_hash)
JOIN
price prices
ON transfers.block_timestamp::DATE = prices.datee
AND transfers.token_address = prices.token_address
LEFT JOIN
aptos.core.dim_tokens AS tokens
ON transfers.token_address = tokens.token_address
WHERE
payload_function IN (
'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::supply',
'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::supply_fa'
)
AND transfer_event = 'WithdrawEvent'
AND transfers.block_timestamp::DATE >= CURRENT_DATE - 30
GROUP BY
account_address
ORDER BY
Last run: 3 months ago
100
9KB
67s