alleria[Flow] Bridge Analysis - Blockchain Inbound
Updated 2022-07-04
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
›
⌄
WITH all_flow_bridges as (
SELECT
date(block_timestamp) as dates,
*,
CASE
WHEN token_contract = 'A.d01e482eb680ec9f.REVV' THEN 'REVV'
WHEN token_contract = 'A.1654653399040a61.FlowToken' THEN 'FLOW'
WHEN token_contract = 'A.0f9df91c9121c460.BloctoToken' THEN 'BLT'
WHEN token_contract = 'A.475755d2c9dccc3a.TeleportedSportiumToken' THEN 'SPRT'
WHEN token_contract = 'A.cfdd90d4a00f7b5b.TeleportedTetherToken' THEN 'USDT'
WHEN token_contract = 'A.231cc0dbbcffc4b7.RLY' THEN 'RLY'
WHEN token_contract = 'A.142fa6570b62fd97.StarlyToken' THEN 'STARLY'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceMATIC' THEN 'MATIC'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceBNB' THEN 'BNB'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceAVAX' THEN 'AVAX'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceWBTC' THEN 'WBTC'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceWETH' THEN 'WETH'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceUSDT' THEN 'USDT'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceFTM' THEN 'FTM'
WHEN token_contract = 'A.231cc0dbbcffc4b7.ceBUSD' THEN 'BUSD'
ELSE 'null'
END as token_name
FROM flow.core.fact_bridge_transactions
)
SELECT
blockchain,
COUNT(1) as "Transactions",
COUNT(DISTINCT flow_wallet_address) as "Bridgers"
FROM all_flow_bridges
WHERE direction = 'inbound'
GROUP BY blockchain
Run a query to Download Data