okay_bears AS (

SELECT

ADDRESS AS MINT

FROM

solana.core.dim_labels

WHERE

label = 'okay bears'

),

okay_bears_mint AS (

SELECT

BLOCK_TIMESTAMP,

MINT,

PURCHASER

FROM

solana.core.fact_nft_mints

WHERE

BLOCK_TIMESTAMP >= '2022-04-26'

AND BLOCK_TIMESTAMP <= '2022-04-27'

AND MINT IN (

SELECT

MINT

FROM

okay_bears

)

),

okay_bears_mint_edited AS (

SELECT

BLOCK_TIMESTAMP,

MINT,

PURCHASER AS TX_TO

FROM

okay_bears_mint

),

okay_bears_transfers as (

SELECT