PREVIEW / futures_1hour / 2017-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-02.parquet
  size:    52 KB
  rows:    1,623

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-08-02 00:00:00	ES	Futures	2705.79	2706.33	2705.51	2705.79	2175.0
2017-08-02 01:00:00	ES	Futures	2705.79	2706.61	2705.51	2705.51	2779.0
2017-08-02 02:00:00	ES	Futures	2705.79	2706.33	2705.51	2706.33	3765.0
2017-08-02 03:00:00	ES	Futures	2706.06	2706.33	2704.15	2705.51	23018.0
2017-08-02 04:00:00	ES	Futures	2705.51	2705.79	2703.87	2704.42	15218.0
2017-08-02 05:00:00	ES	Futures	2704.42	2705.51	2704.15	2705.24	11515.0
2017-08-02 06:00:00	ES	Futures	2705.24	2707.15	2704.15	2704.15	16877.0
2017-08-02 07:00:00	ES	Futures	2704.15	2704.15	2703.05	2703.87	12852.0
2017-08-02 08:00:00	ES	Futures	2704.15	2706.33	2703.87	2705.79	18645.0
2017-08-02 09:00:00	ES	Futures	2706.06	2706.88	2701.69	2702.23	147777.0
2017-08-02 10:00:00	ES	Futures	2702.51	2705.51	2693.21	2694.3	303617.0
2017-08-02 11:00:00	ES	Futures	2694.58	2700.32	2693.48	2698.13	179505.0
2017-08-02 12:00:00	ES	Futures	2698.4	2698.68	2695.94	2697.04	89918.0
2017-08-02 13:00:00	ES	Futures	2697.04	2702.51	2695.94	2702.23	117833.0
2017-08-02 14:00:00	ES	Futures	2701.96	2704.97	2701.14	2703.87	100219.0
2017-08-02 15:00:00	ES	Futures	2704.15	2705.79	2701.69	2704.97	160823.0
2017-08-02 16:00:00	ES	Futures	2704.97	2705.79	2703.6	2704.42	64054.0
2017-08-02 18:00:00	ES	Futures	2704.15	2704.69	2703.6	2704.15	3398.0
2017-08-02 19:00:00	ES	Futures	2703.87	2704.15	2702.51	2703.05	2100.0
2017-08-02 20:00:00	ES	Futures	2703.05	2703.33	2701.14	2702.51	5461.0
2017-08-02 21:00:00	ES	Futures	2702.51	2702.78	2701.14	2701.41	4422.0
2017-08-02 22:00:00	ES	Futures	2701.41	2702.78	2700.59	2702.51	4377.0
2017-08-02 23:00:00	ES	Futures	2702.23	2703.33	2702.23	2702.78	2758.0
2017-08-02 00:00:00	NQ	Futures	7066.23	7079.04	7065.93	7077.84	2573.0
2017-08-02 01:00:00	NQ	Futures	7078.14	7083.5	7076.95	7080.52	1877.0
2017-08-02 02:00:00	NQ	Futures	7080.52	7081.12	7075.46	7076.95	1246.0
2017-08-02 03:00:00	NQ	Futures	7077.25	7077.55	7062.66	7071.0	3701.0
2017-08-02 04:00:00	NQ	Futures	7070.7	7071.0	7063.85	7068.61	2112.0
2017-08-02 05:00:00	NQ	Futures	7068.91	7071.89	7067.13	7069.21	1375.0
2017-08-02 06:00:00	NQ	Futures	7069.21	7077.25	7064.74	7064.74	8186.0
2017-08-02 07:00:00	NQ	Futures	7065.04	7067.42	7057.0	7061.17	3139.0
2017-08-02 08:00:00	NQ	Futures	7061.17	7069.51	7060.87	7067.72	4509.0
2017-08-02 09:00:00	NQ	Futures	7067.72	7069.81	7034.08	7037.65	55780.0
2017-08-02 10:00:00	NQ	Futures	7038.24	7050.45	6979.59	6986.73	97790.0
2017-08-02 11:00:00	NQ	Futures	6986.73	7009.96	6974.82	7002.81	54645.0
2017-08-02 12:00:00	NQ	Futures	7003.11	7009.66	6994.47	7000.73	23607.0
2017-08-02 13:00:00	NQ	Futures	7000.73	7038.24	6990.6	7034.67	38760.0
2017-08-02 14:00:00	NQ	Futures	7034.37	7048.67	7029.01	7045.99	30943.0
2017-08-02 15:00:00	NQ	Futures	7045.39	7054.32	7029.91	7040.92	40210.0
2017-08-02 16:00:00	NQ	Futures	7040.63	7045.99	7034.67	7044.79	6928.0
2017-08-02 18:00:00	NQ	Futures	7040.33	7045.39	7040.33	7043.9	624.0
2017-08-02 19:00:00	NQ	Futures	7043.31	7044.5	7035.27	7038.84	730.0
2017-08-02 20:00:00	NQ	Futures	7038.84	7038.84	7027.23	7032.29	1943.0
2017-08-02 21:00:00	NQ	Futures	7032.59	7034.97	7022.76	7024.55	2042.0
2017-08-02 22:00:00	NQ	Futures	7024.85	7037.95	7021.87	7035.27	2032.0
2017-08-02 23:00:00	NQ	Futures	7034.97	7045.99	7034.67	7040.03	1703.0
2017-08-02 00:00:00	YM	Futures	23899.8	23902.0	23888.9	23890.0	666.0
2017-08-02 01:00:00	YM	Futures	23891.1	23894.4	23886.7	23887.8	667.0
2017-08-02 02:00:00	YM	Futures	23886.7	23892.2	23884.6	23888.9	760.0
2017-08-02 03:00:00	YM	Futures	23888.9	23893.3	23876.9	23888.9	2267.0

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

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