SocioCryptoExpressed vs. regular transactions over time
Updated 2023-10-26
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
›
⌄
-- forked from Expressed vs. regular transactions by chain @ https://flipsidecrypto.xyz/edit/queries/b6a881a3-c81f-4ceb-b509-c5c71009896d
with base_m as(
SELECT
a.date,
coalesce(expressed_txs,0)as n_express,
coalesce(n_txs,0) as txs
FROM (
SELECT
date_trunc('week', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txs
FROM base.core.fact_token_transfers
WHERE origin_from_address = '0xd36aac0c9676e984d72823fb662ce94d3ab5e551'
AND origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
GROUP BY 1 ) a
LEFT JOIN (
SELECT
date_trunc('week', block_timestamp) as date,
count(DISTINCT tx_hash) as expressed_txs
FROM base.core.fact_token_transfers
WHERE origin_from_address = '0xe743a49f04f2f77eb2d3b753ae3ad599de8cea84'
AND origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
GROUP BY 1
) b ON a.date = b.date
)
,
arbitrum_m as (
SELECT
a.date,
coalesce(expressed_txs,0)as n_express,
coalesce(n_txs,0) as txs
FROM (
SELECT
date_trunc('week', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txs
FROM arbitrum.core.ez_token_transfers
Run a query to Download Data