Flipside TeamTop bridged assets volume - mpine copy
Updated 2024-09-12
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
›
⌄
-- forked from MLDZMN / Top bridged assets volume - mpine @ https://flipsidecrypto.xyz/MLDZMN/q/XHt4Fuc1PqfJ/top-bridged-assets-volume---mpine
-- forked from Sandesh / Top bridged assets @ https://flipsidecrypto.xyz/Sandesh/q/TfYfcnbVM5Nx/top-bridged-assets
-- forked from Bridge base query @ https://flipsidecrypto.xyz/edit/queries/1b0b595d-6a46-4d40-8dc5-9443604d20e7
with deposits as
(
(
SELECT
'bridge_out' as action,
tx_hash,
erc20.block_timestamp,
dl.label,
erc20.to_address as bridge_address,
erc20.contract_address as token_address,
erc20.SYMBOL as symbol,
(erc20.amount) as amount,
(erc20.amount_usd) as usd_amount,
from
ethereum.core.ez_token_transfers erc20
inner join
ethereum.core.dim_labels dl
on erc20.to_address=dl.address
where 1=1
-- and eth.to_address = lower('0x28C6c06298d514Db089934071355E5743bf21d60')
and dl.label_type='bridge'
and dl.label_subtype='bridge'
and SYMBOL in (
'USDT','USDC','DAI','WETH','WBTC','ARB','BNB','FDUSD','SHIB','PEPE','stETH',
'FTM','FLOKI','LINK','APEX','TRX','ID','RSR','RNDR','ONDO','FET'
)
)
union
(
SELECT
QueryRunArchived: QueryRun has been archived