DATE | DAILY_NET_BNB_FLOW | CUMULATIVE_BNB_BALANCE | BNB_INFLOW_COUNT | BNB_OUTFLOW_COUNT | SYMBOL | DAILY_NET_TOKEN_FLOW | CUMULATIVE_TOKEN_BALANCE | TOKEN_INFLOW_COUNT | TOKEN_OUTFLOW_COUNT | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 0.14 | 0.87 | 1 | 0 | AKITA | -292 | -5908136 | 0 | 1 |
2 | 2025-02-24 00:00:00.000 | 0.14 | 0.87 | 1 | 0 | USDT | 14560.490712 | 54062.431641 | 9 | 1212 |
3 | 2025-02-24 00:00:00.000 | 0.14 | 0.87 | 1 | 0 | USDТ | -5792.3173 | -17032.3673 | 0 | 3 |
4 | 2025-02-10 00:00:00.000 | 0.15 | 0.45 | 1 | 0 | AKITA | -5907844 | -5907844 | 0 | 4 |
5 | 2025-02-10 00:00:00.000 | 0.15 | 0.45 | 1 | 0 | USDT | 39501.940929 | 39501.940929 | 6 | 910 |
6 | 2025-02-10 00:00:00.000 | 0.15 | 0.45 | 1 | 0 | USDТ | -11240.05 | -11240.05 | 0 | 2 |
gigiokobashocked-magenta
Updated 9 days ago
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 native_transfers AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
SUM(CASE
WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN amount
WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN -amount
ELSE 0
END) AS daily_net_bnb_flow,
COUNT(CASE
WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
ELSE NULL
END) AS inflow_count,
COUNT(CASE
WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
ELSE NULL
END) AS outflow_count
FROM bsc.core.ez_native_transfers
WHERE
(from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47')
OR to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47'))
AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE()) -- ✅ Fixed missing filter
GROUP BY 1
),
token_transfers AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
contract_address,
symbol,
SUM(CASE
WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN amount
WHEN from_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN -amount
ELSE 0
END) AS daily_net_token_flow,
COUNT(CASE
WHEN to_address = LOWER('0xa5990322C9710F1277A37Ef7F8aFA9a3f4eA2D47') THEN 1
Last run: 9 days ago
6
455B
4s