PREVIEW / futures_1hour / 2011-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-11.parquet
  size:    48 KB
  rows:    1,448

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-10-11 00:00:00	ES	Futures	1191.1	1191.6	1190.6	1191.35	3260.0
2011-10-11 01:00:00	ES	Futures	1191.6	1193.86	1191.35	1191.85	7777.0
2011-10-11 02:00:00	ES	Futures	1192.1	1193.86	1188.59	1189.09	17606.0
2011-10-11 03:00:00	ES	Futures	1189.09	1193.86	1188.34	1189.85	52530.0
2011-10-11 04:00:00	ES	Futures	1189.85	1190.1	1184.58	1186.34	41939.0
2011-10-11 05:00:00	ES	Futures	1186.09	1188.34	1185.08	1187.59	41608.0
2011-10-11 06:00:00	ES	Futures	1187.59	1190.6	1185.83	1189.35	17096.0
2011-10-11 07:00:00	ES	Futures	1189.35	1192.35	1187.84	1188.09	23727.0
2011-10-11 08:00:00	ES	Futures	1188.34	1190.35	1184.33	1186.84	56249.0
2011-10-11 09:00:00	ES	Futures	1186.84	1192.35	1184.83	1190.1	256552.0
2011-10-11 10:00:00	ES	Futures	1189.85	1198.37	1187.09	1194.61	364905.0
2011-10-11 11:00:00	ES	Futures	1194.86	1197.12	1191.1	1196.12	212286.0
2011-10-11 12:00:00	ES	Futures	1196.12	1197.62	1190.35	1193.36	136060.0
2011-10-11 13:00:00	ES	Futures	1193.36	1197.12	1189.85	1196.87	153543.0
2011-10-11 14:00:00	ES	Futures	1196.87	1197.37	1190.35	1193.11	156650.0
2011-10-11 15:00:00	ES	Futures	1193.11	1197.37	1192.35	1194.61	279654.0
2011-10-11 16:00:00	ES	Futures	1194.61	1195.61	1188.59	1189.35	92304.0
2011-10-11 17:00:00	ES	Futures	1189.09	1191.6	1188.34	1190.85	4501.0
2011-10-11 18:00:00	ES	Futures	1190.6	1190.85	1189.09	1189.6	3314.0
2011-10-11 19:00:00	ES	Futures	1189.85	1190.35	1188.34	1188.84	5391.0
2011-10-11 20:00:00	ES	Futures	1188.84	1190.1	1185.83	1187.09	11078.0
2011-10-11 21:00:00	ES	Futures	1186.84	1187.34	1184.33	1186.34	11474.0
2011-10-11 22:00:00	ES	Futures	1186.34	1189.09	1185.83	1188.34	7961.0
2011-10-11 23:00:00	ES	Futures	1188.34	1190.35	1187.59	1188.84	6570.0
2011-10-11 00:00:00	NQ	Futures	2618.54	2619.41	2617.39	2619.41	299.0
2011-10-11 01:00:00	NQ	Futures	2619.7	2623.73	2619.7	2621.43	834.0
2011-10-11 02:00:00	NQ	Futures	2621.14	2625.75	2615.66	2617.68	1633.0
2011-10-11 03:00:00	NQ	Futures	2617.39	2627.48	2615.66	2619.7	4957.0
2011-10-11 04:00:00	NQ	Futures	2619.41	2619.41	2609.03	2613.07	3903.0
2011-10-11 05:00:00	NQ	Futures	2612.49	2616.81	2609.32	2615.95	3212.0
2011-10-11 06:00:00	NQ	Futures	2615.95	2620.27	2611.34	2618.54	1587.0
2011-10-11 07:00:00	NQ	Futures	2618.26	2626.04	2617.1	2617.39	2641.0
2011-10-11 08:00:00	NQ	Futures	2617.97	2624.31	2611.62	2617.39	4761.0
2011-10-11 09:00:00	NQ	Futures	2617.68	2630.65	2612.2	2625.46	39060.0
2011-10-11 10:00:00	NQ	Futures	2625.18	2648.24	2619.7	2639.59	42229.0
2011-10-11 11:00:00	NQ	Futures	2639.59	2646.51	2634.11	2643.63	24939.0
2011-10-11 12:00:00	NQ	Futures	2643.63	2646.51	2630.94	2637.0	19730.0
2011-10-11 13:00:00	NQ	Futures	2637.0	2646.8	2629.5	2646.51	20799.0
2011-10-11 14:00:00	NQ	Futures	2646.8	2647.38	2631.81	2640.46	24096.0
2011-10-11 15:00:00	NQ	Futures	2640.17	2648.24	2633.83	2640.75	36125.0
2011-10-11 16:00:00	NQ	Futures	2640.46	2643.34	2632.38	2633.83	6993.0
2011-10-11 17:00:00	NQ	Futures	2633.25	2637.0	2630.65	2635.84	323.0
2011-10-11 18:00:00	NQ	Futures	2635.27	2635.27	2632.1	2633.83	205.0
2011-10-11 19:00:00	NQ	Futures	2632.38	2634.4	2630.94	2632.38	337.0
2011-10-11 20:00:00	NQ	Futures	2632.38	2632.38	2625.18	2627.19	1234.0
2011-10-11 21:00:00	NQ	Futures	2626.62	2628.06	2623.16	2628.06	727.0
2011-10-11 22:00:00	NQ	Futures	2628.06	2633.83	2627.19	2632.38	711.0
2011-10-11 23:00:00	NQ	Futures	2632.1	2636.42	2631.81	2633.54	385.0
2011-10-11 00:00:00	YM	Futures	11165.9	11170.8	11163.9	11167.9	212.0
2011-10-11 01:00:00	YM	Futures	11167.9	11190.5	11167.9	11177.7	608.0

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

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