PREVIEW / futures_1hour / 2019-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-07.parquet
  size:    17 KB
  rows:    353

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-07-07 18:00:00	ES	Futures	3238.44	3242.78	3238.17	3239.8	5986.0
2019-07-07 19:00:00	ES	Futures	3240.07	3240.34	3236.01	3236.28	4794.0
2019-07-07 20:00:00	ES	Futures	3236.55	3237.09	3233.57	3235.47	12125.0
2019-07-07 21:00:00	ES	Futures	3235.47	3236.82	3232.49	3233.57	11008.0
2019-07-07 22:00:00	ES	Futures	3233.3	3234.65	3231.14	3232.22	9649.0
2019-07-07 23:00:00	ES	Futures	3231.95	3234.11	3231.14	3231.95	8376.0
2019-07-07 18:00:00	NQ	Futures	9116.28	9126.14	9112.5	9115.4	2463.0
2019-07-07 19:00:00	NQ	Futures	9115.4	9118.6	9101.77	9102.06	1813.0
2019-07-07 20:00:00	NQ	Futures	9102.35	9104.67	9093.35	9099.74	4098.0
2019-07-07 21:00:00	NQ	Futures	9099.74	9105.83	9088.42	9090.45	4564.0
2019-07-07 22:00:00	NQ	Futures	9090.74	9094.8	9083.49	9086.39	3817.0
2019-07-07 23:00:00	NQ	Futures	9086.1	9093.35	9084.94	9086.39	2698.0
2019-07-07 18:00:00	YM	Futures	29242.9	29279.9	29240.7	29247.2	1349.0
2019-07-07 19:00:00	YM	Futures	29247.2	29253.8	29213.5	29215.7	928.0
2019-07-07 20:00:00	YM	Futures	29215.7	29217.9	29190.7	29205.9	2495.0
2019-07-07 21:00:00	YM	Futures	29207.0	29221.1	29180.9	29186.3	2549.0
2019-07-07 22:00:00	YM	Futures	29187.4	29202.6	29168.9	29176.5	2292.0
2019-07-07 23:00:00	YM	Futures	29175.5	29195.0	29174.4	29177.6	2279.0
2019-07-07 18:00:00	CL	Futures	51.26	51.34	51.12	51.23	4149.0
2019-07-07 19:00:00	CL	Futures	51.23	51.27	51.14	51.16	2049.0
2019-07-07 20:00:00	CL	Futures	51.15	51.22	51.08	51.18	3964.0
2019-07-07 21:00:00	CL	Futures	51.17	51.2	51.07	51.15	9716.0
2019-07-07 22:00:00	CL	Futures	51.15	51.24	51.03	51.08	8860.0
2019-07-07 23:00:00	CL	Futures	51.07	51.13	51.06	51.1	3228.0
2019-07-07 18:00:00	GC	Futures	1791.0	1794.9	1783.4	1787.1	6733.0
2019-07-07 19:00:00	GC	Futures	1787.1	1789.1	1785.7	1787.1	4669.0
2019-07-07 20:00:00	GC	Futures	1787.1	1793.0	1786.6	1789.8	6935.0
2019-07-07 21:00:00	GC	Futures	1789.9	1791.6	1786.8	1791.3	11907.0
2019-07-07 22:00:00	GC	Futures	1791.3	1792.1	1789.3	1789.8	6421.0
2019-07-07 23:00:00	GC	Futures	1789.9	1791.8	1789.8	1790.9	5226.0
2019-07-07 18:00:00	ZN	Futures	128.245636	128.277077	128.229916	128.261356	17756.0
2019-07-07 19:00:00	ZN	Futures	128.261356	128.292797	128.229916	128.261356	12113.0
2019-07-07 20:00:00	ZN	Futures	128.261356	128.387118	128.261356	128.371398	22579.0
2019-07-07 21:00:00	ZN	Futures	128.371398	128.449999	128.355678	128.418559	29798.0
2019-07-07 22:00:00	ZN	Futures	128.418559	128.449999	128.402839	128.418559	9399.0
2019-07-07 23:00:00	ZN	Futures	128.418559	128.465719	128.418559	128.449999	6883.0

> showing 36 of 353 rows — these rows as CSV

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