PREVIEW / futures_1hour / 2011-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-21.parquet
  size:    48 KB
  rows:    1,482

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-06-21 00:00:00	ES	Futures	1269.47	1271.47	1268.73	1270.97	3351.0
2011-06-21 01:00:00	ES	Futures	1270.97	1272.97	1270.97	1271.97	3527.0
2011-06-21 02:00:00	ES	Futures	1271.72	1275.21	1271.47	1274.21	15515.0
2011-06-21 03:00:00	ES	Futures	1274.46	1277.95	1273.46	1276.71	29624.0
2011-06-21 04:00:00	ES	Futures	1276.71	1277.95	1276.21	1276.71	15810.0
2011-06-21 05:00:00	ES	Futures	1276.71	1276.71	1274.46	1275.21	14727.0
2011-06-21 06:00:00	ES	Futures	1275.21	1277.7	1274.46	1276.71	12603.0
2011-06-21 07:00:00	ES	Futures	1276.71	1278.7	1274.96	1277.46	44966.0
2011-06-21 08:00:00	ES	Futures	1277.7	1278.2	1275.71	1276.71	50696.0
2011-06-21 09:00:00	ES	Futures	1276.46	1278.7	1274.46	1277.7	217788.0
2011-06-21 10:00:00	ES	Futures	1277.7	1284.19	1277.7	1283.69	352059.0
2011-06-21 11:00:00	ES	Futures	1283.69	1288.18	1282.69	1286.43	337165.0
2011-06-21 12:00:00	ES	Futures	1286.68	1287.43	1284.94	1286.18	179492.0
2011-06-21 13:00:00	ES	Futures	1286.18	1286.18	1283.19	1284.44	168036.0
2011-06-21 14:00:00	ES	Futures	1284.44	1289.68	1284.44	1288.68	199342.0
2011-06-21 15:00:00	ES	Futures	1288.93	1289.18	1284.94	1286.68	293279.0
2011-06-21 16:00:00	ES	Futures	1286.93	1287.18	1283.94	1285.69	107679.0
2011-06-21 17:00:00	ES	Futures	1285.44	1286.18	1283.19	1285.44	4948.0
2011-06-21 18:00:00	ES	Futures	1286.43	1286.43	1283.19	1285.19	19303.0
2011-06-21 19:00:00	ES	Futures	1284.94	1286.43	1283.94	1285.69	3920.0
2011-06-21 20:00:00	ES	Futures	1285.69	1286.68	1284.69	1285.69	4285.0
2011-06-21 21:00:00	ES	Futures	1285.44	1285.69	1282.44	1282.94	7860.0
2011-06-21 22:00:00	ES	Futures	1282.94	1284.44	1282.44	1283.69	3976.0
2011-06-21 23:00:00	ES	Futures	1283.69	1283.69	1281.94	1282.69	2731.0
2011-06-21 00:00:00	NQ	Futures	2531.18	2533.77	2530.03	2533.49	466.0
2011-06-21 01:00:00	NQ	Futures	2533.49	2535.79	2533.49	2534.35	482.0
2011-06-21 02:00:00	NQ	Futures	2534.35	2541.83	2534.06	2539.24	1360.0
2011-06-21 03:00:00	NQ	Futures	2539.24	2545.86	2537.51	2543.85	3387.0
2011-06-21 04:00:00	NQ	Futures	2543.85	2545.57	2542.69	2542.69	1555.0
2011-06-21 05:00:00	NQ	Futures	2542.69	2542.69	2538.67	2540.39	1686.0
2011-06-21 06:00:00	NQ	Futures	2540.1	2543.85	2538.38	2542.41	1775.0
2011-06-21 07:00:00	NQ	Futures	2542.41	2546.44	2540.1	2544.71	3109.0
2011-06-21 08:00:00	NQ	Futures	2544.71	2545.28	2540.97	2542.41	4088.0
2011-06-21 09:00:00	NQ	Futures	2542.41	2551.9	2530.61	2550.75	47790.0
2011-06-21 10:00:00	NQ	Futures	2550.75	2573.77	2549.89	2572.91	64847.0
2011-06-21 11:00:00	NQ	Futures	2572.91	2581.83	2570.61	2579.24	38417.0
2011-06-21 12:00:00	NQ	Futures	2579.24	2581.83	2576.36	2580.68	34925.0
2011-06-21 13:00:00	NQ	Futures	2580.68	2580.97	2576.36	2578.09	24224.0
2011-06-21 14:00:00	NQ	Futures	2577.8	2589.02	2577.23	2587.3	41741.0
2011-06-21 15:00:00	NQ	Futures	2587.3	2589.6	2580.97	2587.01	59914.0
2011-06-21 16:00:00	NQ	Futures	2587.01	2587.3	2580.1	2582.12	8140.0
2011-06-21 17:00:00	NQ	Futures	2582.69	2585.0	2578.95	2585.0	325.0
2011-06-21 18:00:00	NQ	Futures	2585.0	2585.28	2580.1	2582.41	865.0
2011-06-21 19:00:00	NQ	Futures	2582.41	2583.84	2579.82	2582.98	295.0
2011-06-21 20:00:00	NQ	Futures	2582.98	2584.71	2581.25	2581.54	235.0
2011-06-21 21:00:00	NQ	Futures	2581.83	2582.12	2577.51	2578.95	449.0
2011-06-21 22:00:00	NQ	Futures	2578.66	2580.97	2577.8	2580.39	379.0
2011-06-21 23:00:00	NQ	Futures	2579.82	2579.82	2575.21	2576.07	459.0
2011-06-21 00:00:00	YM	Futures	11625.6	11646.0	11620.8	11645.0	291.0
2011-06-21 01:00:00	YM	Futures	11646.0	11653.7	11643.1	11645.0	293.0

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

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