PREVIEW / futures_1hour / 2020-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-31.parquet
  size:    18 KB
  rows:    367

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
2020-05-31 18:00:00	ES	Futures	3325.63	3331.12	3301.75	3315.47	43670.0
2020-05-31 19:00:00	ES	Futures	3315.2	3322.06	3309.44	3320.96	15231.0
2020-05-31 20:00:00	ES	Futures	3320.69	3337.98	3319.04	3331.94	29451.0
2020-05-31 21:00:00	ES	Futures	3331.94	3344.56	3326.18	3341.82	26647.0
2020-05-31 22:00:00	ES	Futures	3342.09	3345.66	3339.35	3343.46	10148.0
2020-05-31 23:00:00	ES	Futures	3343.74	3346.76	3331.12	3332.21	14872.0
2020-05-31 18:00:00	NQ	Futures	10869.2	10882.34	10797.5	10850.35	11373.0
2020-05-31 19:00:00	NQ	Futures	10848.92	10871.2	10830.64	10861.49	4192.0
2020-05-31 20:00:00	NQ	Futures	10862.34	10910.33	10861.77	10902.33	9412.0
2020-05-31 21:00:00	NQ	Futures	10902.33	10940.04	10883.77	10927.75	9371.0
2020-05-31 22:00:00	NQ	Futures	10927.75	10944.04	10919.47	10937.75	3657.0
2020-05-31 23:00:00	NQ	Futures	10937.75	10945.18	10900.9	10905.47	4933.0
2020-05-31 18:00:00	YM	Futures	27636.0	27707.2	27480.4	27597.6	7001.0
2020-05-31 19:00:00	YM	Futures	27597.6	27660.1	27549.4	27648.0	2514.0
2020-05-31 20:00:00	YM	Futures	27650.2	27807.9	27634.9	27754.3	5537.0
2020-05-31 21:00:00	YM	Futures	27755.3	27861.6	27708.2	27849.5	4957.0
2020-05-31 22:00:00	YM	Futures	27852.8	27880.2	27828.7	27862.7	1965.0
2020-05-31 23:00:00	YM	Futures	27863.8	27891.2	27756.4	27765.2	2523.0
2020-05-31 18:00:00	CL	Futures	24.5	24.98	24.18	24.75	10237.0
2020-05-31 19:00:00	CL	Futures	24.75	24.81	24.47	24.54	4710.0
2020-05-31 20:00:00	CL	Futures	24.54	24.55	24.32	24.39	6360.0
2020-05-31 21:00:00	CL	Futures	24.39	24.61	24.37	24.54	6966.0
2020-05-31 22:00:00	CL	Futures	24.54	24.73	24.48	24.72	4353.0
2020-05-31 23:00:00	CL	Futures	24.71	24.82	24.53	24.57	5282.0
2020-05-31 18:00:00	GC	Futures	2160.2	2171.0	2158.3	2166.0	5329.0
2020-05-31 19:00:00	GC	Futures	2166.0	2168.2	2165.6	2166.9	1044.0
2020-05-31 20:00:00	GC	Futures	2166.9	2167.1	2160.2	2161.4	3090.0
2020-05-31 21:00:00	GC	Futures	2161.3	2166.4	2156.9	2161.5	7310.0
2020-05-31 22:00:00	GC	Futures	2161.5	2165.0	2160.4	2163.4	3003.0
2020-05-31 23:00:00	GC	Futures	2163.4	2163.8	2161.4	2163.4	1396.0
2020-05-31 18:00:00	ZN	Futures	138.643087	138.720758	138.596484	138.658621	341.0
2020-05-31 19:00:00	ZN	Futures	138.674155	138.674155	138.627553	138.627553	810.0
2020-05-31 20:00:00	ZN	Futures	138.627553	138.643087	138.518813	138.518813	901.0
2020-05-31 21:00:00	ZN	Futures	138.534347	138.549881	138.47221	138.487745	324.0
2020-05-31 22:00:00	ZN	Futures	138.47221	138.503279	138.47221	138.503279	326.0
2020-05-31 23:00:00	ZN	Futures	138.518813	138.549881	138.518813	138.549881	174.0

> showing 36 of 367 rows — these rows as CSV

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