PREVIEW / futures_1hour / 2011-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-17.parquet
  size:    34 KB
  rows:    983

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-01-17 00:00:00	ES	Futures	1272.76	1273.51	1272.52	1273.51	2162.0
2011-01-17 01:00:00	ES	Futures	1273.26	1273.51	1272.52	1272.52	2221.0
2011-01-17 02:00:00	ES	Futures	1272.76	1273.01	1271.78	1272.27	8848.0
2011-01-17 03:00:00	ES	Futures	1272.27	1273.75	1271.78	1272.27	18421.0
2011-01-17 04:00:00	ES	Futures	1272.02	1272.76	1271.03	1272.27	15047.0
2011-01-17 05:00:00	ES	Futures	1272.27	1273.26	1272.02	1272.76	8276.0
2011-01-17 06:00:00	ES	Futures	1272.76	1274.0	1272.76	1273.01	7571.0
2011-01-17 07:00:00	ES	Futures	1273.26	1274.0	1272.02	1273.26	5985.0
2011-01-17 08:00:00	ES	Futures	1273.26	1273.75	1270.29	1271.03	18391.0
2011-01-17 09:00:00	ES	Futures	1271.03	1272.52	1269.55	1271.53	27873.0
2011-01-17 10:00:00	ES	Futures	1271.28	1272.02	1270.29	1271.53	15435.0
2011-01-17 11:00:00	ES	Futures	1271.53	1272.27	1271.03	1272.02	9654.0
2011-01-17 18:00:00	ES	Futures	1272.27	1272.27	1270.79	1271.78	6182.0
2011-01-17 19:00:00	ES	Futures	1271.78	1272.76	1271.03	1272.76	4620.0
2011-01-17 20:00:00	ES	Futures	1272.76	1273.26	1272.52	1273.01	3149.0
2011-01-17 21:00:00	ES	Futures	1272.76	1273.26	1272.52	1273.26	2333.0
2011-01-17 22:00:00	ES	Futures	1273.26	1274.74	1273.01	1273.51	5379.0
2011-01-17 23:00:00	ES	Futures	1273.51	1274.74	1273.26	1273.51	5626.0
2011-01-17 00:00:00	NQ	Futures	2660.5	2661.36	2659.93	2661.08	182.0
2011-01-17 01:00:00	NQ	Futures	2661.36	2661.36	2659.36	2659.93	196.0
2011-01-17 02:00:00	NQ	Futures	2659.64	2660.79	2658.21	2659.07	587.0
2011-01-17 03:00:00	NQ	Futures	2659.07	2661.94	2658.21	2659.07	1202.0
2011-01-17 04:00:00	NQ	Futures	2659.07	2659.93	2657.35	2659.07	1813.0
2011-01-17 05:00:00	NQ	Futures	2659.07	2660.79	2658.78	2660.22	577.0
2011-01-17 06:00:00	NQ	Futures	2660.5	2663.09	2659.07	2659.93	1234.0
2011-01-17 07:00:00	NQ	Futures	2659.64	2662.23	2658.21	2661.36	547.0
2011-01-17 08:00:00	NQ	Futures	2661.36	2661.94	2649.02	2649.88	7824.0
2011-01-17 09:00:00	NQ	Futures	2649.88	2650.46	2632.37	2635.82	17362.0
2011-01-17 10:00:00	NQ	Futures	2634.96	2635.24	2623.76	2626.63	11338.0
2011-01-17 11:00:00	NQ	Futures	2626.92	2632.66	2626.06	2631.23	3763.0
2011-01-17 18:00:00	NQ	Futures	2631.8	2667.39	2631.51	2634.96	3843.0
2011-01-17 19:00:00	NQ	Futures	2634.96	2636.11	2632.09	2635.24	521.0
2011-01-17 20:00:00	NQ	Futures	2635.24	2636.68	2633.52	2635.53	543.0
2011-01-17 21:00:00	NQ	Futures	2635.82	2639.26	2634.96	2637.54	659.0
2011-01-17 22:00:00	NQ	Futures	2637.54	2640.41	2636.97	2638.98	690.0
2011-01-17 23:00:00	NQ	Futures	2638.98	2640.7	2638.69	2639.26	626.0
2011-01-17 00:00:00	YM	Futures	11214.7	11217.5	11210.8	11214.7	156.0
2011-01-17 01:00:00	YM	Futures	11215.6	11216.6	11210.8	11211.8	119.0
2011-01-17 02:00:00	YM	Futures	11210.8	11215.6	11206.1	11208.9	708.0
2011-01-17 03:00:00	YM	Futures	11209.9	11222.3	11205.1	11208.9	1422.0
2011-01-17 04:00:00	YM	Futures	11208.9	11212.8	11203.2	11211.8	621.0
2011-01-17 05:00:00	YM	Futures	11210.8	11218.5	11208.9	11215.6	468.0
2011-01-17 06:00:00	YM	Futures	11217.5	11227.1	11216.6	11218.5	384.0
2011-01-17 07:00:00	YM	Futures	11218.5	11224.3	11210.8	11220.4	279.0
2011-01-17 08:00:00	YM	Futures	11222.3	11224.3	11197.4	11204.1	1239.0
2011-01-17 09:00:00	YM	Futures	11203.2	11214.7	11194.6	11209.9	2033.0
2011-01-17 10:00:00	YM	Futures	11208.9	11213.7	11200.3	11210.8	1071.0
2011-01-17 11:00:00	YM	Futures	11211.8	11217.5	11208.9	11217.5	426.0
2011-01-17 18:00:00	YM	Futures	11217.5	11217.5	11206.1	11214.7	163.0
2011-01-17 19:00:00	YM	Futures	11214.7	11218.5	11206.1	11218.5	237.0

> showing 50 of 983 rows — these rows as CSV

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