MasiWeekly New Users
Updated 2024-11-29
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 tb1 as ( select trunc(block_timestamp,'day') as day,
tx_id,
AMOUNT,
amount_usd,
ifnull(destination_address,source_address) as user,
source_chain,
case when token_address = 'A.231cc0dbbcffc4b7.ceWBTC' then 'WBTC'
when token_address = 'A.231cc0dbbcffc4b7.RLY' then 'RLY'
when token_address = 'A.231cc0dbbcffc4b7.ceFTM' then 'FTM'
when token_address = 'A.475755d2c9dccc3a.TeleportedSportiumToken' then 'SPORTIUM'
when token_address = 'A.0f9df91c9121c460.BloctoToken' then 'BLOCKTO'
when token_address = 'A.231cc0dbbcffc4b7.ceAVAX' then 'WAVAX'
when token_address = 'A.231cc0dbbcffc4b7.ceBUSD' then 'BUSD'
when token_address = 'A.231cc0dbbcffc4b7.ceWETH' then 'ETH'
when token_address = 'A.231cc0dbbcffc4b7.ceMATIC' then 'WMATIC'
when token_address = 'A.1654653399040a61.FlowToken' then 'FLOW'
when token_address = 'A.142fa6570b62fd97.StarlyToken' then 'STARLY'
when token_address = 'A.231cc0dbbcffc4b7.ceUSDT' then 'USDT'
when token_address = 'A.d01e482eb680ec9f.REVV' then 'REVV'
when token_address = 'A.b19436aae4d94622.FiatToken' then 'USDC'
when token_address = 'A.cfdd90d4a00f7b5b.TeleportedTetherToken' then 'USDT'
when token_address = 'A.231cc0dbbcffc4b7.ceBNB' then 'WBNB'
when token_address = 'A.231cc0dbbcffc4b7.ceDAI' then 'DAI'
when token_address = 'A.231cc0dbbcffc4b7.ceWBTC' then 'WBTC'
when token_address = 'A.9c6f94adf47904b5.UsdcUsdtSwapPair' then 'USDC' end as token_name,
token_address
from flow.defi.ez_bridge_activity
where destination_chain in ('FLOW','flow','Flow')
)
,
tb2 as ( select trunc(hour,'day') as day,
'FLOW' as token_symbol,
avg(price) as token_price
from flow.price.ez_prices_hourly
where symbol = 'FLOW'
group by 1,2
QueryRunArchived: QueryRun has been archived