PREVIEW / futures_1hour / 2011-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-21.parquet
  size:    47 KB
  rows:    1,425

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-21 00:00:00	ES	Futures	1274.2	1274.7	1272.71	1274.2	1991.0
2011-03-21 01:00:00	ES	Futures	1273.95	1278.42	1273.7	1277.18	6999.0
2011-03-21 02:00:00	ES	Futures	1277.43	1277.68	1274.7	1276.19	6156.0
2011-03-21 03:00:00	ES	Futures	1276.19	1280.66	1275.94	1280.16	27104.0
2011-03-21 04:00:00	ES	Futures	1280.41	1283.14	1277.93	1281.65	50489.0
2011-03-21 05:00:00	ES	Futures	1281.65	1281.9	1279.91	1281.4	20858.0
2011-03-21 06:00:00	ES	Futures	1281.4	1282.4	1279.42	1281.65	17002.0
2011-03-21 07:00:00	ES	Futures	1281.9	1282.4	1279.42	1281.4	32863.0
2011-03-21 08:00:00	ES	Futures	1281.4	1282.9	1280.41	1281.16	51774.0
2011-03-21 09:00:00	ES	Futures	1281.16	1286.62	1279.67	1285.38	266431.0
2011-03-21 10:00:00	ES	Futures	1285.38	1288.11	1284.14	1285.63	240156.0
2011-03-21 11:00:00	ES	Futures	1285.63	1287.86	1284.63	1285.38	123091.0
2011-03-21 12:00:00	ES	Futures	1285.38	1287.37	1284.88	1285.63	109084.0
2011-03-21 13:00:00	ES	Futures	1285.38	1286.12	1283.14	1285.88	86375.0
2011-03-21 14:00:00	ES	Futures	1286.12	1287.12	1284.14	1284.63	73466.0
2011-03-21 15:00:00	ES	Futures	1284.63	1285.88	1282.15	1284.88	213979.0
2011-03-21 16:00:00	ES	Futures	1284.88	1286.62	1283.64	1284.39	109046.0
2011-03-21 17:00:00	ES	Futures	1284.39	1284.63	1283.64	1284.63	1710.0
2011-03-21 18:00:00	ES	Futures	1284.39	1285.88	1284.14	1285.63	4778.0
2011-03-21 19:00:00	ES	Futures	1285.38	1285.88	1284.14	1284.63	1846.0
2011-03-21 20:00:00	ES	Futures	1284.63	1284.63	1282.65	1282.9	6162.0
2011-03-21 21:00:00	ES	Futures	1283.14	1283.39	1281.4	1282.15	6271.0
2011-03-21 22:00:00	ES	Futures	1282.15	1283.39	1281.9	1283.39	2857.0
2011-03-21 23:00:00	ES	Futures	1283.39	1283.64	1281.16	1281.4	3248.0
2011-03-21 00:00:00	NQ	Futures	2566.3	2567.16	2564.0	2566.87	289.0
2011-03-21 01:00:00	NQ	Futures	2566.58	2575.78	2566.3	2572.62	507.0
2011-03-21 02:00:00	NQ	Futures	2572.33	2572.33	2568.31	2570.32	657.0
2011-03-21 03:00:00	NQ	Futures	2569.74	2579.8	2569.17	2579.51	1800.0
2011-03-21 04:00:00	NQ	Futures	2579.8	2586.7	2575.78	2583.25	3916.0
2011-03-21 05:00:00	NQ	Futures	2583.82	2585.26	2580.66	2582.96	1432.0
2011-03-21 06:00:00	NQ	Futures	2582.96	2587.56	2580.09	2584.68	1800.0
2011-03-21 07:00:00	NQ	Futures	2584.68	2586.41	2580.37	2584.68	2706.0
2011-03-21 08:00:00	NQ	Futures	2584.4	2586.7	2581.81	2583.53	5816.0
2011-03-21 09:00:00	NQ	Futures	2583.25	2603.36	2582.1	2599.62	54048.0
2011-03-21 10:00:00	NQ	Futures	2600.2	2606.81	2597.61	2603.36	50414.0
2011-03-21 11:00:00	NQ	Futures	2603.65	2610.54	2600.77	2601.06	26012.0
2011-03-21 12:00:00	NQ	Futures	2601.06	2604.51	2599.05	2600.77	15779.0
2011-03-21 13:00:00	NQ	Futures	2600.49	2601.35	2592.44	2601.06	17592.0
2011-03-21 14:00:00	NQ	Futures	2601.35	2604.51	2597.61	2598.19	15976.0
2011-03-21 15:00:00	NQ	Futures	2598.47	2601.06	2593.59	2596.18	32460.0
2011-03-21 16:00:00	NQ	Futures	2595.89	2598.47	2590.43	2591.87	13501.0
2011-03-21 17:00:00	NQ	Futures	2592.44	2592.73	2591.0	2592.73	253.0
2011-03-21 18:00:00	NQ	Futures	2592.73	2595.89	2591.58	2594.17	191.0
2011-03-21 19:00:00	NQ	Futures	2594.17	2594.74	2592.15	2593.3	247.0
2011-03-21 20:00:00	NQ	Futures	2592.73	2592.73	2588.42	2589.57	480.0
2011-03-21 21:00:00	NQ	Futures	2588.99	2589.57	2586.7	2588.13	423.0
2011-03-21 22:00:00	NQ	Futures	2587.56	2590.43	2586.98	2590.43	224.0
2011-03-21 23:00:00	NQ	Futures	2590.43	2590.43	2586.12	2586.7	314.0
2011-03-21 00:00:00	YM	Futures	11420.5	11423.4	11409.0	11419.6	167.0
2011-03-21 01:00:00	YM	Futures	11419.6	11450.4	11416.7	11443.6	386.0

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

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