theericstoneERC20 Non-exchange Volume
Updated 2022-01-24
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
›
⌄
WITH condeets AS (
SELECT contract_address, symbol, name FROM(
SELECT
cmc.token_address AS contract_address,
cmc.name,
cmc.symbol,
AVG(price.market_cap) AS mean_mcap,
AVG(price.volume) AS mean_vol
FROM
public.daily_candles price JOIN
public.cmc_assets cmc
ON cmc.asset_id = price.asset_id
WHERE
cmc.token_address IS NOT NULL
AND price.recorded_at > getdate() - INTERVAL '7 days'
GROUP BY 1,2,3
) contracts
WHERE mean_mcap > 1000000 OR mean_vol > 10000000
)
SELECT
ee.contract_address,
condeets.symbol,
condeets.name,
date_trunc('day',block_timestamp) AS date,
sum(amount_usd) AS usd_sent,
sum(amount) AS amount_sent,
count( DISTINCT from_address) AS n_senders
FROM gold.ethereum_events ee JOIN
condeets on condeets.contract_address = ee.contract_address
WHERE
((from_label_type <> 'distributor' OR from_label_type IS NULL)
OR (to_label_type <> 'distributor' OR to_label_type IS NULL))
AND ee.contract_address IS NOT NULL
AND block_timestamp > getdate() - INTERVAL '7 days'
AND amount > 0
Run a query to Download Data