ADDRESS | NATIVE_TRANSACTIONS | TOKEN_TRANSFERS | TOTAL_MOVEMENTS | |
|---|---|---|---|---|
1 | 0x0870793286aada55d39ce7f82fb2766e8004cf43 | 3 | 10570 | 10573 |
2 | 0x051100480289e704d20e9db4804837068f3f9204 | 3204 | 3007 | 6211 |
3 | 0xfd36e2c2a6789db23113685031d7f16329158384 | 3038 | 1341 | 4379 |
4 | 0xbbcd063efe506c3d42a0fa2db5c08430288c71fc | 43 | 2125 | 2168 |
5 | 0x0667eed0a0aab930af74a3dfedd263a73994f216 | 436 | 867 | 1303 |
6 | 0x23c4f844ffddc6161174eb32c770d4d8c07833f2 | 0 | 572 | 572 |
7 | 0xf322942f644a996a617bd29c16bd7d231d9f35e9 | 0 | 479 | 479 |
8 | 0x004065d34c6b18ce4370ced1cebde94865dbfafe | 128 | 1 | 129 |
9 | 0xc138aa4e424d1a8539e8f38af5a754a2b7c3cc36 | 7 | 8 | 15 |
10 | 0x9a7890534d9d91d473f28cb97962d176e2b65f1d | 4 | 5 | 9 |
aaronr3gengay-salmon
Updated 2025-02-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
›
⌄
WITH contract_addresses AS (
SELECT LOWER(address) as address
FROM (
VALUES
('0xfD36E2c2a6789Db23113685031d7F16329158384'),
('0x004065D34C6b18cE4370ced1CeBDE94865DbFAFE'),
('0xe4C455cBf870A86399043B8A36A669FfA1583e95'),
('0x051100480289e704d20e9DB4804837068f3f9204'),
('0x0667Eed0a0aAb930af74a3dfeDD263A73994f216'),
('0x0870793286aaDA55D39CE7f82fb2766e8004cF43'),
('0xf322942f644a996a617bd29c16bd7d231d9f35e9'),
('0x8938E6dA30b59c1E27d5f70a94688A89F7c815a4'),
('0xC138aa4E424D1A8539e8F38Af5a754a2B7c3Cc36'),
('0x9A7890534d9d91d473F28cB97962d176e2B65f1d'),
('0xBbCD063efE506c3D42a0Fa2dB5C08430288C71FC'),
('0x23c4F844ffDdC6161174eB32c770D4D8C07833F2')
) as addresses(address)
),
native_tx AS (
SELECT
CASE
WHEN LOWER(from_address) IN (SELECT address FROM contract_addresses) THEN LOWER(from_address)
ELSE LOWER(to_address)
END as address,
COUNT(*) AS tx_count
FROM bsc.core.fact_transactions
WHERE block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
AND (
LOWER(from_address) IN (SELECT address FROM contract_addresses)
OR LOWER(to_address) IN (SELECT address FROM contract_addresses)
)
GROUP BY 1
),
token_tx AS (
SELECT
CASE
Last run: 2 months ago
10
584B
16s