PREVIEW / futures_1hour / 2011-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-02.parquet
  size:    49 KB
  rows:    1,491

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
2011-02-02 00:00:00	ES	Futures	1289.1	1289.34	1288.6	1288.85	1211.0
2011-02-02 01:00:00	ES	Futures	1288.85	1289.1	1288.35	1289.1	2683.0
2011-02-02 02:00:00	ES	Futures	1289.1	1289.84	1288.35	1289.1	7061.0
2011-02-02 03:00:00	ES	Futures	1289.34	1291.82	1288.85	1290.83	24212.0
2011-02-02 04:00:00	ES	Futures	1290.83	1291.07	1289.1	1289.59	13078.0
2011-02-02 05:00:00	ES	Futures	1289.59	1291.57	1289.34	1290.83	14821.0
2011-02-02 06:00:00	ES	Futures	1290.83	1292.06	1289.34	1289.59	25894.0
2011-02-02 07:00:00	ES	Futures	1289.59	1290.33	1288.6	1288.85	24655.0
2011-02-02 08:00:00	ES	Futures	1288.85	1289.59	1286.37	1287.12	72680.0
2011-02-02 09:00:00	ES	Futures	1287.36	1290.08	1284.64	1289.59	249021.0
2011-02-02 10:00:00	ES	Futures	1289.59	1290.83	1286.37	1289.1	234244.0
2011-02-02 11:00:00	ES	Futures	1289.1	1289.34	1286.37	1288.85	150900.0
2011-02-02 12:00:00	ES	Futures	1288.85	1289.34	1286.37	1288.11	112044.0
2011-02-02 13:00:00	ES	Futures	1288.11	1289.1	1287.12	1287.86	70904.0
2011-02-02 14:00:00	ES	Futures	1288.11	1289.59	1287.36	1289.34	79002.0
2011-02-02 15:00:00	ES	Futures	1289.1	1290.08	1285.88	1287.12	205803.0
2011-02-02 16:00:00	ES	Futures	1286.87	1288.11	1286.13	1286.87	60195.0
2011-02-02 17:00:00	ES	Futures	1286.87	1287.12	1286.62	1286.62	718.0
2011-02-02 18:00:00	ES	Futures	1286.87	1287.61	1286.37	1287.12	2943.0
2011-02-02 19:00:00	ES	Futures	1287.12	1287.61	1286.37	1287.36	2045.0
2011-02-02 20:00:00	ES	Futures	1287.36	1287.61	1286.87	1287.12	1162.0
2011-02-02 21:00:00	ES	Futures	1287.36	1287.36	1286.62	1287.12	928.0
2011-02-02 22:00:00	ES	Futures	1286.87	1287.12	1284.39	1284.64	7257.0
2011-02-02 23:00:00	ES	Futures	1284.64	1285.14	1283.4	1284.89	6045.0
2011-02-02 00:00:00	NQ	Futures	2665.67	2665.96	2662.23	2662.8	164.0
2011-02-02 01:00:00	NQ	Futures	2663.09	2663.95	2662.23	2663.66	306.0
2011-02-02 02:00:00	NQ	Futures	2663.37	2664.81	2661.36	2662.51	761.0
2011-02-02 03:00:00	NQ	Futures	2662.51	2667.39	2661.36	2665.96	1100.0
2011-02-02 04:00:00	NQ	Futures	2665.96	2665.96	2663.09	2663.95	448.0
2011-02-02 05:00:00	NQ	Futures	2664.24	2667.11	2663.95	2666.53	416.0
2011-02-02 06:00:00	NQ	Futures	2666.53	2668.25	2663.66	2663.66	989.0
2011-02-02 07:00:00	NQ	Futures	2663.37	2666.53	2662.8	2664.52	780.0
2011-02-02 08:00:00	NQ	Futures	2664.52	2665.38	2658.78	2661.08	5641.0
2011-02-02 09:00:00	NQ	Futures	2661.08	2667.11	2654.48	2665.67	56909.0
2011-02-02 10:00:00	NQ	Futures	2665.67	2672.56	2657.06	2667.39	44927.0
2011-02-02 11:00:00	NQ	Futures	2667.11	2668.83	2660.79	2668.83	19897.0
2011-02-02 12:00:00	NQ	Futures	2668.83	2668.83	2661.94	2665.1	15398.0
2011-02-02 13:00:00	NQ	Futures	2665.1	2665.96	2662.51	2663.37	9256.0
2011-02-02 14:00:00	NQ	Futures	2663.66	2668.25	2662.8	2667.39	8317.0
2011-02-02 15:00:00	NQ	Futures	2667.11	2669.69	2658.49	2661.65	20632.0
2011-02-02 16:00:00	NQ	Futures	2661.65	2663.66	2661.36	2663.37	4679.0
2011-02-02 17:00:00	NQ	Futures	2663.37	2663.37	2662.8	2663.37	17.0
2011-02-02 18:00:00	NQ	Futures	2662.23	2663.09	2661.65	2662.23	208.0
2011-02-02 19:00:00	NQ	Futures	2661.65	2662.51	2661.65	2661.65	297.0
2011-02-02 20:00:00	NQ	Futures	2661.65	2662.8	2661.65	2662.23	127.0
2011-02-02 21:00:00	NQ	Futures	2662.23	2662.51	2660.79	2661.36	71.0
2011-02-02 22:00:00	NQ	Futures	2661.08	2661.08	2656.2	2656.2	322.0
2011-02-02 23:00:00	NQ	Futures	2656.2	2657.35	2655.05	2657.06	274.0
2011-02-02 00:00:00	YM	Futures	11472.3	11472.3	11465.6	11466.6	39.0
2011-02-02 01:00:00	YM	Futures	11467.5	11472.3	11464.7	11472.3	145.0

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

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