Query editor
WITH params AS (SELECTCAST('{{start_date}}' AS DATE) AS start_date,LEAST(CAST('{{end_date}}' AS DATE), CURRENT_DATE) AS end_date)SELECTCAST(q.day AS DATE) AS day,CAST(q.provider AS VARCHAR) AS provider,CAST(q.blockchain AS VARCHAR) AS blockchain,CAST(q.token_address AS VARCHAR) AS token_address,CAST(q.symbol AS VARCHAR) AS symbol,CAST(q.asset_name AS VARCHAR) AS asset_name,CAST(q.circulating_supply_units AS DOUBLE) AS circulating_supply_units,CAST(q.price_usd AS DOUBLE) AS price_usd,CAST(q.aum_usd AS DOUBLE) AS aum_usd,CAST(q.pricing_source AS VARCHAR) AS pricing_source,CAST(q.supply_source AS VARCHAR) AS supply_source,CAST(q.snapshot_method AS VARCHAR) AS snapshot_methodFROM dune.buccaneers.result_tokenized_stocks_asset_state_daily_v01 qCROSS JOIN params pWHERE CAST(q.day AS DATE) BETWEEN p.start_date AND p.end_date