PREVIEW / futures_1hour / 2015-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-17.parquet
  size:    51 KB
  rows:    1,592

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-11-17 00:00:00	ES	Futures	2195.47	2196.54	2194.13	2194.4	3585.0
2015-11-17 01:00:00	ES	Futures	2194.13	2195.73	2193.86	2194.13	4150.0
2015-11-17 02:00:00	ES	Futures	2194.13	2194.4	2189.85	2191.72	12688.0
2015-11-17 03:00:00	ES	Futures	2191.72	2197.61	2189.58	2195.73	26963.0
2015-11-17 04:00:00	ES	Futures	2196.0	2201.89	2194.66	2199.75	22865.0
2015-11-17 05:00:00	ES	Futures	2199.75	2203.23	2198.94	2201.62	21323.0
2015-11-17 06:00:00	ES	Futures	2201.62	2204.03	2199.75	2199.75	21177.0
2015-11-17 07:00:00	ES	Futures	2199.75	2201.35	2197.07	2199.48	26829.0
2015-11-17 08:00:00	ES	Futures	2199.48	2201.89	2196.8	2200.82	32601.0
2015-11-17 09:00:00	ES	Futures	2200.82	2200.82	2189.31	2194.93	194373.0
2015-11-17 10:00:00	ES	Futures	2194.4	2205.37	2190.92	2203.23	247342.0
2015-11-17 11:00:00	ES	Futures	2203.23	2208.58	2200.82	2205.63	168373.0
2015-11-17 12:00:00	ES	Futures	2205.63	2208.04	2196.8	2200.82	135945.0
2015-11-17 13:00:00	ES	Futures	2201.09	2203.49	2194.13	2200.82	147026.0
2015-11-17 14:00:00	ES	Futures	2200.82	2202.96	2186.9	2193.33	194134.0
2015-11-17 15:00:00	ES	Futures	2193.33	2194.93	2185.03	2190.65	260361.0
2015-11-17 16:00:00	ES	Futures	2190.65	2196.27	2190.38	2193.86	59614.0
2015-11-17 18:00:00	ES	Futures	2193.86	2194.13	2191.45	2191.45	3854.0
2015-11-17 19:00:00	ES	Futures	2191.72	2193.33	2189.58	2191.19	5679.0
2015-11-17 20:00:00	ES	Futures	2191.19	2194.4	2191.19	2193.06	5392.0
2015-11-17 21:00:00	ES	Futures	2193.33	2194.66	2192.26	2193.86	2438.0
2015-11-17 22:00:00	ES	Futures	2194.13	2194.13	2190.65	2192.26	3539.0
2015-11-17 23:00:00	ES	Futures	2192.26	2192.79	2190.11	2191.99	2658.0
2015-11-17 00:00:00	NQ	Futures	5414.52	5416.89	5410.37	5410.37	758.0
2015-11-17 01:00:00	NQ	Futures	5410.37	5413.63	5409.48	5410.66	672.0
2015-11-17 02:00:00	NQ	Futures	5410.66	5411.26	5399.69	5404.73	1972.0
2015-11-17 03:00:00	NQ	Futures	5404.14	5420.45	5398.51	5415.71	4080.0
2015-11-17 04:00:00	NQ	Futures	5416.0	5433.2	5413.63	5428.16	3761.0
2015-11-17 05:00:00	NQ	Futures	5428.16	5434.68	5424.9	5433.2	3593.0
2015-11-17 06:00:00	NQ	Futures	5433.49	5438.24	5429.34	5429.94	3095.0
2015-11-17 07:00:00	NQ	Futures	5429.94	5432.31	5424.9	5428.75	2925.0
2015-11-17 08:00:00	NQ	Futures	5428.45	5432.9	5422.82	5427.27	4813.0
2015-11-17 09:00:00	NQ	Futures	5426.97	5427.27	5405.92	5418.67	36029.0
2015-11-17 10:00:00	NQ	Futures	5418.67	5441.8	5406.81	5436.76	43052.0
2015-11-17 11:00:00	NQ	Futures	5437.05	5452.77	5428.75	5444.76	27696.0
2015-11-17 12:00:00	NQ	Futures	5445.06	5450.1	5425.79	5437.94	23806.0
2015-11-17 13:00:00	NQ	Futures	5437.94	5446.54	5421.34	5437.65	24103.0
2015-11-17 14:00:00	NQ	Futures	5437.35	5444.76	5400.88	5421.93	33001.0
2015-11-17 15:00:00	NQ	Futures	5421.93	5422.52	5399.99	5413.33	42896.0
2015-11-17 16:00:00	NQ	Futures	5413.63	5426.08	5413.04	5419.26	6142.0
2015-11-17 18:00:00	NQ	Futures	5420.15	5421.34	5413.63	5414.22	906.0
2015-11-17 19:00:00	NQ	Futures	5414.22	5418.37	5410.07	5413.63	1152.0
2015-11-17 20:00:00	NQ	Futures	5413.93	5422.52	5413.93	5418.97	1116.0
2015-11-17 21:00:00	NQ	Futures	5419.56	5423.71	5416.0	5421.93	483.0
2015-11-17 22:00:00	NQ	Futures	5421.93	5422.23	5411.55	5415.71	608.0
2015-11-17 23:00:00	NQ	Futures	5415.41	5416.89	5409.78	5413.33	616.0
2015-11-17 00:00:00	YM	Futures	18484.0	18494.6	18474.4	18474.4	772.0
2015-11-17 01:00:00	YM	Futures	18474.4	18482.9	18468.1	18469.1	707.0
2015-11-17 02:00:00	YM	Futures	18468.1	18471.3	18432.1	18448.0	2208.0
2015-11-17 03:00:00	YM	Futures	18449.0	18495.6	18431.0	18477.6	4258.0

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

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