PREVIEW / futures_1hour / 2016-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-28.parquet
  size:    53 KB
  rows:    1,625

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-11-28 00:00:00	ES	Futures	2402.19	2403.0	2401.1	2402.73	3624.0
2016-11-28 01:00:00	ES	Futures	2402.46	2403.27	2401.37	2401.91	2657.0
2016-11-28 02:00:00	ES	Futures	2401.64	2402.46	2399.19	2399.19	7063.0
2016-11-28 03:00:00	ES	Futures	2399.46	2399.46	2393.75	2396.2	35091.0
2016-11-28 04:00:00	ES	Futures	2396.47	2398.92	2396.2	2398.92	12623.0
2016-11-28 05:00:00	ES	Futures	2398.65	2401.1	2398.38	2399.46	13568.0
2016-11-28 06:00:00	ES	Futures	2399.19	2400.01	2397.56	2398.92	11720.0
2016-11-28 07:00:00	ES	Futures	2399.19	2402.19	2397.83	2401.37	15904.0
2016-11-28 08:00:00	ES	Futures	2401.64	2401.91	2399.19	2400.28	18861.0
2016-11-28 09:00:00	ES	Futures	2400.28	2403.0	2399.19	2401.1	172624.0
2016-11-28 10:00:00	ES	Futures	2401.37	2404.63	2396.2	2396.47	238495.0
2016-11-28 11:00:00	ES	Futures	2396.2	2399.46	2395.66	2398.65	204918.0
2016-11-28 12:00:00	ES	Futures	2398.92	2403.82	2398.92	2401.91	107627.0
2016-11-28 13:00:00	ES	Futures	2401.64	2401.91	2399.74	2400.55	54370.0
2016-11-28 14:00:00	ES	Futures	2400.55	2401.91	2398.1	2398.65	71274.0
2016-11-28 15:00:00	ES	Futures	2398.92	2399.19	2392.39	2394.3	255907.0
2016-11-28 16:00:00	ES	Futures	2394.3	2396.47	2393.75	2394.3	84304.0
2016-11-28 18:00:00	ES	Futures	2394.57	2395.11	2392.93	2393.75	4801.0
2016-11-28 19:00:00	ES	Futures	2393.75	2394.57	2393.48	2393.75	2543.0
2016-11-28 20:00:00	ES	Futures	2393.75	2394.57	2393.48	2394.3	3377.0
2016-11-28 21:00:00	ES	Futures	2394.57	2395.93	2394.3	2395.11	3438.0
2016-11-28 22:00:00	ES	Futures	2395.11	2395.93	2394.3	2394.57	3388.0
2016-11-28 23:00:00	ES	Futures	2394.57	2394.84	2393.75	2393.75	2185.0
2016-11-28 00:00:00	NQ	Futures	5805.0	5805.6	5802.32	5805.0	578.0
2016-11-28 01:00:00	NQ	Futures	5804.7	5808.58	5804.7	5805.9	554.0
2016-11-28 02:00:00	NQ	Futures	5805.9	5806.79	5799.33	5799.93	938.0
2016-11-28 03:00:00	NQ	Futures	5799.93	5799.93	5779.05	5787.4	5139.0
2016-11-28 04:00:00	NQ	Futures	5787.4	5796.05	5786.8	5795.75	2041.0
2016-11-28 05:00:00	NQ	Futures	5796.05	5804.11	5795.45	5796.95	2634.0
2016-11-28 06:00:00	NQ	Futures	5796.65	5798.74	5792.47	5796.65	1372.0
2016-11-28 07:00:00	NQ	Futures	5796.65	5804.4	5793.37	5802.02	1550.0
2016-11-28 08:00:00	NQ	Futures	5802.02	5803.21	5797.24	5801.42	2800.0
2016-11-28 09:00:00	NQ	Futures	5801.42	5811.56	5789.79	5810.37	22970.0
2016-11-28 10:00:00	NQ	Futures	5810.07	5823.2	5802.32	5803.51	28514.0
2016-11-28 11:00:00	NQ	Futures	5803.51	5815.14	5800.23	5812.16	19348.0
2016-11-28 12:00:00	NQ	Futures	5812.46	5821.41	5809.48	5816.34	11323.0
2016-11-28 13:00:00	NQ	Futures	5816.34	5816.64	5808.88	5810.67	5732.0
2016-11-28 14:00:00	NQ	Futures	5810.67	5815.44	5802.02	5805.0	7728.0
2016-11-28 15:00:00	NQ	Futures	5805.0	5807.09	5792.77	5796.95	18964.0
2016-11-28 16:00:00	NQ	Futures	5796.65	5802.61	5795.16	5796.95	4538.0
2016-11-28 18:00:00	NQ	Futures	5800.82	5800.82	5795.16	5795.75	506.0
2016-11-28 19:00:00	NQ	Futures	5795.75	5798.44	5795.45	5797.84	491.0
2016-11-28 20:00:00	NQ	Futures	5797.54	5800.82	5797.24	5799.93	727.0
2016-11-28 21:00:00	NQ	Futures	5799.93	5803.81	5799.63	5802.61	771.0
2016-11-28 22:00:00	NQ	Futures	5802.32	5803.51	5799.93	5800.82	299.0
2016-11-28 23:00:00	NQ	Futures	5800.23	5801.42	5799.33	5799.33	286.0
2016-11-28 00:00:00	YM	Futures	20640.4	20649.1	20633.9	20645.8	780.0
2016-11-28 01:00:00	YM	Futures	20644.7	20650.1	20637.2	20637.2	501.0
2016-11-28 02:00:00	YM	Futures	20639.3	20644.7	20625.3	20627.4	1492.0
2016-11-28 03:00:00	YM	Futures	20627.4	20628.5	20588.5	20605.8	7380.0

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

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