PREVIEW / futures_1hour / 2012-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-07.parquet
  size:    49 KB
  rows:    1,511

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-07 00:00:00	ES	Futures	1349.4	1349.9	1348.89	1349.4	3722.0
2012-02-07 01:00:00	ES	Futures	1349.65	1349.65	1348.64	1348.89	2119.0
2012-02-07 02:00:00	ES	Futures	1348.89	1352.67	1348.64	1352.42	11335.0
2012-02-07 03:00:00	ES	Futures	1352.42	1353.18	1349.4	1349.9	27216.0
2012-02-07 04:00:00	ES	Futures	1349.9	1349.9	1347.38	1349.65	23689.0
2012-02-07 05:00:00	ES	Futures	1349.65	1350.15	1347.88	1348.64	13857.0
2012-02-07 06:00:00	ES	Futures	1348.64	1348.89	1345.87	1345.87	27243.0
2012-02-07 07:00:00	ES	Futures	1346.12	1346.37	1343.85	1345.11	40229.0
2012-02-07 08:00:00	ES	Futures	1345.36	1348.89	1344.36	1346.88	80663.0
2012-02-07 09:00:00	ES	Futures	1347.13	1349.14	1343.6	1345.36	211675.0
2012-02-07 10:00:00	ES	Futures	1345.36	1352.17	1342.34	1351.92	283303.0
2012-02-07 11:00:00	ES	Futures	1351.92	1354.44	1351.41	1352.67	223341.0
2012-02-07 12:00:00	ES	Futures	1352.92	1354.18	1352.67	1353.93	62141.0
2012-02-07 13:00:00	ES	Futures	1353.93	1355.19	1351.92	1354.18	112936.0
2012-02-07 14:00:00	ES	Futures	1354.44	1354.69	1351.41	1352.17	71284.0
2012-02-07 15:00:00	ES	Futures	1352.17	1356.45	1351.92	1353.93	201435.0
2012-02-07 16:00:00	ES	Futures	1353.93	1355.7	1353.68	1354.94	66988.0
2012-02-07 17:00:00	ES	Futures	1354.94	1355.19	1354.44	1354.44	1093.0
2012-02-07 18:00:00	ES	Futures	1354.18	1354.94	1353.18	1353.68	5285.0
2012-02-07 19:00:00	ES	Futures	1353.43	1354.44	1353.43	1354.44	3193.0
2012-02-07 20:00:00	ES	Futures	1354.44	1354.69	1353.93	1354.18	2022.0
2012-02-07 21:00:00	ES	Futures	1354.18	1354.94	1354.18	1354.94	2425.0
2012-02-07 22:00:00	ES	Futures	1354.69	1355.44	1354.69	1355.19	3342.0
2012-02-07 23:00:00	ES	Futures	1355.19	1355.7	1355.19	1355.44	1902.0
2012-02-07 00:00:00	NQ	Futures	2916.57	2917.73	2915.71	2916.86	222.0
2012-02-07 01:00:00	NQ	Futures	2916.86	2917.73	2916.29	2916.57	177.0
2012-02-07 02:00:00	NQ	Futures	2916.86	2924.37	2916.0	2923.79	1311.0
2012-02-07 03:00:00	NQ	Futures	2923.79	2925.82	2918.02	2918.88	2162.0
2012-02-07 04:00:00	NQ	Futures	2918.88	2918.88	2913.11	2917.15	2147.0
2012-02-07 05:00:00	NQ	Futures	2917.44	2918.6	2914.55	2915.71	1046.0
2012-02-07 06:00:00	NQ	Futures	2915.42	2916.29	2910.8	2911.09	1525.0
2012-02-07 07:00:00	NQ	Futures	2910.8	2910.8	2905.31	2907.33	3812.0
2012-02-07 08:00:00	NQ	Futures	2907.33	2915.13	2905.6	2911.95	5345.0
2012-02-07 09:00:00	NQ	Futures	2912.24	2916.57	2903.58	2909.93	41046.0
2012-02-07 10:00:00	NQ	Futures	2909.64	2922.64	2901.56	2922.06	37918.0
2012-02-07 11:00:00	NQ	Futures	2922.35	2927.55	2921.2	2923.79	22378.0
2012-02-07 12:00:00	NQ	Futures	2923.79	2928.13	2923.51	2926.39	7228.0
2012-02-07 13:00:00	NQ	Futures	2926.39	2927.84	2919.75	2923.51	11418.0
2012-02-07 14:00:00	NQ	Futures	2923.79	2924.66	2917.73	2918.6	10228.0
2012-02-07 15:00:00	NQ	Futures	2918.6	2926.39	2917.73	2922.64	20489.0
2012-02-07 16:00:00	NQ	Futures	2922.35	2924.37	2920.04	2921.77	5732.0
2012-02-07 17:00:00	NQ	Futures	2922.06	2922.35	2920.62	2920.62	96.0
2012-02-07 18:00:00	NQ	Futures	2920.62	2921.48	2919.17	2919.46	323.0
2012-02-07 19:00:00	NQ	Futures	2919.75	2920.91	2919.46	2920.62	315.0
2012-02-07 20:00:00	NQ	Futures	2920.62	2921.2	2920.04	2920.33	197.0
2012-02-07 21:00:00	NQ	Futures	2920.33	2922.35	2920.33	2922.06	280.0
2012-02-07 22:00:00	NQ	Futures	2922.06	2923.79	2922.06	2923.79	230.0
2012-02-07 23:00:00	NQ	Futures	2923.79	2924.37	2923.51	2924.08	115.0
2012-02-07 00:00:00	YM	Futures	12657.8	12662.7	12655.8	12658.8	128.0
2012-02-07 01:00:00	YM	Futures	12658.8	12660.8	12652.8	12654.8	160.0

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

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