PREVIEW / futures_1hour / 2014-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-20.parquet
  size:    41 KB
  rows:    1,246

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
2014-06-20 00:00:00	ES	Futures	2032.53	2032.79	2032.01	2032.79	1803.0
2014-06-20 01:00:00	ES	Futures	2032.79	2033.05	2032.01	2032.01	2114.0
2014-06-20 02:00:00	ES	Futures	2032.27	2032.53	2031.23	2031.49	6370.0
2014-06-20 03:00:00	ES	Futures	2031.75	2032.53	2030.96	2032.01	13546.0
2014-06-20 04:00:00	ES	Futures	2031.75	2033.31	2031.75	2033.31	8609.0
2014-06-20 05:00:00	ES	Futures	2033.57	2035.13	2032.53	2034.87	15852.0
2014-06-20 06:00:00	ES	Futures	2034.61	2034.87	2032.79	2033.83	12735.0
2014-06-20 07:00:00	ES	Futures	2033.83	2034.35	2032.79	2033.83	15116.0
2014-06-20 08:00:00	ES	Futures	2033.57	2038.52	2033.57	2036.7	50302.0
2014-06-20 09:00:00	ES	Futures	2036.7	2039.83	2035.4	2036.44	252265.0
2014-06-20 10:00:00	ES	Futures	2036.44	2038.26	2034.87	2036.96	185179.0
2014-06-20 11:00:00	ES	Futures	2037.22	2038.52	2036.18	2037.22	116243.0
2014-06-20 12:00:00	ES	Futures	2036.96	2037.48	2035.66	2036.44	62942.0
2014-06-20 13:00:00	ES	Futures	2036.18	2036.7	2034.87	2035.66	59459.0
2014-06-20 14:00:00	ES	Futures	2035.66	2036.96	2035.13	2035.92	55404.0
2014-06-20 15:00:00	ES	Futures	2035.92	2038.26	2035.4	2037.74	144257.0
2014-06-20 16:00:00	ES	Futures	2037.48	2037.74	2035.66	2036.7	104778.0
2014-06-20 17:00:00	ES	Futures	2036.96	2037.74	2036.7	2036.7	2324.0
2014-06-20 00:00:00	NQ	Futures	4423.44	4423.73	4422.27	4423.73	301.0
2014-06-20 01:00:00	NQ	Futures	4423.44	4423.73	4421.98	4422.27	380.0
2014-06-20 02:00:00	NQ	Futures	4422.27	4423.15	4421.1	4421.39	497.0
2014-06-20 03:00:00	NQ	Futures	4421.39	4424.9	4420.81	4423.73	1696.0
2014-06-20 04:00:00	NQ	Futures	4423.15	4426.94	4423.15	4426.94	1363.0
2014-06-20 05:00:00	NQ	Futures	4426.94	4431.32	4425.19	4431.32	2010.0
2014-06-20 06:00:00	NQ	Futures	4431.32	4431.32	4426.94	4428.99	1862.0
2014-06-20 07:00:00	NQ	Futures	4428.69	4429.86	4426.65	4428.99	1645.0
2014-06-20 08:00:00	NQ	Futures	4428.69	4434.24	4428.4	4430.45	5259.0
2014-06-20 09:00:00	NQ	Futures	4430.45	4438.04	4426.94	4431.61	38335.0
2014-06-20 10:00:00	NQ	Futures	4431.61	4435.41	4421.69	4426.94	29100.0
2014-06-20 11:00:00	NQ	Futures	4427.23	4433.07	4424.9	4426.65	17508.0
2014-06-20 12:00:00	NQ	Futures	4426.65	4428.99	4422.56	4427.53	10195.0
2014-06-20 13:00:00	NQ	Futures	4427.82	4428.4	4423.15	4426.65	8856.0
2014-06-20 14:00:00	NQ	Futures	4426.65	4430.15	4424.31	4427.23	11300.0
2014-06-20 15:00:00	NQ	Futures	4427.23	4432.49	4426.36	4431.91	18048.0
2014-06-20 16:00:00	NQ	Futures	4431.91	4434.83	4429.86	4433.07	6646.0
2014-06-20 17:00:00	NQ	Futures	4433.07	4433.95	4431.91	4431.91	335.0
2014-06-20 00:00:00	YM	Futures	17403.5	17405.6	17400.4	17403.5	266.0
2014-06-20 01:00:00	YM	Futures	17405.6	17406.6	17401.4	17401.4	478.0
2014-06-20 02:00:00	YM	Futures	17401.4	17404.5	17395.2	17396.3	714.0
2014-06-20 03:00:00	YM	Futures	17398.3	17410.7	17395.2	17405.6	1977.0
2014-06-20 04:00:00	YM	Futures	17406.6	17415.9	17403.5	17415.9	1082.0
2014-06-20 05:00:00	YM	Futures	17414.9	17430.4	17408.7	17428.3	2002.0
2014-06-20 06:00:00	YM	Futures	17429.4	17429.4	17415.9	17421.1	1248.0
2014-06-20 07:00:00	YM	Futures	17421.1	17423.2	17411.8	17419.0	1609.0
2014-06-20 08:00:00	YM	Futures	17419.0	17449.0	17419.0	17440.7	3695.0
2014-06-20 09:00:00	YM	Futures	17440.7	17466.6	17429.4	17455.2	20501.0
2014-06-20 10:00:00	YM	Futures	17454.2	17468.7	17441.8	17465.6	15449.0
2014-06-20 11:00:00	YM	Futures	17466.6	17478.0	17453.2	17461.4	11456.0
2014-06-20 12:00:00	YM	Futures	17461.4	17463.5	17449.0	17452.1	5622.0
2014-06-20 13:00:00	YM	Futures	17452.1	17453.2	17435.6	17445.9	5427.0

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

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