PREVIEW / futures_1hour / 2016-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-02.parquet
  size:    54 KB
  rows:    1,611

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-08-02 00:00:00	ES	Futures	2351.46	2352.54	2350.92	2350.92	3471.0
2016-08-02 01:00:00	ES	Futures	2351.19	2352.0	2350.64	2350.92	3294.0
2016-08-02 02:00:00	ES	Futures	2350.92	2352.0	2349.83	2351.46	11461.0
2016-08-02 03:00:00	ES	Futures	2351.19	2352.81	2343.86	2344.14	45247.0
2016-08-02 04:00:00	ES	Futures	2344.14	2345.76	2340.34	2342.24	33652.0
2016-08-02 05:00:00	ES	Futures	2342.51	2344.68	2341.42	2343.05	20796.0
2016-08-02 06:00:00	ES	Futures	2343.05	2345.22	2342.51	2343.86	21513.0
2016-08-02 07:00:00	ES	Futures	2344.14	2344.68	2340.88	2342.51	28376.0
2016-08-02 08:00:00	ES	Futures	2342.51	2344.68	2341.69	2342.78	32364.0
2016-08-02 09:00:00	ES	Futures	2342.78	2347.39	2339.8	2341.42	266610.0
2016-08-02 10:00:00	ES	Futures	2341.42	2342.24	2326.78	2327.05	385587.0
2016-08-02 11:00:00	ES	Futures	2327.05	2332.75	2327.05	2328.14	204136.0
2016-08-02 12:00:00	ES	Futures	2328.14	2331.39	2324.88	2326.24	157444.0
2016-08-02 13:00:00	ES	Futures	2325.97	2326.78	2322.98	2325.69	168237.0
2016-08-02 14:00:00	ES	Futures	2325.69	2333.83	2324.88	2331.12	213444.0
2016-08-02 15:00:00	ES	Futures	2331.39	2335.46	2329.76	2333.83	246272.0
2016-08-02 16:00:00	ES	Futures	2333.83	2336.54	2333.56	2335.46	83079.0
2016-08-02 18:00:00	ES	Futures	2334.64	2335.46	2333.29	2333.83	5045.0
2016-08-02 19:00:00	ES	Futures	2333.83	2334.64	2333.29	2334.37	2926.0
2016-08-02 20:00:00	ES	Futures	2334.37	2334.37	2332.47	2333.02	6727.0
2016-08-02 21:00:00	ES	Futures	2332.75	2334.64	2332.2	2334.37	6652.0
2016-08-02 22:00:00	ES	Futures	2334.64	2335.46	2333.29	2333.56	4937.0
2016-08-02 23:00:00	ES	Futures	2333.56	2333.56	2332.2	2332.47	5412.0
2016-08-02 00:00:00	NQ	Futures	5667.45	5671.03	5665.96	5665.96	562.0
2016-08-02 01:00:00	NQ	Futures	5665.96	5668.34	5665.07	5665.96	586.0
2016-08-02 02:00:00	NQ	Futures	5665.66	5668.94	5663.58	5666.85	1344.0
2016-08-02 03:00:00	NQ	Futures	5666.85	5671.03	5649.27	5649.57	4359.0
2016-08-02 04:00:00	NQ	Futures	5649.57	5653.14	5641.52	5646.29	4503.0
2016-08-02 05:00:00	NQ	Futures	5646.59	5650.76	5644.8	5647.78	1847.0
2016-08-02 06:00:00	NQ	Futures	5647.48	5652.25	5646.29	5648.97	1878.0
2016-08-02 07:00:00	NQ	Futures	5649.27	5651.06	5642.12	5646.29	2823.0
2016-08-02 08:00:00	NQ	Futures	5646.29	5650.46	5644.2	5647.48	3034.0
2016-08-02 09:00:00	NQ	Futures	5647.48	5658.21	5632.88	5640.03	38831.0
2016-08-02 10:00:00	NQ	Futures	5639.73	5640.92	5596.81	5598.0	52364.0
2016-08-02 11:00:00	NQ	Futures	5597.71	5609.93	5597.41	5601.28	30759.0
2016-08-02 12:00:00	NQ	Futures	5601.28	5609.33	5593.83	5597.11	18460.0
2016-08-02 13:00:00	NQ	Futures	5596.81	5598.0	5581.61	5595.02	25016.0
2016-08-02 14:00:00	NQ	Futures	5595.02	5626.62	5592.04	5616.48	32980.0
2016-08-02 15:00:00	NQ	Futures	5617.08	5627.51	5613.21	5618.57	30646.0
2016-08-02 16:00:00	NQ	Futures	5618.57	5623.93	5618.27	5621.25	6004.0
2016-08-02 18:00:00	NQ	Futures	5619.17	5620.95	5614.7	5615.59	938.0
2016-08-02 19:00:00	NQ	Futures	5615.59	5617.08	5614.4	5615.89	350.0
2016-08-02 20:00:00	NQ	Futures	5616.19	5616.48	5611.12	5611.71	1127.0
2016-08-02 21:00:00	NQ	Futures	5612.01	5617.68	5609.93	5617.38	912.0
2016-08-02 22:00:00	NQ	Futures	5617.38	5620.66	5613.8	5614.1	854.0
2016-08-02 23:00:00	NQ	Futures	5614.1	5615.59	5611.42	5612.31	563.0
2016-08-02 00:00:00	YM	Futures	19749.4	19759.1	19737.6	19740.8	804.0
2016-08-02 01:00:00	YM	Futures	19743.0	19750.5	19740.8	19744.1	620.0
2016-08-02 02:00:00	YM	Futures	19743.0	19751.6	19737.6	19741.9	1651.0
2016-08-02 03:00:00	YM	Futures	19741.9	19757.0	19689.2	19691.3	6238.0

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

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