PREVIEW / futures_1hour / 2011-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-06.parquet
  size:    52 KB
  rows:    1,506

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-10-06 00:00:00	ES	Futures	1136.18	1138.44	1135.93	1137.94	4972.0
2011-10-06 01:00:00	ES	Futures	1138.19	1139.19	1134.43	1137.44	9089.0
2011-10-06 02:00:00	ES	Futures	1137.44	1141.7	1137.19	1139.44	16045.0
2011-10-06 03:00:00	ES	Futures	1139.7	1143.71	1136.44	1143.71	41253.0
2011-10-06 04:00:00	ES	Futures	1143.71	1149.47	1142.45	1147.47	52032.0
2011-10-06 05:00:00	ES	Futures	1147.47	1149.47	1144.21	1145.21	30809.0
2011-10-06 06:00:00	ES	Futures	1145.21	1147.97	1143.71	1147.47	28320.0
2011-10-06 07:00:00	ES	Futures	1147.22	1151.98	1139.19	1142.96	141618.0
2011-10-06 08:00:00	ES	Futures	1142.7	1149.22	1138.69	1143.21	158868.0
2011-10-06 09:00:00	ES	Futures	1142.96	1143.46	1132.42	1136.44	399492.0
2011-10-06 10:00:00	ES	Futures	1136.44	1150.98	1133.68	1145.21	502811.0
2011-10-06 11:00:00	ES	Futures	1145.21	1158.25	1144.46	1154.74	406450.0
2011-10-06 12:00:00	ES	Futures	1154.49	1157.75	1151.98	1152.48	214247.0
2011-10-06 13:00:00	ES	Futures	1152.48	1155.74	1148.97	1153.49	203614.0
2011-10-06 14:00:00	ES	Futures	1153.49	1159.76	1151.73	1155.99	192319.0
2011-10-06 15:00:00	ES	Futures	1155.99	1164.02	1151.23	1162.51	355504.0
2011-10-06 16:00:00	ES	Futures	1162.51	1163.27	1160.51	1161.01	99031.0
2011-10-06 17:00:00	ES	Futures	1161.01	1161.76	1160.51	1161.51	1430.0
2011-10-06 18:00:00	ES	Futures	1161.26	1162.77	1160.51	1161.01	4690.0
2011-10-06 19:00:00	ES	Futures	1161.26	1161.51	1160.26	1161.26	4333.0
2011-10-06 20:00:00	ES	Futures	1161.26	1161.76	1158.5	1159.0	8113.0
2011-10-06 21:00:00	ES	Futures	1159.0	1159.25	1158.0	1158.5	4886.0
2011-10-06 22:00:00	ES	Futures	1158.75	1161.26	1158.5	1160.51	4448.0
2011-10-06 23:00:00	ES	Futures	1160.26	1163.52	1160.01	1162.51	5428.0
2011-10-06 00:00:00	NQ	Futures	2487.93	2494.57	2487.36	2493.99	1105.0
2011-10-06 01:00:00	NQ	Futures	2493.99	2496.01	2486.2	2495.14	1328.0
2011-10-06 02:00:00	NQ	Futures	2495.14	2507.25	2493.7	2503.22	1597.0
2011-10-06 03:00:00	NQ	Futures	2503.22	2511.0	2496.3	2509.56	2729.0
2011-10-06 04:00:00	NQ	Futures	2509.85	2522.53	2506.96	2516.48	3282.0
2011-10-06 05:00:00	NQ	Futures	2517.06	2519.07	2508.41	2511.0	2565.0
2011-10-06 06:00:00	NQ	Futures	2510.71	2516.48	2508.69	2513.02	2326.0
2011-10-06 07:00:00	NQ	Futures	2512.73	2521.67	2504.66	2511.29	11540.0
2011-10-06 08:00:00	NQ	Futures	2511.0	2525.42	2504.95	2514.46	18361.0
2011-10-06 09:00:00	NQ	Futures	2514.75	2516.19	2494.57	2506.96	51948.0
2011-10-06 10:00:00	NQ	Futures	2506.68	2540.12	2500.62	2525.13	71305.0
2011-10-06 11:00:00	NQ	Futures	2524.84	2540.7	2519.36	2536.08	47927.0
2011-10-06 12:00:00	NQ	Futures	2535.51	2546.46	2533.2	2533.49	37391.0
2011-10-06 13:00:00	NQ	Futures	2533.49	2539.26	2520.23	2532.91	43757.0
2011-10-06 14:00:00	NQ	Futures	2532.91	2544.16	2528.88	2538.97	27544.0
2011-10-06 15:00:00	NQ	Futures	2539.54	2552.52	2528.01	2551.37	37513.0
2011-10-06 16:00:00	NQ	Futures	2551.37	2553.1	2542.43	2545.31	12316.0
2011-10-06 17:00:00	NQ	Futures	2545.6	2547.04	2544.73	2545.6	377.0
2011-10-06 18:00:00	NQ	Futures	2545.31	2547.04	2543.29	2545.31	378.0
2011-10-06 19:00:00	NQ	Futures	2545.02	2545.31	2543.0	2544.45	264.0
2011-10-06 20:00:00	NQ	Futures	2544.45	2545.6	2539.83	2540.7	399.0
2011-10-06 21:00:00	NQ	Futures	2540.7	2540.99	2538.97	2540.7	362.0
2011-10-06 22:00:00	NQ	Futures	2540.99	2545.6	2540.99	2543.29	472.0
2011-10-06 23:00:00	NQ	Futures	2543.0	2549.35	2542.72	2548.19	306.0
2011-10-06 00:00:00	YM	Futures	10655.9	10671.6	10654.9	10669.7	289.0
2011-10-06 01:00:00	YM	Futures	10668.7	10679.5	10647.0	10669.7	854.0

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

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