PREVIEW / futures_1hour / 2017-10-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2774.98	2775.53	2774.98	2774.98	1101.0
2017-10-05 01:00:00	ES	Futures	2775.25	2775.53	2773.34	2773.88	5796.0
2017-10-05 02:00:00	ES	Futures	2773.88	2774.43	2773.34	2773.88	5614.0
2017-10-05 03:00:00	ES	Futures	2773.88	2775.53	2773.88	2775.25	13655.0
2017-10-05 04:00:00	ES	Futures	2774.98	2776.07	2774.98	2775.8	8169.0
2017-10-05 05:00:00	ES	Futures	2775.53	2775.8	2774.43	2775.25	8459.0
2017-10-05 06:00:00	ES	Futures	2774.98	2775.8	2774.98	2775.53	6878.0
2017-10-05 07:00:00	ES	Futures	2775.8	2776.89	2775.25	2776.89	7530.0
2017-10-05 08:00:00	ES	Futures	2776.62	2779.08	2776.35	2777.17	24974.0
2017-10-05 09:00:00	ES	Futures	2777.17	2780.45	2776.35	2778.26	139104.0
2017-10-05 10:00:00	ES	Futures	2778.53	2781.27	2778.26	2780.45	117872.0
2017-10-05 11:00:00	ES	Futures	2780.45	2785.65	2779.9	2785.65	116813.0
2017-10-05 12:00:00	ES	Futures	2785.37	2789.48	2785.37	2787.29	149635.0
2017-10-05 13:00:00	ES	Futures	2787.29	2789.48	2787.02	2788.38	101837.0
2017-10-05 14:00:00	ES	Futures	2788.38	2789.48	2787.29	2788.93	70136.0
2017-10-05 15:00:00	ES	Futures	2789.2	2790.3	2787.84	2790.02	187859.0
2017-10-05 16:00:00	ES	Futures	2789.75	2791.12	2788.93	2789.2	104693.0
2017-10-05 18:00:00	ES	Futures	2788.93	2789.48	2788.38	2789.2	3682.0
2017-10-05 19:00:00	ES	Futures	2788.93	2789.48	2788.66	2788.93	2011.0
2017-10-05 20:00:00	ES	Futures	2788.93	2789.75	2788.93	2789.75	5435.0
2017-10-05 21:00:00	ES	Futures	2789.75	2789.75	2789.2	2789.48	3637.0
2017-10-05 22:00:00	ES	Futures	2789.48	2790.02	2789.2	2789.48	3862.0
2017-10-05 23:00:00	ES	Futures	2789.75	2790.02	2789.2	2789.48	2258.0
2017-10-05 00:00:00	NQ	Futures	7144.24	7145.73	7143.35	7144.24	358.0
2017-10-05 01:00:00	NQ	Futures	7144.24	7144.84	7140.97	7142.46	563.0
2017-10-05 02:00:00	NQ	Futures	7141.86	7143.94	7140.97	7142.16	570.0
2017-10-05 03:00:00	NQ	Futures	7142.16	7146.92	7141.27	7145.13	1298.0
2017-10-05 04:00:00	NQ	Futures	7145.13	7148.11	7144.24	7146.32	1120.0
2017-10-05 05:00:00	NQ	Futures	7146.02	7146.92	7143.65	7146.32	846.0
2017-10-05 06:00:00	NQ	Futures	7146.32	7148.11	7146.32	7147.81	648.0
2017-10-05 07:00:00	NQ	Futures	7147.81	7158.81	7146.92	7158.52	2741.0
2017-10-05 08:00:00	NQ	Futures	7158.52	7172.49	7157.62	7165.95	11076.0
2017-10-05 09:00:00	NQ	Futures	7165.95	7186.18	7160.9	7163.87	47384.0
2017-10-05 10:00:00	NQ	Futures	7164.46	7176.06	7158.81	7163.28	35934.0
2017-10-05 11:00:00	NQ	Futures	7163.57	7180.53	7160.0	7175.77	27932.0
2017-10-05 12:00:00	NQ	Futures	7175.47	7196.29	7175.17	7190.93	29160.0
2017-10-05 13:00:00	NQ	Futures	7190.64	7200.45	7189.45	7198.07	20666.0
2017-10-05 14:00:00	NQ	Futures	7198.07	7208.78	7193.02	7207.59	19683.0
2017-10-05 15:00:00	NQ	Futures	7207.59	7215.03	7204.02	7210.86	40149.0
2017-10-05 16:00:00	NQ	Futures	7210.86	7218.89	7208.18	7212.35	8595.0
2017-10-05 18:00:00	NQ	Futures	7212.05	7213.84	7209.67	7213.84	927.0
2017-10-05 19:00:00	NQ	Futures	7213.54	7214.43	7212.35	7213.54	674.0
2017-10-05 20:00:00	NQ	Futures	7213.54	7216.51	7212.65	7215.03	1089.0
2017-10-05 21:00:00	NQ	Futures	7214.73	7216.51	7213.24	7215.92	1138.0
2017-10-05 22:00:00	NQ	Futures	7216.22	7220.97	7215.92	7218.0	1272.0
2017-10-05 23:00:00	NQ	Futures	7218.0	7218.89	7215.03	7215.62	752.0
2017-10-05 00:00:00	YM	Futures	24590.4	24594.7	24590.4	24591.5	294.0
2017-10-05 01:00:00	YM	Futures	24591.5	24591.5	24581.7	24588.2	775.0
2017-10-05 02:00:00	YM	Futures	24587.1	24590.4	24584.9	24589.3	415.0
2017-10-05 03:00:00	YM	Futures	24588.2	24595.8	24584.9	24592.5	977.0

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

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