PREVIEW / futures_1hour / 2012-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-06.parquet
  size:    48 KB
  rows:    1,477

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-02-06 00:00:00	ES	Futures	1345.62	1346.37	1344.86	1345.36	2938.0
2012-02-06 01:00:00	ES	Futures	1345.62	1345.62	1344.61	1345.11	2796.0
2012-02-06 02:00:00	ES	Futures	1345.11	1346.88	1343.85	1346.37	11040.0
2012-02-06 03:00:00	ES	Futures	1346.62	1346.62	1342.59	1343.1	27800.0
2012-02-06 04:00:00	ES	Futures	1343.1	1344.1	1340.83	1342.84	29066.0
2012-02-06 05:00:00	ES	Futures	1342.59	1344.61	1342.09	1343.6	13609.0
2012-02-06 06:00:00	ES	Futures	1343.35	1345.36	1342.34	1344.1	21962.0
2012-02-06 07:00:00	ES	Futures	1344.1	1347.13	1343.85	1346.12	31579.0
2012-02-06 08:00:00	ES	Futures	1346.12	1346.37	1343.1	1343.1	42052.0
2012-02-06 09:00:00	ES	Futures	1343.1	1348.64	1343.1	1347.13	162958.0
2012-02-06 10:00:00	ES	Futures	1347.38	1349.14	1345.36	1347.63	203663.0
2012-02-06 11:00:00	ES	Futures	1347.63	1349.65	1346.88	1349.14	170838.0
2012-02-06 12:00:00	ES	Futures	1349.14	1350.4	1347.63	1349.65	124249.0
2012-02-06 13:00:00	ES	Futures	1349.65	1350.15	1347.13	1348.14	65523.0
2012-02-06 14:00:00	ES	Futures	1347.88	1349.9	1347.88	1348.89	56252.0
2012-02-06 15:00:00	ES	Futures	1348.89	1351.16	1348.89	1350.66	134233.0
2012-02-06 16:00:00	ES	Futures	1350.66	1351.16	1349.14	1350.91	65146.0
2012-02-06 17:00:00	ES	Futures	1350.91	1351.16	1350.66	1350.66	1641.0
2012-02-06 18:00:00	ES	Futures	1350.66	1351.66	1350.66	1350.66	4607.0
2012-02-06 19:00:00	ES	Futures	1350.66	1351.66	1349.9	1351.16	4625.0
2012-02-06 20:00:00	ES	Futures	1351.41	1353.18	1350.91	1352.42	7406.0
2012-02-06 21:00:00	ES	Futures	1352.17	1352.67	1350.15	1350.66	5272.0
2012-02-06 22:00:00	ES	Futures	1350.66	1351.66	1349.14	1349.9	6793.0
2012-02-06 23:00:00	ES	Futures	1349.9	1350.15	1349.14	1349.4	2615.0
2012-02-06 00:00:00	NQ	Futures	2909.93	2910.51	2908.2	2908.78	235.0
2012-02-06 01:00:00	NQ	Futures	2908.78	2909.07	2906.76	2908.49	252.0
2012-02-06 02:00:00	NQ	Futures	2908.78	2911.09	2906.18	2911.09	664.0
2012-02-06 03:00:00	NQ	Futures	2910.51	2910.51	2903.0	2903.87	2488.0
2012-02-06 04:00:00	NQ	Futures	2903.58	2906.18	2900.11	2903.87	1916.0
2012-02-06 05:00:00	NQ	Futures	2903.29	2907.04	2902.42	2903.87	1659.0
2012-02-06 06:00:00	NQ	Futures	2903.87	2907.91	2900.98	2904.73	1413.0
2012-02-06 07:00:00	NQ	Futures	2904.73	2910.51	2904.16	2907.33	3054.0
2012-02-06 08:00:00	NQ	Futures	2907.62	2907.91	2901.85	2902.13	4440.0
2012-02-06 09:00:00	NQ	Futures	2902.13	2910.51	2900.98	2908.78	31318.0
2012-02-06 10:00:00	NQ	Futures	2908.78	2913.11	2903.0	2907.91	25452.0
2012-02-06 11:00:00	NQ	Futures	2907.91	2912.82	2906.18	2911.95	18597.0
2012-02-06 12:00:00	NQ	Futures	2911.95	2916.57	2907.91	2915.13	18215.0
2012-02-06 13:00:00	NQ	Futures	2915.42	2916.57	2911.09	2913.11	10925.0
2012-02-06 14:00:00	NQ	Futures	2913.11	2916.57	2911.95	2911.95	8665.0
2012-02-06 15:00:00	NQ	Futures	2911.66	2917.73	2911.66	2917.15	17012.0
2012-02-06 16:00:00	NQ	Futures	2916.86	2919.46	2914.84	2919.17	8124.0
2012-02-06 17:00:00	NQ	Futures	2918.88	2920.04	2918.88	2918.88	130.0
2012-02-06 18:00:00	NQ	Futures	2917.73	2920.04	2917.73	2919.17	169.0
2012-02-06 19:00:00	NQ	Futures	2918.88	2920.91	2917.73	2919.75	340.0
2012-02-06 20:00:00	NQ	Futures	2919.75	2922.93	2919.46	2922.06	397.0
2012-02-06 21:00:00	NQ	Futures	2921.77	2922.64	2918.6	2919.46	392.0
2012-02-06 22:00:00	NQ	Futures	2919.46	2921.48	2916.29	2917.15	546.0
2012-02-06 23:00:00	NQ	Futures	2917.15	2918.02	2916.29	2916.57	172.0
2012-02-06 00:00:00	YM	Futures	12651.8	12656.8	12644.9	12648.9	297.0
2012-02-06 01:00:00	YM	Futures	12648.9	12648.9	12639.9	12645.9	266.0

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

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