0xHaM-dFlow vs Other L1s Pt (II)
Updated 2022-07-19
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
›
⌄
-- this code coped and edited from @nits2k dashboards
with flow_txs as (
SELECT count(DISTINCT proposer)as flow_transactors from flow.core.fact_transactions
where block_Timestamp >= CURRENT_DATE - 91
)
, flow_swaps as (
SELECT count(DISTINCT trader)as flow_swappers from flow.core.fact_swaps
where block_Timestamp >= CURRENT_DATE - 91
)
, flow_nft_sales as (
SELECT count(DISTINCT buyer)as flow_nft_buyers from flow.core.fact_nft_sales
where block_Timestamp >= CURRENT_DATE - 91
)
,flow as (
SELECT *,flow_swappers/flow_transactors*100 as percent_swappers_flow ,flow_nft_buyers/flow_transactors*100 as percent_nft_buyer_flow
from flow_nft_sales,flow_swaps, flow_txs
)
,sol_txs as (
SELECT count(DISTINCT b.value)as sol_transactors from solana.core.fact_transactions, lateral flatten(input => SIGNERS) b
where block_Timestamp >= CURRENT_DATE - 91
)
,sol_swaps as (
SELECT count(DISTINCT swapper)as sol_swappers from solana.core.fact_swaps
where block_Timestamp >= CURRENT_DATE - 91
)
,sol_nft_sales as (
SELECT count(DISTINCT purchaser)as sol_nft_buyers from solana.core.fact_nft_sales
where block_Timestamp >= CURRENT_DATE - 91
)
,solana as (
SELECT *,sol_swappers/sol_transactors*100 as percent_swappers_sol ,sol_nft_buyers/sol_transactors*100 as percent_nft_buyer_sol
from sol_nft_sales,sol_swaps, sol_txs
)
,eth_txs as (
SELECT count(DISTINCT from_address) as eth_transactors from ethereum.core.fact_transactions
where block_Timestamp >= CURRENT_DATE - 91
Run a query to Download Data