omer93lucille keys transfers
Updated 2025-02-20
99
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
›
⌄
-- 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