flipside

    Grouping txns ($SEI)
    Afonso_DiazGrouping txns ($SEI)
    Updated 2025-05-05
    with

    pricet as (
    select
    hour::date as date,
    avg(price) as token_price_usd
    from
    sei.price.ez_prices_hourly
    where
    token_address = 'usei'
    group by 1
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    -- Determine NFT collection address
    iff(
    decoded_log:consideration[0]:token != '0x0000000000000000000000000000000000000000',
    decoded_log:consideration[0]:token,
    decoded_log:offer[0]:token
    ) as collection_address,

    -- Determine buyer and seller addresses
    iff(
    collection_address = '0x0000000000000000000000000000000000000000',
    origin_from_address,
    decoded_log:consideration[0]:recipient
    ) as buyer_address,

    iff(
    collection_address != '0x0000000000000000000000000000000000000000',
    origin_from_address,
    decoded_log:consideration[0]:recipient
    Last run: 24 days ago
    SALE_CATEGORY
    TRANSACTIONS
    1
    		300 - 600 $SEI • Moderate Sale68
    2
    		60 - 300 $SEI • Small Sale1406
    3
    		600 - 3000 $SEI • Mid-Tier Sale24
    4
    		<60 $SEI • Micro Sale16224
    4
    154B
    3s