'Mint' as action,

a.block_timestamp,

a.tx_hash,

a.origin_function_signature,

a.origin_from_address,

a.event_index,

concat('0x', substr(topics[2],27,40)) as user,

livequery.utils.udf_hex_to_int(SUBSTR(topics[3], 3, 64)) :: int as tokenID,

b.value as eth_value

from blast.core.fact_event_logs a

join blast.core.fact_transactions b using(tx_hash, block_timestamp)

where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- token transfer -- here "nft transfer"

and contract_address = '0xd641dde60985fab88c623188adba6be3148288d9'

and concat('0x', substr(topics[1],27,40)) = '0x0000000000000000000000000000000000000000'

select

user as minter_address,

count(tokenid) as number_of_items,

ARRAY_AGG(tokenid) as "Items_collect[tokenId]"

from mint_data

WHERE block_timestamp < '2024-03-04'

group by 1

order by 2 desc