omer93lucille keys transfers
    Updated 2025-02-20
    -- meva compra https://seitrace.com/tx/0x9d7f291f365e2f60da018ed26d1b87dd80c4dfc0aeeaca6327772725c20e46f0?chain=pacific-1
    -- compra + d'1 https://seitrace.com/tx/0x59c362bda0db6848d3a22aab8eedf2e7976505fb97c734dc3b351a1a8f399abf?chain=pacific-1
    -- possible mint/airdrop https://seitrace.com/tx/0xed966e6cc77878eaa422f25bab1152acfa23a6b6fef0571952102747138f19ec?chain=pacific-1

    with
    receivers as (
    select distinct origin_from_address as wallet,
    min(trunc(block_timestamp,'hour')) as first_transfer,
    sum(TO_NUMBER(RIGHT(data, 1), 'X')) as nfts_received
    from sei.core_evm.fact_event_logs where contract_address='0x5d84c391bc1ed4df4210a94308074aa77d177d52' and origin_function_signature='0xf242432a' and origin_from_address!=lower('0xafdbbc92bA9Ede800B63A7eC5F4e8Bf2c9381541') and tx_status='SUCCESS' --transfer
    group by 1
    )
    select trunc(block_timestamp,'hour') as date,
    count(distinct origin_from_address) as transferers,
    count(distinct wallet) as new_transferers,
    sum(new_transferers) over (order by date) as total_transferers,
    round(count(distinct tx_hash)*avg(nfts_received)) as nfts_transferred,
    sum(nfts_transferred) over (order by date) as total_nfts_transferred,
    avg(nfts_received) as avg_nfts_transferred_per_wallet
    from sei.core_evm.fact_event_logs fel
    join receivers r on trunc(block_timestamp,'hour')=first_transfer
    where contract_address='0x5d84c391bc1ed4df4210a94308074aa77d177d52' and origin_function_signature='0xf242432a' and origin_from_address!=lower('0xafdbbc92bA9Ede800B63A7eC5F4e8Bf2c9381541') and tx_status='SUCCESS' --airdrop
    group by 1 order by 1 desc



    -- select * from sei.core_evm.fact_event_logs where contract_address='0x5d84c391bc1ed4df4210a94308074aa77d177d52' and origin_function_signature='0xf242432a' and origin_from_address!=lower('0xafdbbc92bA9Ede800B63A7eC5F4e8Bf2c9381541') and tx_status='SUCCESS' --transfer
    -- agafar lultim caracter de data per saber quants en trasnfereix




    --per compres:
    -- select * from sei.core_evm.fact_event_logs --where tx_hash='0x308e00f398f05cb80e1188bde0ea45c83f471a07ac2b7783b979a859443947f8'
    -- where topics[1]='0x0000000000000000000000002052f8a2ff46283b30084e5d84c89a2fdbe7f74b' and contract_address='0x5d84c391bc1ed4df4210a94308074aa77d177d52' and tx_status='SUCCESS' and origin_function_signature='0xe7acab24'
    -- agafar lultim caracter de data per saber quants en compra
    QueryRunArchived: QueryRun has been archived