PREVIEW / futures_1hour / 2011-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-08.parquet
  size:    53 KB
  rows:    1,486

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-08 00:00:00	ES	Futures	1166.97	1168.46	1162.23	1168.22	21476.0
2011-08-08 01:00:00	ES	Futures	1167.97	1169.46	1161.73	1161.98	17250.0
2011-08-08 02:00:00	ES	Futures	1161.98	1174.7	1160.23	1171.96	66464.0
2011-08-08 03:00:00	ES	Futures	1171.71	1186.17	1170.46	1180.69	141012.0
2011-08-08 04:00:00	ES	Futures	1180.69	1181.18	1169.71	1170.46	88187.0
2011-08-08 05:00:00	ES	Futures	1170.21	1172.95	1159.49	1166.22	94265.0
2011-08-08 06:00:00	ES	Futures	1166.22	1167.97	1160.23	1164.97	66077.0
2011-08-08 07:00:00	ES	Futures	1164.72	1171.96	1163.98	1169.96	64882.0
2011-08-08 08:00:00	ES	Futures	1169.71	1171.96	1162.23	1162.98	94574.0
2011-08-08 09:00:00	ES	Futures	1162.98	1175.45	1159.49	1167.47	691390.0
2011-08-08 10:00:00	ES	Futures	1167.47	1170.46	1144.77	1150.01	918765.0
2011-08-08 11:00:00	ES	Futures	1150.01	1165.22	1148.01	1155.25	706148.0
2011-08-08 12:00:00	ES	Futures	1155.25	1155.25	1146.02	1148.01	377152.0
2011-08-08 13:00:00	ES	Futures	1148.01	1152.0	1132.8	1133.3	484063.0
2011-08-08 14:00:00	ES	Futures	1133.3	1140.28	1112.1	1123.57	802462.0
2011-08-08 15:00:00	ES	Futures	1123.82	1146.27	1114.34	1114.34	988997.0
2011-08-08 16:00:00	ES	Futures	1114.59	1115.59	1106.86	1110.85	277564.0
2011-08-08 17:00:00	ES	Futures	1110.6	1111.85	1106.61	1107.86	9102.0
2011-08-08 18:00:00	ES	Futures	1107.86	1109.11	1097.38	1099.63	34109.0
2011-08-08 19:00:00	ES	Futures	1099.63	1104.62	1099.63	1102.37	13856.0
2011-08-08 20:00:00	ES	Futures	1102.12	1103.37	1094.14	1095.64	33058.0
2011-08-08 21:00:00	ES	Futures	1095.64	1097.38	1077.93	1083.67	69793.0
2011-08-08 22:00:00	ES	Futures	1083.92	1086.41	1074.44	1084.91	51629.0
2011-08-08 23:00:00	ES	Futures	1085.16	1089.4	1079.43	1082.17	36889.0
2011-08-08 00:00:00	NQ	Futures	2461.26	2463.27	2452.62	2462.41	2414.0
2011-08-08 01:00:00	NQ	Futures	2462.7	2464.42	2449.46	2449.46	2189.0
2011-08-08 02:00:00	NQ	Futures	2449.75	2472.19	2443.99	2467.01	6827.0
2011-08-08 03:00:00	NQ	Futures	2466.72	2498.67	2464.13	2485.72	11030.0
2011-08-08 04:00:00	NQ	Futures	2485.72	2487.16	2461.83	2462.98	4526.0
2011-08-08 05:00:00	NQ	Futures	2462.41	2468.74	2444.85	2453.77	6341.0
2011-08-08 06:00:00	NQ	Futures	2454.35	2459.82	2442.84	2451.76	3125.0
2011-08-08 07:00:00	NQ	Futures	2451.18	2467.59	2450.9	2464.13	4616.0
2011-08-08 08:00:00	NQ	Futures	2463.27	2468.16	2451.47	2452.91	9342.0
2011-08-08 09:00:00	NQ	Futures	2453.2	2488.31	2443.7	2467.88	106669.0
2011-08-08 10:00:00	NQ	Futures	2467.88	2472.19	2414.93	2431.9	129442.0
2011-08-08 11:00:00	NQ	Futures	2431.62	2464.71	2427.3	2445.72	98487.0
2011-08-08 12:00:00	NQ	Futures	2445.43	2445.43	2427.88	2436.22	42303.0
2011-08-08 13:00:00	NQ	Futures	2436.22	2444.85	2411.47	2412.91	53131.0
2011-08-08 14:00:00	NQ	Futures	2412.62	2428.16	2370.9	2389.89	91736.0
2011-08-08 15:00:00	NQ	Futures	2389.89	2430.47	2370.03	2370.61	101055.0
2011-08-08 16:00:00	NQ	Futures	2370.32	2372.05	2338.38	2347.88	39375.0
2011-08-08 17:00:00	NQ	Futures	2348.74	2350.75	2339.53	2340.97	735.0
2011-08-08 18:00:00	NQ	Futures	2341.26	2344.71	2317.09	2324.57	2743.0
2011-08-08 19:00:00	NQ	Futures	2324.57	2334.06	2324.57	2330.9	963.0
2011-08-08 20:00:00	NQ	Futures	2330.32	2332.63	2310.18	2314.5	2151.0
2011-08-08 21:00:00	NQ	Futures	2314.78	2318.81	2276.22	2288.6	3912.0
2011-08-08 22:00:00	NQ	Futures	2288.89	2295.79	2270.18	2293.2	3354.0
2011-08-08 23:00:00	NQ	Futures	2293.2	2304.42	2281.69	2290.32	2954.0
2011-08-08 00:00:00	YM	Futures	10797.7	10809.3	10761.8	10808.3	3290.0
2011-08-08 01:00:00	YM	Futures	10808.3	10819.0	10759.9	10763.8	1866.0

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

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