PREVIEW / futures_1hour / 2016-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-28.parquet
  size:    53 KB
  rows:    1,617

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-28 00:00:00	ES	Futures	2347.93	2349.02	2347.66	2348.2	3047.0
2016-07-28 01:00:00	ES	Futures	2348.2	2348.47	2347.39	2347.93	2485.0
2016-07-28 02:00:00	ES	Futures	2347.93	2348.47	2346.3	2347.93	7407.0
2016-07-28 03:00:00	ES	Futures	2347.93	2352.27	2346.3	2349.29	45132.0
2016-07-28 04:00:00	ES	Futures	2349.29	2350.37	2347.93	2348.75	18623.0
2016-07-28 05:00:00	ES	Futures	2349.02	2349.56	2346.58	2346.85	15882.0
2016-07-28 06:00:00	ES	Futures	2346.85	2347.39	2344.68	2345.49	21552.0
2016-07-28 07:00:00	ES	Futures	2345.22	2345.76	2339.25	2340.07	36701.0
2016-07-28 08:00:00	ES	Futures	2340.07	2343.05	2339.8	2341.97	34012.0
2016-07-28 09:00:00	ES	Futures	2341.97	2346.03	2336.54	2344.41	230183.0
2016-07-28 10:00:00	ES	Futures	2344.41	2346.03	2336.0	2336.81	256909.0
2016-07-28 11:00:00	ES	Futures	2337.08	2341.42	2336.27	2340.88	164584.0
2016-07-28 12:00:00	ES	Futures	2340.61	2342.24	2338.71	2340.88	98049.0
2016-07-28 13:00:00	ES	Futures	2340.88	2346.03	2340.07	2346.03	126028.0
2016-07-28 14:00:00	ES	Futures	2346.03	2348.2	2344.68	2346.85	164827.0
2016-07-28 15:00:00	ES	Futures	2346.85	2351.19	2346.58	2347.39	253523.0
2016-07-28 16:00:00	ES	Futures	2347.39	2349.56	2346.3	2349.56	109139.0
2016-07-28 18:00:00	ES	Futures	2349.02	2350.92	2347.66	2349.56	7280.0
2016-07-28 19:00:00	ES	Futures	2349.83	2350.37	2348.75	2349.56	3042.0
2016-07-28 20:00:00	ES	Futures	2349.29	2350.64	2346.58	2347.39	8220.0
2016-07-28 21:00:00	ES	Futures	2347.39	2348.47	2346.3	2347.39	4084.0
2016-07-28 22:00:00	ES	Futures	2347.12	2349.56	2345.76	2349.02	7219.0
2016-07-28 23:00:00	ES	Futures	2349.02	2351.73	2340.34	2349.02	38707.0
2016-07-28 00:00:00	NQ	Futures	5616.19	5617.68	5614.99	5616.48	466.0
2016-07-28 01:00:00	NQ	Futures	5616.19	5618.27	5615.29	5617.08	579.0
2016-07-28 02:00:00	NQ	Futures	5617.38	5617.38	5612.91	5616.19	1116.0
2016-07-28 03:00:00	NQ	Futures	5616.19	5629.0	5612.61	5621.55	4838.0
2016-07-28 04:00:00	NQ	Futures	5621.85	5623.34	5617.68	5619.76	1771.0
2016-07-28 05:00:00	NQ	Futures	5620.06	5621.25	5615.59	5616.48	1723.0
2016-07-28 06:00:00	NQ	Futures	5616.19	5617.97	5611.71	5612.91	1841.0
2016-07-28 07:00:00	NQ	Futures	5613.21	5614.7	5602.48	5604.26	4125.0
2016-07-28 08:00:00	NQ	Futures	5604.26	5608.44	5603.37	5605.75	4071.0
2016-07-28 09:00:00	NQ	Futures	5606.05	5617.97	5590.85	5611.71	38807.0
2016-07-28 10:00:00	NQ	Futures	5611.71	5619.17	5593.53	5601.28	37670.0
2016-07-28 11:00:00	NQ	Futures	5601.28	5608.44	5596.81	5606.05	21488.0
2016-07-28 12:00:00	NQ	Futures	5606.05	5610.22	5597.41	5599.2	14273.0
2016-07-28 13:00:00	NQ	Futures	5599.49	5613.8	5596.81	5613.8	12557.0
2016-07-28 14:00:00	NQ	Futures	5613.8	5618.27	5609.63	5613.5	15876.0
2016-07-28 15:00:00	NQ	Futures	5613.8	5626.02	5613.8	5619.46	25943.0
2016-07-28 16:00:00	NQ	Futures	5619.46	5641.52	5606.05	5639.73	26496.0
2016-07-28 18:00:00	NQ	Futures	5641.22	5642.71	5633.47	5637.65	2374.0
2016-07-28 19:00:00	NQ	Futures	5637.94	5639.14	5635.26	5636.16	581.0
2016-07-28 20:00:00	NQ	Futures	5636.45	5638.24	5629.0	5631.39	1032.0
2016-07-28 21:00:00	NQ	Futures	5630.79	5633.47	5628.11	5630.49	680.0
2016-07-28 22:00:00	NQ	Futures	5630.79	5635.26	5625.43	5634.66	968.0
2016-07-28 23:00:00	NQ	Futures	5634.37	5641.22	5615.59	5635.26	4237.0
2016-07-28 00:00:00	YM	Futures	19822.6	19830.2	19820.5	19828.0	294.0
2016-07-28 01:00:00	YM	Futures	19826.9	19828.0	19819.4	19823.7	377.0
2016-07-28 02:00:00	YM	Futures	19823.7	19824.8	19808.6	19820.5	1156.0
2016-07-28 03:00:00	YM	Futures	19819.4	19860.3	19805.4	19838.8	5205.0

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

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