Notes.txt

select (to_timestamp(timestamp/1000))::date, * from candle where exchange = 'Binance Perpetual Futures' and symbol = 'DOGE-USDT' order by timestamp asc limit 1;