BRIDGE | SIZE_BUCKET | TX_COUNT | TOTAL_VOLUME | AVG_TX_SIZE | PCT_OF_CHAIN_TXS | PCT_OF_CHAIN_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | lifuel | 0-100n | -5 | -0.000005051372471 | 1.010274494 | 100 | 100 |
2 | lifuel | 0-100 | 4 | 0.000007651114005 | 1.912778501 | 100 | 100 |
3 | relay | 10K+ | 3 | 0.05544691134 | 18482.303779676 | 1.52 | 20.9 |
4 | relay | 5K-10K | 11 | 0.07820762733 | 7109.784302621 | 5.58 | 29.49 |
5 | relay | 1K-5K | 41 | 0.1033868209 | 2521.629778874 | 20.81 | 38.98 |
6 | relay | 1K-5Kn | -1 | -0.001018683492 | 1018.683492449 | 1.14 | 17.97 |
7 | relay | 500-1Kn | -3 | -0.002066112176 | 688.704058717 | 3.41 | 36.44 |
8 | relay | 500-1K | 19 | 0.01543692053 | 812.46950176 | 9.64 | 5.82 |
9 | relay | 100-500 | 50 | 0.01045410641 | 209.082128172 | 25.38 | 3.94 |
10 | relay | 100-500n | -6 | -0.001495220951 | 249.203491785 | 6.82 | 26.37 |
11 | relay | 0-100n | -78 | -0.001089247214 | 13.964707867 | 88.64 | 19.21 |
12 | relay | 0-100 | 73 | 0.002302772074 | 31.544822932 | 37.06 | 0.87 |
13 | stargateV2 | 10K+n | -121 | -5.63084037 | 46535.870829534 | 3.1 | 77.42 |
14 | stargateV2 | 10K+ | 102 | 7.509164227 | 73619.25712816 | 2.14 | 81.84 |
15 | stargateV2 | 5K-10Kn | -51 | -0.3664018621 | 7184.35023693 | 1.31 | 5.04 |
16 | stargateV2 | 5K-10K | 55 | 0.3913862262 | 7116.113203628 | 1.16 | 4.27 |
17 | stargateV2 | 1K-5Kn | -389 | -0.7908790227 | 2033.108027631 | 9.97 | 10.87 |
18 | stargateV2 | 1K-5K | 373 | 0.7156275327 | 1918.572473742 | 7.84 | 7.8 |
19 | stargateV2 | 500-1K | 282 | 0.1910179308 | 677.368548825 | 5.93 | 2.08 |
20 | stargateV2 | 500-1Kn | -266 | -0.188657029 | 709.236951143 | 6.82 | 2.59 |
SocioAnalyticajoint histograms by bridge
Updated 2025-02-02
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
›
⌄
-- forked from elvis / joint histograms by chain @ https://flipsidecrypto.xyz/elvis/q/jrLlPuay_HDx/joint-histograms-by-chain
WITH outgoing_histograms AS (
SELECT
bridge,
size_bucket || 'n' as size_bucket,
-tx_count as tx_count,
-total_volume/1e6 as total_volume,
avg_tx_size as avg_tx_size,
pct_of_chain_txs,
pct_of_chain_volume
FROM $query('57999564-76aa-4577-a112-e6ca35a4a580')
),
incoming_histograms AS (
SELECT
bridge,
size_bucket,
tx_count,
total_volume/1e6,
avg_tx_size,
pct_of_chain_txs,
pct_of_chain_volume
FROM $query('f9b57c6f-13e6-4a1d-a60e-be7706b4c1df')
)
SELECT *
FROM (
SELECT * FROM outgoing_histograms
UNION
SELECT * FROM incoming_histograms
)
ORDER BY
bridge,
CASE
WHEN size_bucket = '10K+' OR size_bucket = '10K+n' THEN 1
WHEN size_bucket = '5K-10K' OR size_bucket = '5K-10Kn' THEN 2
WHEN size_bucket = '1K-5K' OR size_bucket = '1K-5Kn' THEN 3
Last run: 2 months ago
48
3KB
2s