PREVIEW / futures_1hour / 2017-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-06.parquet
  size:    44 KB
  rows:    1,321

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-06 00:00:00	ES	Futures	2789.48	2790.02	2789.2	2789.75	1600.0
2017-10-06 01:00:00	ES	Futures	2789.75	2790.02	2789.2	2789.2	3093.0
2017-10-06 02:00:00	ES	Futures	2789.2	2790.02	2788.93	2789.48	4726.0
2017-10-06 03:00:00	ES	Futures	2789.48	2790.02	2788.93	2789.48	18998.0
2017-10-06 04:00:00	ES	Futures	2789.48	2789.75	2788.38	2788.66	11823.0
2017-10-06 05:00:00	ES	Futures	2788.66	2789.2	2788.11	2789.2	10430.0
2017-10-06 06:00:00	ES	Futures	2788.93	2789.48	2788.38	2789.2	8720.0
2017-10-06 07:00:00	ES	Futures	2788.93	2789.75	2788.38	2788.66	12117.0
2017-10-06 08:00:00	ES	Futures	2788.66	2788.93	2782.91	2782.91	77771.0
2017-10-06 09:00:00	ES	Futures	2783.19	2786.47	2782.91	2785.92	140677.0
2017-10-06 10:00:00	ES	Futures	2785.92	2787.56	2781.27	2782.64	186965.0
2017-10-06 11:00:00	ES	Futures	2782.64	2784.55	2781.0	2782.09	109001.0
2017-10-06 12:00:00	ES	Futures	2782.36	2784.55	2781.0	2783.19	111787.0
2017-10-06 13:00:00	ES	Futures	2783.19	2783.73	2781.54	2783.46	74456.0
2017-10-06 14:00:00	ES	Futures	2783.19	2785.92	2782.91	2785.65	62556.0
2017-10-06 15:00:00	ES	Futures	2785.65	2787.29	2784.01	2786.74	189541.0
2017-10-06 16:00:00	ES	Futures	2787.02	2787.56	2784.01	2784.55	88987.0
2017-10-06 00:00:00	NQ	Futures	7215.32	7218.3	7215.32	7216.81	383.0
2017-10-06 01:00:00	NQ	Futures	7216.81	7218.59	7215.62	7216.22	509.0
2017-10-06 02:00:00	NQ	Futures	7216.22	7219.78	7215.62	7219.19	1126.0
2017-10-06 03:00:00	NQ	Futures	7218.89	7219.19	7215.03	7217.7	2100.0
2017-10-06 04:00:00	NQ	Futures	7217.7	7218.3	7212.05	7213.54	2102.0
2017-10-06 05:00:00	NQ	Futures	7213.54	7220.68	7212.05	7220.38	2359.0
2017-10-06 06:00:00	NQ	Futures	7220.38	7223.06	7219.49	7220.08	1810.0
2017-10-06 07:00:00	NQ	Futures	7220.08	7221.87	7216.81	7217.11	1956.0
2017-10-06 08:00:00	NQ	Futures	7217.11	7217.11	7187.96	7189.75	17751.0
2017-10-06 09:00:00	NQ	Futures	7190.04	7207.89	7182.61	7203.13	43211.0
2017-10-06 10:00:00	NQ	Futures	7203.13	7213.54	7187.66	7194.5	41927.0
2017-10-06 11:00:00	NQ	Futures	7194.5	7208.48	7193.91	7207.0	22781.0
2017-10-06 12:00:00	NQ	Futures	7206.7	7219.49	7201.05	7212.94	26407.0
2017-10-06 13:00:00	NQ	Futures	7212.65	7214.43	7206.4	7211.75	15158.0
2017-10-06 14:00:00	NQ	Futures	7211.46	7215.32	7208.48	7212.35	11692.0
2017-10-06 15:00:00	NQ	Futures	7212.35	7220.08	7205.51	7218.3	25790.0
2017-10-06 16:00:00	NQ	Futures	7218.3	7220.38	7212.35	7216.51	7627.0
2017-10-06 00:00:00	YM	Futures	24720.9	24726.3	24720.9	24725.2	301.0
2017-10-06 01:00:00	YM	Futures	24725.2	24727.4	24723.1	24724.2	554.0
2017-10-06 02:00:00	YM	Futures	24724.2	24732.9	24722.0	24731.8	1034.0
2017-10-06 03:00:00	YM	Futures	24730.7	24732.9	24719.8	24725.2	1559.0
2017-10-06 04:00:00	YM	Futures	24724.2	24725.2	24716.5	24719.8	1018.0
2017-10-06 05:00:00	YM	Futures	24719.8	24722.0	24715.4	24722.0	872.0
2017-10-06 06:00:00	YM	Futures	24720.9	24725.2	24718.7	24723.1	546.0
2017-10-06 07:00:00	YM	Futures	24724.2	24727.4	24719.8	24724.2	959.0
2017-10-06 08:00:00	YM	Futures	24724.2	24724.2	24682.8	24683.9	6398.0
2017-10-06 09:00:00	YM	Futures	24685.0	24706.7	24677.4	24701.3	11932.0
2017-10-06 10:00:00	YM	Futures	24701.3	24713.3	24673.0	24687.2	11793.0
2017-10-06 11:00:00	YM	Futures	24687.2	24710.0	24674.1	24680.6	8231.0
2017-10-06 12:00:00	YM	Futures	24681.7	24699.1	24675.2	24686.1	6645.0
2017-10-06 13:00:00	YM	Futures	24687.2	24691.5	24668.7	24682.8	5810.0
2017-10-06 14:00:00	YM	Futures	24682.8	24710.0	24681.7	24706.7	4630.0
2017-10-06 15:00:00	YM	Futures	24705.7	24712.2	24693.7	24708.9	8151.0

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

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