PREVIEW / futures_1hour / 2015-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-15.parquet
  size:    52 KB
  rows:    1,575

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
2015-10-15 00:00:00	ES	Futures	2137.13	2137.13	2134.99	2136.06	3354.0
2015-10-15 01:00:00	ES	Futures	2136.33	2137.13	2134.19	2136.06	5138.0
2015-10-15 02:00:00	ES	Futures	2136.06	2139.28	2135.8	2137.94	13150.0
2015-10-15 03:00:00	ES	Futures	2137.94	2140.35	2133.39	2137.67	24340.0
2015-10-15 04:00:00	ES	Futures	2137.67	2139.81	2135.53	2139.54	16827.0
2015-10-15 05:00:00	ES	Futures	2139.54	2140.61	2137.67	2140.08	14541.0
2015-10-15 06:00:00	ES	Futures	2139.81	2140.08	2137.13	2138.47	14536.0
2015-10-15 07:00:00	ES	Futures	2138.74	2139.28	2135.26	2136.33	36327.0
2015-10-15 08:00:00	ES	Futures	2136.6	2140.08	2132.59	2136.06	55692.0
2015-10-15 09:00:00	ES	Futures	2136.06	2138.47	2131.25	2134.99	205026.0
2015-10-15 10:00:00	ES	Futures	2134.99	2141.42	2131.78	2139.54	235552.0
2015-10-15 11:00:00	ES	Futures	2139.54	2140.88	2129.37	2131.52	197236.0
2015-10-15 12:00:00	ES	Futures	2131.25	2140.08	2130.71	2139.81	134222.0
2015-10-15 13:00:00	ES	Futures	2139.81	2148.64	2139.28	2146.77	179670.0
2015-10-15 14:00:00	ES	Futures	2146.77	2154.79	2146.77	2153.19	186650.0
2015-10-15 15:00:00	ES	Futures	2153.19	2158.81	2152.65	2158.54	259416.0
2015-10-15 16:00:00	ES	Futures	2158.54	2161.48	2156.4	2160.68	92387.0
2015-10-15 18:00:00	ES	Futures	2160.15	2165.23	2159.08	2163.09	11102.0
2015-10-15 19:00:00	ES	Futures	2163.09	2164.43	2162.02	2164.16	5078.0
2015-10-15 20:00:00	ES	Futures	2163.89	2164.43	2159.88	2160.95	7994.0
2015-10-15 21:00:00	ES	Futures	2160.95	2162.02	2159.88	2161.75	5637.0
2015-10-15 22:00:00	ES	Futures	2162.02	2162.55	2159.88	2160.15	5135.0
2015-10-15 23:00:00	ES	Futures	2160.15	2160.41	2158.81	2159.34	3799.0
2015-10-15 00:00:00	NQ	Futures	5169.32	5170.21	5165.47	5167.25	772.0
2015-10-15 01:00:00	NQ	Futures	5167.25	5169.91	5162.5	5166.36	968.0
2015-10-15 02:00:00	NQ	Futures	5167.25	5173.77	5165.47	5171.1	2482.0
2015-10-15 03:00:00	NQ	Futures	5171.1	5177.62	5157.16	5170.51	4932.0
2015-10-15 04:00:00	NQ	Futures	5170.51	5177.03	5164.87	5174.95	3768.0
2015-10-15 05:00:00	NQ	Futures	5175.25	5178.81	5170.21	5177.62	2373.0
2015-10-15 06:00:00	NQ	Futures	5177.62	5177.62	5168.73	5171.1	1899.0
2015-10-15 07:00:00	NQ	Futures	5171.1	5174.06	5165.76	5169.32	5070.0
2015-10-15 08:00:00	NQ	Futures	5169.32	5174.95	5156.87	5165.17	8731.0
2015-10-15 09:00:00	NQ	Futures	5165.17	5189.48	5156.87	5181.48	41860.0
2015-10-15 10:00:00	NQ	Futures	5181.48	5192.45	5168.14	5186.81	41630.0
2015-10-15 11:00:00	NQ	Futures	5186.81	5191.56	5154.79	5160.43	30770.0
2015-10-15 12:00:00	NQ	Futures	5160.13	5185.04	5158.35	5180.88	22012.0
2015-10-15 13:00:00	NQ	Futures	5180.59	5201.64	5179.7	5197.78	23984.0
2015-10-15 14:00:00	NQ	Futures	5197.78	5217.35	5197.78	5212.02	27973.0
2015-10-15 15:00:00	NQ	Futures	5212.31	5228.03	5209.64	5227.14	34524.0
2015-10-15 16:00:00	NQ	Futures	5227.14	5232.47	5223.88	5232.18	7872.0
2015-10-15 18:00:00	NQ	Futures	5229.81	5244.33	5227.43	5239.89	2635.0
2015-10-15 19:00:00	NQ	Futures	5240.18	5243.74	5237.81	5243.44	1018.0
2015-10-15 20:00:00	NQ	Futures	5243.15	5243.44	5233.36	5237.22	944.0
2015-10-15 21:00:00	NQ	Futures	5236.62	5239.29	5235.14	5237.81	1160.0
2015-10-15 22:00:00	NQ	Futures	5238.11	5238.7	5232.77	5233.66	660.0
2015-10-15 23:00:00	NQ	Futures	5233.96	5233.96	5228.03	5230.1	805.0
2015-10-15 00:00:00	YM	Futures	17924.7	17925.7	17909.9	17916.2	562.0
2015-10-15 01:00:00	YM	Futures	17917.3	17925.7	17902.4	17917.3	739.0
2015-10-15 02:00:00	YM	Futures	17918.3	17936.3	17909.9	17926.8	1981.0
2015-10-15 03:00:00	YM	Futures	17925.7	17946.9	17891.8	17924.7	3349.0

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

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