Popex404#1 Squid Competitive Analysis - Daily Transactions
Updated 2023-04-21
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 Squid_TX_GROWTH as (
SELECT Month as date,
((Monthly_Transactions/Previous_Month)-1) *100 as squid_tx_growth_rates,
Monthly_Change as squid_tx_changes,
Monthly_Transactions as squid_daily_txs
FROM(
SELECT
date_trunc('d',block_timestamp) as Month
,count(distinct tx_hash) as Monthly_Transactions
,lag(Monthly_Transactions) OVER (ORDER BY Month) as Previous_Month
,Monthly_Transactions - Coalesce(Previous_Month,0) as Monthly_Change
from axelar.core.ez_squid
where block_timestamp >= '2023-03-01'
GROUP BY 1
ORDER BY Month ASC
)
WHERE Previous_Month != 0
and Month >= '2023-01-01'),
Thorchain_TX_GROWTH as (
SELECT Month as date,
((Monthly_Transactions/Previous_Month)-1) *100 as Thorchain_tx_growth_rates,
Monthly_Change as Thorchain_tx_changes,
Monthly_Transactions as Thorchain_daily_txs
FROM(
SELECT
date_trunc('d',block_timestamp) as Month
,count(distinct tx_id) as Monthly_Transactions
,lag(Monthly_Transactions) OVER (ORDER BY Month) as Previous_Month
,Monthly_Transactions - Coalesce(Previous_Month,0) as Monthly_Change
from thorchain.core.fact_swaps
where block_timestamp >= '2023-03-01'
GROUP BY 1
ORDER BY Month ASC
)
WHERE Previous_Month != 0
Run a query to Download Data