kliuievUFi/ETH New Trade
    Updated 2025-01-27
    -- 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
    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.00011-3161.4256157410.03708313173119.22648.180.038010136780.0381466124747753-6
    1
    115B
    10s