PREVIEW / futures_1hour / 2011-11-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1258.3	1258.81	1255.29	1255.55	5417.0
2011-11-08 01:00:00	ES	Futures	1255.55	1256.55	1254.79	1256.05	5147.0
2011-11-08 02:00:00	ES	Futures	1256.05	1258.55	1252.79	1253.54	11770.0
2011-11-08 03:00:00	ES	Futures	1253.54	1262.82	1252.29	1262.57	40760.0
2011-11-08 04:00:00	ES	Futures	1262.57	1267.33	1262.57	1263.07	43664.0
2011-11-08 05:00:00	ES	Futures	1263.07	1266.08	1262.57	1265.33	19455.0
2011-11-08 06:00:00	ES	Futures	1265.58	1267.33	1263.32	1266.33	20089.0
2011-11-08 07:00:00	ES	Futures	1266.08	1271.09	1264.57	1270.59	42627.0
2011-11-08 08:00:00	ES	Futures	1270.34	1271.34	1267.08	1268.33	40273.0
2011-11-08 09:00:00	ES	Futures	1268.33	1271.84	1264.82	1271.84	201852.0
2011-11-08 10:00:00	ES	Futures	1271.59	1272.35	1260.06	1263.07	456019.0
2011-11-08 11:00:00	ES	Futures	1262.82	1264.57	1255.29	1258.81	288627.0
2011-11-08 12:00:00	ES	Futures	1258.81	1263.07	1256.8	1260.56	127879.0
2011-11-08 13:00:00	ES	Futures	1260.56	1271.59	1258.3	1269.59	237717.0
2011-11-08 14:00:00	ES	Futures	1269.59	1274.6	1267.08	1273.6	215579.0
2011-11-08 15:00:00	ES	Futures	1273.6	1278.87	1270.59	1277.36	346947.0
2011-11-08 16:00:00	ES	Futures	1277.11	1279.12	1276.61	1277.36	85446.0
2011-11-08 17:00:00	ES	Futures	1277.61	1277.86	1276.86	1277.36	1926.0
2011-11-08 18:00:00	ES	Futures	1277.11	1277.11	1275.36	1276.61	6212.0
2011-11-08 19:00:00	ES	Futures	1276.61	1276.86	1275.61	1276.86	4694.0
2011-11-08 20:00:00	ES	Futures	1276.86	1277.86	1275.36	1276.86	6398.0
2011-11-08 21:00:00	ES	Futures	1277.11	1277.61	1275.86	1275.86	3721.0
2011-11-08 22:00:00	ES	Futures	1275.86	1276.36	1274.1	1274.85	5496.0
2011-11-08 23:00:00	ES	Futures	1274.85	1275.1	1273.1	1273.6	3616.0
2011-11-08 00:00:00	NQ	Futures	2728.68	2729.84	2722.05	2722.63	362.0
2011-11-08 01:00:00	NQ	Futures	2722.63	2723.78	2720.61	2723.21	251.0
2011-11-08 02:00:00	NQ	Futures	2723.49	2727.82	2718.3	2719.17	1177.0
2011-11-08 03:00:00	NQ	Futures	2719.17	2741.08	2716.29	2741.08	4848.0
2011-11-08 04:00:00	NQ	Futures	2741.08	2750.31	2740.79	2743.96	4141.0
2011-11-08 05:00:00	NQ	Futures	2743.68	2751.17	2742.81	2749.73	3240.0
2011-11-08 06:00:00	NQ	Futures	2749.44	2750.88	2745.41	2748.87	2246.0
2011-11-08 07:00:00	NQ	Futures	2748.87	2760.98	2746.56	2759.82	4917.0
2011-11-08 08:00:00	NQ	Futures	2759.53	2761.55	2752.61	2754.92	3894.0
2011-11-08 09:00:00	NQ	Futures	2754.63	2761.55	2746.56	2761.26	31094.0
2011-11-08 10:00:00	NQ	Futures	2760.98	2761.84	2733.3	2737.91	51381.0
2011-11-08 11:00:00	NQ	Futures	2737.33	2741.66	2719.46	2731.86	31728.0
2011-11-08 12:00:00	NQ	Futures	2731.57	2739.06	2727.53	2733.3	14000.0
2011-11-08 13:00:00	NQ	Futures	2733.01	2756.36	2728.68	2753.48	29107.0
2011-11-08 14:00:00	NQ	Futures	2753.77	2760.4	2747.14	2757.8	24937.0
2011-11-08 15:00:00	NQ	Futures	2758.09	2767.32	2752.9	2761.84	34266.0
2011-11-08 16:00:00	NQ	Futures	2762.13	2766.17	2760.98	2762.99	6551.0
2011-11-08 17:00:00	NQ	Futures	2762.99	2765.01	2762.99	2763.86	94.0
2011-11-08 18:00:00	NQ	Futures	2763.86	2763.86	2761.26	2762.99	257.0
2011-11-08 19:00:00	NQ	Futures	2762.99	2763.57	2760.98	2763.28	247.0
2011-11-08 20:00:00	NQ	Futures	2763.57	2764.44	2760.69	2763.28	312.0
2011-11-08 21:00:00	NQ	Futures	2763.57	2763.86	2761.26	2761.26	183.0
2011-11-08 22:00:00	NQ	Futures	2761.26	2761.84	2758.09	2758.67	358.0
2011-11-08 23:00:00	NQ	Futures	2758.67	2759.25	2756.94	2757.52	260.0
2011-11-08 00:00:00	YM	Futures	11801.9	11804.9	11778.3	11779.3	236.0
2011-11-08 01:00:00	YM	Futures	11778.3	11789.1	11773.4	11786.2	211.0

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

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