PREVIEW / futures_1hour / 2011-10-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1088.54	1094.31	1088.04	1092.3	7543.0
2011-10-04 01:00:00	ES	Futures	1092.55	1096.56	1090.8	1096.56	10192.0
2011-10-04 02:00:00	ES	Futures	1096.31	1097.32	1095.06	1096.06	14484.0
2011-10-04 03:00:00	ES	Futures	1095.81	1096.06	1081.77	1082.52	76314.0
2011-10-04 04:00:00	ES	Futures	1082.27	1090.3	1081.02	1087.29	67189.0
2011-10-04 05:00:00	ES	Futures	1087.29	1090.8	1082.77	1088.79	49673.0
2011-10-04 06:00:00	ES	Futures	1088.79	1089.29	1080.27	1080.52	45483.0
2011-10-04 07:00:00	ES	Futures	1080.52	1084.03	1076.25	1077.26	61494.0
2011-10-04 08:00:00	ES	Futures	1077.01	1082.77	1075.0	1081.52	112529.0
2011-10-04 09:00:00	ES	Futures	1081.52	1086.03	1071.24	1075.75	467943.0
2011-10-04 10:00:00	ES	Futures	1075.75	1092.05	1071.49	1089.29	761831.0
2011-10-04 11:00:00	ES	Futures	1089.54	1096.31	1084.28	1093.05	441074.0
2011-10-04 12:00:00	ES	Futures	1093.05	1100.58	1093.05	1096.06	303927.0
2011-10-04 13:00:00	ES	Futures	1095.81	1097.57	1087.04	1088.29	260684.0
2011-10-04 14:00:00	ES	Futures	1088.04	1092.55	1079.26	1080.52	341944.0
2011-10-04 15:00:00	ES	Futures	1080.77	1123.15	1075.75	1120.64	863009.0
2011-10-04 16:00:00	ES	Futures	1120.39	1121.64	1110.86	1116.37	235498.0
2011-10-04 17:00:00	ES	Futures	1116.37	1119.13	1116.12	1118.63	7012.0
2011-10-04 18:00:00	ES	Futures	1118.13	1120.89	1115.62	1119.89	13223.0
2011-10-04 19:00:00	ES	Futures	1120.14	1121.89	1118.88	1119.13	7653.0
2011-10-04 20:00:00	ES	Futures	1119.13	1119.38	1112.61	1115.87	15292.0
2011-10-04 21:00:00	ES	Futures	1116.12	1116.63	1111.61	1112.86	12063.0
2011-10-04 22:00:00	ES	Futures	1112.86	1115.37	1111.36	1114.37	10089.0
2011-10-04 23:00:00	ES	Futures	1114.37	1117.13	1113.62	1115.62	6778.0
2011-10-04 00:00:00	NQ	Futures	2379.24	2390.77	2377.51	2387.31	408.0
2011-10-04 01:00:00	NQ	Futures	2386.45	2393.36	2383.56	2393.36	1240.0
2011-10-04 02:00:00	NQ	Futures	2393.65	2395.38	2390.19	2392.79	935.0
2011-10-04 03:00:00	NQ	Futures	2391.63	2392.21	2365.69	2365.69	7195.0
2011-10-04 04:00:00	NQ	Futures	2365.69	2380.39	2363.09	2376.93	5062.0
2011-10-04 05:00:00	NQ	Futures	2376.93	2382.99	2367.7	2380.39	2345.0
2011-10-04 06:00:00	NQ	Futures	2380.1	2382.12	2366.55	2367.13	2726.0
2011-10-04 07:00:00	NQ	Futures	2366.84	2374.91	2356.75	2359.05	4340.0
2011-10-04 08:00:00	NQ	Futures	2359.05	2373.47	2354.44	2371.74	9086.0
2011-10-04 09:00:00	NQ	Futures	2371.74	2382.7	2357.32	2368.28	56082.0
2011-10-04 10:00:00	NQ	Futures	2368.28	2405.76	2355.59	2402.3	88583.0
2011-10-04 11:00:00	NQ	Futures	2402.59	2419.89	2395.96	2416.14	56906.0
2011-10-04 12:00:00	NQ	Futures	2416.14	2432.86	2410.66	2412.39	37787.0
2011-10-04 13:00:00	NQ	Futures	2412.39	2417.58	2386.73	2388.18	49456.0
2011-10-04 14:00:00	NQ	Futures	2387.89	2397.11	2361.36	2363.09	71881.0
2011-10-04 15:00:00	NQ	Futures	2363.38	2451.32	2347.81	2447.28	114034.0
2011-10-04 16:00:00	NQ	Futures	2446.99	2452.76	2425.95	2437.48	25217.0
2011-10-04 17:00:00	NQ	Futures	2436.9	2442.38	2436.9	2441.51	452.0
2011-10-04 18:00:00	NQ	Futures	2441.23	2449.59	2438.05	2449.01	1825.0
2011-10-04 19:00:00	NQ	Futures	2448.72	2451.03	2444.97	2444.97	641.0
2011-10-04 20:00:00	NQ	Futures	2445.26	2445.84	2432.86	2439.78	1631.0
2011-10-04 21:00:00	NQ	Futures	2439.5	2441.23	2429.98	2432.0	1210.0
2011-10-04 22:00:00	NQ	Futures	2432.29	2436.04	2429.41	2433.73	882.0
2011-10-04 23:00:00	NQ	Futures	2432.86	2439.21	2431.71	2436.61	472.0
2011-10-04 00:00:00	YM	Futures	10360.5	10405.8	10354.6	10392.0	817.0
2011-10-04 01:00:00	YM	Futures	10392.0	10424.5	10380.2	10423.5	1161.0

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

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