zakkisyed2023-09-16 01:20 PM
Updated 2023-09-16
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
›
⌄
--MArk Cuban 2 0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab
-- SELECT
-- SUM(usd_value_last_activity) AS total_usd_before_drain,
-- SUM(usd_value_now) AS total_usd_now
-- FROM
-- ETHEREUM.core.ez_current_balances
-- WHERE
-- user_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
-- AND
-- last_activity_block_timestamp::date >= CURRENT_DATE - 1;
-- select * from ethereum.core.ez_token_transfers
-- where origin_from_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
-- limit 10
-- USDC balabces
SELECT
date_trunc(hour,b.block_timestamp),
p.SYMBOL as token_symbol,
b.balance/6
FROM
ethereum.core.fact_token_balances AS b
JOIN
ethereum.price.ez_hourly_token_prices AS p ON b.contract_address = p.TOKEN_ADDRESS
WHERE
b.user_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
AND b.contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
AND b.block_timestamp >= current_date -1
ORDER BY
b.block_timestamp;
Run a query to Download Data