DAYS | COUNTS_BNB | COUNTS_BASE | |
|---|---|---|---|
1 | 2024-01-22 00:00:00.000 | 19058 | 5554 |
2 | 2024-01-22 00:00:00.000 | 19058 | 19271 |
3 | 2024-01-22 00:00:00.000 | 19058 | 8372 |
4 | 2024-01-22 00:00:00.000 | 19058 | 10168 |
5 | 2024-01-22 00:00:00.000 | 19058 | 19382 |
6 | 2024-01-22 00:00:00.000 | 19058 | 15529 |
7 | 2024-01-22 00:00:00.000 | 19058 | 13363 |
8 | 2024-01-22 00:00:00.000 | 19058 | 8916 |
9 | 2024-01-22 00:00:00.000 | 19058 | 4671 |
10 | 2024-01-22 00:00:00.000 | 19058 | 19001 |
11 | 2024-01-22 00:00:00.000 | 19058 | 17029 |
12 | 2024-01-22 00:00:00.000 | 19058 | 4599 |
13 | 2024-01-22 00:00:00.000 | 19058 | 5058 |
14 | 2024-01-22 00:00:00.000 | 19058 | 19057 |
15 | 2024-01-22 00:00:00.000 | 19058 | 13861 |
16 | 2024-01-22 00:00:00.000 | 19058 | 14876 |
17 | 2024-01-22 00:00:00.000 | 19058 | 4321 |
18 | 2024-01-22 00:00:00.000 | 19058 | 8938 |
19 | 2024-01-22 00:00:00.000 | 19058 | 3921 |
20 | 2024-01-22 00:00:00.000 | 19058 | 2427 |
0xHedmanDmail Daily Transactions
Updated 2024-01-26
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
›
⌄
with A as(
SELECT
date_trunc('day', block_timestamp) as days,
count(*) as counts_BNB
FROM bsc.core.fact_transactions
WHERE TO_ADDRESS = '0x98f39d0f8c67885071cc99c5af1d4cacbcc89b0c'
GROUP BY 1
ORDER BY days desc),
B as(
SELECT
date_trunc('day', block_timestamp) as days,
count(*) as counts_BASE
FROM base.core.fact_transactions
WHERE TO_ADDRESS = '0x47fbe95e981c0df9737b6971b451fb15fdc989d9'
GROUP BY 1
ORDER BY days desc)
SELECT A.days, counts_BNB, counts_BASE
FROM
A LEFT JOIN B
WHERE A.days > '2023-07-01'
Last run: about 1 year ago
...
19646
742KB
37s