PREVIEW / futures_1hour / 2011-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-22.parquet
  size:    49 KB
  rows:    1,470

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
2011-11-22 00:00:00	ES	Futures	1199.12	1200.13	1197.37	1199.63	5471.0
2011-11-22 01:00:00	ES	Futures	1199.63	1200.13	1196.87	1198.12	4638.0
2011-11-22 02:00:00	ES	Futures	1198.37	1200.38	1197.62	1199.12	9732.0
2011-11-22 03:00:00	ES	Futures	1198.87	1202.38	1196.87	1199.38	49091.0
2011-11-22 04:00:00	ES	Futures	1199.63	1200.13	1193.86	1194.36	37363.0
2011-11-22 05:00:00	ES	Futures	1194.61	1200.13	1193.86	1199.12	25764.0
2011-11-22 06:00:00	ES	Futures	1199.38	1202.64	1198.37	1200.88	31118.0
2011-11-22 07:00:00	ES	Futures	1200.88	1201.88	1194.86	1196.62	44071.0
2011-11-22 08:00:00	ES	Futures	1196.62	1197.12	1187.59	1190.85	115202.0
2011-11-22 09:00:00	ES	Futures	1190.6	1198.12	1189.35	1195.11	225530.0
2011-11-22 10:00:00	ES	Futures	1195.36	1196.87	1185.08	1186.84	352002.0
2011-11-22 11:00:00	ES	Futures	1186.84	1188.84	1182.83	1186.84	313167.0
2011-11-22 12:00:00	ES	Futures	1186.84	1196.12	1186.34	1195.11	325317.0
2011-11-22 13:00:00	ES	Futures	1194.86	1198.87	1192.35	1193.11	171433.0
2011-11-22 14:00:00	ES	Futures	1193.11	1194.61	1187.84	1189.35	141133.0
2011-11-22 15:00:00	ES	Futures	1189.35	1192.35	1187.59	1189.35	264251.0
2011-11-22 16:00:00	ES	Futures	1189.35	1189.85	1183.58	1186.34	110960.0
2011-11-22 17:00:00	ES	Futures	1186.59	1186.84	1185.83	1186.59	2055.0
2011-11-22 18:00:00	ES	Futures	1187.09	1188.59	1184.58	1187.84	7524.0
2011-11-22 19:00:00	ES	Futures	1187.59	1187.84	1184.58	1185.33	5458.0
2011-11-22 20:00:00	ES	Futures	1185.33	1186.09	1172.29	1175.3	34118.0
2011-11-22 21:00:00	ES	Futures	1175.3	1176.06	1170.29	1173.55	29606.0
2011-11-22 22:00:00	ES	Futures	1173.55	1176.06	1171.29	1173.05	16160.0
2011-11-22 23:00:00	ES	Futures	1172.8	1174.55	1171.79	1173.3	5563.0
2011-11-22 00:00:00	NQ	Futures	2562.9	2564.63	2558.57	2562.9	402.0
2011-11-22 01:00:00	NQ	Futures	2562.61	2563.76	2557.13	2559.44	594.0
2011-11-22 02:00:00	NQ	Futures	2559.15	2562.61	2554.25	2555.69	1591.0
2011-11-22 03:00:00	NQ	Futures	2555.69	2557.42	2544.16	2549.92	6938.0
2011-11-22 04:00:00	NQ	Futures	2549.92	2551.08	2540.12	2541.27	2857.0
2011-11-22 05:00:00	NQ	Futures	2541.27	2552.52	2540.12	2551.08	1726.0
2011-11-22 06:00:00	NQ	Futures	2551.37	2557.13	2548.77	2554.54	1992.0
2011-11-22 07:00:00	NQ	Futures	2554.54	2556.56	2544.16	2548.48	3521.0
2011-11-22 08:00:00	NQ	Futures	2548.48	2549.35	2532.05	2538.68	10763.0
2011-11-22 09:00:00	NQ	Futures	2538.68	2560.02	2537.24	2554.54	36692.0
2011-11-22 10:00:00	NQ	Futures	2554.25	2557.71	2530.03	2533.78	40258.0
2011-11-22 11:00:00	NQ	Futures	2533.78	2540.7	2526.57	2539.54	31648.0
2011-11-22 12:00:00	NQ	Futures	2539.83	2556.27	2539.54	2555.98	36476.0
2011-11-22 13:00:00	NQ	Futures	2556.56	2564.63	2551.37	2556.56	19981.0
2011-11-22 14:00:00	NQ	Futures	2556.56	2560.59	2550.21	2552.52	18748.0
2011-11-22 15:00:00	NQ	Futures	2552.81	2561.46	2547.62	2555.98	34450.0
2011-11-22 16:00:00	NQ	Futures	2555.69	2556.84	2547.33	2553.67	9444.0
2011-11-22 17:00:00	NQ	Futures	2553.38	2553.96	2552.81	2553.38	167.0
2011-11-22 18:00:00	NQ	Futures	2553.96	2556.56	2550.79	2555.98	356.0
2011-11-22 19:00:00	NQ	Futures	2555.98	2555.98	2550.79	2552.52	681.0
2011-11-22 20:00:00	NQ	Futures	2553.38	2553.67	2529.45	2532.62	3197.0
2011-11-22 21:00:00	NQ	Futures	2532.05	2534.93	2522.24	2528.59	3080.0
2011-11-22 22:00:00	NQ	Futures	2528.59	2533.49	2525.13	2527.72	1413.0
2011-11-22 23:00:00	NQ	Futures	2527.72	2532.34	2526.28	2528.01	577.0
2011-11-22 00:00:00	YM	Futures	11372.7	11380.5	11356.9	11375.6	647.0
2011-11-22 01:00:00	YM	Futures	11374.6	11380.5	11350.0	11360.8	656.0

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

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