PREVIEW / futures_1hour / 2017-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-12.parquet
  size:    50 KB
  rows:    1,613

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
2017-10-12 00:00:00	ES	Futures	2791.94	2792.21	2791.39	2791.67	1932.0
2017-10-12 01:00:00	ES	Futures	2791.67	2791.67	2789.75	2791.12	6235.0
2017-10-12 02:00:00	ES	Futures	2791.12	2792.21	2790.3	2791.67	5681.0
2017-10-12 03:00:00	ES	Futures	2791.67	2791.94	2789.75	2790.02	13826.0
2017-10-12 04:00:00	ES	Futures	2790.3	2790.84	2788.66	2788.93	9687.0
2017-10-12 05:00:00	ES	Futures	2788.93	2791.39	2788.66	2790.57	7898.0
2017-10-12 06:00:00	ES	Futures	2790.57	2791.39	2789.48	2790.02	7194.0
2017-10-12 07:00:00	ES	Futures	2790.02	2790.02	2787.29	2788.66	17593.0
2017-10-12 08:00:00	ES	Futures	2788.38	2789.75	2787.84	2788.11	16361.0
2017-10-12 09:00:00	ES	Futures	2788.11	2790.3	2787.29	2788.38	100601.0
2017-10-12 10:00:00	ES	Futures	2788.66	2792.76	2787.84	2791.12	123545.0
2017-10-12 11:00:00	ES	Futures	2791.12	2793.31	2790.57	2793.31	74098.0
2017-10-12 12:00:00	ES	Futures	2793.03	2793.85	2790.84	2791.67	67420.0
2017-10-12 13:00:00	ES	Futures	2791.94	2793.85	2791.67	2792.49	53606.0
2017-10-12 14:00:00	ES	Futures	2792.21	2793.03	2788.93	2790.3	86537.0
2017-10-12 15:00:00	ES	Futures	2790.02	2791.67	2786.19	2788.93	257807.0
2017-10-12 16:00:00	ES	Futures	2789.2	2789.75	2788.66	2788.93	52378.0
2017-10-12 18:00:00	ES	Futures	2788.11	2788.66	2787.56	2788.66	4079.0
2017-10-12 19:00:00	ES	Futures	2788.38	2788.93	2787.29	2787.56	1990.0
2017-10-12 20:00:00	ES	Futures	2787.84	2788.38	2787.02	2788.11	5449.0
2017-10-12 21:00:00	ES	Futures	2788.11	2789.48	2788.11	2788.93	3305.0
2017-10-12 22:00:00	ES	Futures	2788.93	2789.75	2788.38	2789.2	3247.0
2017-10-12 23:00:00	ES	Futures	2789.2	2790.3	2789.2	2790.3	3884.0
2017-10-12 00:00:00	NQ	Futures	7236.74	7237.63	7235.84	7235.84	334.0
2017-10-12 01:00:00	NQ	Futures	7236.14	7237.33	7231.09	7234.65	965.0
2017-10-12 02:00:00	NQ	Futures	7234.65	7237.63	7232.57	7236.74	956.0
2017-10-12 03:00:00	NQ	Futures	7236.44	7237.93	7232.28	7232.87	1264.0
2017-10-12 04:00:00	NQ	Futures	7232.87	7234.65	7228.71	7229.9	1087.0
2017-10-12 05:00:00	NQ	Futures	7229.6	7237.03	7229.3	7234.65	1294.0
2017-10-12 06:00:00	NQ	Futures	7235.25	7237.03	7231.09	7234.95	1059.0
2017-10-12 07:00:00	NQ	Futures	7234.95	7236.14	7225.44	7230.19	3102.0
2017-10-12 08:00:00	NQ	Futures	7230.49	7231.98	7223.06	7225.73	4391.0
2017-10-12 09:00:00	NQ	Futures	7226.03	7236.14	7219.19	7230.79	33895.0
2017-10-12 10:00:00	NQ	Futures	7230.79	7243.58	7224.54	7235.84	38001.0
2017-10-12 11:00:00	NQ	Futures	7236.14	7247.15	7233.47	7245.66	19944.0
2017-10-12 12:00:00	NQ	Futures	7245.96	7253.39	7238.22	7240.9	18100.0
2017-10-12 13:00:00	NQ	Futures	7240.9	7247.15	7240.31	7242.09	11635.0
2017-10-12 14:00:00	NQ	Futures	7242.09	7245.36	7225.73	7230.19	18404.0
2017-10-12 15:00:00	NQ	Futures	7230.19	7236.44	7217.11	7225.44	35580.0
2017-10-12 16:00:00	NQ	Futures	7225.44	7227.52	7223.65	7226.03	5071.0
2017-10-12 18:00:00	NQ	Futures	7224.84	7226.33	7223.06	7225.44	764.0
2017-10-12 19:00:00	NQ	Futures	7225.73	7225.73	7222.46	7223.06	524.0
2017-10-12 20:00:00	NQ	Futures	7223.35	7224.54	7219.49	7223.95	1100.0
2017-10-12 21:00:00	NQ	Futures	7224.25	7227.81	7223.95	7226.92	922.0
2017-10-12 22:00:00	NQ	Futures	7226.92	7229.6	7226.33	7229.0	742.0
2017-10-12 23:00:00	NQ	Futures	7228.71	7232.57	7228.71	7232.28	767.0
2017-10-12 00:00:00	YM	Futures	24817.7	24819.9	24814.4	24814.4	369.0
2017-10-12 01:00:00	YM	Futures	24814.4	24817.7	24803.6	24813.3	1221.0
2017-10-12 02:00:00	YM	Futures	24813.3	24817.7	24802.5	24811.2	1229.0
2017-10-12 03:00:00	YM	Futures	24811.2	24817.7	24804.6	24806.8	1203.0

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

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