PREVIEW / futures_1hour / 2012-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-08.parquet
  size:    48 KB
  rows:    1,483

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-08-08 00:00:00	ES	Futures	1418.9	1419.66	1418.39	1418.65	2871.0
2012-08-08 01:00:00	ES	Futures	1418.65	1419.41	1418.14	1419.16	3611.0
2012-08-08 02:00:00	ES	Futures	1419.41	1419.92	1417.38	1417.88	8489.0
2012-08-08 03:00:00	ES	Futures	1417.88	1419.16	1416.61	1417.88	24507.0
2012-08-08 04:00:00	ES	Futures	1418.14	1419.41	1416.87	1417.38	20986.0
2012-08-08 05:00:00	ES	Futures	1417.38	1417.88	1415.85	1416.61	20020.0
2012-08-08 06:00:00	ES	Futures	1416.87	1419.66	1415.85	1417.12	25298.0
2012-08-08 07:00:00	ES	Futures	1417.12	1418.14	1416.61	1416.61	20015.0
2012-08-08 08:00:00	ES	Futures	1416.87	1417.12	1414.32	1415.09	47489.0
2012-08-08 09:00:00	ES	Futures	1415.09	1419.66	1414.83	1418.39	159385.0
2012-08-08 10:00:00	ES	Futures	1418.14	1420.17	1417.38	1419.16	197545.0
2012-08-08 11:00:00	ES	Futures	1419.41	1424.24	1418.9	1422.46	209895.0
2012-08-08 12:00:00	ES	Futures	1422.72	1423.73	1420.17	1421.95	82003.0
2012-08-08 13:00:00	ES	Futures	1422.21	1423.73	1421.19	1421.95	63434.0
2012-08-08 14:00:00	ES	Futures	1421.95	1422.21	1419.41	1420.43	102069.0
2012-08-08 15:00:00	ES	Futures	1420.68	1423.48	1420.43	1422.72	150133.0
2012-08-08 16:00:00	ES	Futures	1422.72	1423.48	1421.19	1421.7	60359.0
2012-08-08 17:00:00	ES	Futures	1421.7	1421.7	1420.94	1421.19	1165.0
2012-08-08 18:00:00	ES	Futures	1421.44	1421.95	1421.19	1421.44	1457.0
2012-08-08 19:00:00	ES	Futures	1421.44	1421.44	1420.94	1420.94	918.0
2012-08-08 20:00:00	ES	Futures	1420.94	1421.7	1420.43	1420.68	3073.0
2012-08-08 21:00:00	ES	Futures	1420.68	1424.5	1420.43	1424.5	8754.0
2012-08-08 22:00:00	ES	Futures	1424.24	1425.77	1423.99	1425.0	7157.0
2012-08-08 23:00:00	ES	Futures	1425.0	1426.02	1424.75	1426.02	4740.0
2012-08-08 00:00:00	NQ	Futures	3142.64	3144.67	3142.35	3143.8	864.0
2012-08-08 01:00:00	NQ	Futures	3143.51	3144.09	3142.35	3144.09	784.0
2012-08-08 02:00:00	NQ	Futures	3144.38	3145.25	3140.03	3140.9	1105.0
2012-08-08 03:00:00	NQ	Futures	3141.19	3144.67	3139.16	3142.35	2347.0
2012-08-08 04:00:00	NQ	Futures	3142.64	3145.25	3139.45	3139.74	1671.0
2012-08-08 05:00:00	NQ	Futures	3140.61	3141.48	3136.27	3138.0	1770.0
2012-08-08 06:00:00	NQ	Futures	3137.71	3142.93	3135.69	3138.87	2504.0
2012-08-08 07:00:00	NQ	Futures	3138.58	3141.19	3137.71	3138.0	1843.0
2012-08-08 08:00:00	NQ	Futures	3138.0	3138.29	3133.37	3133.66	5497.0
2012-08-08 09:00:00	NQ	Futures	3133.66	3145.25	3133.37	3136.85	29518.0
2012-08-08 10:00:00	NQ	Futures	3136.56	3142.93	3131.63	3137.14	27353.0
2012-08-08 11:00:00	NQ	Futures	3137.42	3149.89	3135.11	3147.28	22254.0
2012-08-08 12:00:00	NQ	Futures	3146.99	3150.47	3138.87	3144.09	24152.0
2012-08-08 13:00:00	NQ	Futures	3144.38	3146.99	3140.9	3144.38	20241.0
2012-08-08 14:00:00	NQ	Futures	3144.09	3144.96	3139.16	3140.32	9261.0
2012-08-08 15:00:00	NQ	Futures	3140.32	3145.25	3138.58	3142.64	15431.0
2012-08-08 16:00:00	NQ	Futures	3142.64	3146.12	3137.71	3139.16	5731.0
2012-08-08 17:00:00	NQ	Futures	3138.87	3138.87	3137.71	3138.29	78.0
2012-08-08 18:00:00	NQ	Futures	3138.29	3139.45	3138.29	3138.87	63.0
2012-08-08 19:00:00	NQ	Futures	3138.87	3139.16	3138.0	3138.29	140.0
2012-08-08 20:00:00	NQ	Futures	3138.29	3138.87	3137.14	3137.71	346.0
2012-08-08 21:00:00	NQ	Futures	3138.0	3146.12	3137.71	3145.83	776.0
2012-08-08 22:00:00	NQ	Futures	3146.12	3149.02	3144.67	3148.15	790.0
2012-08-08 23:00:00	NQ	Futures	3148.15	3153.08	3147.86	3152.79	1298.0
2012-08-08 00:00:00	YM	Futures	13027.7	13033.6	13022.7	13026.7	394.0
2012-08-08 01:00:00	YM	Futures	13025.7	13030.7	13022.7	13030.7	356.0

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

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