PREVIEW / futures_1hour / 2011-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-24.parquet
  size:    48 KB
  rows:    1,453

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-03-24 00:00:00	ES	Futures	1283.39	1283.89	1282.15	1282.65	2728.0
2011-03-24 01:00:00	ES	Futures	1282.9	1284.39	1282.4	1283.64	2357.0
2011-03-24 02:00:00	ES	Futures	1283.64	1285.13	1283.39	1283.89	2597.0
2011-03-24 03:00:00	ES	Futures	1283.89	1284.39	1281.16	1282.9	15423.0
2011-03-24 04:00:00	ES	Futures	1282.9	1286.62	1281.16	1285.88	31712.0
2011-03-24 05:00:00	ES	Futures	1285.88	1291.34	1284.88	1289.35	51611.0
2011-03-24 06:00:00	ES	Futures	1289.6	1291.34	1288.61	1290.85	20353.0
2011-03-24 07:00:00	ES	Futures	1290.85	1292.83	1289.35	1292.34	39774.0
2011-03-24 08:00:00	ES	Futures	1292.34	1294.57	1289.85	1290.85	106492.0
2011-03-24 09:00:00	ES	Futures	1290.6	1292.09	1285.88	1286.62	229458.0
2011-03-24 10:00:00	ES	Futures	1286.62	1293.83	1284.39	1293.08	295021.0
2011-03-24 11:00:00	ES	Futures	1293.08	1294.82	1292.58	1294.07	213229.0
2011-03-24 12:00:00	ES	Futures	1294.07	1296.56	1292.09	1293.08	218496.0
2011-03-24 13:00:00	ES	Futures	1292.83	1294.82	1291.84	1293.58	112918.0
2011-03-24 14:00:00	ES	Futures	1293.83	1296.56	1293.58	1295.57	96785.0
2011-03-24 15:00:00	ES	Futures	1295.57	1298.55	1294.82	1296.56	272221.0
2011-03-24 16:00:00	ES	Futures	1296.56	1297.3	1295.81	1297.3	81651.0
2011-03-24 17:00:00	ES	Futures	1297.06	1305.75	1296.81	1300.29	18543.0
2011-03-24 18:00:00	ES	Futures	1299.79	1301.78	1299.79	1300.78	8114.0
2011-03-24 19:00:00	ES	Futures	1300.78	1300.78	1299.54	1299.79	3262.0
2011-03-24 20:00:00	ES	Futures	1299.54	1300.04	1298.79	1299.79	4216.0
2011-03-24 21:00:00	ES	Futures	1299.79	1300.53	1298.79	1299.79	2929.0
2011-03-24 22:00:00	ES	Futures	1299.79	1300.78	1299.54	1300.53	2623.0
2011-03-24 23:00:00	ES	Futures	1300.53	1301.78	1300.04	1301.28	4315.0
2011-03-24 00:00:00	NQ	Futures	2603.07	2603.93	2600.49	2601.64	174.0
2011-03-24 01:00:00	NQ	Futures	2601.64	2603.93	2601.06	2603.07	266.0
2011-03-24 02:00:00	NQ	Futures	2602.78	2608.24	2601.64	2605.66	589.0
2011-03-24 03:00:00	NQ	Futures	2605.37	2606.81	2601.06	2606.52	1967.0
2011-03-24 04:00:00	NQ	Futures	2606.23	2613.99	2602.5	2612.55	2027.0
2011-03-24 05:00:00	NQ	Futures	2612.27	2624.62	2612.27	2621.46	4389.0
2011-03-24 06:00:00	NQ	Futures	2621.17	2626.34	2620.02	2624.91	1326.0
2011-03-24 07:00:00	NQ	Futures	2624.91	2626.06	2620.89	2624.91	2768.0
2011-03-24 08:00:00	NQ	Futures	2624.62	2631.8	2622.03	2624.62	9845.0
2011-03-24 09:00:00	NQ	Futures	2624.33	2626.34	2611.69	2616.29	41808.0
2011-03-24 10:00:00	NQ	Futures	2616.29	2639.27	2612.84	2638.41	46927.0
2011-03-24 11:00:00	NQ	Futures	2638.41	2645.02	2637.84	2643.01	37692.0
2011-03-24 12:00:00	NQ	Futures	2643.3	2648.47	2642.43	2645.02	36107.0
2011-03-24 13:00:00	NQ	Futures	2644.73	2648.76	2641.28	2645.59	21587.0
2011-03-24 14:00:00	NQ	Futures	2645.88	2653.64	2645.59	2651.34	22043.0
2011-03-24 15:00:00	NQ	Futures	2651.34	2658.81	2649.9	2653.64	44992.0
2011-03-24 16:00:00	NQ	Futures	2653.64	2656.51	2647.89	2651.34	12806.0
2011-03-24 17:00:00	NQ	Futures	2651.34	2683.52	2651.05	2661.4	2575.0
2011-03-24 18:00:00	NQ	Futures	2660.53	2667.14	2659.96	2665.13	968.0
2011-03-24 19:00:00	NQ	Futures	2665.42	2665.42	2661.97	2662.55	347.0
2011-03-24 20:00:00	NQ	Futures	2661.97	2663.7	2660.53	2663.7	608.0
2011-03-24 21:00:00	NQ	Futures	2663.12	2664.84	2662.26	2664.56	313.0
2011-03-24 22:00:00	NQ	Futures	2663.98	2665.42	2663.41	2664.84	223.0
2011-03-24 23:00:00	NQ	Futures	2664.84	2665.13	2661.4	2664.56	563.0
2011-03-24 00:00:00	YM	Futures	11574.6	11577.5	11566.0	11569.8	115.0
2011-03-24 01:00:00	YM	Futures	11568.8	11584.3	11566.9	11579.4	235.0

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

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