PREVIEW / futures_1hour / 2017-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-11.parquet
  size:    51 KB
  rows:    1,616

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-11 00:00:00	ES	Futures	2789.2	2789.75	2788.66	2788.93	1848.0
2017-10-11 01:00:00	ES	Futures	2788.93	2788.93	2787.29	2788.11	3414.0
2017-10-11 02:00:00	ES	Futures	2787.84	2788.66	2787.56	2787.84	4477.0
2017-10-11 03:00:00	ES	Futures	2788.11	2788.11	2784.83	2785.37	14968.0
2017-10-11 04:00:00	ES	Futures	2785.37	2786.74	2785.37	2785.92	10145.0
2017-10-11 05:00:00	ES	Futures	2785.92	2786.19	2785.1	2786.19	9414.0
2017-10-11 06:00:00	ES	Futures	2786.19	2787.56	2785.92	2787.29	8940.0
2017-10-11 07:00:00	ES	Futures	2787.02	2787.29	2784.01	2785.1	15447.0
2017-10-11 08:00:00	ES	Futures	2785.37	2787.29	2784.55	2787.02	14181.0
2017-10-11 09:00:00	ES	Futures	2786.74	2789.75	2785.92	2787.29	105211.0
2017-10-11 10:00:00	ES	Futures	2787.29	2789.75	2786.74	2788.38	93006.0
2017-10-11 11:00:00	ES	Futures	2788.66	2790.3	2787.84	2788.93	77690.0
2017-10-11 12:00:00	ES	Futures	2789.2	2791.39	2788.93	2790.02	46990.0
2017-10-11 13:00:00	ES	Futures	2790.3	2791.39	2789.48	2789.75	49690.0
2017-10-11 14:00:00	ES	Futures	2789.48	2792.49	2789.2	2790.57	74155.0
2017-10-11 15:00:00	ES	Futures	2790.57	2793.85	2790.57	2793.85	180902.0
2017-10-11 16:00:00	ES	Futures	2793.58	2794.13	2792.76	2793.03	69207.0
2017-10-11 18:00:00	ES	Futures	2792.76	2793.03	2791.94	2792.21	4917.0
2017-10-11 19:00:00	ES	Futures	2792.49	2792.49	2791.94	2792.21	2038.0
2017-10-11 20:00:00	ES	Futures	2792.21	2792.21	2790.84	2791.12	6702.0
2017-10-11 21:00:00	ES	Futures	2790.84	2791.39	2790.84	2790.84	3054.0
2017-10-11 22:00:00	ES	Futures	2790.84	2791.94	2790.84	2791.67	2797.0
2017-10-11 23:00:00	ES	Futures	2791.94	2792.21	2791.67	2791.67	1759.0
2017-10-11 00:00:00	NQ	Futures	7220.08	7220.97	7219.19	7219.49	276.0
2017-10-11 01:00:00	NQ	Futures	7219.78	7220.38	7216.22	7217.4	627.0
2017-10-11 02:00:00	NQ	Futures	7217.4	7218.89	7215.32	7217.11	692.0
2017-10-11 03:00:00	NQ	Futures	7216.81	7216.81	7204.62	7206.7	2573.0
2017-10-11 04:00:00	NQ	Futures	7206.4	7211.46	7206.1	7210.27	1486.0
2017-10-11 05:00:00	NQ	Futures	7210.27	7210.27	7205.81	7208.78	949.0
2017-10-11 06:00:00	NQ	Futures	7208.48	7215.03	7208.48	7213.24	1474.0
2017-10-11 07:00:00	NQ	Futures	7213.24	7213.84	7201.34	7204.62	3193.0
2017-10-11 08:00:00	NQ	Futures	7204.91	7211.75	7201.94	7210.86	4188.0
2017-10-11 09:00:00	NQ	Futures	7210.56	7220.68	7204.62	7212.94	33663.0
2017-10-11 10:00:00	NQ	Futures	7212.94	7227.22	7210.86	7220.08	31158.0
2017-10-11 11:00:00	NQ	Futures	7220.38	7226.03	7214.13	7220.38	19792.0
2017-10-11 12:00:00	NQ	Futures	7220.97	7226.62	7220.38	7223.95	9854.0
2017-10-11 13:00:00	NQ	Futures	7224.25	7229.0	7220.68	7222.16	8709.0
2017-10-11 14:00:00	NQ	Futures	7222.46	7232.28	7219.78	7227.81	20045.0
2017-10-11 15:00:00	NQ	Futures	7227.81	7240.31	7227.52	7239.12	30111.0
2017-10-11 16:00:00	NQ	Futures	7239.12	7239.41	7234.65	7237.03	5803.0
2017-10-11 18:00:00	NQ	Futures	7237.33	7238.22	7234.36	7236.44	1317.0
2017-10-11 19:00:00	NQ	Futures	7236.14	7236.74	7234.95	7235.84	341.0
2017-10-11 20:00:00	NQ	Futures	7235.84	7235.84	7231.09	7231.98	1173.0
2017-10-11 21:00:00	NQ	Futures	7232.28	7234.65	7231.09	7232.28	906.0
2017-10-11 22:00:00	NQ	Futures	7232.28	7237.03	7231.98	7235.25	864.0
2017-10-11 23:00:00	NQ	Futures	7235.25	7237.93	7235.25	7236.74	373.0
2017-10-11 00:00:00	YM	Futures	24797.0	24801.4	24792.7	24795.9	1165.0
2017-10-11 01:00:00	YM	Futures	24795.9	24797.0	24785.1	24788.3	936.0
2017-10-11 02:00:00	YM	Futures	24788.3	24790.5	24781.8	24785.1	796.0
2017-10-11 03:00:00	YM	Futures	24785.1	24786.1	24764.4	24768.7	1940.0

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

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