PREVIEW / futures_1hour / 2011-03-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1281.4	1283.14	1280.91	1282.15	4703.0
2011-03-22 01:00:00	ES	Futures	1282.15	1284.14	1280.91	1283.89	4998.0
2011-03-22 02:00:00	ES	Futures	1283.64	1285.13	1282.4	1284.88	4276.0
2011-03-22 03:00:00	ES	Futures	1284.88	1286.62	1283.64	1283.89	11386.0
2011-03-22 04:00:00	ES	Futures	1283.89	1288.36	1283.64	1287.37	31800.0
2011-03-22 05:00:00	ES	Futures	1287.12	1287.86	1285.63	1285.88	13812.0
2011-03-22 06:00:00	ES	Futures	1285.63	1286.12	1283.14	1283.39	17344.0
2011-03-22 07:00:00	ES	Futures	1283.39	1286.12	1283.14	1285.13	21548.0
2011-03-22 08:00:00	ES	Futures	1285.38	1286.12	1283.64	1284.63	29686.0
2011-03-22 09:00:00	ES	Futures	1284.63	1286.62	1282.4	1282.4	203099.0
2011-03-22 10:00:00	ES	Futures	1282.4	1286.12	1280.41	1280.66	228963.0
2011-03-22 11:00:00	ES	Futures	1280.66	1284.39	1280.16	1283.64	193085.0
2011-03-22 12:00:00	ES	Futures	1283.64	1284.88	1281.65	1282.65	122375.0
2011-03-22 13:00:00	ES	Futures	1282.9	1283.64	1280.41	1282.65	96765.0
2011-03-22 14:00:00	ES	Futures	1282.9	1283.39	1279.42	1281.4	153978.0
2011-03-22 15:00:00	ES	Futures	1281.65	1282.65	1280.16	1280.91	190447.0
2011-03-22 16:00:00	ES	Futures	1280.66	1281.9	1279.42	1280.41	82714.0
2011-03-22 17:00:00	ES	Futures	1280.41	1281.16	1280.16	1281.16	1322.0
2011-03-22 18:00:00	ES	Futures	1280.91	1281.16	1279.67	1280.66	3323.0
2011-03-22 19:00:00	ES	Futures	1280.41	1281.4	1279.17	1279.42	3361.0
2011-03-22 20:00:00	ES	Futures	1279.42	1279.91	1275.19	1276.93	14070.0
2011-03-22 21:00:00	ES	Futures	1276.68	1277.43	1276.19	1276.93	3705.0
2011-03-22 22:00:00	ES	Futures	1276.68	1277.18	1275.19	1275.69	5041.0
2011-03-22 23:00:00	ES	Futures	1275.94	1277.93	1275.69	1277.68	3689.0
2011-03-22 00:00:00	NQ	Futures	2586.41	2589.86	2584.97	2587.56	351.0
2011-03-22 01:00:00	NQ	Futures	2587.84	2591.58	2585.55	2590.14	393.0
2011-03-22 02:00:00	NQ	Futures	2590.14	2592.15	2585.55	2591.58	923.0
2011-03-22 03:00:00	NQ	Futures	2591.58	2595.03	2589.28	2591.0	1199.0
2011-03-22 04:00:00	NQ	Futures	2591.0	2599.05	2590.43	2596.75	3563.0
2011-03-22 05:00:00	NQ	Futures	2596.18	2598.19	2595.03	2595.03	1093.0
2011-03-22 06:00:00	NQ	Futures	2595.03	2595.03	2591.29	2591.29	2190.0
2011-03-22 07:00:00	NQ	Futures	2591.29	2596.46	2591.0	2595.31	1856.0
2011-03-22 08:00:00	NQ	Futures	2595.6	2599.62	2592.44	2598.19	6509.0
2011-03-22 09:00:00	NQ	Futures	2598.19	2602.21	2590.43	2592.73	42892.0
2011-03-22 10:00:00	NQ	Futures	2592.73	2601.92	2589.57	2589.86	39982.0
2011-03-22 11:00:00	NQ	Futures	2589.86	2596.75	2588.71	2595.89	26698.0
2011-03-22 12:00:00	NQ	Futures	2595.89	2599.05	2592.44	2593.88	17196.0
2011-03-22 13:00:00	NQ	Futures	2593.88	2595.31	2586.7	2594.17	17517.0
2011-03-22 14:00:00	NQ	Futures	2594.17	2594.45	2586.41	2591.58	18724.0
2011-03-22 15:00:00	NQ	Futures	2591.87	2595.03	2590.14	2593.3	22525.0
2011-03-22 16:00:00	NQ	Futures	2593.3	2596.46	2591.29	2593.59	8334.0
2011-03-22 17:00:00	NQ	Futures	2593.88	2595.6	2593.59	2595.03	258.0
2011-03-22 18:00:00	NQ	Futures	2594.17	2595.89	2592.15	2593.59	175.0
2011-03-22 19:00:00	NQ	Futures	2593.3	2595.03	2591.29	2591.29	281.0
2011-03-22 20:00:00	NQ	Futures	2591.58	2591.58	2583.53	2586.98	1180.0
2011-03-22 21:00:00	NQ	Futures	2586.98	2588.13	2584.68	2586.7	520.0
2011-03-22 22:00:00	NQ	Futures	2586.41	2586.7	2582.96	2584.11	362.0
2011-03-22 23:00:00	NQ	Futures	2584.4	2587.84	2584.11	2587.84	288.0
2011-03-22 00:00:00	YM	Futures	11497.6	11513.9	11491.8	11502.4	502.0
2011-03-22 01:00:00	YM	Futures	11501.4	11522.6	11497.6	11515.9	261.0

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

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