PREVIEW / futures_1hour / 2012-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-05.parquet
  size:    46 KB
  rows:    1,463

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
2012-11-05 00:00:00	ES	Futures	1438.77	1440.05	1438.52	1439.28	2737.0
2012-11-05 01:00:00	ES	Futures	1439.28	1439.54	1438.26	1438.77	2123.0
2012-11-05 02:00:00	ES	Futures	1438.52	1439.54	1436.73	1437.24	6840.0
2012-11-05 03:00:00	ES	Futures	1437.24	1438.26	1434.43	1436.22	30140.0
2012-11-05 04:00:00	ES	Futures	1435.96	1437.49	1435.2	1435.2	13618.0
2012-11-05 05:00:00	ES	Futures	1435.2	1437.75	1434.43	1437.49	17845.0
2012-11-05 06:00:00	ES	Futures	1437.49	1438.52	1435.2	1436.98	17194.0
2012-11-05 07:00:00	ES	Futures	1436.73	1436.98	1433.66	1435.2	21199.0
2012-11-05 08:00:00	ES	Futures	1435.2	1438.26	1433.92	1437.49	41657.0
2012-11-05 09:00:00	ES	Futures	1437.49	1438.52	1433.66	1435.71	195138.0
2012-11-05 10:00:00	ES	Futures	1435.45	1441.07	1433.66	1440.56	252229.0
2012-11-05 11:00:00	ES	Futures	1440.56	1441.84	1437.75	1438.77	164017.0
2012-11-05 12:00:00	ES	Futures	1439.03	1439.54	1435.45	1436.22	122045.0
2012-11-05 13:00:00	ES	Futures	1436.47	1439.79	1435.96	1438.77	84367.0
2012-11-05 14:00:00	ES	Futures	1439.03	1442.6	1438.77	1441.33	88051.0
2012-11-05 15:00:00	ES	Futures	1441.33	1446.44	1440.82	1443.63	219909.0
2012-11-05 16:00:00	ES	Futures	1443.37	1443.63	1441.07	1441.58	66353.0
2012-11-05 17:00:00	ES	Futures	1441.58	1442.09	1440.56	1441.33	3748.0
2012-11-05 18:00:00	ES	Futures	1441.58	1442.35	1441.33	1441.58	2885.0
2012-11-05 19:00:00	ES	Futures	1441.58	1441.84	1440.82	1441.07	2666.0
2012-11-05 20:00:00	ES	Futures	1441.07	1441.84	1440.82	1441.84	2535.0
2012-11-05 21:00:00	ES	Futures	1441.84	1442.09	1441.07	1442.09	2147.0
2012-11-05 22:00:00	ES	Futures	1442.35	1444.39	1441.33	1444.39	6900.0
2012-11-05 23:00:00	ES	Futures	1444.14	1444.65	1443.88	1444.39	2896.0
2012-11-05 00:00:00	NQ	Futures	3078.37	3079.82	3077.79	3078.95	264.0
2012-11-05 01:00:00	NQ	Futures	3078.37	3078.37	3076.04	3076.33	182.0
2012-11-05 02:00:00	NQ	Futures	3076.33	3078.37	3072.55	3072.85	704.0
2012-11-05 03:00:00	NQ	Futures	3072.85	3076.62	3067.91	3072.55	2533.0
2012-11-05 04:00:00	NQ	Futures	3072.55	3074.88	3069.94	3070.23	1268.0
2012-11-05 05:00:00	NQ	Futures	3070.23	3074.88	3068.49	3074.88	1194.0
2012-11-05 06:00:00	NQ	Futures	3074.88	3077.2	3070.52	3073.72	1153.0
2012-11-05 07:00:00	NQ	Futures	3074.01	3074.3	3067.03	3068.49	3267.0
2012-11-05 08:00:00	NQ	Futures	3068.49	3081.85	3064.71	3079.24	10083.0
2012-11-05 09:00:00	NQ	Futures	3079.53	3089.12	3074.88	3082.43	34467.0
2012-11-05 10:00:00	NQ	Futures	3082.14	3097.54	3075.75	3094.93	47609.0
2012-11-05 11:00:00	NQ	Futures	3094.64	3096.96	3084.76	3087.96	28462.0
2012-11-05 12:00:00	NQ	Futures	3087.96	3088.25	3075.75	3078.66	39112.0
2012-11-05 13:00:00	NQ	Futures	3078.95	3088.25	3077.79	3083.02	27206.0
2012-11-05 14:00:00	NQ	Futures	3082.72	3096.67	3082.72	3093.77	14039.0
2012-11-05 15:00:00	NQ	Futures	3093.48	3107.42	3092.02	3101.03	28491.0
2012-11-05 16:00:00	NQ	Futures	3101.03	3102.77	3090.57	3090.57	7590.0
2012-11-05 17:00:00	NQ	Futures	3090.57	3091.15	3083.89	3087.66	2381.0
2012-11-05 18:00:00	NQ	Futures	3088.54	3089.99	3087.96	3088.54	253.0
2012-11-05 19:00:00	NQ	Futures	3088.83	3089.12	3087.96	3088.25	386.0
2012-11-05 20:00:00	NQ	Futures	3088.25	3089.99	3087.96	3089.12	246.0
2012-11-05 21:00:00	NQ	Futures	3089.12	3090.57	3088.54	3090.57	328.0
2012-11-05 22:00:00	NQ	Futures	3091.15	3096.96	3089.7	3096.67	991.0
2012-11-05 23:00:00	NQ	Futures	3096.38	3098.13	3096.38	3096.38	338.0
2012-11-05 00:00:00	YM	Futures	13026.7	13034.7	13025.7	13031.7	404.0
2012-11-05 01:00:00	YM	Futures	13030.7	13031.7	13020.7	13024.7	215.0

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

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