PREVIEW / futures_1hour / 2019-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-29.parquet
  size:    17 KB
  rows:    366

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-12-29 18:00:00	ES	Futures	3510.1	3513.7	3509.9	3512.8	7771.0
2019-12-29 19:00:00	ES	Futures	3513.1	3514.5	3511.5	3513.4	11349.0
2019-12-29 20:00:00	ES	Futures	3513.4	3515.8	3512.8	3515.6	5076.0
2019-12-29 21:00:00	ES	Futures	3515.6	3515.8	3514.7	3515.3	3805.0
2019-12-29 22:00:00	ES	Futures	3515.6	3516.6	3515.3	3516.1	3342.0
2019-12-29 23:00:00	ES	Futures	3515.8	3516.4	3515.3	3516.1	2429.0
2019-12-29 18:00:00	NQ	Futures	10159.81	10178.32	10159.24	10176.3	4825.0
2019-12-29 19:00:00	NQ	Futures	10176.3	10180.92	10171.38	10175.72	5359.0
2019-12-29 20:00:00	NQ	Futures	10175.72	10184.1	10174.56	10183.24	2673.0
2019-12-29 21:00:00	NQ	Futures	10183.24	10184.39	10181.5	10184.39	1614.0
2019-12-29 22:00:00	NQ	Futures	10184.1	10190.18	10183.82	10187.57	2335.0
2019-12-29 23:00:00	NQ	Futures	10187.57	10189.89	10184.68	10189.31	1372.0
2019-12-29 18:00:00	YM	Futures	31157.6	31188.1	31157.6	31183.8	1463.0
2019-12-29 19:00:00	YM	Futures	31183.8	31190.3	31164.2	31177.2	2197.0
2019-12-29 20:00:00	YM	Futures	31177.2	31196.8	31174.0	31194.6	1400.0
2019-12-29 21:00:00	YM	Futures	31195.7	31195.7	31188.1	31192.5	981.0
2019-12-29 22:00:00	YM	Futures	31192.5	31201.2	31192.5	31195.7	740.0
2019-12-29 23:00:00	YM	Futures	31194.6	31195.7	31187.0	31193.6	522.0
2019-12-29 18:00:00	CL	Futures	54.68	54.71	54.62	54.69	1959.0
2019-12-29 19:00:00	CL	Futures	54.69	54.7	54.63	54.64	1608.0
2019-12-29 20:00:00	CL	Futures	54.64	54.69	54.63	54.68	2461.0
2019-12-29 21:00:00	CL	Futures	54.68	54.72	54.68	54.72	1483.0
2019-12-29 22:00:00	CL	Futures	54.71	54.75	54.7	54.73	2189.0
2019-12-29 23:00:00	CL	Futures	54.74	54.75	54.72	54.74	1029.0
2019-12-29 18:00:00	GC	Futures	1911.3	1913.3	1910.5	1912.7	4232.0
2019-12-29 19:00:00	GC	Futures	1912.7	1913.7	1911.7	1911.9	3489.0
2019-12-29 20:00:00	GC	Futures	1912.0	1914.3	1912.0	1913.2	5881.0
2019-12-29 21:00:00	GC	Futures	1913.2	1914.6	1912.3	1914.2	4343.0
2019-12-29 22:00:00	GC	Futures	1914.2	1915.3	1913.7	1914.3	4235.0
2019-12-29 23:00:00	GC	Futures	1914.3	1914.4	1913.4	1913.7	1980.0
2019-12-29 18:00:00	ZN	Futures	128.762974	128.825549	128.762974	128.809905	5403.0
2019-12-29 19:00:00	ZN	Futures	128.809905	128.841192	128.731687	128.747331	11135.0
2019-12-29 20:00:00	ZN	Futures	128.747331	128.794262	128.747331	128.794262	5792.0
2019-12-29 21:00:00	ZN	Futures	128.794262	128.809905	128.762974	128.794262	5974.0
2019-12-29 22:00:00	ZN	Futures	128.794262	128.825549	128.794262	128.809905	5748.0
2019-12-29 23:00:00	ZN	Futures	128.794262	128.825549	128.794262	128.794262	6300.0

> showing 36 of 366 rows — these rows as CSV

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