PREVIEW / futures_1hour / 2016-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-18.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-05-18 00:00:00	ES	Futures	2206.28	2206.55	2203.04	2204.93	6768.0
2016-05-18 01:00:00	ES	Futures	2205.2	2207.9	2204.93	2207.09	5416.0
2016-05-18 02:00:00	ES	Futures	2207.09	2207.09	2201.42	2204.93	17131.0
2016-05-18 03:00:00	ES	Futures	2204.93	2207.9	2201.96	2204.39	38291.0
2016-05-18 04:00:00	ES	Futures	2204.39	2208.71	2203.85	2208.44	20746.0
2016-05-18 05:00:00	ES	Futures	2208.44	2208.71	2206.01	2207.36	11340.0
2016-05-18 06:00:00	ES	Futures	2207.63	2209.25	2204.39	2205.47	14492.0
2016-05-18 07:00:00	ES	Futures	2205.47	2208.17	2203.58	2203.85	18916.0
2016-05-18 08:00:00	ES	Futures	2203.58	2204.66	2198.99	2200.88	43483.0
2016-05-18 09:00:00	ES	Futures	2200.88	2206.28	2197.91	2206.28	244030.0
2016-05-18 10:00:00	ES	Futures	2206.55	2216.0	2204.66	2208.44	290658.0
2016-05-18 11:00:00	ES	Futures	2208.44	2216.27	2208.17	2211.68	210292.0
2016-05-18 12:00:00	ES	Futures	2211.68	2216.81	2210.33	2216.81	105642.0
2016-05-18 13:00:00	ES	Futures	2216.81	2222.21	2216.54	2217.89	168451.0
2016-05-18 14:00:00	ES	Futures	2217.89	2218.16	2193.05	2204.39	475738.0
2016-05-18 15:00:00	ES	Futures	2204.39	2209.25	2197.37	2207.36	297225.0
2016-05-18 16:00:00	ES	Futures	2207.09	2207.36	2204.39	2206.55	65256.0
2016-05-18 18:00:00	ES	Futures	2206.82	2208.17	2204.12	2205.74	6137.0
2016-05-18 19:00:00	ES	Futures	2205.47	2207.09	2205.2	2206.82	3868.0
2016-05-18 20:00:00	ES	Futures	2206.55	2207.36	2203.85	2204.93	5146.0
2016-05-18 21:00:00	ES	Futures	2204.93	2205.2	2198.18	2199.8	13966.0
2016-05-18 22:00:00	ES	Futures	2199.8	2201.42	2198.99	2200.61	8804.0
2016-05-18 23:00:00	ES	Futures	2200.88	2201.15	2198.72	2200.61	5427.0
2016-05-18 00:00:00	NQ	Futures	5141.31	5142.8	5133.88	5137.74	1001.0
2016-05-18 01:00:00	NQ	Futures	5138.04	5147.56	5137.74	5144.29	909.0
2016-05-18 02:00:00	NQ	Futures	5144.88	5144.88	5131.2	5139.23	1775.0
2016-05-18 03:00:00	NQ	Futures	5139.23	5144.29	5130.6	5135.96	5014.0
2016-05-18 04:00:00	NQ	Futures	5135.36	5147.26	5135.36	5146.67	2716.0
2016-05-18 05:00:00	NQ	Futures	5146.67	5147.56	5139.83	5143.1	1350.0
2016-05-18 06:00:00	NQ	Futures	5143.1	5147.56	5135.66	5138.04	1727.0
2016-05-18 07:00:00	NQ	Futures	5138.34	5143.1	5133.58	5134.77	1883.0
2016-05-18 08:00:00	NQ	Futures	5134.77	5136.85	5125.84	5130.01	4668.0
2016-05-18 09:00:00	NQ	Futures	5129.71	5153.81	5122.27	5152.32	37159.0
2016-05-18 10:00:00	NQ	Futures	5152.32	5178.21	5149.64	5160.65	39155.0
2016-05-18 11:00:00	NQ	Futures	5160.95	5180.29	5159.76	5168.98	29250.0
2016-05-18 12:00:00	NQ	Futures	5168.98	5175.23	5160.36	5174.93	17395.0
2016-05-18 13:00:00	NQ	Futures	5175.23	5187.73	5174.93	5179.4	19754.0
2016-05-18 14:00:00	NQ	Futures	5179.1	5179.4	5118.7	5147.56	79739.0
2016-05-18 15:00:00	NQ	Futures	5147.56	5162.44	5134.77	5159.76	47331.0
2016-05-18 16:00:00	NQ	Futures	5159.76	5162.74	5152.32	5161.55	7412.0
2016-05-18 18:00:00	NQ	Futures	5162.44	5166.01	5156.78	5158.87	597.0
2016-05-18 19:00:00	NQ	Futures	5158.87	5165.41	5158.57	5163.93	864.0
2016-05-18 20:00:00	NQ	Futures	5164.22	5166.01	5157.08	5158.87	754.0
2016-05-18 21:00:00	NQ	Futures	5158.87	5159.46	5142.5	5145.78	1764.0
2016-05-18 22:00:00	NQ	Futures	5145.78	5149.64	5143.4	5146.97	1212.0
2016-05-18 23:00:00	NQ	Futures	5147.26	5147.56	5141.91	5146.07	534.0
2016-05-18 00:00:00	YM	Futures	18715.8	18721.1	18692.2	18704.0	1190.0
2016-05-18 01:00:00	YM	Futures	18705.1	18731.8	18702.9	18721.1	1128.0
2016-05-18 02:00:00	YM	Futures	18720.0	18721.1	18674.0	18699.7	2831.0
2016-05-18 03:00:00	YM	Futures	18699.7	18722.2	18677.2	18696.5	5596.0

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

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