WITH all_nft_holders AS (
SELECT
DISTINCT TX_FROM AS nft_holders
FROM
osmosis.core.fact_transactions
WHERE
MSGS[14].attributes[2].value = lower('osmo1mrl3lug3cr5ltcutlpj2m8vqgcsw3fw94jysgcctyukdunnrmjhs8cacrf')
AND
BLOCK_TIMESTAMP >= '2024-04-16'
)
SELECT
DATE,
BALANCE/1000000 AS balance,
ADDRESS AS holders
FROM
osmosis.core.fact_daily_balances
WHERE
ADDRESS IN (SELECT nft_holders FROM all_nft_holders)
AND
CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
AND
DATE >= CURRENT_DATE