PREVIEW / futures_1hour / 2012-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-03.parquet
  size:    41 KB
  rows:    1,231

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
2012-01-03 06:00:00	ES	Futures	1284.89	1290.18	1282.87	1285.14	80509.0
2012-01-03 07:00:00	ES	Futures	1285.14	1285.89	1281.11	1281.61	29363.0
2012-01-03 08:00:00	ES	Futures	1281.86	1283.37	1280.86	1282.87	42191.0
2012-01-03 09:00:00	ES	Futures	1283.12	1287.15	1282.62	1285.64	199803.0
2012-01-03 10:00:00	ES	Futures	1285.39	1289.93	1284.13	1288.67	290315.0
2012-01-03 11:00:00	ES	Futures	1288.67	1289.67	1284.89	1285.64	189955.0
2012-01-03 12:00:00	ES	Futures	1285.64	1285.89	1280.35	1281.61	142448.0
2012-01-03 13:00:00	ES	Futures	1281.36	1283.88	1280.6	1283.37	117675.0
2012-01-03 14:00:00	ES	Futures	1283.37	1286.9	1282.62	1286.65	108926.0
2012-01-03 15:00:00	ES	Futures	1286.65	1286.65	1280.6	1281.61	272968.0
2012-01-03 16:00:00	ES	Futures	1281.61	1283.63	1280.6	1283.37	93624.0
2012-01-03 17:00:00	ES	Futures	1283.12	1283.88	1282.37	1283.63	2189.0
2012-01-03 18:00:00	ES	Futures	1283.12	1283.63	1282.37	1282.62	4349.0
2012-01-03 19:00:00	ES	Futures	1282.62	1283.37	1281.86	1282.37	3907.0
2012-01-03 20:00:00	ES	Futures	1282.11	1282.87	1281.11	1282.87	5454.0
2012-01-03 21:00:00	ES	Futures	1282.62	1282.87	1281.36	1281.61	2946.0
2012-01-03 22:00:00	ES	Futures	1281.61	1281.86	1280.6	1281.11	4234.0
2012-01-03 23:00:00	ES	Futures	1281.11	1282.11	1281.11	1282.11	3596.0
2012-01-03 06:00:00	NQ	Futures	2671.38	2684.96	2671.38	2677.45	5584.0
2012-01-03 07:00:00	NQ	Futures	2677.74	2680.34	2670.52	2671.38	2251.0
2012-01-03 08:00:00	NQ	Futures	2671.67	2671.96	2666.19	2669.65	5524.0
2012-01-03 09:00:00	NQ	Futures	2669.94	2689.29	2669.07	2682.07	35140.0
2012-01-03 10:00:00	NQ	Futures	2682.07	2689.58	2680.05	2687.27	25614.0
2012-01-03 11:00:00	NQ	Futures	2687.27	2688.71	2679.76	2680.92	20124.0
2012-01-03 12:00:00	NQ	Futures	2680.92	2683.51	2669.07	2673.12	18505.0
2012-01-03 13:00:00	NQ	Futures	2673.12	2677.74	2669.94	2677.16	16813.0
2012-01-03 14:00:00	NQ	Futures	2677.45	2685.82	2676.01	2685.82	13643.0
2012-01-03 15:00:00	NQ	Futures	2685.54	2685.82	2673.98	2675.72	27567.0
2012-01-03 16:00:00	NQ	Futures	2675.72	2680.05	2674.27	2676.58	7251.0
2012-01-03 17:00:00	NQ	Futures	2676.58	2677.45	2675.43	2677.45	39.0
2012-01-03 18:00:00	NQ	Futures	2677.45	2678.32	2675.43	2676.29	238.0
2012-01-03 19:00:00	NQ	Futures	2676.58	2676.87	2674.56	2675.14	198.0
2012-01-03 20:00:00	NQ	Futures	2674.85	2674.85	2673.12	2674.85	303.0
2012-01-03 21:00:00	NQ	Futures	2675.14	2675.14	2673.41	2674.27	127.0
2012-01-03 22:00:00	NQ	Futures	2673.98	2674.27	2672.25	2672.54	185.0
2012-01-03 23:00:00	NQ	Futures	2672.83	2674.56	2672.83	2674.56	151.0
2012-01-03 06:00:00	YM	Futures	12242.5	12278.2	12233.6	12253.4	5369.0
2012-01-03 07:00:00	YM	Futures	12255.4	12260.3	12222.7	12227.6	1489.0
2012-01-03 08:00:00	YM	Futures	12226.6	12238.5	12218.7	12236.6	2283.0
2012-01-03 09:00:00	YM	Futures	12236.6	12284.1	12232.6	12273.2	13832.0
2012-01-03 10:00:00	YM	Futures	12274.2	12304.9	12263.3	12288.1	15634.0
2012-01-03 11:00:00	YM	Futures	12289.1	12293.1	12255.4	12265.3	10182.0
2012-01-03 12:00:00	YM	Futures	12265.3	12269.3	12213.8	12221.7	10035.0
2012-01-03 13:00:00	YM	Futures	12222.7	12252.4	12217.7	12242.5	10072.0
2012-01-03 14:00:00	YM	Futures	12244.5	12271.2	12241.5	12268.3	6499.0
2012-01-03 15:00:00	YM	Futures	12269.3	12269.3	12213.8	12220.7	12804.0
2012-01-03 16:00:00	YM	Futures	12219.7	12239.5	12212.8	12236.6	3049.0
2012-01-03 17:00:00	YM	Futures	12237.5	12240.5	12231.6	12240.5	52.0
2012-01-03 18:00:00	YM	Futures	12233.6	12242.5	12230.6	12232.6	218.0
2012-01-03 19:00:00	YM	Futures	12233.6	12236.6	12215.7	12222.7	703.0

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

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