PREVIEW / futures_1hour / 2010-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-13.parquet
  size:    44 KB
  rows:    1,338

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-09-13 00:00:00	ES	Futures	1098.07	1099.05	1098.07	1098.32	669.0
2010-09-13 01:00:00	ES	Futures	1098.07	1098.56	1097.09	1097.34	1176.0
2010-09-13 02:00:00	ES	Futures	1097.34	1099.55	1097.09	1098.56	6397.0
2010-09-13 03:00:00	ES	Futures	1098.56	1099.79	1096.36	1096.85	11586.0
2010-09-13 04:00:00	ES	Futures	1097.09	1099.79	1096.85	1099.3	5627.0
2010-09-13 05:00:00	ES	Futures	1099.05	1101.26	1099.05	1099.3	7289.0
2010-09-13 06:00:00	ES	Futures	1099.05	1099.55	1098.32	1098.81	4798.0
2010-09-13 07:00:00	ES	Futures	1098.56	1099.55	1097.83	1098.07	4639.0
2010-09-13 08:00:00	ES	Futures	1098.32	1099.05	1096.85	1097.34	13780.0
2010-09-13 09:00:00	ES	Futures	1097.34	1101.51	1097.09	1098.81	67301.0
2010-09-13 10:00:00	ES	Futures	1098.81	1103.23	1098.56	1101.75	69258.0
2010-09-13 11:00:00	ES	Futures	1101.51	1102.0	1098.81	1100.04	34238.0
2010-09-13 12:00:00	ES	Futures	1100.28	1100.28	1095.13	1097.09	32757.0
2010-09-13 13:00:00	ES	Futures	1097.09	1099.05	1096.36	1097.34	13307.0
2010-09-13 14:00:00	ES	Futures	1097.34	1099.55	1095.86	1099.3	20265.0
2010-09-13 15:00:00	ES	Futures	1099.3	1102.24	1097.83	1101.02	43711.0
2010-09-13 16:00:00	ES	Futures	1101.02	1102.0	1100.04	1101.75	16858.0
2010-09-13 17:00:00	ES	Futures	1101.51	1103.72	1101.51	1102.98	908.0
2010-09-13 18:00:00	ES	Futures	1102.74	1103.47	1101.75	1102.24	560.0
2010-09-13 19:00:00	ES	Futures	1102.24	1102.49	1101.26	1101.26	490.0
2010-09-13 20:00:00	ES	Futures	1101.26	1101.26	1099.55	1100.04	1569.0
2010-09-13 21:00:00	ES	Futures	1100.28	1101.51	1099.79	1100.28	791.0
2010-09-13 22:00:00	ES	Futures	1100.28	1100.53	1099.79	1100.53	325.0
2010-09-13 23:00:00	ES	Futures	1100.53	1101.02	1099.79	1100.28	579.0
2010-09-13 00:00:00	NQ	Futures	2187.65	2188.22	2187.07	2187.65	48.0
2010-09-13 01:00:00	NQ	Futures	2187.65	2188.22	2184.78	2187.07	115.0
2010-09-13 02:00:00	NQ	Futures	2187.36	2190.8	2186.5	2188.22	399.0
2010-09-13 03:00:00	NQ	Futures	2188.22	2190.51	2183.63	2185.35	1055.0
2010-09-13 04:00:00	NQ	Futures	2185.64	2190.22	2185.35	2188.79	432.0
2010-09-13 05:00:00	NQ	Futures	2189.08	2191.94	2187.93	2188.22	388.0
2010-09-13 06:00:00	NQ	Futures	2188.22	2188.22	2185.93	2187.07	238.0
2010-09-13 07:00:00	NQ	Futures	2187.07	2187.93	2184.49	2185.35	237.0
2010-09-13 08:00:00	NQ	Futures	2185.64	2186.79	2181.91	2182.2	711.0
2010-09-13 09:00:00	NQ	Futures	2182.2	2200.25	2182.2	2193.38	11130.0
2010-09-13 10:00:00	NQ	Futures	2192.8	2204.84	2192.8	2201.97	6960.0
2010-09-13 11:00:00	NQ	Futures	2201.69	2203.69	2198.25	2200.25	5868.0
2010-09-13 12:00:00	NQ	Futures	2200.25	2200.25	2191.66	2193.95	5318.0
2010-09-13 13:00:00	NQ	Futures	2194.24	2198.82	2193.09	2195.96	3601.0
2010-09-13 14:00:00	NQ	Futures	2196.53	2200.54	2192.52	2199.11	3101.0
2010-09-13 15:00:00	NQ	Futures	2199.39	2206.84	2195.96	2201.69	7162.0
2010-09-13 16:00:00	NQ	Futures	2201.97	2202.55	2197.96	2199.97	2229.0
2010-09-13 17:00:00	NQ	Futures	2201.4	2204.84	2201.4	2202.83	69.0
2010-09-13 18:00:00	NQ	Futures	2203.41	2204.27	2203.41	2203.69	44.0
2010-09-13 19:00:00	NQ	Futures	2201.97	2202.55	2200.25	2200.25	26.0
2010-09-13 20:00:00	NQ	Futures	2200.25	2200.25	2198.25	2198.25	42.0
2010-09-13 21:00:00	NQ	Futures	2199.11	2200.54	2198.25	2198.53	43.0
2010-09-13 22:00:00	NQ	Futures	2198.53	2198.82	2197.67	2198.53	19.0
2010-09-13 23:00:00	NQ	Futures	2199.68	2199.68	2198.25	2199.11	8.0
2010-09-13 00:00:00	YM	Futures	9980.0	9984.8	9979.1	9980.0	102.0
2010-09-13 01:00:00	YM	Futures	9980.0	9980.0	9969.5	9972.4	170.0

> showing 50 of 1,338 rows — these rows as CSV

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