CryptoIcicleFlow-3.Flow vs L1s
Updated 2022-05-29
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
›
⌄
-- Payout 37.31 FLOW
-- Grand Prize 111.94 FLOW
-- Level Intermediate
-- Q3. Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand.
-- Visualize these metrics over time since May 9th.
-- 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
-- How does Flow compare to these other chains and how do you think it will trend over time?
with
flow_txns as (
select
e.block_timestamp::date as date,
count(distinct e.tx_id) as n_txns,
0 as fee, -- txns are free currently
count(distinct t.proposer) as n_wallets
from flow.core.fact_events e join flow.core.fact_transactions t on e.tx_id = t.tx_id
where e.block_timestamp >= '2022-05-09'
group by date
),
algo_txns as (
select
block_timestamp::date as date,
count(distinct tx_id) as n_txns,
sum(fee * 0.37) as fee,
count(distinct sender) as n_wallets
from flipside_prod_db.algorand.transactions
where block_timestamp >= '2022-05-09'
group by date
),
solana_txns as (
select
Run a query to Download Data