PREVIEW / futures_1hour / 2019-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-13.parquet
  size:    17 KB
  rows:    347

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
2019-01-13 18:00:00	ES	Futures	2811.99	2815.79	2806.01	2806.28	16150.0
2019-01-13 19:00:00	ES	Futures	2806.55	2808.73	2805.2	2807.37	7892.0
2019-01-13 20:00:00	ES	Futures	2807.1	2808.18	2795.69	2798.14	15324.0
2019-01-13 21:00:00	ES	Futures	2798.14	2798.68	2794.61	2797.05	9736.0
2019-01-13 22:00:00	ES	Futures	2797.32	2797.59	2793.79	2797.32	5975.0
2019-01-13 23:00:00	ES	Futures	2797.32	2799.22	2796.78	2797.86	3326.0
2019-01-13 18:00:00	NQ	Futures	7712.63	7716.72	7688.09	7688.96	4090.0
2019-01-13 19:00:00	NQ	Futures	7688.96	7694.51	7685.75	7692.18	2590.0
2019-01-13 20:00:00	NQ	Futures	7691.59	7695.68	7651.56	7658.28	6236.0
2019-01-13 21:00:00	NQ	Futures	7658.57	7659.74	7648.64	7655.65	4762.0
2019-01-13 22:00:00	NQ	Futures	7655.65	7656.24	7645.72	7653.61	3369.0
2019-01-13 23:00:00	NQ	Futures	7653.61	7658.28	7652.44	7655.36	1743.0
2019-01-13 18:00:00	YM	Futures	25969.0	25969.0	25891.9	25894.1	2585.0
2019-01-13 19:00:00	YM	Futures	25891.9	25918.0	25884.3	25903.9	2042.0
2019-01-13 20:00:00	YM	Futures	25901.7	25912.6	25802.9	25822.4	3292.0
2019-01-13 21:00:00	YM	Futures	25822.4	25824.6	25787.7	25810.5	2671.0
2019-01-13 22:00:00	YM	Futures	25810.5	25810.5	25774.7	25806.2	1961.0
2019-01-13 23:00:00	YM	Futures	25805.1	25819.2	25797.5	25806.2	1154.0
2019-01-13 18:00:00	CL	Futures	47.22	47.56	47.21	47.32	5878.0
2019-01-13 19:00:00	CL	Futures	47.31	47.42	47.21	47.34	4956.0
2019-01-13 20:00:00	CL	Futures	47.33	47.33	47.0	47.03	11266.0
2019-01-13 21:00:00	CL	Futures	47.03	47.03	46.8	46.82	10863.0
2019-01-13 22:00:00	CL	Futures	46.82	46.82	46.41	46.65	16857.0
2019-01-13 23:00:00	CL	Futures	46.66	46.69	46.56	46.61	5138.0
2019-01-13 18:00:00	GC	Futures	1668.5	1669.8	1668.1	1669.2	1994.0
2019-01-13 19:00:00	GC	Futures	1669.2	1671.1	1668.8	1670.3	3337.0
2019-01-13 20:00:00	GC	Futures	1670.3	1675.0	1669.8	1674.4	10043.0
2019-01-13 21:00:00	GC	Futures	1674.5	1674.7	1671.6	1671.8	6591.0
2019-01-13 22:00:00	GC	Futures	1671.8	1673.5	1671.6	1672.7	4623.0
2019-01-13 23:00:00	GC	Futures	1672.7	1673.1	1671.6	1672.0	1860.0
2019-01-13 18:00:00	ZN	Futures	122.824688	122.934873	122.808947	122.934873	6465.0
2019-01-13 19:00:00	ZN	Futures	122.919132	122.950613	122.887651	122.934873	5774.0
2019-01-13 20:00:00	ZN	Futures	122.934873	123.10802	122.919132	123.076539	26058.0
2019-01-13 21:00:00	ZN	Futures	123.076539	123.09228	123.045058	123.076539	10767.0
2019-01-13 22:00:00	ZN	Futures	123.076539	123.155242	123.076539	123.10802	8414.0
2019-01-13 23:00:00	ZN	Futures	123.10802	123.123761	123.10802	123.10802	1800.0

> showing 36 of 347 rows — these rows as CSV

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