PREVIEW / futures_1hour / 2020-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-02.parquet
  size:    17 KB
  rows:    354

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-08-02 18:00:00	ES	Futures	3654.74	3656.69	3640.22	3644.41	13930.0
2020-08-02 19:00:00	ES	Futures	3644.69	3647.76	3636.59	3646.08	12933.0
2020-08-02 20:00:00	ES	Futures	3646.08	3650.27	3639.94	3647.2	23571.0
2020-08-02 21:00:00	ES	Futures	3647.2	3654.18	3644.97	3651.95	19894.0
2020-08-02 22:00:00	ES	Futures	3651.95	3652.23	3643.57	3645.52	12103.0
2020-08-02 23:00:00	ES	Futures	3645.8	3647.76	3642.73	3643.85	5786.0
2020-08-02 18:00:00	NQ	Futures	12646.64	12656.77	12580.71	12620.91	4252.0
2020-08-02 19:00:00	NQ	Futures	12620.62	12631.32	12587.65	12622.64	3184.0
2020-08-02 20:00:00	NQ	Futures	12623.51	12646.36	12600.38	12637.68	5017.0
2020-08-02 21:00:00	NQ	Futures	12639.13	12671.8	12629.29	12665.15	6104.0
2020-08-02 22:00:00	NQ	Futures	12666.02	12666.89	12638.26	12650.98	4469.0
2020-08-02 23:00:00	NQ	Futures	12651.85	12655.9	12629.29	12635.37	2958.0
2020-08-02 18:00:00	YM	Futures	29070.1	29089.9	28936.9	28963.3	1924.0
2020-08-02 19:00:00	YM	Futures	28964.4	28995.2	28904.9	28982.0	1894.0
2020-08-02 20:00:00	YM	Futures	28984.2	29010.6	28928.0	28966.6	3555.0
2020-08-02 21:00:00	YM	Futures	28965.5	29007.3	28945.7	28974.3	2658.0
2020-08-02 22:00:00	YM	Futures	28974.3	28976.5	28897.2	28909.3	2255.0
2020-08-02 23:00:00	YM	Futures	28910.4	28934.7	28891.7	28906.0	895.0
2020-08-02 18:00:00	CL	Futures	28.17	28.2	27.97	27.99	2488.0
2020-08-02 19:00:00	CL	Futures	27.98	28.04	27.88	28.02	2233.0
2020-08-02 20:00:00	CL	Futures	28.01	28.02	27.84	27.9	3364.0
2020-08-02 21:00:00	CL	Futures	27.9	27.94	27.83	27.89	3069.0
2020-08-02 22:00:00	CL	Futures	27.89	27.91	27.81	27.88	2444.0
2020-08-02 23:00:00	CL	Futures	27.88	27.94	27.88	27.9	1095.0
2020-08-02 18:00:00	GC	Futures	2429.2	2443.9	2426.7	2433.9	8832.0
2020-08-02 19:00:00	GC	Futures	2433.9	2434.9	2424.5	2430.9	6427.0
2020-08-02 20:00:00	GC	Futures	2430.9	2431.4	2421.1	2425.3	7286.0
2020-08-02 21:00:00	GC	Futures	2425.4	2427.1	2415.7	2419.4	7725.0
2020-08-02 22:00:00	GC	Futures	2419.6	2424.4	2416.6	2423.3	3465.0
2020-08-02 23:00:00	GC	Futures	2423.6	2423.6	2420.3	2423.0	2024.0
2020-08-02 18:00:00	ZN	Futures	139.786705	139.802289	139.708786	139.755538	6991.0
2020-08-02 19:00:00	ZN	Futures	139.755538	139.786705	139.739954	139.739954	3983.0
2020-08-02 20:00:00	ZN	Futures	139.739954	139.755538	139.615284	139.630867	20660.0
2020-08-02 21:00:00	ZN	Futures	139.615284	139.630867	139.568532	139.5997	20778.0
2020-08-02 22:00:00	ZN	Futures	139.5997	139.693203	139.5997	139.693203	19811.0
2020-08-02 23:00:00	ZN	Futures	139.693203	139.708786	139.677619	139.677619	2356.0

> showing 36 of 354 rows — these rows as CSV

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