PREVIEW / futures_1hour / 2016-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-07.parquet
  size:    51 KB
  rows:    1,590

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
2016-03-07 00:00:00	ES	Futures	2141.88	2142.15	2140.0	2140.8	2847.0
2016-03-07 01:00:00	ES	Futures	2140.54	2142.69	2139.73	2142.42	3212.0
2016-03-07 02:00:00	ES	Futures	2142.42	2144.3	2140.0	2141.07	11282.0
2016-03-07 03:00:00	ES	Futures	2141.07	2145.64	2137.31	2140.0	38241.0
2016-03-07 04:00:00	ES	Futures	2140.0	2144.03	2136.24	2136.77	23038.0
2016-03-07 05:00:00	ES	Futures	2136.77	2138.12	2133.82	2134.89	23833.0
2016-03-07 06:00:00	ES	Futures	2134.89	2137.31	2134.89	2135.16	16088.0
2016-03-07 07:00:00	ES	Futures	2135.16	2138.12	2134.89	2137.58	20745.0
2016-03-07 08:00:00	ES	Futures	2137.31	2138.39	2133.01	2134.36	36642.0
2016-03-07 09:00:00	ES	Futures	2134.36	2141.34	2134.36	2137.31	210914.0
2016-03-07 10:00:00	ES	Futures	2137.04	2147.79	2135.7	2143.49	288799.0
2016-03-07 11:00:00	ES	Futures	2143.49	2153.43	2141.88	2149.94	203698.0
2016-03-07 12:00:00	ES	Futures	2149.67	2152.36	2147.52	2150.75	85196.0
2016-03-07 13:00:00	ES	Futures	2151.02	2154.51	2144.57	2146.99	128991.0
2016-03-07 14:00:00	ES	Futures	2146.99	2148.6	2137.04	2140.8	162634.0
2016-03-07 15:00:00	ES	Futures	2140.54	2149.94	2137.04	2149.4	207619.0
2016-03-07 16:00:00	ES	Futures	2149.4	2151.55	2147.79	2149.4	64500.0
2016-03-07 18:00:00	ES	Futures	2148.6	2149.94	2146.72	2149.67	4064.0
2016-03-07 19:00:00	ES	Futures	2149.67	2149.67	2144.84	2145.37	8227.0
2016-03-07 20:00:00	ES	Futures	2145.1	2145.37	2139.19	2139.73	12848.0
2016-03-07 21:00:00	ES	Futures	2139.73	2140.8	2137.31	2139.19	14621.0
2016-03-07 22:00:00	ES	Futures	2139.19	2140.27	2137.04	2137.85	7040.0
2016-03-07 23:00:00	ES	Futures	2138.12	2143.76	2137.85	2143.49	8507.0
2016-03-07 00:00:00	NQ	Futures	5125.03	5125.33	5119.69	5119.69	702.0
2016-03-07 01:00:00	NQ	Futures	5120.28	5126.52	5117.61	5125.63	351.0
2016-03-07 02:00:00	NQ	Futures	5125.33	5131.57	5116.42	5121.47	2297.0
2016-03-07 03:00:00	NQ	Futures	5121.17	5134.24	5109.59	5116.42	4962.0
2016-03-07 04:00:00	NQ	Futures	5115.83	5126.52	5108.41	5109.3	2155.0
2016-03-07 05:00:00	NQ	Futures	5109.0	5113.16	5102.47	5106.92	3063.0
2016-03-07 06:00:00	NQ	Futures	5107.22	5113.45	5105.73	5108.7	2594.0
2016-03-07 07:00:00	NQ	Futures	5108.41	5117.31	5107.81	5115.83	2152.0
2016-03-07 08:00:00	NQ	Futures	5115.83	5118.5	5105.14	5108.11	3890.0
2016-03-07 09:00:00	NQ	Futures	5108.41	5121.17	5094.15	5096.23	34212.0
2016-03-07 10:00:00	NQ	Futures	5096.23	5113.75	5089.4	5107.22	40351.0
2016-03-07 11:00:00	NQ	Futures	5107.22	5142.85	5101.58	5129.79	32767.0
2016-03-07 12:00:00	NQ	Futures	5129.79	5136.02	5123.25	5129.49	10748.0
2016-03-07 13:00:00	NQ	Futures	5129.49	5138.1	5098.31	5100.39	23473.0
2016-03-07 14:00:00	NQ	Futures	5100.09	5106.03	5074.26	5081.09	29438.0
2016-03-07 15:00:00	NQ	Futures	5080.79	5116.13	5070.1	5108.41	35718.0
2016-03-07 16:00:00	NQ	Futures	5108.41	5114.35	5105.73	5110.78	8428.0
2016-03-07 18:00:00	NQ	Futures	5108.41	5111.38	5102.47	5109.3	429.0
2016-03-07 19:00:00	NQ	Futures	5109.59	5110.19	5094.75	5095.34	1619.0
2016-03-07 20:00:00	NQ	Futures	5095.04	5095.64	5078.71	5080.2	3129.0
2016-03-07 21:00:00	NQ	Futures	5079.6	5081.98	5073.96	5077.23	2541.0
2016-03-07 22:00:00	NQ	Futures	5077.23	5081.09	5072.78	5075.74	940.0
2016-03-07 23:00:00	NQ	Futures	5076.34	5092.67	5075.74	5091.78	1153.0
2016-03-07 00:00:00	YM	Futures	18051.4	18051.4	18036.5	18038.6	537.0
2016-03-07 01:00:00	YM	Futures	18039.7	18058.9	18032.3	18057.8	513.0
2016-03-07 02:00:00	YM	Futures	18058.9	18066.3	18036.5	18046.1	1021.0
2016-03-07 03:00:00	YM	Futures	18046.1	18081.2	18012.0	18031.2	4464.0

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

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