nitsArb vs BSC
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
›
⌄
-- -Number of transactions -Transaction success rates -Number of unique wallets to make a transaction -Number of wallets that used the chain everyday since May 9th -Transaction fees
with bsc_data as
(SELECT date(block_timestamp) as day, count(DISTINCT tx_hash) as total_txs, sum(success)/(sum(success)+sum(failed))*100 as percent_sucess,
avg(percent_sucess) over (order by day) as avg_sucess, sum(total_txs) over (order by day) as cumulative_txs, count(DISTINCT from_address) as daily_users,
sum(daily_users) over (order by day) as cumulative_wallets , 'bsc' as type, sum(tx_fee) as fees, sum(FEES) over (order by day) as cumulative_fees
from (SELECT *, iff(status = 'SUCCESS', '1', '0') as success,iff(status = 'FAILED', '0', '1') as failed
from bsc.core.fact_transactions)
where day >= '2022-06-22'
GROUP by 1 )
,
arbitrum_data as
(SELECT date(block_timestamp) as day, count(DISTINCT tx_hash) as total_txs, sum(success)/(sum(success)+sum(failed))*100 as percent_sucess,
avg(percent_sucess) over (order by day) as avg_sucess, sum(total_txs) over (order by day) as cumulative_txs, count(DISTINCT from_address) as daily_users,
sum(daily_users) over (order by day) as cumulative_wallets , 'arbitrum' as type, sum(tx_fee)/pow(10,6) as fees, sum(FEES) over (order by day) as cumulative_fees
from (SELECT *, iff(status = 'SUCCESS', '1', '0') as success,iff(status = 'FAILED', '0', '1') as failed
from arbitrum.core.fact_transactions)
where day >= '2022-06-22' and tx_fee < pow(10,4)
GROUP by 1 )
SELECT * FROM bsc_data
UNION ALL
SELECT * FROM arbitrum_data
-- limit 1000
Run a query to Download Data