DATE | NEW_SWAPPERS | TOTAL_SWAPPERS | |
|---|---|---|---|
1 | 2024-12-07 00:00:00.000 | 11 | 11 |
2 | 2024-12-08 00:00:00.000 | 18 | 29 |
3 | 2024-12-09 00:00:00.000 | 13 | 42 |
4 | 2024-12-10 00:00:00.000 | 14 | 56 |
5 | 2024-12-11 00:00:00.000 | 14 | 70 |
6 | 2024-12-12 00:00:00.000 | 5 | 75 |
7 | 2024-12-13 00:00:00.000 | 8 | 83 |
8 | 2024-12-14 00:00:00.000 | 7 | 90 |
9 | 2024-12-15 00:00:00.000 | 8 | 98 |
10 | 2024-12-16 00:00:00.000 | 7 | 105 |
11 | 2024-12-17 00:00:00.000 | 8 | 113 |
12 | 2024-12-18 00:00:00.000 | 12 | 125 |
13 | 2024-12-19 00:00:00.000 | 13 | 138 |
14 | 2024-12-20 00:00:00.000 | 5 | 143 |
15 | 2024-12-21 00:00:00.000 | 5 | 148 |
16 | 2024-12-22 00:00:00.000 | 8 | 156 |
17 | 2024-12-23 00:00:00.000 | 10 | 166 |
18 | 2024-12-24 00:00:00.000 | 5 | 171 |
19 | 2024-12-25 00:00:00.000 | 5 | 176 |
20 | 2024-12-26 00:00:00.000 | 10 | 186 |
Pine Analyticsnotable-ivory copy copy copy copy
Updated 2025-02-21
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
›
⌄
SELECT
date(first_swap) as date,
count(*) as new_swappers,
sum(count(*)) over (
order by
date(first_swap)
) as total_swappers
FROM
(
SELECT
ORIGIN_FROM_ADDRESS,
sum(AMOUNT_USD) as swap_volume,
sum(AMOUNT_USD) as fee_payed,
count(*) as swaps,
count(DISTINCT date(block_timestamp)) as active_days,
min(block_timestamp) as first_swap
FROM
(
SELECT
block_timestamp,
ORIGIN_FROM_ADDRESS,
AMOUNT_USD
FROM
base.core.ez_token_transfers
WHERE
to_address = lower('0x0b480f79d77524588E29FBdBB3454f66279B16a4')
AND block_timestamp > '2024-12-06'
UNION
ALL
SELECT
block_timestamp,
ORIGIN_FROM_ADDRESS,
AMOUNT_USD
FROM
base.core.ez_native_transfers
WHERE
Last run: 2 months ago
77
3KB
127s