PREVIEW / futures_1hour / 2011-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-11.parquet
  size:    48 KB
  rows:    1,439

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-04-11 00:00:00	ES	Futures	1317.18	1319.66	1316.68	1318.67	4278.0
2011-04-11 01:00:00	ES	Futures	1318.92	1319.17	1317.43	1317.43	5322.0
2011-04-11 02:00:00	ES	Futures	1317.68	1319.66	1316.93	1319.17	7944.0
2011-04-11 03:00:00	ES	Futures	1319.17	1319.66	1317.18	1318.42	15848.0
2011-04-11 04:00:00	ES	Futures	1318.67	1318.67	1315.69	1316.68	28482.0
2011-04-11 05:00:00	ES	Futures	1316.68	1317.43	1315.94	1316.93	7907.0
2011-04-11 06:00:00	ES	Futures	1317.18	1320.16	1316.18	1319.41	14703.0
2011-04-11 07:00:00	ES	Futures	1319.41	1319.66	1317.43	1317.43	15076.0
2011-04-11 08:00:00	ES	Futures	1317.68	1318.42	1315.44	1318.17	35877.0
2011-04-11 09:00:00	ES	Futures	1317.92	1321.9	1316.93	1319.66	207607.0
2011-04-11 10:00:00	ES	Futures	1319.66	1320.91	1316.18	1319.41	215217.0
2011-04-11 11:00:00	ES	Futures	1319.41	1320.41	1316.93	1317.18	140097.0
2011-04-11 12:00:00	ES	Futures	1316.93	1317.68	1312.71	1312.71	151306.0
2011-04-11 13:00:00	ES	Futures	1312.96	1314.45	1311.96	1314.45	132194.0
2011-04-11 14:00:00	ES	Futures	1314.2	1315.69	1310.97	1311.46	164389.0
2011-04-11 15:00:00	ES	Futures	1311.46	1312.46	1308.73	1311.71	264197.0
2011-04-11 16:00:00	ES	Futures	1311.71	1312.21	1309.48	1310.22	75542.0
2011-04-11 17:00:00	ES	Futures	1310.47	1310.47	1308.98	1309.23	3276.0
2011-04-11 18:00:00	ES	Futures	1308.73	1310.22	1308.24	1308.73	5317.0
2011-04-11 19:00:00	ES	Futures	1308.98	1309.23	1307.99	1308.73	4943.0
2011-04-11 20:00:00	ES	Futures	1308.98	1309.23	1306.25	1306.74	15556.0
2011-04-11 21:00:00	ES	Futures	1306.99	1307.74	1305.5	1306.99	11563.0
2011-04-11 22:00:00	ES	Futures	1306.99	1306.99	1303.27	1304.26	15772.0
2011-04-11 23:00:00	ES	Futures	1304.26	1305.01	1301.78	1304.76	17687.0
2011-04-11 00:00:00	NQ	Futures	2671.74	2677.77	2670.88	2675.48	232.0
2011-04-11 01:00:00	NQ	Futures	2675.19	2675.76	2672.03	2672.6	156.0
2011-04-11 02:00:00	NQ	Futures	2672.31	2676.91	2670.59	2676.34	649.0
2011-04-11 03:00:00	NQ	Futures	2676.05	2676.91	2671.45	2674.04	1702.0
2011-04-11 04:00:00	NQ	Futures	2674.33	2674.33	2666.28	2668.87	2546.0
2011-04-11 05:00:00	NQ	Futures	2669.15	2671.17	2667.43	2669.73	673.0
2011-04-11 06:00:00	NQ	Futures	2670.02	2676.91	2667.43	2674.9	985.0
2011-04-11 07:00:00	NQ	Futures	2675.19	2675.19	2670.3	2671.17	1309.0
2011-04-11 08:00:00	NQ	Futures	2671.17	2674.61	2666.57	2673.46	4252.0
2011-04-11 09:00:00	NQ	Futures	2673.46	2679.5	2665.99	2666.57	41853.0
2011-04-11 10:00:00	NQ	Futures	2666.57	2669.15	2654.79	2664.27	43074.0
2011-04-11 11:00:00	NQ	Futures	2664.27	2668.87	2654.79	2655.08	18198.0
2011-04-11 12:00:00	NQ	Futures	2655.36	2658.24	2650.48	2650.77	22596.0
2011-04-11 13:00:00	NQ	Futures	2650.48	2656.8	2647.61	2655.36	20152.0
2011-04-11 14:00:00	NQ	Futures	2655.65	2658.52	2648.76	2649.9	18857.0
2011-04-11 15:00:00	NQ	Futures	2650.19	2655.36	2645.59	2654.5	34392.0
2011-04-11 16:00:00	NQ	Futures	2654.5	2657.09	2648.18	2649.62	7483.0
2011-04-11 17:00:00	NQ	Futures	2649.62	2650.19	2647.32	2648.47	195.0
2011-04-11 18:00:00	NQ	Futures	2648.47	2650.48	2646.74	2647.32	327.0
2011-04-11 19:00:00	NQ	Futures	2647.89	2648.76	2646.17	2648.47	189.0
2011-04-11 20:00:00	NQ	Futures	2648.47	2648.76	2643.87	2645.02	734.0
2011-04-11 21:00:00	NQ	Futures	2644.73	2645.88	2642.43	2644.45	570.0
2011-04-11 22:00:00	NQ	Futures	2644.16	2644.16	2637.55	2638.99	841.0
2011-04-11 23:00:00	NQ	Futures	2639.56	2643.01	2635.25	2641.86	1891.0
2011-04-11 00:00:00	YM	Futures	11891.5	11908.9	11888.6	11902.1	209.0
2011-04-11 01:00:00	YM	Futures	11902.1	11904.0	11889.6	11892.5	188.0

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

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