nat_nomadROUTERS SHARE - ETH (monthly) test
Updated 2023-04-18
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 ROUTERS SHARE - ETH (daily) test @ https://flipsidecrypto.xyz/edit/queries/a82fb0a1-8216-401e-a836-ad4c20170509
WITH routers AS (
SELECT *
FROM VALUES
--update 2023-02-24
('ethereum', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45', 'Uniswap', 'Router'),
('ethereum', '0x7a250d5630b4cf539739df2c5dacb4c659f2488d', 'Uniswap', 'Router'),
('ethereum', '0xe592427a0aece92de3edee1f18e0157c05861564', 'Uniswap', 'Router'),
('ethereum', '0xf164fc0ec4e93095b804a4795bbe1e041497b92a', 'Uniswap', 'Router'),
('ethereum', '0x1111111254fb6c44bac0bed2854e76f90643097d', '1inch', 'Aggregator'),
('ethereum', '0x1111111254eeb25477b68fb85ed929f73a960582', '1inch', 'Aggregator'),
('ethereum', '0x11111112542d85b3ef69ae05771c2dccff4faa26', '1inch', 'Aggregator'),
('ethereum', '0xe66b31678d6c16e9ebf358268a790b763c133750', 'ZeroEx', 'Aggregator'),
('ethereum', '0xdef1c0ded9bec7f1a1670819833240f027b25eff', 'ZeroEx', 'Aggregator')
AS data(blockchain, address, project, contract_type)
),
incorrect_tokens AS (
SELECT *
FROM VALUES
('0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4'),
('0x35a18000230da775cac24873d00ff85bccded550'),
('0x5d3a536e4d6dbd6114cc1ead35777bab948e3643')
AS date(token_address)
)
SELECT
DATE_TRUNC('month', block_timestamp) AS time,
project_agg AS project,
SUM(usd_amount) AS volume,
COUNT(*) AS txs,
COUNT(DISTINCT tx_from) AS wallets
FROM (
SELECT
r.*,
Run a query to Download Data