PREVIEW / futures_1hour / 2010-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-12-31.parquet
  size:    31 KB
  rows:    853

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-12-31 00:00:00	ES	Futures	1242.58	1242.83	1242.33	1242.58	318.0
2010-12-31 01:00:00	ES	Futures	1242.58	1243.32	1242.58	1243.32	1327.0
2010-12-31 02:00:00	ES	Futures	1243.07	1243.32	1242.33	1242.83	636.0
2010-12-31 03:00:00	ES	Futures	1242.83	1243.07	1242.08	1242.58	2092.0
2010-12-31 04:00:00	ES	Futures	1242.83	1242.83	1241.34	1241.84	2086.0
2010-12-31 05:00:00	ES	Futures	1242.08	1242.33	1240.6	1240.85	5105.0
2010-12-31 06:00:00	ES	Futures	1240.85	1240.85	1240.1	1240.35	4095.0
2010-12-31 07:00:00	ES	Futures	1240.6	1240.6	1238.62	1238.62	8447.0
2010-12-31 08:00:00	ES	Futures	1238.87	1239.11	1237.14	1238.62	16496.0
2010-12-31 09:00:00	ES	Futures	1238.62	1239.86	1236.64	1237.88	90745.0
2010-12-31 10:00:00	ES	Futures	1237.63	1240.6	1236.89	1240.6	63461.0
2010-12-31 11:00:00	ES	Futures	1240.6	1241.09	1239.86	1241.09	31956.0
2010-12-31 12:00:00	ES	Futures	1240.85	1242.08	1239.61	1240.6	54470.0
2010-12-31 13:00:00	ES	Futures	1240.6	1241.84	1240.35	1240.85	33724.0
2010-12-31 14:00:00	ES	Futures	1241.09	1242.08	1240.35	1241.34	37590.0
2010-12-31 15:00:00	ES	Futures	1241.59	1241.84	1238.37	1241.34	181460.0
2010-12-31 16:00:00	ES	Futures	1241.59	1244.81	1241.09	1244.56	122364.0
2010-12-31 00:00:00	NQ	Futures	2556.31	2557.46	2556.31	2557.46	37.0
2010-12-31 01:00:00	NQ	Futures	2557.75	2558.61	2556.6	2557.46	80.0
2010-12-31 02:00:00	NQ	Futures	2557.46	2558.03	2556.6	2556.6	32.0
2010-12-31 03:00:00	NQ	Futures	2556.89	2557.75	2555.74	2556.31	218.0
2010-12-31 04:00:00	NQ	Futures	2556.89	2557.46	2554.01	2554.01	267.0
2010-12-31 05:00:00	NQ	Futures	2554.88	2555.16	2552.58	2553.73	199.0
2010-12-31 06:00:00	NQ	Futures	2553.44	2554.3	2552.58	2552.87	191.0
2010-12-31 07:00:00	NQ	Futures	2552.87	2552.87	2551.43	2551.72	365.0
2010-12-31 08:00:00	NQ	Futures	2552.01	2553.15	2550.57	2552.29	1758.0
2010-12-31 09:00:00	NQ	Futures	2552.58	2554.01	2534.5	2539.66	30977.0
2010-12-31 10:00:00	NQ	Futures	2539.66	2540.81	2535.64	2540.52	14390.0
2010-12-31 11:00:00	NQ	Futures	2540.52	2542.25	2539.09	2539.95	8689.0
2010-12-31 12:00:00	NQ	Futures	2539.66	2541.67	2537.08	2539.09	6563.0
2010-12-31 13:00:00	NQ	Futures	2539.09	2543.39	2538.51	2541.1	5275.0
2010-12-31 14:00:00	NQ	Futures	2541.39	2543.39	2540.52	2543.11	3577.0
2010-12-31 15:00:00	NQ	Futures	2543.39	2546.26	2539.09	2546.26	17036.0
2010-12-31 16:00:00	NQ	Futures	2546.26	2553.73	2544.26	2553.73	8921.0
2010-12-31 00:00:00	YM	Futures	11040.4	11042.3	11039.4	11042.3	8.0
2010-12-31 01:00:00	YM	Futures	11042.3	11047.1	11041.3	11045.1	72.0
2010-12-31 02:00:00	YM	Futures	11044.2	11046.1	11041.3	11044.2	43.0
2010-12-31 03:00:00	YM	Futures	11045.1	11045.1	11037.5	11037.5	50.0
2010-12-31 04:00:00	YM	Futures	11040.4	11040.4	11027.9	11028.9	123.0
2010-12-31 05:00:00	YM	Futures	11033.7	11036.5	11024.1	11031.7	142.0
2010-12-31 06:00:00	YM	Futures	11028.9	11031.7	11021.2	11024.1	203.0
2010-12-31 07:00:00	YM	Futures	11024.1	11024.1	11014.5	11015.5	211.0
2010-12-31 08:00:00	YM	Futures	11015.5	11015.5	10999.2	11008.8	388.0
2010-12-31 09:00:00	YM	Futures	11008.8	11016.4	10988.6	10992.5	5740.0
2010-12-31 10:00:00	YM	Futures	10992.5	11022.2	10982.9	11020.2	5251.0
2010-12-31 11:00:00	YM	Futures	11020.2	11029.8	11016.4	11025.0	1739.0
2010-12-31 12:00:00	YM	Futures	11024.1	11050.9	11023.1	11034.6	5302.0
2010-12-31 13:00:00	YM	Futures	11033.7	11041.3	11028.9	11033.7	941.0
2010-12-31 14:00:00	YM	Futures	11033.7	11036.5	11027.9	11031.7	837.0
2010-12-31 15:00:00	YM	Futures	11030.8	11040.4	11014.5	11039.4	6107.0

> showing 50 of 853 rows — these rows as CSV

> unlock the full archive -- $79 one-time