PREVIEW / futures_1hour / 2011-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-03.parquet
  size:    51 KB
  rows:    1,490

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-03 00:00:00	ES	Futures	1120.64	1123.15	1119.63	1122.89	7421.0
2011-10-03 01:00:00	ES	Futures	1122.89	1124.4	1119.38	1120.39	12527.0
2011-10-03 02:00:00	ES	Futures	1120.39	1121.39	1114.62	1118.88	28654.0
2011-10-03 03:00:00	ES	Futures	1119.13	1123.9	1116.63	1121.89	51926.0
2011-10-03 04:00:00	ES	Futures	1121.89	1127.16	1121.14	1121.89	39076.0
2011-10-03 05:00:00	ES	Futures	1121.89	1127.16	1121.89	1123.15	25148.0
2011-10-03 06:00:00	ES	Futures	1123.15	1129.16	1121.64	1127.16	37597.0
2011-10-03 07:00:00	ES	Futures	1127.16	1128.41	1124.65	1128.16	48421.0
2011-10-03 08:00:00	ES	Futures	1127.91	1130.17	1121.14	1121.39	60820.0
2011-10-03 09:00:00	ES	Futures	1121.39	1126.91	1117.88	1118.88	279574.0
2011-10-03 10:00:00	ES	Futures	1119.13	1136.94	1117.88	1121.39	666187.0
2011-10-03 11:00:00	ES	Futures	1121.39	1129.41	1118.38	1127.91	376596.0
2011-10-03 12:00:00	ES	Futures	1128.16	1129.16	1113.87	1114.37	276291.0
2011-10-03 13:00:00	ES	Futures	1114.62	1114.62	1101.08	1106.34	384530.0
2011-10-03 14:00:00	ES	Futures	1106.09	1110.36	1098.57	1103.84	342408.0
2011-10-03 15:00:00	ES	Futures	1103.84	1110.11	1095.31	1096.06	582118.0
2011-10-03 16:00:00	ES	Futures	1096.06	1097.32	1088.54	1089.79	210293.0
2011-10-03 17:00:00	ES	Futures	1089.79	1089.79	1087.29	1088.29	5595.0
2011-10-03 18:00:00	ES	Futures	1089.54	1091.55	1088.29	1091.55	9352.0
2011-10-03 19:00:00	ES	Futures	1091.3	1091.55	1087.54	1090.55	8577.0
2011-10-03 20:00:00	ES	Futures	1090.55	1091.3	1087.54	1089.29	16803.0
2011-10-03 21:00:00	ES	Futures	1089.54	1093.56	1088.29	1093.31	15926.0
2011-10-03 22:00:00	ES	Futures	1093.31	1095.06	1091.55	1094.31	10768.0
2011-10-03 23:00:00	ES	Futures	1094.31	1094.56	1087.29	1088.54	9166.0
2011-10-03 00:00:00	NQ	Futures	2439.21	2444.97	2436.9	2442.96	1003.0
2011-10-03 01:00:00	NQ	Futures	2443.24	2444.4	2435.75	2437.48	1808.0
2011-10-03 02:00:00	NQ	Futures	2436.32	2438.05	2424.22	2433.15	3130.0
2011-10-03 03:00:00	NQ	Futures	2433.15	2442.96	2427.96	2438.34	5234.0
2011-10-03 04:00:00	NQ	Futures	2438.05	2451.03	2437.19	2438.92	3513.0
2011-10-03 05:00:00	NQ	Futures	2438.92	2449.59	2438.34	2441.51	2820.0
2011-10-03 06:00:00	NQ	Futures	2441.23	2453.05	2439.21	2448.72	3383.0
2011-10-03 07:00:00	NQ	Futures	2448.43	2450.45	2443.24	2449.59	6432.0
2011-10-03 08:00:00	NQ	Futures	2449.59	2453.91	2436.61	2437.77	5968.0
2011-10-03 09:00:00	NQ	Futures	2437.77	2454.49	2427.68	2431.71	51833.0
2011-10-03 10:00:00	NQ	Futures	2431.14	2477.27	2427.68	2443.53	102918.0
2011-10-03 11:00:00	NQ	Futures	2443.82	2463.14	2438.63	2457.95	41035.0
2011-10-03 12:00:00	NQ	Futures	2458.24	2460.26	2427.68	2430.56	36221.0
2011-10-03 13:00:00	NQ	Futures	2430.27	2430.27	2406.05	2418.16	52453.0
2011-10-03 14:00:00	NQ	Futures	2417.87	2424.79	2398.27	2407.49	40465.0
2011-10-03 15:00:00	NQ	Futures	2407.2	2424.79	2395.67	2396.25	64016.0
2011-10-03 16:00:00	NQ	Futures	2396.25	2397.11	2378.95	2382.7	23798.0
2011-10-03 17:00:00	NQ	Futures	2382.99	2382.99	2376.35	2378.66	870.0
2011-10-03 18:00:00	NQ	Futures	2380.1	2383.56	2377.51	2383.56	493.0
2011-10-03 19:00:00	NQ	Futures	2383.85	2384.43	2375.78	2381.83	1117.0
2011-10-03 20:00:00	NQ	Futures	2381.83	2383.85	2376.93	2380.97	890.0
2011-10-03 21:00:00	NQ	Futures	2381.26	2388.46	2378.66	2388.46	961.0
2011-10-03 22:00:00	NQ	Futures	2388.18	2391.06	2385.0	2390.19	1985.0
2011-10-03 23:00:00	NQ	Futures	2390.19	2390.19	2376.35	2378.08	807.0
2011-10-03 00:00:00	YM	Futures	10600.8	10621.4	10592.9	10618.5	604.0
2011-10-03 01:00:00	YM	Futures	10619.5	10626.4	10588.0	10596.8	1049.0

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

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