DATE | SELLERS | BUYERS | ASSET_BALANCE | BASE_BALANCE | BASE_USD_BALANCE | BASE_USD_VOLUME | MIN_PRICE | MAX_PRICE | TOTAL_NEW_HOLDERS | DAILY_NEW_HOLDERS | DAILY_HOLDERS_CHURN | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-01-03 00:00:00.000 | 1 | 1 | -3161.425615741 | 0.03708313173 | 119.22 | 648.18 | 0.03801013678 | 0.03814661247 | 4775 | 3 | -6 |
kliuievUFi/ETH New Trade
Updated 2025-01-27
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 UFI_ETH_OrganicVolumesAll @ https://flipsidecrypto.xyz/studio/queries/0d1a18a8-c0af-44b9-814a-db4d19772f6d
with labels as(
select *
from values
('0x16b9a82891338f9ba80e2d6970fdda79d1eb0dae', 'EXO')
as my_labels(address, label)
),
fresh_newcomers as (
select to_address as address
from (select
to_address,
min(block_timestamp)::date date
from ethereum.core.ez_token_transfers
where
block_number > 12908356
and contract_address = '0xcda4e840411c00a614ad9205caec807c7458a0e3'
group by to_address
) as f
where date > '{{start_date}}'
),
organic_sell as (
select
block_timestamp::date date,
count(distinct origin_from_address) sellers,
--sender,
sum(amount_out) base_out,
sum(amount_out_usd) usd_out,
sum(amount_in) asset_in,
min(amount_out_usd/amount_in) min_price,
max(amount_out_usd/amount_in) max_price
from ethereum.defi.ez_dex_swaps
where
block_timestamp::date >= '{{start_date}}'
Last run: 19 days ago
1
115B
10s