PREVIEW / futures_1hour / 2020-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-22.parquet
  size:    18 KB
  rows:    362

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-03-22 18:00:00	ES	Futures	2437.07	2440.09	2386.31	2386.31	34887.0
2020-03-22 19:00:00	ES	Futures	2386.31	2446.68	2386.31	2404.69	36406.0
2020-03-22 20:00:00	ES	Futures	2404.69	2420.88	2386.31	2392.34	57228.0
2020-03-22 21:00:00	ES	Futures	2393.17	2412.65	2387.13	2411.28	26590.0
2020-03-22 22:00:00	ES	Futures	2411.0	2412.38	2387.68	2411.28	25319.0
2020-03-22 23:00:00	ES	Futures	2411.0	2440.09	2410.73	2413.2	31356.0
2020-03-22 18:00:00	NQ	Futures	7767.14	7767.14	7573.76	7573.76	4765.0
2020-03-22 19:00:00	NQ	Futures	7573.76	7753.14	7573.76	7637.17	6783.0
2020-03-22 20:00:00	NQ	Futures	7638.6	7692.87	7573.76	7606.9	9347.0
2020-03-22 21:00:00	NQ	Futures	7609.47	7688.3	7598.04	7685.16	4476.0
2020-03-22 22:00:00	NQ	Futures	7684.02	7686.3	7610.04	7680.88	4106.0
2020-03-22 23:00:00	NQ	Futures	7680.31	7778.57	7677.45	7693.44	6779.0
2020-03-22 18:00:00	YM	Futures	20267.8	20271.0	19809.9	19809.9	1977.0
2020-03-22 19:00:00	YM	Futures	19809.9	20261.2	19809.9	19923.8	4939.0
2020-03-22 20:00:00	YM	Futures	19935.9	20078.3	19809.9	19838.4	5450.0
2020-03-22 21:00:00	YM	Futures	19853.7	20003.8	19809.9	19984.1	2974.0
2020-03-22 22:00:00	YM	Futures	19983.0	19985.2	19809.9	19964.4	2893.0
2020-03-22 23:00:00	YM	Futures	19956.7	20202.0	19952.3	19970.9	3825.0
2020-03-22 18:00:00	CL	Futures	20.0	20.49	18.47	19.05	25111.0
2020-03-22 19:00:00	CL	Futures	19.04	19.27	18.5	19.16	15935.0
2020-03-22 20:00:00	CL	Futures	19.16	20.04	19.16	19.81	28137.0
2020-03-22 21:00:00	CL	Futures	19.79	20.64	19.62	20.06	32645.0
2020-03-22 22:00:00	CL	Futures	20.04	20.3	19.63	20.22	19398.0
2020-03-22 23:00:00	CL	Futures	20.22	20.54	20.04	20.17	12875.0
2020-03-22 18:00:00	GC	Futures	1879.8	1887.0	1854.4	1862.2	12323.0
2020-03-22 19:00:00	GC	Futures	1862.3	1873.5	1858.8	1866.0	7421.0
2020-03-22 20:00:00	GC	Futures	1865.8	1878.8	1865.8	1870.8	5717.0
2020-03-22 21:00:00	GC	Futures	1870.6	1870.6	1859.0	1867.8	10844.0
2020-03-22 22:00:00	GC	Futures	1867.5	1873.0	1864.5	1868.6	5334.0
2020-03-22 23:00:00	GC	Futures	1869.0	1874.8	1865.7	1869.1	5215.0
2020-03-22 18:00:00	ZN	Futures	136.763444	137.26054	136.685773	137.058594	21900.0
2020-03-22 19:00:00	ZN	Futures	137.058594	137.136266	136.825581	137.058594	23542.0
2020-03-22 20:00:00	ZN	Futures	137.058594	137.120731	136.716841	136.872184	21768.0
2020-03-22 21:00:00	ZN	Futures	136.856649	136.934321	136.825581	136.856649	9156.0
2020-03-22 22:00:00	ZN	Futures	136.872184	137.011992	136.74791	136.794512	13333.0
2020-03-22 23:00:00	ZN	Futures	136.794512	136.794512	136.406156	136.685773	24128.0

> showing 36 of 362 rows — these rows as CSV

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