PREVIEW / futures_1hour / 2020-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-29.parquet
  size:    18 KB
  rows:    386

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-11-29 18:00:00	ES	Futures	4082.38	4091.62	4077.9	4080.14	14093.0
2020-11-29 19:00:00	ES	Futures	4080.42	4080.7	4066.97	4069.49	16980.0
2020-11-29 20:00:00	ES	Futures	4069.49	4070.33	4059.41	4065.85	14734.0
2020-11-29 21:00:00	ES	Futures	4065.85	4067.53	4060.53	4066.69	7202.0
2020-11-29 22:00:00	ES	Futures	4066.69	4071.45	4061.37	4062.21	6809.0
2020-11-29 23:00:00	ES	Futures	4062.21	4063.05	4053.25	4055.21	9797.0
2020-11-29 18:00:00	NQ	Futures	14226.23	14284.99	14225.94	14261.83	6275.0
2020-11-29 19:00:00	NQ	Futures	14262.7	14265.6	14210.89	14221.31	7531.0
2020-11-29 20:00:00	NQ	Futures	14221.6	14225.36	14187.73	14216.68	6912.0
2020-11-29 21:00:00	NQ	Futures	14216.39	14223.62	14196.7	14219.57	2887.0
2020-11-29 22:00:00	NQ	Futures	14220.44	14234.33	14201.33	14205.68	3613.0
2020-11-29 23:00:00	NQ	Futures	14205.39	14208.28	14172.39	14182.81	4989.0
2020-11-29 18:00:00	YM	Futures	33073.5	33137.6	33028.2	33050.3	2075.0
2020-11-29 19:00:00	YM	Futures	33051.4	33052.5	32935.3	32949.7	3674.0
2020-11-29 20:00:00	YM	Futures	32951.9	32956.3	32883.3	32918.7	3786.0
2020-11-29 21:00:00	YM	Futures	32917.6	32925.3	32865.6	32918.7	1845.0
2020-11-29 22:00:00	YM	Futures	32920.9	32957.4	32874.5	32887.8	1702.0
2020-11-29 23:00:00	YM	Futures	32887.8	32894.4	32804.8	32815.9	2755.0
2020-11-29 18:00:00	CL	Futures	30.81	30.87	30.37	30.69	7096.0
2020-11-29 19:00:00	CL	Futures	30.69	30.81	30.64	30.68	4191.0
2020-11-29 20:00:00	CL	Futures	30.68	30.75	30.55	30.71	8102.0
2020-11-29 21:00:00	CL	Futures	30.71	30.77	30.56	30.62	4781.0
2020-11-29 22:00:00	CL	Futures	30.61	30.65	30.53	30.6	2207.0
2020-11-29 23:00:00	CL	Futures	30.6	30.62	30.49	30.56	2098.0
2020-11-29 18:00:00	GC	Futures	2170.4	2173.5	2167.9	2169.0	2965.0
2020-11-29 19:00:00	GC	Futures	2168.9	2169.8	2161.3	2164.0	4992.0
2020-11-29 20:00:00	GC	Futures	2164.0	2167.2	2161.2	2163.9	6579.0
2020-11-29 21:00:00	GC	Futures	2163.9	2163.9	2141.8	2144.7	14807.0
2020-11-29 22:00:00	GC	Futures	2144.6	2153.2	2143.3	2149.7	10093.0
2020-11-29 23:00:00	GC	Futures	2149.8	2151.7	2148.0	2148.6	2854.0
2020-11-29 18:00:00	ZN	Futures	138.352129	138.352129	138.320919	138.352129	721.0
2020-11-29 19:00:00	ZN	Futures	138.352129	138.367734	138.336524	138.352129	1612.0
2020-11-29 20:00:00	ZN	Futures	138.352129	138.398943	138.352129	138.383338	2169.0
2020-11-29 21:00:00	ZN	Futures	138.383338	138.398943	138.352129	138.352129	162.0
2020-11-29 22:00:00	ZN	Futures	138.352129	138.383338	138.352129	138.367734	344.0
2020-11-29 23:00:00	ZN	Futures	138.383338	138.383338	138.367734	138.367734	64.0

> showing 36 of 386 rows — these rows as CSV

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