PREVIEW / futures_1hour / 2014-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-17.parquet
  size:    50 KB
  rows:    1,549

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-07-17 00:00:00	ES	Futures	2054.16	2054.42	2053.38	2053.9	2644.0
2014-07-17 01:00:00	ES	Futures	2053.9	2053.9	2053.12	2053.38	3214.0
2014-07-17 02:00:00	ES	Futures	2053.38	2053.9	2051.81	2053.38	8786.0
2014-07-17 03:00:00	ES	Futures	2053.12	2055.72	2052.07	2055.46	27648.0
2014-07-17 04:00:00	ES	Futures	2055.46	2055.72	2052.34	2052.86	14958.0
2014-07-17 05:00:00	ES	Futures	2052.6	2053.64	2050.77	2051.03	12568.0
2014-07-17 06:00:00	ES	Futures	2051.29	2051.29	2045.56	2046.34	30214.0
2014-07-17 07:00:00	ES	Futures	2046.6	2050.25	2044.78	2047.64	36890.0
2014-07-17 08:00:00	ES	Futures	2047.64	2051.81	2047.64	2050.51	35253.0
2014-07-17 09:00:00	ES	Futures	2050.51	2058.07	2049.73	2057.55	225855.0
2014-07-17 10:00:00	ES	Futures	2057.55	2059.89	2055.72	2056.5	261764.0
2014-07-17 11:00:00	ES	Futures	2056.77	2057.29	2045.04	2046.86	459980.0
2014-07-17 12:00:00	ES	Futures	2047.12	2050.51	2042.69	2049.73	277624.0
2014-07-17 13:00:00	ES	Futures	2049.73	2054.16	2046.6	2047.9	181132.0
2014-07-17 14:00:00	ES	Futures	2048.17	2048.17	2043.73	2045.3	170547.0
2014-07-17 15:00:00	ES	Futures	2045.3	2045.3	2031.75	2035.13	528023.0
2014-07-17 16:00:00	ES	Futures	2034.87	2037.48	2031.23	2032.27	139021.0
2014-07-17 17:00:00	ES	Futures	2032.27	2032.79	2031.49	2031.49	2728.0
2014-07-17 18:00:00	ES	Futures	2032.01	2033.57	2024.97	2025.75	32467.0
2014-07-17 19:00:00	ES	Futures	2026.01	2031.49	2025.75	2031.49	12095.0
2014-07-17 20:00:00	ES	Futures	2031.75	2034.61	2030.44	2032.79	13376.0
2014-07-17 21:00:00	ES	Futures	2032.79	2035.13	2032.27	2034.87	7515.0
2014-07-17 22:00:00	ES	Futures	2034.87	2035.13	2033.31	2034.35	5763.0
2014-07-17 23:00:00	ES	Futures	2034.35	2034.61	2033.31	2033.57	2950.0
2014-07-17 00:00:00	NQ	Futures	4573.53	4574.41	4571.78	4572.37	547.0
2014-07-17 01:00:00	NQ	Futures	4572.37	4573.53	4571.2	4572.95	475.0
2014-07-17 02:00:00	NQ	Futures	4572.95	4573.24	4568.28	4572.07	1061.0
2014-07-17 03:00:00	NQ	Futures	4571.78	4578.5	4569.45	4578.21	3445.0
2014-07-17 04:00:00	NQ	Futures	4578.21	4579.96	4572.07	4572.95	2958.0
2014-07-17 05:00:00	NQ	Futures	4573.24	4574.99	4567.69	4569.74	2085.0
2014-07-17 06:00:00	NQ	Futures	4569.45	4569.74	4552.51	4554.26	6332.0
2014-07-17 07:00:00	NQ	Futures	4553.97	4561.56	4548.42	4553.38	8902.0
2014-07-17 08:00:00	NQ	Futures	4553.38	4567.4	4553.38	4565.65	9439.0
2014-07-17 09:00:00	NQ	Futures	4565.36	4586.09	4564.48	4581.13	41236.0
2014-07-17 10:00:00	NQ	Futures	4581.71	4587.55	4572.95	4576.75	44576.0
2014-07-17 11:00:00	NQ	Futures	4576.45	4577.91	4540.83	4547.25	72712.0
2014-07-17 12:00:00	NQ	Futures	4547.54	4554.85	4535.86	4551.63	38392.0
2014-07-17 13:00:00	NQ	Futures	4551.63	4563.02	4546.38	4549.88	24255.0
2014-07-17 14:00:00	NQ	Futures	4549.88	4550.17	4538.49	4543.16	27061.0
2014-07-17 15:00:00	NQ	Futures	4543.16	4543.75	4507.83	4522.72	73564.0
2014-07-17 16:00:00	NQ	Futures	4522.72	4532.36	4515.72	4517.76	19531.0
2014-07-17 17:00:00	NQ	Futures	4517.76	4519.51	4516.3	4517.47	334.0
2014-07-17 18:00:00	NQ	Futures	4520.97	4523.31	4501.7	4504.33	4136.0
2014-07-17 19:00:00	NQ	Futures	4504.62	4518.64	4503.74	4518.05	2146.0
2014-07-17 20:00:00	NQ	Futures	4518.34	4525.64	4516.01	4521.85	1944.0
2014-07-17 21:00:00	NQ	Futures	4521.85	4527.4	4521.26	4527.4	1328.0
2014-07-17 22:00:00	NQ	Futures	4527.4	4527.98	4523.31	4525.64	1072.0
2014-07-17 23:00:00	NQ	Futures	4526.23	4526.81	4523.02	4523.31	816.0
2014-07-17 00:00:00	YM	Futures	17628.0	17630.1	17622.8	17624.9	472.0
2014-07-17 01:00:00	YM	Futures	17624.9	17628.0	17620.7	17623.8	935.0

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

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