TOTAL_FEES | AVG_BRIDGE_FEE | |
|---|---|---|
1 | 17.40636 | 0.001852331595 |
datavortexTotal Fees
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
tx_hash AS "Transaction_hash",
CASE
WHEN event_address = '0x7e4fd97ef92302eea9b10f74be1d96fb1f1511cf7ed28867b0144ca89c6ebc3c' THEN 'MOVE'
WHEN event_address = '0x4d2969d384e440db9f1a51391cfc261d1ec08ee1bdf7b9711a6c05d485a4110a' THEN 'USDC.e'
WHEN event_address = '0x38cdb3f0afabee56a3393793940d28214cba1f5781e13d5db18fa7079f60ab55' THEN 'USDT.e'
WHEN event_address = '0x3dfe1ac4574c7dbbe6f1c5ba862de88fc3e7d3cf8eba95ef1abf32b582889e6d' THEN 'WETH.e'
Last run: about 1 month ago
1
27B
9s