PREVIEW / futures_1hour / 2020-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-07.parquet
  size:    17 KB
  rows:    351

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-06-07 18:00:00	ES	Futures	3504.27	3518.54	3498.78	3514.42	22580.0
2020-06-07 19:00:00	ES	Futures	3514.42	3525.13	3513.6	3521.56	17998.0
2020-06-07 20:00:00	ES	Futures	3521.83	3521.83	3507.56	3508.94	32179.0
2020-06-07 21:00:00	ES	Futures	3508.66	3510.31	3499.33	3502.08	27561.0
2020-06-07 22:00:00	ES	Futures	3502.35	3508.94	3497.41	3504.82	18164.0
2020-06-07 23:00:00	ES	Futures	3504.55	3510.03	3503.17	3505.64	10250.0
2020-06-07 18:00:00	NQ	Futures	11218.82	11267.67	11206.54	11255.1	5656.0
2020-06-07 19:00:00	NQ	Futures	11256.24	11283.38	11253.67	11279.09	3330.0
2020-06-07 20:00:00	NQ	Futures	11279.38	11279.38	11250.24	11255.38	7384.0
2020-06-07 21:00:00	NQ	Futures	11255.38	11261.1	11231.68	11238.53	7256.0
2020-06-07 22:00:00	NQ	Futures	11238.53	11259.1	11227.11	11245.67	5415.0
2020-06-07 23:00:00	NQ	Futures	11245.67	11259.67	11239.39	11242.24	3983.0
2020-06-07 18:00:00	YM	Futures	29709.4	29840.8	29650.2	29810.2	4123.0
2020-06-07 19:00:00	YM	Futures	29809.1	29898.9	29801.4	29861.6	2765.0
2020-06-07 20:00:00	YM	Futures	29862.7	29862.7	29730.2	29746.6	4061.0
2020-06-07 21:00:00	YM	Futures	29741.2	29751.0	29654.6	29677.6	3806.0
2020-06-07 22:00:00	YM	Futures	29680.9	29737.9	29633.8	29701.7	2950.0
2020-06-07 23:00:00	YM	Futures	29701.7	29751.0	29687.5	29719.2	1949.0
2020-06-07 18:00:00	CL	Futures	27.42	27.92	27.33	27.89	12866.0
2020-06-07 19:00:00	CL	Futures	27.89	28.14	27.84	28.1	6206.0
2020-06-07 20:00:00	CL	Futures	28.1	28.11	27.91	27.98	4841.0
2020-06-07 21:00:00	CL	Futures	27.97	27.99	27.0	27.52	18753.0
2020-06-07 22:00:00	CL	Futures	27.52	27.76	27.36	27.75	6672.0
2020-06-07 23:00:00	CL	Futures	27.75	27.84	27.65	27.79	4193.0
2020-06-07 18:00:00	GC	Futures	2082.3	2084.1	2074.9	2077.3	3671.0
2020-06-07 19:00:00	GC	Futures	2077.3	2079.9	2075.0	2079.7	1602.0
2020-06-07 20:00:00	GC	Futures	2079.8	2085.5	2079.7	2082.2	4353.0
2020-06-07 21:00:00	GC	Futures	2082.2	2088.3	2081.4	2085.0	4925.0
2020-06-07 22:00:00	GC	Futures	2084.9	2087.3	2084.1	2085.6	2874.0
2020-06-07 23:00:00	GC	Futures	2085.7	2089.4	2085.7	2088.3	2202.0
2020-06-07 18:00:00	ZN	Futures	136.685773	136.685773	136.685773	136.685773	2.0
2020-06-07 19:00:00	ZN	Futures	136.732375	136.763444	136.732375	136.763444	67.0
2020-06-07 20:00:00	ZN	Futures	136.794512	136.825581	136.74791	136.778978	277.0
2020-06-07 21:00:00	ZN	Futures	136.778978	136.841115	136.763444	136.841115	61.0
2020-06-07 22:00:00	ZN	Futures	136.825581	136.841115	136.794512	136.794512	57.0
2020-06-07 23:00:00	ZN	Futures	136.778978	136.778978	136.763444	136.763444	50.0

> showing 36 of 351 rows — these rows as CSV

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