PREVIEW / futures_1hour / 2020-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-27.parquet
  size:    17 KB
  rows:    356

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-09-27 18:00:00	ES	Futures	3687.16	3695.57	3683.24	3694.17	14595.0
2020-09-27 19:00:00	ES	Futures	3694.17	3695.01	3690.81	3691.93	5439.0
2020-09-27 20:00:00	ES	Futures	3692.21	3694.73	3688.28	3689.12	15569.0
2020-09-27 21:00:00	ES	Futures	3689.4	3698.93	3688.28	3698.09	14443.0
2020-09-27 22:00:00	ES	Futures	3698.09	3698.93	3693.89	3694.45	8325.0
2020-09-27 23:00:00	ES	Futures	3694.45	3698.65	3692.77	3696.97	6153.0
2020-09-27 18:00:00	NQ	Futures	12904.51	12946.2	12904.51	12932.88	5850.0
2020-09-27 19:00:00	NQ	Futures	12932.01	12936.65	12909.44	12920.72	2857.0
2020-09-27 20:00:00	NQ	Futures	12920.72	12929.12	12899.01	12907.99	6725.0
2020-09-27 21:00:00	NQ	Futures	12908.57	12956.62	12904.51	12954.88	7157.0
2020-09-27 22:00:00	NQ	Futures	12954.3	12958.07	12933.46	12937.22	5007.0
2020-09-27 23:00:00	NQ	Futures	12937.22	12952.57	12928.25	12942.72	3045.0
2020-09-27 18:00:00	YM	Futures	29918.1	30016.5	29918.1	30006.5	1877.0
2020-09-27 19:00:00	YM	Futures	30006.5	30014.3	29980.0	29986.6	1565.0
2020-09-27 20:00:00	YM	Futures	29988.8	30014.3	29955.7	29962.3	2435.0
2020-09-27 21:00:00	YM	Futures	29963.4	30044.1	29955.7	30037.5	2784.0
2020-09-27 22:00:00	YM	Futures	30036.4	30048.5	30009.8	30014.3	1921.0
2020-09-27 23:00:00	YM	Futures	30014.3	30051.8	30001.0	30041.9	1654.0
2020-09-27 18:00:00	CL	Futures	27.62	27.74	27.56	27.74	2163.0
2020-09-27 19:00:00	CL	Futures	27.74	27.75	27.65	27.65	914.0
2020-09-27 20:00:00	CL	Futures	27.65	27.67	27.53	27.55	3159.0
2020-09-27 21:00:00	CL	Futures	27.56	27.66	27.54	27.65	2422.0
2020-09-27 22:00:00	CL	Futures	27.65	27.67	27.59	27.61	1854.0
2020-09-27 23:00:00	CL	Futures	27.61	27.61	27.55	27.56	1403.0
2020-09-27 18:00:00	GC	Futures	2265.3	2273.1	2264.9	2271.6	2769.0
2020-09-27 19:00:00	GC	Futures	2271.4	2271.8	2268.0	2268.6	1085.0
2020-09-27 20:00:00	GC	Futures	2268.5	2269.2	2264.9	2265.6	3440.0
2020-09-27 21:00:00	GC	Futures	2265.7	2269.1	2263.0	2268.0	5546.0
2020-09-27 22:00:00	GC	Futures	2267.9	2269.2	2265.5	2266.8	3885.0
2020-09-27 23:00:00	GC	Futures	2266.7	2268.6	2265.3	2267.3	1931.0
2020-09-27 18:00:00	ZN	Futures	139.460069	139.460069	139.42886	139.460069	4143.0
2020-09-27 19:00:00	ZN	Futures	139.460069	139.475674	139.444465	139.460069	4167.0
2020-09-27 20:00:00	ZN	Futures	139.444465	139.460069	139.382045	139.444465	12103.0
2020-09-27 21:00:00	ZN	Futures	139.460069	139.460069	139.39765	139.42886	10610.0
2020-09-27 22:00:00	ZN	Futures	139.42886	139.444465	139.413255	139.444465	8213.0
2020-09-27 23:00:00	ZN	Futures	139.444465	139.460069	139.42886	139.42886	2578.0

> showing 36 of 356 rows — these rows as CSV

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