PREVIEW / futures_1hour / 2011-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-29.parquet
  size:    44 KB
  rows:    1,306

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-08-29 00:00:00	ES	Futures	1182.18	1185.67	1182.18	1183.43	9956.0
2011-08-29 01:00:00	ES	Futures	1183.43	1185.18	1182.43	1183.18	5712.0
2011-08-29 02:00:00	ES	Futures	1182.93	1184.93	1182.18	1183.18	10857.0
2011-08-29 03:00:00	ES	Futures	1183.18	1185.18	1182.18	1183.93	24864.0
2011-08-29 04:00:00	ES	Futures	1183.93	1185.18	1183.18	1184.18	13788.0
2011-08-29 05:00:00	ES	Futures	1184.18	1185.67	1183.93	1184.43	10903.0
2011-08-29 06:00:00	ES	Futures	1184.43	1185.18	1182.68	1184.68	12346.0
2011-08-29 07:00:00	ES	Futures	1184.68	1188.17	1183.93	1184.43	30876.0
2011-08-29 08:00:00	ES	Futures	1184.43	1187.42	1183.68	1185.67	44465.0
2011-08-29 09:00:00	ES	Futures	1185.92	1193.9	1185.18	1192.41	243861.0
2011-08-29 10:00:00	ES	Futures	1192.41	1195.9	1190.41	1192.41	270530.0
2011-08-29 11:00:00	ES	Futures	1192.16	1195.65	1189.17	1193.9	230555.0
2011-08-29 12:00:00	ES	Futures	1194.15	1199.14	1193.9	1197.89	167844.0
2011-08-29 13:00:00	ES	Futures	1197.89	1200.89	1196.9	1198.14	129121.0
2011-08-29 14:00:00	ES	Futures	1198.14	1203.13	1197.89	1201.14	168195.0
2011-08-29 15:00:00	ES	Futures	1201.14	1205.63	1200.39	1205.13	300695.0
2011-08-29 16:00:00	ES	Futures	1204.88	1205.88	1203.63	1204.63	106772.0
2011-08-29 17:00:00	ES	Futures	1204.63	1205.38	1204.13	1204.63	2584.0
2011-08-29 18:00:00	ES	Futures	1204.38	1204.63	1203.63	1203.88	3679.0
2011-08-29 19:00:00	ES	Futures	1204.13	1204.88	1203.88	1204.63	2676.0
2011-08-29 20:00:00	ES	Futures	1204.63	1207.12	1203.88	1205.13	9828.0
2011-08-29 21:00:00	ES	Futures	1205.38	1205.88	1203.63	1204.63	6033.0
2011-08-29 22:00:00	ES	Futures	1204.88	1206.62	1204.63	1205.88	4137.0
2011-08-29 23:00:00	ES	Futures	1205.63	1205.88	1203.88	1204.38	3901.0
2011-08-29 00:00:00	NQ	Futures	2506.44	2515.07	2506.15	2512.19	1383.0
2011-08-29 01:00:00	NQ	Futures	2511.62	2516.51	2511.62	2512.77	581.0
2011-08-29 02:00:00	NQ	Futures	2512.77	2516.8	2511.04	2513.34	1041.0
2011-08-29 03:00:00	NQ	Futures	2513.05	2516.51	2510.75	2512.77	2213.0
2011-08-29 04:00:00	NQ	Futures	2512.77	2515.07	2510.46	2512.77	946.0
2011-08-29 05:00:00	NQ	Futures	2513.05	2515.93	2510.75	2512.19	1050.0
2011-08-29 06:00:00	NQ	Futures	2511.9	2513.63	2509.31	2512.19	1236.0
2011-08-29 07:00:00	NQ	Futures	2512.19	2518.52	2511.62	2511.9	1995.0
2011-08-29 08:00:00	NQ	Futures	2512.19	2518.81	2510.75	2516.51	3694.0
2011-08-29 09:00:00	NQ	Futures	2516.51	2537.8	2511.62	2533.2	39997.0
2011-08-29 10:00:00	NQ	Futures	2533.2	2541.54	2527.44	2535.21	33231.0
2011-08-29 11:00:00	NQ	Futures	2534.92	2543.27	2528.31	2540.68	17594.0
2011-08-29 12:00:00	NQ	Futures	2540.68	2548.16	2540.1	2545.86	15817.0
2011-08-29 13:00:00	NQ	Futures	2545.57	2551.9	2542.41	2544.71	15521.0
2011-08-29 14:00:00	NQ	Futures	2544.42	2554.49	2544.13	2550.75	14933.0
2011-08-29 15:00:00	NQ	Futures	2550.46	2559.67	2548.16	2557.66	32881.0
2011-08-29 16:00:00	NQ	Futures	2557.37	2561.11	2553.34	2555.36	10577.0
2011-08-29 17:00:00	NQ	Futures	2555.36	2556.51	2554.78	2555.93	108.0
2011-08-29 18:00:00	NQ	Futures	2554.78	2555.64	2552.77	2553.92	270.0
2011-08-29 19:00:00	NQ	Futures	2553.92	2555.36	2553.92	2555.36	99.0
2011-08-29 20:00:00	NQ	Futures	2554.49	2560.54	2553.63	2556.51	484.0
2011-08-29 21:00:00	NQ	Futures	2556.79	2558.52	2553.92	2555.93	321.0
2011-08-29 22:00:00	NQ	Futures	2556.22	2558.52	2555.64	2557.37	298.0
2011-08-29 23:00:00	NQ	Futures	2557.08	2557.37	2553.63	2554.78	276.0
2011-08-29 00:00:00	YM	Futures	10993.3	11020.4	10993.3	11004.9	415.0
2011-08-29 01:00:00	YM	Futures	11003.9	11020.4	10997.1	11002.0	236.0

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

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