hessCustom Wallet Tracker
    Updated 2023-07-04
    with tb1 as ( select trunc(block_timestamp,'day') as day,
    label,
    count(DISTINCT tx_id) as sales,
    count(DISTINCT purchaser) as buyers,
    sum(sales_amount) as sol_amount,
    avg(sales_amount) as avg_price,
    max(sales_amount) as Max_buy_amount,
    min(sales_amount) as min_amount,
    median(sales_amount) as median_amount
    from solana.core.fact_nft_sales a join solana.core.dim_labels b on a.mint = b.address
    where succeeded = 'true'
    and label is not null
    group by 1,2)
    ,
    tb2 as ( select trunc(recorded_hour,'day') as day,
    avg(close) as price
    from solana.core.fact_token_prices_hourly
    where symbol = 'SOL'
    group by 1)
    ,
    tb3 as ( select a.day,
    label,
    sol_amount,
    sol_amount*price as volume
    from tb1 a join tb2 b on a.day = b.day)
    ,
    tb4 as ( select day,
    sum(volume) as volume_on_solana
    from tb3
    group by 1)
    ,
    tb5 as ( select trunc(block_timestamp,'day') as day,
    sum(price_usd) as volume_on_ethereum
    from ethereum.core.ez_nft_sales
    where price_usd < 1000000
    and price_usd > 0
    Run a query to Download Data