PREVIEW / futures_1hour / 2019-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-29.parquet
  size:    16 KB
  rows:    344

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-09-29 18:00:00	ES	Futures	3233.5	3238.11	3222.09	3223.99	14895.0
2019-09-29 19:00:00	ES	Futures	3224.26	3228.61	3224.26	3228.06	5396.0
2019-09-29 20:00:00	ES	Futures	3227.79	3229.69	3226.43	3228.06	8144.0
2019-09-29 21:00:00	ES	Futures	3228.06	3234.58	3227.79	3232.41	13443.0
2019-09-29 22:00:00	ES	Futures	3232.41	3235.94	3231.59	3234.04	8467.0
2019-09-29 23:00:00	ES	Futures	3234.31	3235.12	3232.95	3234.31	3632.0
2019-09-29 18:00:00	NQ	Futures	8988.41	9015.72	8953.84	8962.27	8011.0
2019-09-29 19:00:00	NQ	Futures	8962.27	8977.08	8962.27	8975.05	2914.0
2019-09-29 20:00:00	NQ	Futures	8975.34	8978.54	8968.37	8970.69	3756.0
2019-09-29 21:00:00	NQ	Futures	8970.4	8998.87	8970.4	8990.74	6469.0
2019-09-29 22:00:00	NQ	Futures	8991.03	9004.1	8988.7	8998.58	3625.0
2019-09-29 23:00:00	NQ	Futures	8998.58	9000.9	8993.35	8998.29	2068.0
2019-09-29 18:00:00	YM	Futures	29274.5	29320.2	29190.7	29209.2	3190.0
2019-09-29 19:00:00	YM	Futures	29209.2	29236.4	29208.1	29233.1	1021.0
2019-09-29 20:00:00	YM	Futures	29231.0	29247.3	29215.7	29232.1	1899.0
2019-09-29 21:00:00	YM	Futures	29229.9	29287.6	29229.9	29268.0	3126.0
2019-09-29 22:00:00	YM	Futures	29268.0	29296.3	29262.5	29279.9	1921.0
2019-09-29 23:00:00	YM	Futures	29281.0	29286.5	29268.0	29281.0	1004.0
2019-09-29 18:00:00	CL	Futures	50.23	50.26	49.8	49.86	4796.0
2019-09-29 19:00:00	CL	Futures	49.86	49.91	49.74	49.8	2189.0
2019-09-29 20:00:00	CL	Futures	49.8	49.86	49.77	49.79	1765.0
2019-09-29 21:00:00	CL	Futures	49.78	49.83	49.7	49.8	5711.0
2019-09-29 22:00:00	CL	Futures	49.8	49.88	49.78	49.78	3281.0
2019-09-29 23:00:00	CL	Futures	49.79	49.85	49.76	49.79	2343.0
2019-09-29 18:00:00	GC	Futures	1902.4	1909.4	1901.7	1906.2	4942.0
2019-09-29 19:00:00	GC	Futures	1906.1	1906.6	1903.7	1903.8	2059.0
2019-09-29 20:00:00	GC	Futures	1903.8	1905.1	1902.6	1904.5	4250.0
2019-09-29 21:00:00	GC	Futures	1904.5	1904.9	1899.4	1900.3	11873.0
2019-09-29 22:00:00	GC	Futures	1900.2	1900.7	1897.1	1898.4	7672.0
2019-09-29 23:00:00	GC	Futures	1898.3	1899.2	1897.1	1898.3	3724.0
2019-09-29 18:00:00	ZN	Futures	130.295291	130.467267	130.201485	130.435998	9345.0
2019-09-29 19:00:00	ZN	Futures	130.420364	130.420364	130.342193	130.357827	4706.0
2019-09-29 20:00:00	ZN	Futures	130.357827	130.420364	130.342193	130.373461	9587.0
2019-09-29 21:00:00	ZN	Futures	130.357827	130.373461	130.279656	130.326559	15711.0
2019-09-29 22:00:00	ZN	Futures	130.326559	130.357827	130.295291	130.310925	10249.0
2019-09-29 23:00:00	ZN	Futures	130.310925	130.342193	130.295291	130.326559	4289.0

> showing 36 of 344 rows — these rows as CSV

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