PREVIEW / futures_1hour / 2016-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-27.parquet
  size:    54 KB
  rows:    1,618

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-07-27 00:00:00	ES	Futures	2350.92	2351.46	2350.64	2350.92	4021.0
2016-07-27 01:00:00	ES	Futures	2351.19	2351.73	2350.1	2350.64	6786.0
2016-07-27 02:00:00	ES	Futures	2350.64	2352.27	2350.1	2350.64	7583.0
2016-07-27 03:00:00	ES	Futures	2350.37	2353.08	2350.1	2351.46	22175.0
2016-07-27 04:00:00	ES	Futures	2351.73	2352.54	2350.92	2351.73	12633.0
2016-07-27 05:00:00	ES	Futures	2352.0	2352.0	2349.56	2349.83	7445.0
2016-07-27 06:00:00	ES	Futures	2349.83	2351.19	2349.83	2350.92	8797.0
2016-07-27 07:00:00	ES	Futures	2350.92	2351.73	2349.29	2351.19	15344.0
2016-07-27 08:00:00	ES	Futures	2351.46	2352.27	2349.83	2352.27	23761.0
2016-07-27 09:00:00	ES	Futures	2352.27	2353.08	2347.66	2350.64	162711.0
2016-07-27 10:00:00	ES	Futures	2350.64	2351.19	2341.15	2343.05	248172.0
2016-07-27 11:00:00	ES	Futures	2343.32	2344.68	2339.53	2340.34	183701.0
2016-07-27 12:00:00	ES	Futures	2340.34	2341.69	2338.71	2340.07	123558.0
2016-07-27 13:00:00	ES	Futures	2340.07	2343.05	2338.17	2341.69	107342.0
2016-07-27 14:00:00	ES	Futures	2341.42	2348.2	2334.37	2345.76	247346.0
2016-07-27 15:00:00	ES	Futures	2345.49	2350.37	2342.51	2344.68	289222.0
2016-07-27 16:00:00	ES	Futures	2344.68	2346.58	2341.42	2346.58	106760.0
2016-07-27 18:00:00	ES	Futures	2346.03	2346.58	2344.41	2345.22	2609.0
2016-07-27 19:00:00	ES	Futures	2345.49	2345.49	2344.41	2344.95	2318.0
2016-07-27 20:00:00	ES	Futures	2344.68	2347.66	2344.68	2346.58	7310.0
2016-07-27 21:00:00	ES	Futures	2346.58	2347.39	2344.95	2346.58	6452.0
2016-07-27 22:00:00	ES	Futures	2346.85	2348.2	2346.3	2347.12	3546.0
2016-07-27 23:00:00	ES	Futures	2347.39	2348.2	2346.58	2347.93	2811.0
2016-07-27 00:00:00	NQ	Futures	5597.11	5598.0	5594.43	5595.32	910.0
2016-07-27 01:00:00	NQ	Futures	5595.62	5598.9	5593.83	5596.51	1033.0
2016-07-27 02:00:00	NQ	Futures	5596.81	5599.2	5594.43	5595.62	1032.0
2016-07-27 03:00:00	NQ	Futures	5595.62	5599.49	5594.13	5596.22	3350.0
2016-07-27 04:00:00	NQ	Futures	5596.51	5601.28	5595.62	5599.2	1869.0
2016-07-27 05:00:00	NQ	Futures	5599.2	5599.49	5595.02	5595.92	1165.0
2016-07-27 06:00:00	NQ	Futures	5595.62	5598.3	5595.02	5597.41	1577.0
2016-07-27 07:00:00	NQ	Futures	5597.11	5606.95	5596.51	5605.75	3543.0
2016-07-27 08:00:00	NQ	Futures	5605.46	5607.24	5601.88	5605.75	3464.0
2016-07-27 09:00:00	NQ	Futures	5606.35	5613.21	5593.53	5607.24	36455.0
2016-07-27 10:00:00	NQ	Futures	5607.24	5609.03	5587.87	5591.15	32650.0
2016-07-27 11:00:00	NQ	Futures	5591.15	5599.49	5588.47	5589.36	18955.0
2016-07-27 12:00:00	NQ	Futures	5589.06	5590.26	5582.8	5586.38	12300.0
2016-07-27 13:00:00	NQ	Futures	5586.38	5595.02	5583.7	5591.45	10655.0
2016-07-27 14:00:00	NQ	Futures	5592.34	5605.75	5575.65	5601.58	38167.0
2016-07-27 15:00:00	NQ	Futures	5601.88	5614.99	5595.02	5599.2	35134.0
2016-07-27 16:00:00	NQ	Futures	5599.2	5620.06	5582.21	5617.97	17954.0
2016-07-27 18:00:00	NQ	Futures	5615.59	5617.08	5610.22	5610.82	874.0
2016-07-27 19:00:00	NQ	Futures	5610.82	5613.5	5610.22	5610.52	623.0
2016-07-27 20:00:00	NQ	Futures	5610.52	5616.78	5610.52	5614.1	794.0
2016-07-27 21:00:00	NQ	Futures	5614.4	5615.59	5609.93	5614.4	794.0
2016-07-27 22:00:00	NQ	Futures	5613.8	5617.97	5613.21	5615.59	666.0
2016-07-27 23:00:00	NQ	Futures	5615.89	5616.48	5613.8	5616.19	600.0
2016-07-27 00:00:00	YM	Futures	19850.6	19853.8	19845.2	19850.6	462.0
2016-07-27 01:00:00	YM	Futures	19849.5	19858.1	19843.1	19846.3	1013.0
2016-07-27 02:00:00	YM	Futures	19845.2	19857.1	19839.8	19843.1	1173.0
2016-07-27 03:00:00	YM	Futures	19844.1	19866.7	19842.0	19854.9	2033.0

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

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