TYPE | AMOUNT_BRIDGED | |
|---|---|---|
1 | L2bridge | 162122.685450502 |
2 | bridge | 50621.111430514 |
lidowstETH Amount by Bridges type
Updated 7 hours ago
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 wstETH Amount Bridged @ https://flipsidecrypto.xyz/edit/queries/0a97f1c9-6446-43f6-87c1-2354465cc350
WITH bridges AS (
SELECT *
FROM (
SELECT
value[0]::text AS bridge_address,
value[1]::text AS platform,
value[2]::text AS category
FROM (
SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/eda386bd-b076-47c7-b72a-92c27d8b40d3/latest-run') as response
), lateral FLATTEN (input => response:data:result:rows)
)
)
, transfers as (
SELECT
BLOCK_TIMESTAMP::date AS time
, CASE
WHEN TO_ADDRESS IN (SELECT bridge_address FROM bridges) THEN TO_ADDRESS
WHEN FROM_ADDRESS IN (SELECT bridge_address FROM bridges) THEN FROM_ADDRESS
END AS bridge
, SUM(CASE WHEN TO_ADDRESS IN (SELECT bridge_address FROM bridges) THEN AMOUNT ELSE 0 END) AS amount_in
, SUM(CASE WHEN FROM_ADDRESS IN (SELECT bridge_address FROM bridges) THEN AMOUNT ELSE 0 END) AS amount_out
FROM ethereum.core.ez_token_transfers
WHERE (TO_ADDRESS IN (SELECT bridge_address FROM bridges)
OR FROM_ADDRESS IN (SELECT bridge_address FROM bridges))
AND SYMBOL = 'wstETH'
GROUP BY 1, 2
)
, balances_daily as (
SELECT
time
, bridge
Last run: about 7 hours agoAuto-refreshes every 24 hours
2
58B
103s