emilieexpress percent copy
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
›
⌄
-- forked from BlockTracker / express percent @ https://flipsidecrypto.xyz/BlockTracker/q/2LSCqjnjTVbC/express-percent
with dest as (
SELECT
date_trunc('week', a.block_timestamp) as date,
count(DISTINCT a.tx_hash)
+ count(DISTINCT b.tx_hash)
+ count(DISTINCT c.tx_hash)
+ count(DISTINCT d.tx_hash)
+ count(DISTINCT e.tx_hash)
+ count(DISTINCT f.tx_hash)
+ count(DISTINCT g.tx_hash)
as n_txs
FROM polygon.core.ez_token_transfers a
LEFT JOIN avalanche.core.ez_token_transfers b
ON date_trunc('week', a.block_timestamp) = date_trunc('week', b.block_timestamp)
LEFT JOIN ethereum.core.ez_token_transfers c
ON date_trunc('week', a.block_timestamp) = date_trunc('week', c.block_timestamp)
LEFT JOIN bsc.core.ez_token_transfers d
ON date_trunc('week', a.block_timestamp) = date_trunc('week', d.block_timestamp)
LEFT JOIN optimism.core.ez_token_transfers e
ON date_trunc('week', a.block_timestamp) = date_trunc('week', e.block_timestamp)
LEFT JOIN arbitrum.core.ez_token_transfers f
ON date_trunc('week', a.block_timestamp) = date_trunc('week', f.block_timestamp)
LEFT JOIN base.core.fact_token_transfers g
ON date_trunc('week', a.block_timestamp) = date_trunc('week', g.block_timestamp)
WHERE a.origin_from_address = '0xd36aac0c9676e984d72823fb662ce94d3ab5e551'
AND a.origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
GROUP BY 1
),
express as (
SELECT
date_trunc('week', a.block_timestamp) as date,
count(DISTINCT a.tx_hash)
+ count(DISTINCT b.tx_hash)
+ count(DISTINCT c.tx_hash)
Run a query to Download Data