PREVIEW / futures_1hour / 2010-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-27.parquet
  size:    48 KB
  rows:    1,453

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
2010-10-27 00:00:00	ES	Futures	1161.65	1161.9	1159.68	1160.42	10664.0
2010-10-27 01:00:00	ES	Futures	1160.18	1161.41	1159.93	1161.16	5509.0
2010-10-27 02:00:00	ES	Futures	1160.92	1161.9	1159.44	1160.42	16346.0
2010-10-27 03:00:00	ES	Futures	1160.18	1160.42	1157.71	1159.19	45764.0
2010-10-27 04:00:00	ES	Futures	1159.19	1160.18	1158.45	1158.94	19519.0
2010-10-27 05:00:00	ES	Futures	1158.94	1162.64	1157.71	1160.92	34702.0
2010-10-27 06:00:00	ES	Futures	1160.92	1162.89	1160.67	1161.9	20756.0
2010-10-27 07:00:00	ES	Futures	1161.9	1162.39	1159.44	1159.93	23238.0
2010-10-27 08:00:00	ES	Futures	1160.18	1161.41	1157.22	1158.2	89699.0
2010-10-27 09:00:00	ES	Futures	1158.2	1160.92	1156.23	1160.92	259405.0
2010-10-27 10:00:00	ES	Futures	1160.92	1162.39	1153.52	1153.52	444471.0
2010-10-27 11:00:00	ES	Futures	1153.52	1156.48	1151.8	1155.25	322091.0
2010-10-27 12:00:00	ES	Futures	1155.49	1155.99	1152.78	1153.52	115743.0
2010-10-27 13:00:00	ES	Futures	1153.52	1155.99	1151.3	1155.74	163254.0
2010-10-27 14:00:00	ES	Futures	1155.99	1159.68	1155.0	1158.2	227992.0
2010-10-27 15:00:00	ES	Futures	1157.96	1163.87	1156.73	1162.15	301761.0
2010-10-27 16:00:00	ES	Futures	1162.39	1162.64	1160.92	1161.41	97812.0
2010-10-27 17:00:00	ES	Futures	1161.16	1161.9	1161.16	1161.65	1532.0
2010-10-27 18:00:00	ES	Futures	1161.41	1161.9	1160.92	1161.65	2476.0
2010-10-27 19:00:00	ES	Futures	1161.65	1163.63	1161.65	1162.89	6469.0
2010-10-27 20:00:00	ES	Futures	1162.89	1163.63	1161.9	1163.13	4824.0
2010-10-27 21:00:00	ES	Futures	1163.13	1163.38	1161.65	1162.15	4431.0
2010-10-27 22:00:00	ES	Futures	1161.9	1163.13	1161.65	1162.89	2534.0
2010-10-27 23:00:00	ES	Futures	1162.89	1164.61	1162.64	1164.12	5305.0
2010-10-27 00:00:00	NQ	Futures	2423.75	2424.33	2420.31	2422.03	721.0
2010-10-27 01:00:00	NQ	Futures	2421.74	2423.47	2421.46	2422.89	282.0
2010-10-27 02:00:00	NQ	Futures	2422.6	2424.9	2420.6	2421.74	1289.0
2010-10-27 03:00:00	NQ	Futures	2421.74	2422.32	2417.15	2421.17	2826.0
2010-10-27 04:00:00	NQ	Futures	2420.6	2422.6	2419.16	2419.16	1388.0
2010-10-27 05:00:00	NQ	Futures	2419.45	2426.62	2417.44	2420.31	3242.0
2010-10-27 06:00:00	NQ	Futures	2420.6	2425.76	2420.6	2424.61	989.0
2010-10-27 07:00:00	NQ	Futures	2424.61	2425.47	2418.88	2418.88	2220.0
2010-10-27 08:00:00	NQ	Futures	2419.16	2421.46	2414.57	2418.3	7309.0
2010-10-27 09:00:00	NQ	Futures	2418.3	2432.65	2412.56	2431.21	45300.0
2010-10-27 10:00:00	NQ	Futures	2431.21	2434.08	2416.87	2417.44	52549.0
2010-10-27 11:00:00	NQ	Futures	2417.73	2423.18	2412.56	2420.31	38258.0
2010-10-27 12:00:00	NQ	Futures	2420.6	2421.46	2415.72	2418.88	13165.0
2010-10-27 13:00:00	NQ	Futures	2418.88	2426.05	2413.14	2426.05	24195.0
2010-10-27 14:00:00	NQ	Futures	2426.05	2432.07	2423.75	2428.92	22263.0
2010-10-27 15:00:00	NQ	Futures	2428.92	2438.67	2425.47	2437.24	37917.0
2010-10-27 16:00:00	NQ	Futures	2437.24	2438.67	2430.64	2433.79	9614.0
2010-10-27 17:00:00	NQ	Futures	2433.79	2434.08	2432.36	2433.51	321.0
2010-10-27 18:00:00	NQ	Futures	2434.08	2434.08	2432.07	2433.22	231.0
2010-10-27 19:00:00	NQ	Futures	2433.79	2438.67	2433.22	2438.1	657.0
2010-10-27 20:00:00	NQ	Futures	2437.81	2439.25	2436.66	2438.1	798.0
2010-10-27 21:00:00	NQ	Futures	2438.67	2438.67	2436.09	2436.66	628.0
2010-10-27 22:00:00	NQ	Futures	2436.66	2438.38	2436.09	2437.81	307.0
2010-10-27 23:00:00	NQ	Futures	2438.1	2438.96	2437.81	2438.38	244.0
2010-10-27 00:00:00	YM	Futures	10558.2	10561.1	10544.9	10550.6	506.0
2010-10-27 01:00:00	YM	Futures	10549.7	10558.2	10547.7	10557.3	302.0

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

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