PREVIEW / futures_1hour / 2011-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-19.parquet
  size:    41 KB
  rows:    1,162

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-19 00:00:00	ES	Futures	1132.3	1133.3	1130.56	1132.55	4449.0
2011-08-19 01:00:00	ES	Futures	1132.55	1133.05	1128.56	1130.06	11711.0
2011-08-19 02:00:00	ES	Futures	1130.31	1136.29	1129.31	1135.79	26827.0
2011-08-19 03:00:00	ES	Futures	1136.04	1136.54	1114.84	1122.57	160240.0
2011-08-19 04:00:00	ES	Futures	1122.32	1125.07	1116.84	1123.07	82796.0
2011-08-19 05:00:00	ES	Futures	1123.07	1126.81	1119.33	1120.08	61423.0
2011-08-19 06:00:00	ES	Futures	1119.83	1123.82	1115.84	1120.83	60220.0
2011-08-19 07:00:00	ES	Futures	1120.58	1128.31	1118.58	1127.31	76159.0
2011-08-19 08:00:00	ES	Futures	1127.06	1133.55	1123.57	1124.32	119629.0
2011-08-19 09:00:00	ES	Futures	1124.32	1136.04	1119.33	1134.8	540163.0
2011-08-19 10:00:00	ES	Futures	1134.8	1150.51	1133.55	1140.03	633938.0
2011-08-19 11:00:00	ES	Futures	1140.03	1141.78	1129.06	1138.04	351819.0
2011-08-19 12:00:00	ES	Futures	1137.79	1138.54	1131.55	1134.8	166901.0
2011-08-19 13:00:00	ES	Futures	1134.8	1137.29	1127.81	1129.81	184055.0
2011-08-19 14:00:00	ES	Futures	1129.81	1131.8	1120.08	1122.08	307838.0
2011-08-19 15:00:00	ES	Futures	1122.08	1125.32	1116.34	1118.58	522642.0
2011-08-19 16:00:00	ES	Futures	1118.58	1123.32	1118.33	1121.08	140912.0
2011-08-19 00:00:00	NQ	Futures	2384.71	2385.86	2380.39	2383.56	345.0
2011-08-19 01:00:00	NQ	Futures	2384.14	2385.57	2375.5	2378.09	1113.0
2011-08-19 02:00:00	NQ	Futures	2378.38	2389.6	2376.08	2388.16	1585.0
2011-08-19 03:00:00	NQ	Futures	2388.16	2390.18	2348.45	2361.69	10624.0
2011-08-19 04:00:00	NQ	Futures	2361.4	2367.16	2351.04	2363.13	3914.0
2011-08-19 05:00:00	NQ	Futures	2362.55	2370.03	2355.07	2356.51	2410.0
2011-08-19 06:00:00	NQ	Futures	2357.09	2364.86	2346.15	2354.78	4432.0
2011-08-19 07:00:00	NQ	Futures	2354.21	2381.55	2349.89	2378.67	8161.0
2011-08-19 08:00:00	NQ	Futures	2378.67	2389.03	2367.16	2368.02	11582.0
2011-08-19 09:00:00	NQ	Futures	2368.02	2395.65	2360.25	2392.19	65175.0
2011-08-19 10:00:00	NQ	Futures	2392.77	2419.53	2387.59	2399.1	66982.0
2011-08-19 11:00:00	NQ	Futures	2399.1	2403.42	2377.8	2395.93	40249.0
2011-08-19 12:00:00	NQ	Futures	2396.22	2397.66	2382.98	2387.01	19226.0
2011-08-19 13:00:00	NQ	Futures	2387.01	2391.33	2368.88	2373.2	23464.0
2011-08-19 14:00:00	NQ	Futures	2373.2	2376.37	2351.33	2354.21	39279.0
2011-08-19 15:00:00	NQ	Futures	2354.5	2357.95	2340.97	2342.98	58481.0
2011-08-19 16:00:00	NQ	Futures	2343.27	2353.34	2342.41	2351.04	10747.0
2011-08-19 00:00:00	YM	Futures	10589.4	10600.1	10574.9	10592.4	782.0
2011-08-19 01:00:00	YM	Futures	10593.3	10598.2	10557.5	10571.0	951.0
2011-08-19 02:00:00	YM	Futures	10572.0	10624.3	10562.3	10617.5	792.0
2011-08-19 03:00:00	YM	Futures	10619.5	10629.2	10451.0	10514.9	4634.0
2011-08-19 04:00:00	YM	Futures	10514.9	10539.1	10474.2	10522.6	3037.0
2011-08-19 05:00:00	YM	Futures	10521.7	10545.9	10489.7	10496.5	1833.0
2011-08-19 06:00:00	YM	Futures	10494.5	10521.7	10468.4	10502.3	2015.0
2011-08-19 07:00:00	YM	Futures	10502.3	10547.8	10483.9	10543.0	2368.0
2011-08-19 08:00:00	YM	Futures	10541.0	10590.4	10514.9	10521.7	3384.0
2011-08-19 09:00:00	YM	Futures	10521.7	10592.4	10480.0	10569.1	25625.0
2011-08-19 10:00:00	YM	Futures	10571.0	10715.3	10560.4	10635.9	24981.0
2011-08-19 11:00:00	YM	Futures	10637.9	10649.5	10543.9	10621.4	18097.0
2011-08-19 12:00:00	YM	Futures	10621.4	10625.3	10562.3	10589.4	9641.0
2011-08-19 13:00:00	YM	Futures	10588.5	10606.9	10540.1	10554.6	11726.0
2011-08-19 14:00:00	YM	Futures	10553.6	10570.1	10477.1	10491.6	18286.0
2011-08-19 15:00:00	YM	Futures	10492.6	10519.7	10437.4	10454.8	27011.0

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

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