TOTAL_VOLUME | AVG_VOLUME | MEDIAN_VOLUME | |
---|---|---|---|
1 | 21171248.5709413 | 2184.855373678 | 143.050086933 |
datavortexconservative-blue
Updated 2024-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH tab1 AS (
SELECT
TX_HASH
FROM polygon.core.ez_decoded_event_logs
WHERE EVENT_NAME = 'LiFiTransferStarted'
AND DECODED_LOG:bridgeData:integrator = 'jumper.exchange'
AND ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND BLOCK_TIMESTAMP >= DATE_TRUNC('month', CURRENT_DATE)
)
SELECT
SUM(AMOUNT_USD) AS total_volume,
AVG(AMOUNT_USD) AS avg_volume,
MEDIAN(AMOUNT_USD) AS median_volume
FROM polygon.core.ez_token_transfers
WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS
AND TX_HASH IN (SELECT TX_HASH FROM tab1)
AND BLOCK_TIMESTAMP >= DATE_TRUNC('month', CURRENT_DATE);
Last run: about 2 months ago
1
49B
74s