MOVEMENT_TO_ETHEREUM_TOTAL_BRIDGES | MOVEMENT_TO_ETHEREUM_TOTAL_BRIDGERS | MOVEMENT_TO_ETHEREUM_TOTAL_AMOUNT_USD_BRIDGED | MOVEMENT_TO_ETHEREUM_AVG_BRIDGE_VOLUME | MOVEMENT_TO_ETHEREUM_AVG_BRIDGES_PER_BRIDGER | ETHEREUM_TO_MOVEMENT_TOTAL_BRIDGES | ETHEREUM_TO_MOVEMENT_TOTAL_BRIDGERS | ETHEREUM_TO_MOVEMENT_TOTAL_AMOUNT_USD_BRIDGED | ETHEREUM_TO_MOVEMENT_AVG_BRIDGE_VOLUME | ETHEREUM_TO_MOVEMENT_AVG_BRIDGES_PER_BRIDGER | TOTAL_BRIDGES | TOTAL_BRIDGERS | TOTAL_AMOUNT_USD_BRIDGED | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 940 | 794 | 620794.911392811 | 660.420118503 | 1.183879093 | 8457 | 5615 | 24188641.0519326 | 2860.191681676 | 1.506144256 | 9397 | 5773 | 24809435.9633254 |
datavortexfinal
Updated 2025-04-15
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 token_prices AS (
SELECT
token_address,
CASE
WHEN token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' THEN 'WBTC'
WHEN token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 'WETH'
WHEN token_address = '0x3073f7aaa4db83f95e9fff17424f71d4751a3073' THEN 'MOVE'
WHEN token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'USDC'
WHEN token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'USDT'
ELSE 'unknown'
END AS symbol,
AVG(price) AS avg_price,
CAST(DATE(hour) AS DATE) AS date
FROM
ethereum.price.ez_prices_hourly
WHERE
token_address IN (
'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', -- WBTC
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', -- WETH
'0x3073f7aaa4db83f95e9fff17424f71d4751a3073', -- MOVE
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
'0xdac17f958d2ee523a2206206994597c13d831ec7' -- USDT
)
GROUP BY
token_address,
CAST(DATE(hour) AS DATE)
),
-- Movement to Ethereum
movement_to_ethereum AS (
SELECT
block_timestamp AS "Bridge Date",
tx_hash AS "Transaction hash",
event_data:from_address AS "bridger",
event_data:amount_sent_ld AS "amount bridged",
CASE
WHEN event_data:dst_eid = '30101' THEN 'ethereum'
Last run: 2 months ago
1
135B
4s