PREVIEW / futures_1hour / 2015-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-02.parquet
  size:    47 KB
  rows:    1,419

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
2015-04-02 00:00:00	ES	Futures	2166.56	2167.88	2166.29	2167.35	1519.0
2015-04-02 01:00:00	ES	Futures	2167.61	2168.94	2166.29	2166.29	3440.0
2015-04-02 02:00:00	ES	Futures	2166.29	2166.56	2161.54	2162.6	13177.0
2015-04-02 03:00:00	ES	Futures	2162.6	2164.18	2160.75	2161.28	20166.0
2015-04-02 04:00:00	ES	Futures	2161.54	2162.33	2159.43	2161.01	12470.0
2015-04-02 05:00:00	ES	Futures	2161.01	2162.33	2159.69	2161.8	8896.0
2015-04-02 06:00:00	ES	Futures	2161.8	2162.6	2160.22	2162.07	7146.0
2015-04-02 07:00:00	ES	Futures	2162.07	2165.5	2161.8	2165.24	12715.0
2015-04-02 08:00:00	ES	Futures	2165.24	2167.35	2162.33	2166.03	28593.0
2015-04-02 09:00:00	ES	Futures	2166.29	2180.03	2164.45	2179.24	207679.0
2015-04-02 10:00:00	ES	Futures	2179.24	2181.35	2173.43	2175.01	157723.0
2015-04-02 11:00:00	ES	Futures	2175.27	2177.65	2172.9	2173.69	98635.0
2015-04-02 12:00:00	ES	Futures	2173.95	2175.54	2169.2	2174.22	96808.0
2015-04-02 13:00:00	ES	Futures	2174.22	2177.12	2173.16	2175.54	69187.0
2015-04-02 14:00:00	ES	Futures	2175.8	2178.97	2172.9	2174.75	69904.0
2015-04-02 15:00:00	ES	Futures	2174.75	2179.5	2173.43	2175.01	143134.0
2015-04-02 16:00:00	ES	Futures	2175.27	2177.65	2173.69	2177.12	66492.0
2015-04-02 17:00:00	ES	Futures	2176.86	2177.12	2175.8	2176.59	2003.0
2015-04-02 18:00:00	ES	Futures	2176.33	2176.59	2174.75	2175.01	770.0
2015-04-02 19:00:00	ES	Futures	2175.01	2175.8	2174.75	2175.01	855.0
2015-04-02 20:00:00	ES	Futures	2175.01	2177.39	2173.69	2176.07	1923.0
2015-04-02 21:00:00	ES	Futures	2176.07	2176.59	2175.8	2176.33	547.0
2015-04-02 22:00:00	ES	Futures	2176.33	2177.65	2176.33	2177.12	673.0
2015-04-02 23:00:00	ES	Futures	2176.86	2177.65	2176.59	2176.86	472.0
2015-04-02 00:00:00	NQ	Futures	5065.83	5067.89	5064.66	5067.6	380.0
2015-04-02 01:00:00	NQ	Futures	5067.3	5069.66	5062.6	5063.77	989.0
2015-04-02 02:00:00	NQ	Futures	5063.19	5063.77	5053.19	5054.07	1578.0
2015-04-02 03:00:00	NQ	Futures	5054.95	5058.77	5049.95	5050.84	2285.0
2015-04-02 04:00:00	NQ	Futures	5050.54	5053.78	5044.37	5049.66	1692.0
2015-04-02 05:00:00	NQ	Futures	5049.36	5053.48	5046.13	5052.31	896.0
2015-04-02 06:00:00	NQ	Futures	5052.31	5055.83	5048.78	5054.07	1198.0
2015-04-02 07:00:00	NQ	Futures	5054.07	5066.42	5053.78	5065.83	2163.0
2015-04-02 08:00:00	NQ	Futures	5065.83	5069.36	5058.48	5067.01	4167.0
2015-04-02 09:00:00	NQ	Futures	5067.3	5079.95	5049.66	5075.24	40869.0
2015-04-02 10:00:00	NQ	Futures	5075.54	5082.59	5059.66	5064.36	27294.0
2015-04-02 11:00:00	NQ	Futures	5064.36	5072.6	5061.72	5064.07	17270.0
2015-04-02 12:00:00	NQ	Futures	5063.77	5068.48	5052.6	5064.95	14339.0
2015-04-02 13:00:00	NQ	Futures	5064.95	5073.18	5061.42	5069.07	10767.0
2015-04-02 14:00:00	NQ	Futures	5069.36	5076.12	5060.25	5063.77	11883.0
2015-04-02 15:00:00	NQ	Futures	5063.77	5080.24	5062.89	5067.6	20466.0
2015-04-02 16:00:00	NQ	Futures	5067.3	5070.24	5064.07	5068.48	6534.0
2015-04-02 17:00:00	NQ	Futures	5068.48	5068.48	5065.54	5066.13	193.0
2015-04-02 18:00:00	NQ	Futures	5065.83	5066.42	5063.77	5064.66	76.0
2015-04-02 19:00:00	NQ	Futures	5064.66	5064.66	5061.72	5062.6	104.0
2015-04-02 20:00:00	NQ	Futures	5062.6	5067.01	5061.42	5063.19	305.0
2015-04-02 21:00:00	NQ	Futures	5062.89	5064.66	5062.6	5063.48	64.0
2015-04-02 22:00:00	NQ	Futures	5063.77	5067.6	5063.77	5066.71	87.0
2015-04-02 23:00:00	NQ	Futures	5066.13	5067.3	5064.95	5066.42	96.0
2015-04-02 00:00:00	YM	Futures	18459.7	18469.1	18457.6	18468.1	278.0
2015-04-02 01:00:00	YM	Futures	18469.1	18479.6	18460.7	18462.8	1121.0

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

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