PREVIEW / futures_1hour / 2014-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-08.parquet
  size:    49 KB
  rows:    1,510

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-09-08 00:00:00	ES	Futures	2089.08	2089.6	2088.82	2089.34	1152.0
2014-09-08 01:00:00	ES	Futures	2089.34	2089.6	2088.82	2089.08	1213.0
2014-09-08 02:00:00	ES	Futures	2089.08	2089.34	2087.78	2088.3	6648.0
2014-09-08 03:00:00	ES	Futures	2088.3	2089.34	2087.26	2089.08	17434.0
2014-09-08 04:00:00	ES	Futures	2089.34	2089.6	2087.26	2088.04	11599.0
2014-09-08 05:00:00	ES	Futures	2088.04	2088.82	2087.0	2087.26	10456.0
2014-09-08 06:00:00	ES	Futures	2087.52	2088.82	2087.0	2087.52	14139.0
2014-09-08 07:00:00	ES	Futures	2087.78	2088.82	2086.74	2088.3	13143.0
2014-09-08 08:00:00	ES	Futures	2088.56	2089.08	2086.74	2087.26	24642.0
2014-09-08 09:00:00	ES	Futures	2087.26	2091.17	2087.0	2089.86	123455.0
2014-09-08 10:00:00	ES	Futures	2089.86	2091.43	2084.13	2087.78	209662.0
2014-09-08 11:00:00	ES	Futures	2087.78	2089.86	2085.17	2085.69	145745.0
2014-09-08 12:00:00	ES	Futures	2085.95	2087.52	2084.91	2086.48	63998.0
2014-09-08 13:00:00	ES	Futures	2086.74	2087.26	2078.66	2079.96	200692.0
2014-09-08 14:00:00	ES	Futures	2080.22	2083.09	2079.7	2082.31	88232.0
2014-09-08 15:00:00	ES	Futures	2082.57	2086.74	2082.31	2085.17	157969.0
2014-09-08 16:00:00	ES	Futures	2085.17	2086.48	2084.65	2086.48	57752.0
2014-09-08 17:00:00	ES	Futures	2086.48	2086.48	2085.43	2085.69	1286.0
2014-09-08 18:00:00	ES	Futures	2085.17	2085.69	2084.39	2084.65	3260.0
2014-09-08 19:00:00	ES	Futures	2084.91	2085.17	2084.39	2084.91	1033.0
2014-09-08 20:00:00	ES	Futures	2084.91	2085.43	2084.13	2084.39	2820.0
2014-09-08 21:00:00	ES	Futures	2084.39	2084.65	2083.35	2083.61	2854.0
2014-09-08 22:00:00	ES	Futures	2083.61	2084.65	2083.09	2083.61	3457.0
2014-09-08 23:00:00	ES	Futures	2083.61	2084.39	2082.05	2082.05	4309.0
2014-09-08 00:00:00	NQ	Futures	4770.35	4771.23	4769.48	4770.06	321.0
2014-09-08 01:00:00	NQ	Futures	4770.35	4770.94	4770.06	4770.35	191.0
2014-09-08 02:00:00	NQ	Futures	4770.64	4770.64	4767.43	4769.18	897.0
2014-09-08 03:00:00	NQ	Futures	4768.89	4770.64	4766.85	4770.06	2560.0
2014-09-08 04:00:00	NQ	Futures	4769.77	4770.94	4766.26	4767.72	2091.0
2014-09-08 05:00:00	NQ	Futures	4767.43	4769.48	4765.68	4766.85	2145.0
2014-09-08 06:00:00	NQ	Futures	4766.85	4769.77	4766.56	4767.72	2742.0
2014-09-08 07:00:00	NQ	Futures	4767.72	4771.23	4766.26	4770.94	2067.0
2014-09-08 08:00:00	NQ	Futures	4770.94	4772.4	4768.31	4768.89	4132.0
2014-09-08 09:00:00	NQ	Futures	4768.89	4793.42	4768.89	4791.67	29516.0
2014-09-08 10:00:00	NQ	Futures	4791.67	4794.88	4779.99	4791.38	36562.0
2014-09-08 11:00:00	NQ	Futures	4791.38	4792.84	4777.65	4777.94	24744.0
2014-09-08 12:00:00	NQ	Futures	4777.65	4785.24	4775.61	4782.03	14710.0
2014-09-08 13:00:00	NQ	Futures	4782.03	4784.37	4760.42	4766.26	33302.0
2014-09-08 14:00:00	NQ	Futures	4765.97	4774.44	4765.1	4772.1	15875.0
2014-09-08 15:00:00	NQ	Futures	4772.69	4784.66	4772.1	4782.91	24081.0
2014-09-08 16:00:00	NQ	Futures	4782.91	4783.78	4779.99	4783.78	4829.0
2014-09-08 17:00:00	NQ	Futures	4783.49	4784.08	4780.57	4780.86	822.0
2014-09-08 18:00:00	NQ	Futures	4780.28	4781.45	4778.82	4780.28	749.0
2014-09-08 19:00:00	NQ	Futures	4779.99	4780.86	4778.82	4780.57	303.0
2014-09-08 20:00:00	NQ	Futures	4780.28	4780.28	4778.24	4778.24	694.0
2014-09-08 21:00:00	NQ	Futures	4778.53	4778.53	4775.02	4775.9	786.0
2014-09-08 22:00:00	NQ	Futures	4776.19	4778.82	4775.32	4776.78	631.0
2014-09-08 23:00:00	NQ	Futures	4776.48	4778.53	4772.98	4772.98	688.0
2014-09-08 00:00:00	YM	Futures	17696.3	17705.6	17694.2	17695.2	1335.0
2014-09-08 01:00:00	YM	Futures	17695.2	17696.3	17694.2	17694.2	294.0

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

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