PREVIEW / futures_1hour / 2011-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-16.parquet
  size:    48 KB
  rows:    1,434

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-16 00:00:00	ES	Futures	1191.16	1191.41	1190.16	1190.91	3817.0
2011-08-16 01:00:00	ES	Futures	1191.16	1191.16	1189.42	1189.91	5414.0
2011-08-16 02:00:00	ES	Futures	1190.16	1190.16	1184.18	1186.67	39441.0
2011-08-16 03:00:00	ES	Futures	1186.42	1187.17	1180.69	1185.92	50007.0
2011-08-16 04:00:00	ES	Futures	1185.92	1186.17	1178.44	1180.69	40489.0
2011-08-16 05:00:00	ES	Futures	1180.69	1184.93	1180.69	1183.18	22916.0
2011-08-16 06:00:00	ES	Futures	1183.18	1183.68	1177.69	1178.94	26069.0
2011-08-16 07:00:00	ES	Futures	1178.94	1182.18	1178.19	1179.69	41026.0
2011-08-16 08:00:00	ES	Futures	1179.69	1181.93	1176.94	1181.43	62354.0
2011-08-16 09:00:00	ES	Futures	1181.43	1190.16	1180.94	1184.18	327365.0
2011-08-16 10:00:00	ES	Futures	1183.93	1192.91	1183.18	1192.66	328932.0
2011-08-16 11:00:00	ES	Futures	1192.66	1194.9	1187.92	1193.65	198650.0
2011-08-16 12:00:00	ES	Futures	1193.65	1198.64	1181.68	1182.93	451833.0
2011-08-16 13:00:00	ES	Futures	1183.18	1185.92	1174.7	1184.18	259424.0
2011-08-16 14:00:00	ES	Futures	1184.18	1189.91	1180.94	1181.68	195004.0
2011-08-16 15:00:00	ES	Futures	1181.43	1193.41	1181.18	1187.17	357133.0
2011-08-16 16:00:00	ES	Futures	1187.42	1190.41	1186.42	1188.92	108567.0
2011-08-16 17:00:00	ES	Futures	1188.92	1189.42	1187.17	1187.67	3412.0
2011-08-16 18:00:00	ES	Futures	1187.42	1187.67	1183.43	1183.93	7558.0
2011-08-16 19:00:00	ES	Futures	1183.68	1185.18	1183.18	1184.93	6979.0
2011-08-16 20:00:00	ES	Futures	1184.93	1186.67	1183.68	1185.67	9131.0
2011-08-16 21:00:00	ES	Futures	1185.67	1186.17	1182.18	1183.18	8356.0
2011-08-16 22:00:00	ES	Futures	1183.18	1186.17	1182.18	1185.92	4440.0
2011-08-16 23:00:00	ES	Futures	1185.92	1186.92	1183.68	1186.67	3658.0
2011-08-16 00:00:00	NQ	Futures	2530.32	2530.9	2528.59	2529.17	196.0
2011-08-16 01:00:00	NQ	Futures	2530.03	2530.03	2525.43	2526.87	372.0
2011-08-16 02:00:00	NQ	Futures	2527.15	2527.44	2517.08	2519.67	1816.0
2011-08-16 03:00:00	NQ	Futures	2519.67	2521.4	2507.87	2517.37	3912.0
2011-08-16 04:00:00	NQ	Futures	2517.66	2517.95	2502.41	2507.01	3794.0
2011-08-16 05:00:00	NQ	Futures	2507.3	2515.36	2507.01	2511.33	1812.0
2011-08-16 06:00:00	NQ	Futures	2511.62	2513.63	2504.71	2507.01	1916.0
2011-08-16 07:00:00	NQ	Futures	2506.44	2512.48	2505.28	2509.31	2542.0
2011-08-16 08:00:00	NQ	Futures	2509.6	2514.21	2504.13	2512.77	6072.0
2011-08-16 09:00:00	NQ	Futures	2512.77	2527.44	2512.19	2515.93	39362.0
2011-08-16 10:00:00	NQ	Futures	2515.64	2539.53	2513.63	2538.95	34080.0
2011-08-16 11:00:00	NQ	Futures	2538.67	2538.95	2526.58	2534.35	16570.0
2011-08-16 12:00:00	NQ	Futures	2534.35	2545.28	2507.01	2508.45	56736.0
2011-08-16 13:00:00	NQ	Futures	2508.45	2517.66	2490.32	2513.92	40879.0
2011-08-16 14:00:00	NQ	Futures	2513.92	2521.69	2507.59	2508.74	28945.0
2011-08-16 15:00:00	NQ	Futures	2508.74	2536.08	2507.59	2523.41	41125.0
2011-08-16 16:00:00	NQ	Futures	2523.7	2533.2	2522.55	2524.28	14515.0
2011-08-16 17:00:00	NQ	Futures	2524.56	2526.0	2522.55	2525.43	292.0
2011-08-16 18:00:00	NQ	Futures	2524.28	2524.28	2517.37	2517.37	393.0
2011-08-16 19:00:00	NQ	Futures	2517.66	2519.67	2512.77	2517.08	622.0
2011-08-16 20:00:00	NQ	Futures	2517.37	2520.25	2514.49	2518.81	892.0
2011-08-16 21:00:00	NQ	Futures	2519.67	2519.67	2512.19	2514.21	444.0
2011-08-16 22:00:00	NQ	Futures	2514.49	2518.52	2512.48	2518.52	513.0
2011-08-16 23:00:00	NQ	Futures	2518.52	2521.4	2514.78	2520.54	299.0
2011-08-16 00:00:00	YM	Futures	11016.5	11020.4	11009.7	11016.5	134.0
2011-08-16 01:00:00	YM	Futures	11017.5	11017.5	11004.9	11007.8	292.0

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

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