-
Notifications
You must be signed in to change notification settings - Fork 321
Open
Description
SQL:
SELECT *
FROM "read_parquet('/mnt/raid60/data_feed/basic_data/trading_calendar/year=*/data.parquet', hive_partitioning = true)"
WHERE "exchange" = 'SSE'
AND "year" >= '2023'
AND "year" <= '2023'
AND "is_trading" = true
AND "trading_day" >= '2023-01-31'
AND "trading_day" <= '2023-02-10'
ORDER BY "trading_day"But I actually need
SELECT *
FROM read_parquet('/mnt/raid60/data_feed/basic_data/trading_calendar/year=*/data.parquet', hive_partitioning = true)
WHERE "exchange" = 'SSE'
AND "year" >= '2023'
AND "year" <= '2023'
AND "is_trading" = true
AND "trading_day" >= '2023-01-31'
AND "trading_day" <= '2023-02-10'
ORDER BY "trading_day"domkm
Metadata
Metadata
Assignees
Labels
No labels