PREVIEW / futures_1hour / 2011-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-28.parquet
  size:    52 KB
  rows:    1,506

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-09-28 00:00:00	ES	Futures	1168.03	1170.29	1167.03	1169.28	3518.0
2011-09-28 01:00:00	ES	Futures	1169.28	1170.29	1165.77	1166.02	8094.0
2011-09-28 02:00:00	ES	Futures	1166.28	1173.3	1166.02	1171.04	20641.0
2011-09-28 03:00:00	ES	Futures	1170.79	1180.32	1168.03	1177.31	68396.0
2011-09-28 04:00:00	ES	Futures	1177.56	1177.56	1169.79	1174.3	40697.0
2011-09-28 05:00:00	ES	Futures	1174.55	1181.32	1173.05	1180.82	35036.0
2011-09-28 06:00:00	ES	Futures	1180.82	1185.33	1178.06	1182.83	59213.0
2011-09-28 07:00:00	ES	Futures	1182.83	1183.58	1178.31	1179.32	41978.0
2011-09-28 08:00:00	ES	Futures	1179.32	1182.57	1174.55	1176.56	93939.0
2011-09-28 09:00:00	ES	Futures	1176.81	1182.83	1173.55	1180.57	261525.0
2011-09-28 10:00:00	ES	Futures	1180.57	1180.82	1166.78	1170.79	457543.0
2011-09-28 11:00:00	ES	Futures	1170.79	1177.56	1166.28	1175.8	349089.0
2011-09-28 12:00:00	ES	Futures	1175.8	1176.81	1168.78	1172.8	166960.0
2011-09-28 13:00:00	ES	Futures	1172.8	1172.8	1158.0	1158.75	256585.0
2011-09-28 14:00:00	ES	Futures	1158.75	1162.26	1155.74	1160.76	214910.0
2011-09-28 15:00:00	ES	Futures	1161.01	1166.02	1146.97	1148.72	536290.0
2011-09-28 16:00:00	ES	Futures	1148.47	1152.99	1147.97	1150.73	113475.0
2011-09-28 17:00:00	ES	Futures	1150.73	1150.98	1149.98	1150.23	1905.0
2011-09-28 18:00:00	ES	Futures	1149.73	1151.48	1148.47	1150.23	7426.0
2011-09-28 19:00:00	ES	Futures	1150.48	1150.73	1147.72	1148.47	4830.0
2011-09-28 20:00:00	ES	Futures	1148.47	1150.48	1144.46	1146.47	15974.0
2011-09-28 21:00:00	ES	Futures	1146.47	1149.98	1145.21	1149.47	12626.0
2011-09-28 22:00:00	ES	Futures	1149.47	1152.73	1147.97	1150.73	5978.0
2011-09-28 23:00:00	ES	Futures	1150.48	1155.49	1150.48	1155.24	7111.0
2011-09-28 00:00:00	NQ	Futures	2587.41	2592.6	2585.96	2590.58	356.0
2011-09-28 01:00:00	NQ	Futures	2590.29	2594.04	2583.95	2584.52	399.0
2011-09-28 02:00:00	NQ	Futures	2584.23	2599.52	2583.95	2593.46	1598.0
2011-09-28 03:00:00	NQ	Futures	2593.75	2612.78	2587.41	2605.86	4171.0
2011-09-28 04:00:00	NQ	Futures	2604.99	2604.99	2590.29	2599.52	2999.0
2011-09-28 05:00:00	NQ	Futures	2599.52	2613.64	2596.63	2613.07	3256.0
2011-09-28 06:00:00	NQ	Futures	2613.07	2621.43	2606.72	2615.08	5257.0
2011-09-28 07:00:00	NQ	Futures	2615.66	2618.83	2610.47	2611.91	3114.0
2011-09-28 08:00:00	NQ	Futures	2611.34	2616.24	2600.96	2606.15	5821.0
2011-09-28 09:00:00	NQ	Futures	2606.44	2624.6	2601.82	2615.95	37680.0
2011-09-28 10:00:00	NQ	Futures	2616.24	2616.81	2590.0	2599.23	51131.0
2011-09-28 11:00:00	NQ	Futures	2599.23	2610.76	2589.42	2607.59	37243.0
2011-09-28 12:00:00	NQ	Futures	2607.3	2609.89	2592.6	2602.11	22297.0
2011-09-28 13:00:00	NQ	Futures	2601.53	2601.53	2573.28	2575.3	35102.0
2011-09-28 14:00:00	NQ	Futures	2575.3	2585.68	2570.11	2581.06	33855.0
2011-09-28 15:00:00	NQ	Futures	2580.77	2593.17	2551.08	2554.25	65930.0
2011-09-28 16:00:00	NQ	Futures	2554.25	2560.88	2553.1	2556.56	9646.0
2011-09-28 17:00:00	NQ	Futures	2556.84	2556.84	2555.11	2555.4	193.0
2011-09-28 18:00:00	NQ	Futures	2555.4	2558.86	2553.1	2556.56	508.0
2011-09-28 19:00:00	NQ	Futures	2556.27	2557.13	2550.5	2551.65	386.0
2011-09-28 20:00:00	NQ	Futures	2552.52	2555.98	2543.87	2548.77	1375.0
2011-09-28 21:00:00	NQ	Futures	2547.91	2555.4	2545.6	2555.4	854.0
2011-09-28 22:00:00	NQ	Futures	2554.54	2561.75	2551.37	2557.13	482.0
2011-09-28 23:00:00	NQ	Futures	2557.13	2566.65	2556.27	2566.65	602.0
2011-09-28 00:00:00	YM	Futures	10908.9	10927.6	10898.1	10921.7	286.0
2011-09-28 01:00:00	YM	Futures	10919.8	10926.6	10888.3	10890.2	547.0

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

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