DATE_TIME | ADDRESS | TRANSACTION | TOTAL_TRANSACTION | |
|---|---|---|---|---|
1 | 2022-10-17 00:00:00.000 | 2 | 23 | 993459 |
2 | 2022-10-24 00:00:00.000 | 3 | 13 | 993459 |
3 | 2022-10-31 00:00:00.000 | 2 | 2 | 993459 |
4 | 2022-11-07 00:00:00.000 | 778 | 910 | 993459 |
5 | 2022-11-14 00:00:00.000 | 1814 | 2179 | 993459 |
6 | 2022-11-21 00:00:00.000 | 1545 | 1850 | 993459 |
7 | 2022-11-28 00:00:00.000 | 1343 | 1655 | 993459 |
8 | 2022-12-05 00:00:00.000 | 603 | 789 | 993459 |
9 | 2022-12-12 00:00:00.000 | 607 | 779 | 993459 |
10 | 2022-12-19 00:00:00.000 | 381 | 473 | 993459 |
11 | 2022-12-26 00:00:00.000 | 344 | 428 | 993459 |
12 | 2023-01-02 00:00:00.000 | 279 | 346 | 993459 |
13 | 2023-01-09 00:00:00.000 | 358 | 455 | 993459 |
14 | 2023-01-16 00:00:00.000 | 453 | 557 | 993459 |
15 | 2023-01-23 00:00:00.000 | 439 | 568 | 993459 |
16 | 2023-01-30 00:00:00.000 | 448 | 564 | 993459 |
17 | 2023-02-06 00:00:00.000 | 477 | 611 | 993459 |
18 | 2023-02-13 00:00:00.000 | 564 | 688 | 993459 |
19 | 2023-02-20 00:00:00.000 | 581 | 719 | 993459 |
20 | 2023-02-27 00:00:00.000 | 586 | 746 | 993459 |
freeman_7ETHEREUM
Updated 2025-02-03
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
›
⌄
-- For ethereum
with transactions as (
select
date(date_trunc('{{Period}}',block_timestamp)) as date_time,
count(distinct origin_from_address) as address,
count( distinct tx_hash) as transaction
from ethereum.core.ez_decoded_event_logs
where origin_to_address = lower('0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE')
or decoded_log:bridgeData:integrator = 'jumper.exchange'
or decoded_log:integrator = 'jumper.exchange'
And event_name in ('LiFiGenericSwapCompleted','LiFiTransferStarted','LiFiSwappedGeneric')
group by date_time
)
select
date_time,
address,
transaction,
sum(transaction) over() as total_transaction
from transactions
order by date_time
Last run: about 1 month ago
...
121
5KB
167s