PREVIEW / futures_1hour / 2014-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-18.parquet
  size:    51 KB
  rows:    1,570

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-18 00:00:00	ES	Futures	2090.24	2090.24	2089.71	2089.98	2043.0
2014-09-18 01:00:00	ES	Futures	2090.24	2090.76	2089.71	2089.98	2576.0
2014-09-18 02:00:00	ES	Futures	2089.98	2090.5	2089.19	2089.19	6424.0
2014-09-18 03:00:00	ES	Futures	2089.45	2090.76	2088.93	2090.24	14653.0
2014-09-18 04:00:00	ES	Futures	2090.24	2094.17	2090.24	2094.17	20084.0
2014-09-18 05:00:00	ES	Futures	2093.91	2098.36	2093.38	2097.31	27908.0
2014-09-18 06:00:00	ES	Futures	2097.31	2098.62	2096.26	2097.05	20543.0
2014-09-18 07:00:00	ES	Futures	2097.05	2098.36	2095.74	2096.0	20405.0
2014-09-18 08:00:00	ES	Futures	2096.0	2096.52	2093.91	2094.69	32892.0
2014-09-18 09:00:00	ES	Futures	2094.95	2097.31	2092.86	2096.26	161520.0
2014-09-18 10:00:00	ES	Futures	2096.26	2100.19	2093.91	2097.83	259625.0
2014-09-18 11:00:00	ES	Futures	2097.57	2099.41	2095.74	2096.79	112291.0
2014-09-18 12:00:00	ES	Futures	2096.79	2098.88	2096.52	2098.1	60448.0
2014-09-18 13:00:00	ES	Futures	2098.36	2098.88	2096.26	2097.31	74036.0
2014-09-18 14:00:00	ES	Futures	2097.05	2099.41	2096.79	2097.05	83001.0
2014-09-18 15:00:00	ES	Futures	2096.79	2100.98	2096.52	2100.19	171437.0
2014-09-18 16:00:00	ES	Futures	2099.93	2102.81	2099.93	2102.29	103013.0
2014-09-18 17:00:00	ES	Futures	2102.29	2102.55	2101.76	2102.29	3688.0
2014-09-18 18:00:00	ES	Futures	2102.03	2105.69	2100.98	2104.12	14131.0
2014-09-18 19:00:00	ES	Futures	2104.38	2104.91	2103.07	2103.34	3614.0
2014-09-18 20:00:00	ES	Futures	2103.34	2104.65	2103.07	2104.38	5818.0
2014-09-18 21:00:00	ES	Futures	2104.38	2108.05	2104.38	2105.69	17695.0
2014-09-18 22:00:00	ES	Futures	2105.69	2107.53	2104.91	2106.74	7207.0
2014-09-18 23:00:00	ES	Futures	2106.74	2109.89	2106.74	2108.84	9061.0
2014-09-18 00:00:00	NQ	Futures	4764.86	4765.74	4763.98	4764.57	459.0
2014-09-18 01:00:00	NQ	Futures	4764.57	4766.32	4763.39	4763.39	668.0
2014-09-18 02:00:00	NQ	Futures	4763.69	4764.27	4759.88	4759.88	3490.0
2014-09-18 03:00:00	NQ	Futures	4760.17	4764.57	4759.58	4763.69	2671.0
2014-09-18 04:00:00	NQ	Futures	4763.69	4773.36	4763.39	4773.06	2641.0
2014-09-18 05:00:00	NQ	Futures	4773.36	4783.9	4771.01	4781.85	4386.0
2014-09-18 06:00:00	NQ	Futures	4781.85	4786.25	4778.92	4782.44	3750.0
2014-09-18 07:00:00	NQ	Futures	4782.44	4785.66	4779.8	4779.8	3123.0
2014-09-18 08:00:00	NQ	Futures	4779.8	4781.85	4776.58	4779.22	5176.0
2014-09-18 09:00:00	NQ	Futures	4778.92	4787.71	4773.36	4786.54	33700.0
2014-09-18 10:00:00	NQ	Futures	4785.96	4796.21	4784.2	4789.18	46119.0
2014-09-18 11:00:00	NQ	Futures	4789.18	4791.82	4784.49	4785.66	18567.0
2014-09-18 12:00:00	NQ	Futures	4785.96	4795.04	4785.37	4792.69	11555.0
2014-09-18 13:00:00	NQ	Futures	4792.69	4795.92	4790.35	4791.82	11261.0
2014-09-18 14:00:00	NQ	Futures	4792.11	4799.43	4791.23	4792.11	15489.0
2014-09-18 15:00:00	NQ	Futures	4792.11	4800.61	4790.94	4800.61	24466.0
2014-09-18 16:00:00	NQ	Futures	4800.61	4805.0	4800.31	4804.71	12584.0
2014-09-18 17:00:00	NQ	Futures	4804.41	4804.71	4803.24	4804.12	359.0
2014-09-18 18:00:00	NQ	Futures	4803.83	4813.5	4800.9	4809.69	3179.0
2014-09-18 19:00:00	NQ	Futures	4809.98	4810.57	4807.64	4808.22	758.0
2014-09-18 20:00:00	NQ	Futures	4808.52	4811.15	4807.64	4810.86	789.0
2014-09-18 21:00:00	NQ	Futures	4810.27	4819.36	4810.27	4814.08	2588.0
2014-09-18 22:00:00	NQ	Futures	4814.08	4818.19	4813.2	4817.6	981.0
2014-09-18 23:00:00	NQ	Futures	4817.6	4823.17	4817.01	4821.41	1513.0
2014-09-18 00:00:00	YM	Futures	17761.2	17764.4	17759.2	17761.2	334.0
2014-09-18 01:00:00	YM	Futures	17762.3	17765.4	17759.2	17762.3	503.0

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

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