SELECT

block_timestamp,

tx_hash,

ORIGIN_FROM_ADDRESS as buyer_address,

'Mint' AS event,

regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented

FROM

blast.core.ez_decoded_event_logs

WHERE

contract_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'

AND origin_function_signature = '0x1ff7712f' --mint

AND block_timestamp >= date_trunc('day', current_timestamp - interval '21 days')

),

fantasy_mints AS (

SELECT

block_timestamp,

tx_hash,

buyer_address,

utils.udf_hex_to_int(segmented [0]) AS mint_config_id --, LTRIM(segmented[1]) AS buyer

--, utils.udf_hex_to_int(segmented[2]) AS total_minted

,

utils.udf_hex_to_int(segmented [3]) AS first_id,

utils.udf_hex_to_int(segmented [4]) AS last_id,

utils.udf_hex_to_int(segmented [5]) :: decimal / 1e18 AS price

FROM

decoded_fantasy_mints --where buyer_address = '0x162f95a9364c891028d255467f616902a479681a'

) --, vrgda_mints (

--date_trunc('day', block_timestamp) AS day,count(*) VRGDA

*

fantasy_mints -- WHERE CASE WHEN price = 0 THEN 'Free'

-- WHEN price = 0.033 THEN '0.033 ETH'

-- WHEN price = 0.066 THEN '0.066 ETH'

-- ELSE 'VRGDA'