SELECT
date,
symbol,
PARSE_JSON(TOKEN_DATA):holders AS holders,
PARSE_JSON(TOKEN_DATA):onchain_market_cap AS onchain_market_cap,
PARSE_JSON(TOKEN_DATA):transfers AS transfers,
PARSE_JSON(TOKEN_DATA):volume_24h AS volume_24h
from near.core.fact_token_metadata
WHERE symbol='USDC'