PREVIEW / futures_1hour / 2014-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-18.parquet
  size:    42 KB
  rows:    1,250

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-18 00:00:00	ES	Futures	2033.57	2034.61	2033.31	2033.83	2141.0
2014-07-18 01:00:00	ES	Futures	2033.57	2034.87	2033.57	2034.61	2884.0
2014-07-18 02:00:00	ES	Futures	2034.87	2036.7	2034.35	2036.44	17186.0
2014-07-18 03:00:00	ES	Futures	2036.44	2039.04	2033.83	2038.78	50050.0
2014-07-18 04:00:00	ES	Futures	2038.78	2039.04	2037.22	2037.74	17759.0
2014-07-18 05:00:00	ES	Futures	2037.74	2038.0	2035.66	2036.18	18681.0
2014-07-18 06:00:00	ES	Futures	2035.92	2040.61	2035.66	2040.09	28199.0
2014-07-18 07:00:00	ES	Futures	2040.09	2041.91	2037.74	2038.52	35116.0
2014-07-18 08:00:00	ES	Futures	2038.52	2040.09	2038.26	2038.78	33381.0
2014-07-18 09:00:00	ES	Futures	2038.78	2044.52	2038.78	2042.43	263437.0
2014-07-18 10:00:00	ES	Futures	2042.69	2048.17	2040.61	2047.64	308668.0
2014-07-18 11:00:00	ES	Futures	2047.64	2051.81	2046.6	2049.99	243478.0
2014-07-18 12:00:00	ES	Futures	2050.25	2053.12	2049.99	2052.34	125623.0
2014-07-18 13:00:00	ES	Futures	2052.34	2052.6	2048.95	2052.07	100572.0
2014-07-18 14:00:00	ES	Futures	2052.07	2056.24	2050.77	2054.68	160486.0
2014-07-18 15:00:00	ES	Futures	2054.94	2058.07	2054.16	2055.98	232093.0
2014-07-18 16:00:00	ES	Futures	2055.72	2056.24	2054.68	2054.94	75980.0
2014-07-18 17:00:00	ES	Futures	2054.94	2055.2	2054.42	2054.94	2876.0
2014-07-18 00:00:00	NQ	Futures	4523.6	4525.94	4522.72	4523.89	330.0
2014-07-18 01:00:00	NQ	Futures	4524.18	4527.4	4523.02	4526.23	638.0
2014-07-18 02:00:00	NQ	Futures	4526.52	4532.36	4525.94	4531.19	2287.0
2014-07-18 03:00:00	NQ	Futures	4530.9	4532.36	4521.56	4531.48	7038.0
2014-07-18 04:00:00	NQ	Futures	4531.48	4533.82	4527.4	4533.53	3012.0
2014-07-18 05:00:00	NQ	Futures	4533.24	4534.4	4528.27	4528.56	3731.0
2014-07-18 06:00:00	NQ	Futures	4528.56	4537.62	4527.4	4536.16	3404.0
2014-07-18 07:00:00	NQ	Futures	4536.45	4541.41	4534.99	4537.91	5135.0
2014-07-18 08:00:00	NQ	Futures	4537.91	4544.62	4537.32	4541.7	7675.0
2014-07-18 09:00:00	NQ	Futures	4542.0	4559.81	4540.83	4550.76	50689.0
2014-07-18 10:00:00	NQ	Futures	4551.05	4565.07	4542.87	4564.19	54235.0
2014-07-18 11:00:00	NQ	Futures	4564.19	4575.87	4564.19	4572.07	40214.0
2014-07-18 12:00:00	NQ	Futures	4571.78	4580.25	4570.91	4577.62	18003.0
2014-07-18 13:00:00	NQ	Futures	4577.91	4582.88	4570.61	4581.42	17348.0
2014-07-18 14:00:00	NQ	Futures	4581.13	4593.68	4578.5	4588.72	26463.0
2014-07-18 15:00:00	NQ	Futures	4589.01	4597.19	4587.26	4593.68	31400.0
2014-07-18 16:00:00	NQ	Futures	4593.98	4594.27	4590.47	4592.22	8453.0
2014-07-18 17:00:00	NQ	Futures	4591.93	4593.1	4590.76	4593.1	387.0
2014-07-18 00:00:00	YM	Futures	17487.3	17495.6	17486.3	17489.4	446.0
2014-07-18 01:00:00	YM	Futures	17488.3	17495.6	17486.3	17493.5	807.0
2014-07-18 02:00:00	YM	Futures	17494.5	17508.0	17491.4	17504.9	2701.0
2014-07-18 03:00:00	YM	Futures	17504.9	17529.7	17480.0	17529.7	7522.0
2014-07-18 04:00:00	YM	Futures	17528.7	17530.7	17512.1	17520.4	3018.0
2014-07-18 05:00:00	YM	Futures	17519.4	17520.4	17497.6	17500.7	3042.0
2014-07-18 06:00:00	YM	Futures	17500.7	17545.2	17498.7	17533.8	4532.0
2014-07-18 07:00:00	YM	Futures	17534.9	17548.3	17521.4	17526.6	4912.0
2014-07-18 08:00:00	YM	Futures	17526.6	17541.1	17524.5	17530.7	3149.0
2014-07-18 09:00:00	YM	Futures	17530.7	17564.9	17530.7	17543.2	20391.0
2014-07-18 10:00:00	YM	Futures	17544.2	17585.6	17531.8	17581.4	24155.0
2014-07-18 11:00:00	YM	Futures	17581.4	17609.4	17572.1	17598.0	19454.0
2014-07-18 12:00:00	YM	Futures	17598.0	17613.5	17593.8	17600.1	8366.0
2014-07-18 13:00:00	YM	Futures	17600.1	17605.2	17572.1	17601.1	9797.0

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

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