DT | CHAIN | NEW_USERS | |
|---|---|---|---|
1 | 2021-11-01 00:00:00.000 | ethereum | 1857 |
2 | 2021-11-01 00:00:00.000 | bsc | 3415 |
3 | 2021-11-01 00:00:00.000 | polygon | 2625 |
4 | 2023-05-01 00:00:00.000 | ethereum | 677 |
5 | 2023-05-01 00:00:00.000 | arbitrum | 798 |
6 | 2023-05-01 00:00:00.000 | avalanche | 219 |
7 | 2023-05-01 00:00:00.000 | bsc | 2817 |
8 | 2023-05-01 00:00:00.000 | optimism | 93 |
9 | 2023-05-01 00:00:00.000 | polygon | 1072 |
10 | 2024-10-01 00:00:00.000 | ethereum | 996 |
11 | 2024-07-01 00:00:00.000 | ethereum | 380 |
12 | 2024-10-01 00:00:00.000 | base | 2422 |
13 | 2024-07-01 00:00:00.000 | base | 878 |
14 | 2024-10-01 00:00:00.000 | arbitrum | 1112 |
15 | 2024-07-01 00:00:00.000 | arbitrum | 418 |
16 | 2024-07-01 00:00:00.000 | avalanche | 71 |
17 | 2024-10-01 00:00:00.000 | avalanche | 81 |
18 | 2024-07-01 00:00:00.000 | bsc | 587 |
19 | 2024-10-01 00:00:00.000 | bsc | 354 |
20 | 2024-07-01 00:00:00.000 | optimism | 121 |
shadabwormhole_data
Updated 2025-02-02
999
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 cte1 AS (
SELECT
ORIGIN_FROM_ADDRESS AS user,
MIN(DATE_TRUNC('month', BLOCK_TIMESTAMP)) AS dt
FROM
ethereum.defi.ez_bridge_activity
WHERE
platform = 'wormhole' AND event_name = 'Transfer'
GROUP BY
ORIGIN_FROM_ADDRESS
),
cte2 AS (
SELECT
dt,
'ethereum' AS chain,
COUNT(DISTINCT user) AS new_users
FROM
cte1
GROUP BY
dt, chain
),
cte3 as (
SELECT
ORIGIN_FROM_ADDRESS AS user,
MIN(DATE_TRUNC('month', BLOCK_TIMESTAMP)) AS dt
FROM
base.defi.ez_bridge_activity
WHERE
platform = 'wormhole' AND event_name = 'Transfer'
GROUP BY
ORIGIN_FROM_ADDRESS
),
cte4 AS (
Last run: 3 months ago
...
233
10KB
18s