PREVIEW / futures_1hour / 2019-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-10.parquet
  size:    17 KB
  rows:    362

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-11-10 18:00:00	ES	Futures	3357.9	3359.8	3356.0	3356.0	7614.0
2019-11-10 19:00:00	ES	Futures	3356.0	3356.54	3353.83	3354.37	8536.0
2019-11-10 20:00:00	ES	Futures	3354.1	3354.1	3350.02	3351.11	15148.0
2019-11-10 21:00:00	ES	Futures	3350.84	3351.65	3348.4	3349.75	10680.0
2019-11-10 22:00:00	ES	Futures	3349.75	3350.84	3348.94	3349.75	6245.0
2019-11-10 23:00:00	ES	Futures	3349.75	3350.02	3349.21	3349.48	2796.0
2019-11-10 18:00:00	NQ	Futures	9594.67	9599.9	9587.99	9589.15	2188.0
2019-11-10 19:00:00	NQ	Futures	9588.57	9590.02	9579.56	9581.31	2783.0
2019-11-10 20:00:00	NQ	Futures	9581.31	9581.89	9566.78	9570.56	5468.0
2019-11-10 21:00:00	NQ	Futures	9570.56	9572.3	9563.3	9569.69	3485.0
2019-11-10 22:00:00	NQ	Futures	9569.69	9573.46	9566.2	9567.65	1868.0
2019-11-10 23:00:00	NQ	Futures	9567.65	9572.59	9567.65	9570.85	1128.0
2019-11-10 18:00:00	YM	Futures	30087.5	30088.6	30063.6	30064.6	1224.0
2019-11-10 19:00:00	YM	Futures	30063.6	30066.8	30037.4	30038.5	1488.0
2019-11-10 20:00:00	YM	Futures	30038.5	30039.6	29996.1	30008.1	2392.0
2019-11-10 21:00:00	YM	Futures	30008.1	30012.4	29983.0	29993.9	1769.0
2019-11-10 22:00:00	YM	Futures	29993.9	30012.4	29988.5	29992.8	1320.0
2019-11-10 23:00:00	YM	Futures	29993.9	29996.1	29987.4	29990.6	636.0
2019-11-10 18:00:00	CL	Futures	50.94	50.94	50.62	50.7	5577.0
2019-11-10 19:00:00	CL	Futures	50.7	50.72	50.63	50.65	2353.0
2019-11-10 20:00:00	CL	Futures	50.66	50.66	50.45	50.5	6852.0
2019-11-10 21:00:00	CL	Futures	50.5	50.5	50.41	50.46	3577.0
2019-11-10 22:00:00	CL	Futures	50.46	50.47	50.34	50.37	2805.0
2019-11-10 23:00:00	CL	Futures	50.37	50.41	50.34	50.37	1497.0
2019-11-10 18:00:00	GC	Futures	1849.6	1852.0	1849.0	1852.0	3177.0
2019-11-10 19:00:00	GC	Futures	1852.0	1852.9	1850.8	1852.8	3188.0
2019-11-10 20:00:00	GC	Futures	1852.8	1855.4	1852.7	1854.3	8449.0
2019-11-10 21:00:00	GC	Futures	1854.3	1855.1	1853.2	1854.1	5723.0
2019-11-10 22:00:00	GC	Futures	1854.1	1854.4	1852.4	1853.0	4426.0
2019-11-10 23:00:00	GC	Futures	1852.9	1853.9	1852.9	1853.9	2088.0
2019-11-10 18:00:00	ZN	Futures	128.325383	128.403554	128.294115	128.38792	14586.0
2019-11-10 19:00:00	ZN	Futures	128.403554	128.450457	128.372286	128.450457	8488.0
2019-11-10 20:00:00	ZN	Futures	128.466091	128.481725	128.434823	128.466091	10907.0
2019-11-10 21:00:00	ZN	Futures	128.466091	128.512994	128.450457	128.512994	17344.0
2019-11-10 22:00:00	ZN	Futures	128.512994	128.512994	128.466091	128.481725	5457.0
2019-11-10 23:00:00	ZN	Futures	128.481725	128.512994	128.481725	128.481725	5939.0

> showing 36 of 362 rows — these rows as CSV

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