PREVIEW / futures_1hour / 2012-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-23.parquet
  size:    33 KB
  rows:    935

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-11-23 00:00:00	ES	Futures	1421.14	1423.19	1420.89	1423.19	2185.0
2012-11-23 01:00:00	ES	Futures	1422.93	1423.44	1422.42	1422.42	1737.0
2012-11-23 02:00:00	ES	Futures	1422.68	1423.7	1422.42	1423.44	3459.0
2012-11-23 03:00:00	ES	Futures	1423.19	1423.7	1417.57	1418.08	25636.0
2012-11-23 04:00:00	ES	Futures	1418.33	1421.66	1418.08	1421.4	19743.0
2012-11-23 05:00:00	ES	Futures	1421.4	1421.4	1418.85	1419.1	12222.0
2012-11-23 06:00:00	ES	Futures	1419.1	1421.14	1417.82	1420.89	12074.0
2012-11-23 07:00:00	ES	Futures	1420.89	1421.91	1420.38	1421.66	4802.0
2012-11-23 08:00:00	ES	Futures	1421.91	1423.95	1421.91	1422.93	27130.0
2012-11-23 09:00:00	ES	Futures	1423.19	1427.02	1422.93	1426.51	141750.0
2012-11-23 10:00:00	ES	Futures	1426.51	1432.9	1426.51	1431.11	217418.0
2012-11-23 11:00:00	ES	Futures	1431.36	1432.64	1430.34	1430.85	86865.0
2012-11-23 12:00:00	ES	Futures	1430.85	1438.26	1429.57	1437.49	167017.0
2012-11-23 13:00:00	ES	Futures	1437.49	1437.75	1435.2	1435.45	67498.0
2012-11-23 00:00:00	NQ	Futures	3024.61	3026.35	3024.03	3026.35	184.0
2012-11-23 01:00:00	NQ	Futures	3026.35	3027.81	3026.06	3026.35	222.0
2012-11-23 02:00:00	NQ	Futures	3026.35	3028.68	3025.48	3027.52	567.0
2012-11-23 03:00:00	NQ	Futures	3026.93	3028.39	3017.64	3019.67	1989.0
2012-11-23 04:00:00	NQ	Futures	3019.96	3026.64	3018.8	3026.06	1690.0
2012-11-23 05:00:00	NQ	Futures	3026.35	3027.81	3023.45	3023.74	1351.0
2012-11-23 06:00:00	NQ	Futures	3024.03	3027.22	3021.99	3027.22	1253.0
2012-11-23 07:00:00	NQ	Futures	3027.22	3028.97	3026.35	3028.68	783.0
2012-11-23 08:00:00	NQ	Futures	3028.68	3033.91	3028.68	3031.29	3679.0
2012-11-23 09:00:00	NQ	Futures	3031.58	3044.95	3030.71	3040.01	29057.0
2012-11-23 10:00:00	NQ	Futures	3040.3	3056.28	3040.01	3055.12	36578.0
2012-11-23 11:00:00	NQ	Futures	3055.41	3060.64	3054.83	3058.03	15087.0
2012-11-23 12:00:00	NQ	Futures	3058.03	3067.03	3051.34	3066.45	22452.0
2012-11-23 13:00:00	NQ	Futures	3066.45	3066.74	3061.8	3062.09	4712.0
2012-11-23 00:00:00	YM	Futures	12836.6	12846.6	12836.6	12846.6	212.0
2012-11-23 01:00:00	YM	Futures	12847.6	12851.6	12844.6	12846.6	171.0
2012-11-23 02:00:00	YM	Futures	12846.6	12854.6	12844.6	12849.6	270.0
2012-11-23 03:00:00	YM	Futures	12848.6	12852.6	12807.6	12811.6	2123.0
2012-11-23 04:00:00	YM	Futures	12813.6	12837.6	12809.6	12834.6	1325.0
2012-11-23 05:00:00	YM	Futures	12834.6	12836.6	12818.6	12820.6	1093.0
2012-11-23 06:00:00	YM	Futures	12820.6	12830.6	12811.6	12830.6	970.0
2012-11-23 07:00:00	YM	Futures	12831.6	12837.6	12827.6	12837.6	333.0
2012-11-23 08:00:00	YM	Futures	12838.6	12851.6	12838.6	12845.6	1415.0
2012-11-23 09:00:00	YM	Futures	12845.6	12885.6	12844.6	12882.6	9702.0
2012-11-23 10:00:00	YM	Futures	12882.6	12945.7	12882.6	12926.7	15034.0
2012-11-23 11:00:00	YM	Futures	12926.7	12938.7	12913.6	12917.6	5757.0
2012-11-23 12:00:00	YM	Futures	12917.6	12988.7	12911.6	12983.7	9284.0
2012-11-23 13:00:00	YM	Futures	12982.7	12987.7	12959.7	12965.7	3518.0
2012-11-23 00:00:00	CL	Futures	140.85	140.88	140.75	140.87	208.0
2012-11-23 01:00:00	CL	Futures	140.88	140.93	140.67	140.88	416.0
2012-11-23 02:00:00	CL	Futures	140.88	141.03	140.71	140.96	522.0
2012-11-23 03:00:00	CL	Futures	140.96	141.03	140.43	140.5	1606.0
2012-11-23 04:00:00	CL	Futures	140.51	140.8	140.38	140.67	1798.0
2012-11-23 05:00:00	CL	Futures	140.64	140.79	140.53	140.54	881.0
2012-11-23 06:00:00	CL	Futures	140.58	140.92	140.56	140.77	1068.0
2012-11-23 07:00:00	CL	Futures	140.75	141.03	140.64	140.9	1473.0

> showing 50 of 935 rows — these rows as CSV

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