PREVIEW / futures_1hour / 2016-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-05.parquet
  size:    53 KB
  rows:    1,608

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-01-05 00:00:00	ES	Futures	2163.11	2164.18	2159.88	2160.15	8480.0
2016-01-05 01:00:00	ES	Futures	2160.15	2164.45	2156.39	2163.11	11959.0
2016-01-05 02:00:00	ES	Futures	2163.11	2163.65	2160.42	2162.03	10000.0
2016-01-05 03:00:00	ES	Futures	2162.03	2163.38	2153.43	2155.05	28305.0
2016-01-05 04:00:00	ES	Futures	2155.05	2155.05	2146.72	2146.99	31812.0
2016-01-05 05:00:00	ES	Futures	2146.99	2147.52	2141.34	2142.95	31668.0
2016-01-05 06:00:00	ES	Futures	2142.95	2146.99	2142.42	2146.72	17440.0
2016-01-05 07:00:00	ES	Futures	2146.99	2149.13	2142.95	2148.87	27450.0
2016-01-05 08:00:00	ES	Futures	2148.87	2159.88	2148.06	2157.73	64790.0
2016-01-05 09:00:00	ES	Futures	2158.0	2163.65	2153.43	2153.97	232891.0
2016-01-05 10:00:00	ES	Futures	2153.7	2160.15	2147.79	2158.27	248750.0
2016-01-05 11:00:00	ES	Futures	2158.27	2159.88	2150.48	2153.7	168673.0
2016-01-05 12:00:00	ES	Futures	2153.7	2153.97	2144.57	2150.48	144781.0
2016-01-05 13:00:00	ES	Futures	2150.75	2160.42	2147.25	2158.0	138624.0
2016-01-05 14:00:00	ES	Futures	2158.27	2164.99	2155.58	2159.08	154615.0
2016-01-05 15:00:00	ES	Futures	2159.08	2162.57	2152.63	2159.88	241472.0
2016-01-05 16:00:00	ES	Futures	2160.15	2163.65	2158.54	2160.69	66615.0
2016-01-05 18:00:00	ES	Futures	2161.23	2162.84	2160.69	2160.96	4146.0
2016-01-05 19:00:00	ES	Futures	2161.23	2163.91	2159.61	2162.03	7707.0
2016-01-05 20:00:00	ES	Futures	2162.03	2162.03	2148.6	2148.6	29962.0
2016-01-05 21:00:00	ES	Futures	2148.87	2148.87	2134.89	2137.31	40113.0
2016-01-05 22:00:00	ES	Futures	2137.31	2144.03	2135.7	2142.69	24070.0
2016-01-05 23:00:00	ES	Futures	2142.69	2144.84	2140.27	2143.76	9892.0
2016-01-05 00:00:00	NQ	Futures	5362.88	5364.66	5350.7	5353.67	1697.0
2016-01-05 01:00:00	NQ	Futures	5353.97	5361.69	5343.58	5357.83	2276.0
2016-01-05 02:00:00	NQ	Futures	5357.83	5359.61	5350.11	5355.75	2214.0
2016-01-05 03:00:00	NQ	Futures	5355.45	5359.61	5334.67	5340.01	5891.0
2016-01-05 04:00:00	NQ	Futures	5339.42	5340.01	5317.45	5320.12	5081.0
2016-01-05 05:00:00	NQ	Futures	5320.12	5320.12	5304.38	5309.73	5103.0
2016-01-05 06:00:00	NQ	Futures	5309.43	5319.82	5308.54	5318.93	2933.0
2016-01-05 07:00:00	NQ	Futures	5319.23	5323.09	5311.21	5322.79	4111.0
2016-01-05 08:00:00	NQ	Futures	5322.79	5349.22	5319.82	5345.06	9425.0
2016-01-05 09:00:00	NQ	Futures	5345.06	5361.69	5328.73	5329.62	42371.0
2016-01-05 10:00:00	NQ	Futures	5329.62	5351.0	5316.56	5342.69	41352.0
2016-01-05 11:00:00	NQ	Futures	5342.98	5347.14	5318.93	5323.68	28737.0
2016-01-05 12:00:00	NQ	Futures	5324.28	5324.87	5293.99	5309.73	36791.0
2016-01-05 13:00:00	NQ	Futures	5310.02	5340.01	5301.12	5332.89	25564.0
2016-01-05 14:00:00	NQ	Futures	5332.59	5348.03	5319.82	5323.98	26345.0
2016-01-05 15:00:00	NQ	Futures	5323.98	5332.89	5307.94	5315.96	39669.0
2016-01-05 16:00:00	NQ	Futures	5315.96	5329.92	5313.88	5322.79	7891.0
2016-01-05 18:00:00	NQ	Futures	5323.39	5326.95	5322.79	5323.98	499.0
2016-01-05 19:00:00	NQ	Futures	5324.57	5329.92	5321.01	5325.46	1218.0
2016-01-05 20:00:00	NQ	Futures	5325.46	5325.46	5294.29	5294.58	5640.0
2016-01-05 21:00:00	NQ	Futures	5294.58	5294.58	5256.28	5262.51	7992.0
2016-01-05 22:00:00	NQ	Futures	5263.11	5280.63	5258.65	5275.58	5218.0
2016-01-05 23:00:00	NQ	Futures	5275.88	5283.3	5270.23	5280.03	2707.0
2016-01-05 00:00:00	YM	Futures	18221.7	18228.1	18188.7	18193.0	2068.0
2016-01-05 01:00:00	YM	Futures	18190.9	18223.9	18165.3	18213.2	2669.0
2016-01-05 02:00:00	YM	Futures	18213.2	18222.8	18196.2	18207.9	2198.0
2016-01-05 03:00:00	YM	Futures	18209.0	18221.7	18137.6	18151.5	5989.0

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

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