PREVIEW / futures_1hour / 2017-10-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	2770.88	2771.15	2770.05	2770.05	3345.0
2017-10-04 01:00:00	ES	Futures	2770.05	2770.33	2769.51	2770.05	4273.0
2017-10-04 02:00:00	ES	Futures	2770.33	2770.88	2769.78	2770.6	4844.0
2017-10-04 03:00:00	ES	Futures	2770.6	2770.6	2769.51	2769.51	15364.0
2017-10-04 04:00:00	ES	Futures	2769.51	2770.6	2769.51	2769.78	10157.0
2017-10-04 05:00:00	ES	Futures	2769.78	2770.33	2769.23	2769.78	8225.0
2017-10-04 06:00:00	ES	Futures	2769.51	2770.05	2768.41	2769.23	9502.0
2017-10-04 07:00:00	ES	Futures	2769.23	2770.05	2768.41	2769.51	11223.0
2017-10-04 08:00:00	ES	Futures	2769.51	2769.51	2767.87	2768.41	15204.0
2017-10-04 09:00:00	ES	Futures	2768.14	2771.15	2767.32	2770.33	133119.0
2017-10-04 10:00:00	ES	Futures	2770.05	2771.15	2768.69	2771.15	119860.0
2017-10-04 11:00:00	ES	Futures	2771.15	2775.53	2770.88	2775.25	115190.0
2017-10-04 12:00:00	ES	Futures	2775.25	2777.17	2774.16	2774.98	112824.0
2017-10-04 13:00:00	ES	Futures	2774.98	2775.8	2771.42	2773.34	102749.0
2017-10-04 14:00:00	ES	Futures	2773.06	2774.43	2772.24	2773.88	58830.0
2017-10-04 15:00:00	ES	Futures	2773.88	2775.25	2771.97	2774.43	121015.0
2017-10-04 16:00:00	ES	Futures	2774.16	2775.53	2773.61	2774.7	72347.0
2017-10-04 18:00:00	ES	Futures	2774.16	2774.98	2773.61	2774.7	2872.0
2017-10-04 19:00:00	ES	Futures	2774.7	2774.7	2773.61	2774.43	1573.0
2017-10-04 20:00:00	ES	Futures	2774.43	2774.43	2773.34	2773.61	4559.0
2017-10-04 21:00:00	ES	Futures	2773.61	2774.7	2773.34	2774.43	2143.0
2017-10-04 22:00:00	ES	Futures	2774.7	2775.53	2774.43	2775.25	1716.0
2017-10-04 23:00:00	ES	Futures	2775.25	2775.53	2774.98	2775.25	921.0
2017-10-04 00:00:00	NQ	Futures	7133.53	7133.83	7132.34	7133.24	394.0
2017-10-04 01:00:00	NQ	Futures	7133.24	7134.13	7130.86	7132.05	654.0
2017-10-04 02:00:00	NQ	Futures	7132.05	7134.72	7131.45	7134.43	640.0
2017-10-04 03:00:00	NQ	Futures	7134.13	7134.43	7130.26	7132.64	1416.0
2017-10-04 04:00:00	NQ	Futures	7132.34	7133.24	7131.15	7131.15	794.0
2017-10-04 05:00:00	NQ	Futures	7131.45	7132.05	7126.69	7126.99	1253.0
2017-10-04 06:00:00	NQ	Futures	7127.29	7129.96	7123.42	7126.99	1334.0
2017-10-04 07:00:00	NQ	Futures	7126.69	7130.56	7123.72	7125.8	2235.0
2017-10-04 08:00:00	NQ	Futures	7125.8	7126.69	7118.96	7121.34	4866.0
2017-10-04 09:00:00	NQ	Futures	7121.34	7134.13	7113.61	7126.99	44771.0
2017-10-04 10:00:00	NQ	Futures	7126.99	7132.34	7115.09	7126.69	39108.0
2017-10-04 11:00:00	NQ	Futures	7126.69	7145.13	7126.69	7140.97	31204.0
2017-10-04 12:00:00	NQ	Futures	7140.97	7156.43	7139.18	7144.24	27232.0
2017-10-04 13:00:00	NQ	Futures	7144.54	7146.02	7120.74	7131.75	27847.0
2017-10-04 14:00:00	NQ	Futures	7131.45	7140.97	7130.56	7139.78	17334.0
2017-10-04 15:00:00	NQ	Futures	7139.78	7144.24	7136.21	7141.56	22494.0
2017-10-04 16:00:00	NQ	Futures	7141.56	7145.43	7139.48	7143.94	4997.0
2017-10-04 18:00:00	NQ	Futures	7143.94	7144.84	7141.27	7143.94	775.0
2017-10-04 19:00:00	NQ	Futures	7143.94	7144.54	7141.27	7143.65	429.0
2017-10-04 20:00:00	NQ	Futures	7143.94	7144.24	7139.18	7139.78	880.0
2017-10-04 21:00:00	NQ	Futures	7139.48	7143.05	7139.18	7142.46	431.0
2017-10-04 22:00:00	NQ	Futures	7142.75	7146.92	7142.75	7146.32	697.0
2017-10-04 23:00:00	NQ	Futures	7146.02	7146.62	7143.94	7144.24	355.0
2017-10-04 00:00:00	YM	Futures	24592.5	24593.6	24588.2	24588.2	482.0
2017-10-04 01:00:00	YM	Futures	24588.2	24590.4	24580.6	24589.3	717.0
2017-10-04 02:00:00	YM	Futures	24589.3	24590.4	24583.8	24588.2	761.0
2017-10-04 03:00:00	YM	Futures	24587.1	24590.4	24579.5	24584.9	1570.0

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

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