PREVIEW / futures_1hour / 2011-06-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	1271.72	1271.72	1269.98	1270.97	4212.0
2011-06-09 01:00:00	ES	Futures	1270.97	1273.21	1270.97	1271.96	4570.0
2011-06-09 02:00:00	ES	Futures	1271.96	1272.96	1271.72	1272.21	6335.0
2011-06-09 03:00:00	ES	Futures	1272.21	1277.18	1271.96	1275.44	33207.0
2011-06-09 04:00:00	ES	Futures	1275.44	1275.94	1272.46	1272.71	22963.0
2011-06-09 05:00:00	ES	Futures	1272.71	1273.7	1270.23	1272.96	22092.0
2011-06-09 06:00:00	ES	Futures	1272.96	1273.7	1271.72	1272.71	13768.0
2011-06-09 07:00:00	ES	Futures	1272.71	1274.7	1272.21	1273.95	21944.0
2011-06-09 08:00:00	ES	Futures	1274.2	1276.19	1271.22	1273.21	96656.0
2011-06-09 09:00:00	ES	Futures	1273.21	1276.93	1270.97	1276.68	191841.0
2011-06-09 10:00:00	ES	Futures	1276.93	1281.9	1276.68	1280.66	240091.0
2011-06-09 11:00:00	ES	Futures	1280.41	1283.89	1278.42	1282.65	158284.0
2011-06-09 12:00:00	ES	Futures	1282.65	1284.88	1281.65	1282.9	94873.0
2011-06-09 13:00:00	ES	Futures	1282.65	1284.63	1282.15	1283.39	55371.0
2011-06-09 14:00:00	ES	Futures	1283.39	1285.88	1282.9	1285.88	62040.0
2011-06-09 15:00:00	ES	Futures	1285.63	1285.88	1279.91	1280.16	150438.0
2011-06-09 16:00:00	ES	Futures	1280.41	1280.66	1278.67	1279.42	64756.0
2011-06-09 17:00:00	ES	Futures	1279.17	1280.16	1279.17	1279.67	1231.0
2011-06-09 18:00:00	ES	Futures	1279.67	1280.66	1279.17	1280.16	2860.0
2011-06-09 19:00:00	ES	Futures	1280.16	1280.41	1278.92	1279.17	4226.0
2011-06-09 20:00:00	ES	Futures	1279.17	1280.66	1278.92	1278.92	3648.0
2011-06-09 21:00:00	ES	Futures	1278.92	1278.92	1277.43	1277.68	4974.0
2011-06-09 22:00:00	ES	Futures	1277.68	1277.68	1276.44	1276.93	5015.0
2011-06-09 23:00:00	ES	Futures	1276.93	1277.68	1274.95	1275.44	5635.0
2011-06-09 00:00:00	NQ	Futures	2587.84	2587.84	2584.97	2587.27	343.0
2011-06-09 01:00:00	NQ	Futures	2587.56	2591.0	2587.56	2589.86	337.0
2011-06-09 02:00:00	NQ	Futures	2589.57	2591.29	2588.13	2589.86	502.0
2011-06-09 03:00:00	NQ	Futures	2589.57	2597.33	2589.57	2594.45	3264.0
2011-06-09 04:00:00	NQ	Futures	2594.45	2595.03	2588.71	2589.28	1604.0
2011-06-09 05:00:00	NQ	Futures	2588.71	2591.29	2584.68	2589.57	2645.0
2011-06-09 06:00:00	NQ	Futures	2589.57	2590.72	2586.98	2588.99	1451.0
2011-06-09 07:00:00	NQ	Futures	2589.28	2593.3	2588.13	2591.87	1983.0
2011-06-09 08:00:00	NQ	Futures	2592.15	2594.17	2585.55	2589.57	10762.0
2011-06-09 09:00:00	NQ	Futures	2589.57	2592.44	2581.24	2589.57	34573.0
2011-06-09 10:00:00	NQ	Futures	2589.86	2597.04	2588.71	2594.74	24644.0
2011-06-09 11:00:00	NQ	Futures	2594.74	2597.61	2590.14	2595.31	13497.0
2011-06-09 12:00:00	NQ	Futures	2595.03	2601.64	2594.74	2599.34	10960.0
2011-06-09 13:00:00	NQ	Futures	2599.05	2601.64	2597.61	2599.05	7739.0
2011-06-09 14:00:00	NQ	Futures	2599.05	2604.51	2598.47	2603.93	6650.0
2011-06-09 15:00:00	NQ	Futures	2604.22	2605.95	2593.02	2593.02	22127.0
2011-06-09 16:00:00	NQ	Futures	2593.02	2593.3	2588.42	2588.71	6906.0
2011-06-09 17:00:00	NQ	Futures	2588.42	2590.43	2588.42	2590.14	51.0
2011-06-09 18:00:00	NQ	Futures	2589.57	2592.44	2589.57	2590.72	120.0
2011-06-09 19:00:00	NQ	Futures	2591.0	2591.58	2588.99	2589.28	192.0
2011-06-09 20:00:00	NQ	Futures	2589.28	2592.15	2588.71	2589.28	286.0
2011-06-09 21:00:00	NQ	Futures	2588.71	2589.28	2586.41	2586.98	211.0
2011-06-09 22:00:00	NQ	Futures	2586.7	2586.7	2584.11	2584.4	470.0
2011-06-09 23:00:00	NQ	Futures	2584.68	2585.83	2581.52	2582.1	271.0
2011-06-09 00:00:00	YM	Futures	11610.3	11611.2	11598.7	11604.5	177.0
2011-06-09 01:00:00	YM	Futures	11604.5	11619.9	11603.5	11611.2	257.0

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

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