PREVIEW / futures_1hour / 2019-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-05.parquet
  size:    18 KB
  rows:    376

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-05-05 18:00:00	ES	Futures	3164.03	3164.03	3137.74	3154.55	91989.0
2019-05-05 19:00:00	ES	Futures	3154.55	3154.55	3136.92	3139.64	45588.0
2019-05-05 20:00:00	ES	Futures	3139.64	3145.33	3130.96	3131.77	59737.0
2019-05-05 21:00:00	ES	Futures	3131.77	3138.82	3126.89	3138.28	46698.0
2019-05-05 22:00:00	ES	Futures	3138.01	3140.45	3133.67	3134.76	21535.0
2019-05-05 23:00:00	ES	Futures	3135.03	3138.01	3128.79	3130.15	16903.0
2019-05-05 18:00:00	NQ	Futures	9095.72	9095.72	8966.44	9024.38	21476.0
2019-05-05 19:00:00	NQ	Futures	9024.67	9027.0	8967.02	8975.18	11226.0
2019-05-05 20:00:00	NQ	Futures	8974.89	8989.73	8941.98	8945.77	20357.0
2019-05-05 21:00:00	NQ	Futures	8946.35	8961.49	8929.76	8960.04	14575.0
2019-05-05 22:00:00	NQ	Futures	8959.75	8970.81	8948.97	8954.21	7209.0
2019-05-05 23:00:00	NQ	Futures	8955.09	8966.44	8939.07	8945.19	6762.0
2019-05-05 18:00:00	YM	Futures	28588.2	28588.2	28282.6	28444.7	14030.0
2019-05-05 19:00:00	YM	Futures	28444.7	28452.3	28290.2	28315.2	5630.0
2019-05-05 20:00:00	YM	Futures	28316.3	28366.4	28244.5	28251.1	11058.0
2019-05-05 21:00:00	YM	Futures	28250.0	28307.6	28205.4	28294.6	8379.0
2019-05-05 22:00:00	YM	Futures	28293.5	28309.8	28252.2	28261.9	3908.0
2019-05-05 23:00:00	YM	Futures	28263.0	28291.3	28214.1	28227.1	3057.0
2019-05-05 18:00:00	CL	Futures	54.92	54.94	53.94	54.3	16070.0
2019-05-05 19:00:00	CL	Futures	54.3	54.34	54.06	54.09	8951.0
2019-05-05 20:00:00	CL	Futures	54.09	54.21	53.79	53.84	20032.0
2019-05-05 21:00:00	CL	Futures	53.84	54.16	53.68	54.15	24926.0
2019-05-05 22:00:00	CL	Futures	54.14	54.15	53.96	54.13	11758.0
2019-05-05 23:00:00	CL	Futures	54.12	54.21	54.0	54.02	6528.0
2019-05-05 18:00:00	GC	Futures	1644.9	1652.1	1644.9	1648.6	10705.0
2019-05-05 19:00:00	GC	Futures	1648.5	1650.4	1646.6	1649.9	6398.0
2019-05-05 20:00:00	GC	Futures	1649.9	1651.3	1648.0	1649.9	10815.0
2019-05-05 21:00:00	GC	Futures	1649.9	1650.0	1646.6	1647.7	14562.0
2019-05-05 22:00:00	GC	Futures	1647.9	1648.0	1646.7	1647.7	6960.0
2019-05-05 23:00:00	GC	Futures	1647.6	1649.0	1647.3	1649.0	4449.0
2019-05-05 18:00:00	ZN	Futures	124.223722	124.553603	124.223722	124.443643	79513.0
2019-05-05 19:00:00	ZN	Futures	124.427934	124.616437	124.412225	124.600729	35157.0
2019-05-05 20:00:00	ZN	Futures	124.58502	124.773523	124.537894	124.726398	73163.0
2019-05-05 21:00:00	ZN	Futures	124.726398	124.757815	124.58502	124.58502	37216.0
2019-05-05 22:00:00	ZN	Futures	124.58502	124.679272	124.569311	124.600729	22584.0
2019-05-05 23:00:00	ZN	Futures	124.600729	124.679272	124.58502	124.663563	9637.0

> showing 36 of 376 rows — these rows as CSV

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