PREVIEW / futures_1hour / 2020-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-03.parquet
  size:    18 KB
  rows:    372

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-03 18:00:00	ES	Futures	3061.37	3070.15	3047.37	3052.58	44553.0
2020-05-03 19:00:00	ES	Futures	3052.86	3058.07	3043.8	3048.47	20191.0
2020-05-03 20:00:00	ES	Futures	3048.47	3055.6	3041.61	3046.82	22728.0
2020-05-03 21:00:00	ES	Futures	3046.82	3068.23	3046.55	3066.58	24986.0
2020-05-03 22:00:00	ES	Futures	3066.31	3069.87	3060.27	3067.95	10704.0
2020-05-03 23:00:00	ES	Futures	3067.95	3080.58	3067.95	3080.58	12987.0
2020-05-03 18:00:00	NQ	Futures	9853.46	9874.31	9816.61	9835.46	7706.0
2020-05-03 19:00:00	NQ	Futures	9836.32	9842.89	9782.62	9806.04	6833.0
2020-05-03 20:00:00	NQ	Futures	9806.9	9819.75	9776.05	9795.19	6304.0
2020-05-03 21:00:00	NQ	Futures	9796.05	9867.74	9795.19	9862.03	7517.0
2020-05-03 22:00:00	NQ	Futures	9861.74	9870.6	9841.75	9859.46	3368.0
2020-05-03 23:00:00	NQ	Futures	9859.74	9900.02	9859.17	9898.59	5017.0
2020-05-03 18:00:00	YM	Futures	25591.0	25629.3	25456.3	25500.1	5118.0
2020-05-03 19:00:00	YM	Futures	25504.5	25537.3	25430.0	25481.5	2850.0
2020-05-03 20:00:00	YM	Futures	25484.8	25522.0	25420.1	25457.4	2414.0
2020-05-03 21:00:00	YM	Futures	25465.0	25629.3	25459.6	25614.0	3205.0
2020-05-03 22:00:00	YM	Futures	25612.9	25641.4	25562.5	25620.6	1713.0
2020-05-03 23:00:00	YM	Futures	25622.8	25724.6	25622.8	25723.5	2197.0
2020-05-03 18:00:00	CL	Futures	13.51	13.81	13.08	13.26	7596.0
2020-05-03 19:00:00	CL	Futures	13.26	13.33	13.08	13.16	2854.0
2020-05-03 20:00:00	CL	Futures	13.16	13.26	12.83	12.97	4689.0
2020-05-03 21:00:00	CL	Futures	12.98	13.04	12.8	13.0	4008.0
2020-05-03 22:00:00	CL	Futures	12.99	13.15	12.97	13.04	3846.0
2020-05-03 23:00:00	CL	Futures	13.04	13.57	13.02	13.47	6748.0
2020-05-03 18:00:00	GC	Futures	2135.2	2136.2	2121.6	2123.4	4306.0
2020-05-03 19:00:00	GC	Futures	2123.7	2130.2	2123.1	2130.0	2595.0
2020-05-03 20:00:00	GC	Futures	2130.0	2130.7	2124.1	2124.4	2639.0
2020-05-03 21:00:00	GC	Futures	2124.6	2132.2	2124.6	2130.8	2945.0
2020-05-03 22:00:00	GC	Futures	2130.7	2131.2	2127.3	2129.5	2518.0
2020-05-03 23:00:00	GC	Futures	2129.5	2135.9	2129.4	2134.5	2545.0
2020-05-03 18:00:00	ZN	Futures	138.301334	138.332402	138.223662	138.316868	10399.0
2020-05-03 19:00:00	ZN	Futures	138.316868	138.379005	138.285799	138.363471	4407.0
2020-05-03 20:00:00	ZN	Futures	138.363471	138.410073	138.347936	138.410073	6705.0
2020-05-03 21:00:00	ZN	Futures	138.394539	138.410073	138.332402	138.347936	4225.0
2020-05-03 22:00:00	ZN	Futures	138.347936	138.363471	138.316868	138.332402	3374.0
2020-05-03 23:00:00	ZN	Futures	138.332402	138.332402	138.301334	138.301334	2617.0

> showing 36 of 372 rows — these rows as CSV

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