PREVIEW / futures_1hour / 2016-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-16.parquet
  size:    52 KB
  rows:    1,585

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-03-16 00:00:00	ES	Futures	2166.59	2168.48	2166.32	2167.94	1917.0
2016-03-16 01:00:00	ES	Futures	2167.94	2170.91	2166.86	2169.29	4189.0
2016-03-16 02:00:00	ES	Futures	2169.02	2169.56	2166.59	2167.94	4082.0
2016-03-16 03:00:00	ES	Futures	2167.94	2169.02	2166.05	2168.48	7024.0
2016-03-16 04:00:00	ES	Futures	2168.48	2170.91	2167.13	2170.37	16446.0
2016-03-16 05:00:00	ES	Futures	2170.1	2170.64	2167.94	2169.02	13299.0
2016-03-16 06:00:00	ES	Futures	2169.02	2169.83	2166.32	2166.59	18157.0
2016-03-16 07:00:00	ES	Futures	2166.59	2167.4	2164.43	2165.24	18672.0
2016-03-16 08:00:00	ES	Futures	2165.24	2166.59	2157.95	2158.76	55436.0
2016-03-16 09:00:00	ES	Futures	2158.76	2169.29	2156.6	2166.32	223310.0
2016-03-16 10:00:00	ES	Futures	2166.32	2169.83	2165.51	2167.94	145161.0
2016-03-16 11:00:00	ES	Futures	2167.67	2169.56	2166.59	2167.13	114672.0
2016-03-16 12:00:00	ES	Futures	2167.13	2169.02	2162.81	2163.62	110195.0
2016-03-16 13:00:00	ES	Futures	2163.62	2164.7	2159.57	2162.27	86987.0
2016-03-16 14:00:00	ES	Futures	2162.0	2183.33	2161.73	2173.61	445905.0
2016-03-16 15:00:00	ES	Futures	2173.88	2184.41	2173.07	2179.82	308510.0
2016-03-16 16:00:00	ES	Futures	2180.09	2180.36	2177.12	2178.47	67561.0
2016-03-16 17:00:00	ES	Futures	2178.47	2178.47	2178.2	2178.2	64.0
2016-03-16 18:00:00	ES	Futures	2178.2	2179.28	2177.12	2178.47	4440.0
2016-03-16 19:00:00	ES	Futures	2178.47	2181.71	2177.93	2181.44	5898.0
2016-03-16 20:00:00	ES	Futures	2181.17	2187.38	2180.63	2186.84	15835.0
2016-03-16 21:00:00	ES	Futures	2186.84	2187.92	2184.68	2185.76	10784.0
2016-03-16 22:00:00	ES	Futures	2185.49	2186.57	2183.6	2183.87	5287.0
2016-03-16 23:00:00	ES	Futures	2183.87	2187.65	2183.6	2185.22	6437.0
2016-03-16 00:00:00	NQ	Futures	5183.56	5189.22	5182.97	5187.43	342.0
2016-03-16 01:00:00	NQ	Futures	5186.54	5195.76	5184.75	5191.0	562.0
2016-03-16 02:00:00	NQ	Futures	5191.0	5192.49	5185.05	5188.32	532.0
2016-03-16 03:00:00	NQ	Futures	5188.62	5193.08	5185.05	5190.7	1000.0
2016-03-16 04:00:00	NQ	Futures	5191.0	5197.25	5187.13	5195.76	2497.0
2016-03-16 05:00:00	NQ	Futures	5196.36	5197.84	5190.41	5193.68	1132.0
2016-03-16 06:00:00	NQ	Futures	5194.27	5194.57	5184.16	5186.84	1643.0
2016-03-16 07:00:00	NQ	Futures	5186.54	5188.62	5182.97	5185.65	1925.0
2016-03-16 08:00:00	NQ	Futures	5185.65	5189.22	5169.28	5171.36	5840.0
2016-03-16 09:00:00	NQ	Futures	5171.36	5195.17	5165.71	5192.19	31360.0
2016-03-16 10:00:00	NQ	Futures	5192.19	5199.93	5189.22	5195.76	23041.0
2016-03-16 11:00:00	NQ	Futures	5196.06	5205.28	5192.79	5201.41	17469.0
2016-03-16 12:00:00	NQ	Futures	5201.41	5207.66	5183.86	5185.65	19922.0
2016-03-16 13:00:00	NQ	Futures	5185.35	5188.62	5176.72	5188.03	15785.0
2016-03-16 14:00:00	NQ	Futures	5187.73	5235.93	5187.73	5215.99	70514.0
2016-03-16 15:00:00	NQ	Futures	5215.99	5245.75	5215.1	5232.65	41225.0
2016-03-16 16:00:00	NQ	Futures	5232.36	5232.95	5220.16	5224.32	6865.0
2016-03-16 18:00:00	NQ	Futures	5221.94	5224.62	5218.08	5223.43	541.0
2016-03-16 19:00:00	NQ	Futures	5223.43	5229.98	5222.24	5229.68	605.0
2016-03-16 20:00:00	NQ	Futures	5229.38	5245.15	5229.08	5244.56	1595.0
2016-03-16 21:00:00	NQ	Futures	5243.96	5249.02	5239.5	5241.28	1148.0
2016-03-16 22:00:00	NQ	Futures	5240.99	5246.04	5236.52	5237.12	719.0
2016-03-16 23:00:00	NQ	Futures	5237.42	5247.83	5235.93	5242.47	687.0
2016-03-16 00:00:00	YM	Futures	18349.7	18366.8	18349.7	18363.6	406.0
2016-03-16 01:00:00	YM	Futures	18363.6	18386.1	18356.1	18372.2	689.0
2016-03-16 02:00:00	YM	Futures	18373.2	18375.4	18356.1	18363.6	634.0

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

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