CHAIN | VOLUME_BUCKET | VOLUME_BUCKET_INDEX | USER_COUNT | |
|---|---|---|---|---|
1 | Arbitrum | <$100 | 1 | 3235 |
2 | Arbitrum | $100-$500 | 2 | 1067 |
3 | Arbitrum | $500-$1K | 3 | 403 |
4 | Arbitrum | $1K-$10K | 4 | 920 |
5 | Arbitrum | $10K-$100K | 5 | 342 |
6 | Arbitrum | $100K-$1M | 6 | 55 |
7 | Arbitrum | >$1M | 7 | 8 |
8 | Ethereum | <$100 | 1 | 1410 |
9 | Ethereum | $100-$500 | 2 | 1053 |
10 | Ethereum | $500-$1K | 3 | 407 |
11 | Ethereum | $1K-$10K | 4 | 799 |
12 | Ethereum | $10K-$100K | 5 | 299 |
13 | Ethereum | $100K-$1M | 6 | 106 |
14 | Ethereum | >$1M | 7 | 19 |
15 | Base | <$100 | 1 | 2983 |
16 | Base | $100-$500 | 2 | 921 |
17 | Base | $500-$1K | 3 | 298 |
18 | Base | $1K-$10K | 4 | 612 |
19 | Base | $10K-$100K | 5 | 159 |
20 | Base | $100K-$1M | 6 | 24 |
SocioAnalyticauser vol histogram by chain
Updated 2025-02-11
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
ethereum_bridge_txs AS (SELECT * FROM $query('378caf92-42fd-4fa9-aa11-19f2d6d731c8')),
arbitrum_bridge_txs AS (SELECT * FROM $query('7aa67484-f639-4a58-9e35-18460971423e')),
avalanche_bridge_txs AS (SELECT * FROM $query('4424046c-1851-448a-9cd5-739828b10826')),
base_bridge_txs AS (SELECT * FROM $query('47d7e8cc-173e-417b-8816-7443365b0352')),
optimism_bridge_txs AS (SELECT * FROM $query('8e829a16-a353-4508-bdda-ac3184295d1d')),
polygon_bridge_txs AS (SELECT * FROM $query('2a4afae7-5a43-48e9-a073-0443eaedc240')),
all_bridge_txs AS (
SELECT * FROM (
SELECT * FROM ethereum_bridge_txs
UNION ALL
SELECT * FROM arbitrum_bridge_txs
UNION ALL
SELECT * FROM avalanche_bridge_txs
UNION ALL
SELECT * FROM base_bridge_txs
UNION ALL
SELECT * FROM optimism_bridge_txs
UNION ALL
SELECT * FROM polygon_bridge_txs
)
WHERE
token_symbol is not NULL
AND usd_amount_received is not NULL
AND block_timestamp > '2025-02-03'
),
user_volume_buckets AS (
SELECT
chain,
sender,
SUM(usd_amount_received) as total_volume_usd,
CASE
WHEN SUM(usd_amount_received) >= 1000000 THEN '>$1M'
WHEN SUM(usd_amount_received) >= 100000 THEN '$100K-$1M'
Last run: 3 months ago
41
1KB
4s