SELECT '2025-03-29 14:56:00' :: TIMESTAMP AS SNAPSHOT_TIME

),

honeyland_items as (

select

livequery.live.udf_api(

'https://raw.githubusercontent.com/Cyboria/honeyland/main/honeyland_items.txt'

): data as data

),

honeyland_items_call as (

SELECT

VALUE:MINT :: STRING AS MINT,

VALUE:TX_TO :: STRING AS TX_TO

FROM

(

select

*

from

honeyland_items

) response,

LATERAL FLATTEN(INPUT => PARSE_JSON(response.data))

),

honeyland_items_snapshot as (

(

SELECT

MINT,

TX_TO,

DECLARED_VARS.SNAPSHOT_TIME AS BLOCK_TIMESTAMP

FROM

honeyland_items_call,

DECLARED_VARS

)

),

honeyland_items_transfers as (

SELECT

DISTINCT ft.BLOCK_TIMESTAMP,