PREVIEW / futures_1hour / 2020-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-03.parquet
  size:    61 KB
  rows:    1,903

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-12-03 00:00:00	ES	Futures	4103.38	4106.19	4102.26	4103.66	5173.0
2020-12-03 01:00:00	ES	Futures	4103.66	4107.59	4103.1	4107.03	3314.0
2020-12-03 02:00:00	ES	Futures	4107.03	4110.11	4105.06	4109.27	5618.0
2020-12-03 03:00:00	ES	Futures	4108.99	4111.51	4102.26	4103.1	10551.0
2020-12-03 04:00:00	ES	Futures	4103.38	4108.99	4097.78	4102.82	14346.0
2020-12-03 05:00:00	ES	Futures	4102.82	4107.03	4101.98	4107.03	8515.0
2020-12-03 06:00:00	ES	Futures	4107.03	4109.83	4105.91	4108.15	7854.0
2020-12-03 07:00:00	ES	Futures	4108.43	4111.51	4105.06	4110.95	12932.0
2020-12-03 08:00:00	ES	Futures	4111.23	4111.51	4106.19	4108.15	19475.0
2020-12-03 09:00:00	ES	Futures	4108.15	4114.87	4107.59	4111.79	115647.0
2020-12-03 10:00:00	ES	Futures	4111.51	4122.71	4110.95	4117.39	144306.0
2020-12-03 11:00:00	ES	Futures	4117.39	4121.59	4110.39	4118.51	106398.0
2020-12-03 12:00:00	ES	Futures	4118.79	4121.87	4112.35	4116.83	83600.0
2020-12-03 13:00:00	ES	Futures	4117.11	4117.39	4105.06	4106.19	66373.0
2020-12-03 14:00:00	ES	Futures	4106.47	4118.79	4105.91	4118.23	69046.0
2020-12-03 15:00:00	ES	Futures	4118.23	4125.23	4095.26	4108.43	288604.0
2020-12-03 16:00:00	ES	Futures	4108.71	4112.91	4103.66	4108.99	51366.0
2020-12-03 18:00:00	ES	Futures	4109.83	4115.43	4106.75	4111.79	7872.0
2020-12-03 19:00:00	ES	Futures	4111.79	4116.83	4111.51	4114.87	9212.0
2020-12-03 20:00:00	ES	Futures	4114.59	4116.83	4110.95	4111.23	7332.0
2020-12-03 21:00:00	ES	Futures	4111.51	4115.43	4108.99	4114.87	5736.0
2020-12-03 22:00:00	ES	Futures	4115.15	4115.15	4112.07	4112.35	3251.0
2020-12-03 23:00:00	ES	Futures	4112.35	4114.59	4112.07	4113.75	2461.0
2020-12-03 00:00:00	NQ	Futures	14436.38	14451.15	14430.88	14443.91	1697.0
2020-12-03 01:00:00	NQ	Futures	14442.46	14454.62	14441.88	14450.86	1167.0
2020-12-03 02:00:00	NQ	Futures	14450.57	14461.57	14435.51	14449.41	2882.0
2020-12-03 03:00:00	NQ	Futures	14449.7	14454.62	14436.67	14442.46	3871.0
2020-12-03 04:00:00	NQ	Futures	14442.46	14458.96	14424.8	14450.86	5199.0
2020-12-03 05:00:00	NQ	Futures	14449.99	14454.33	14433.49	14443.33	3659.0
2020-12-03 06:00:00	NQ	Futures	14444.49	14454.33	14440.15	14449.41	2791.0
2020-12-03 07:00:00	NQ	Futures	14449.41	14466.49	14444.49	14460.7	4167.0
2020-12-03 08:00:00	NQ	Futures	14460.7	14463.01	14429.44	14441.59	11667.0
2020-12-03 09:00:00	NQ	Futures	14441.88	14478.07	14430.59	14467.94	48157.0
2020-12-03 10:00:00	NQ	Futures	14467.65	14520.04	14448.54	14450.57	64448.0
2020-12-03 11:00:00	NQ	Futures	14450.86	14489.65	14413.8	14485.88	50938.0
2020-12-03 12:00:00	NQ	Futures	14485.88	14502.38	14444.49	14458.96	37301.0
2020-12-03 13:00:00	NQ	Futures	14458.96	14470.54	14431.17	14437.54	25707.0
2020-12-03 14:00:00	NQ	Futures	14437.83	14480.67	14436.09	14477.2	22268.0
2020-12-03 15:00:00	NQ	Futures	14477.2	14489.07	14408.59	14441.59	58328.0
2020-12-03 16:00:00	NQ	Futures	14441.3	14463.3	14428.57	14459.83	9252.0
2020-12-03 18:00:00	NQ	Futures	14458.38	14469.96	14443.62	14456.94	2844.0
2020-12-03 19:00:00	NQ	Futures	14457.8	14469.96	14452.88	14466.49	2251.0
2020-12-03 20:00:00	NQ	Futures	14465.62	14471.99	14450.28	14457.22	2614.0
2020-12-03 21:00:00	NQ	Futures	14456.65	14466.49	14448.25	14465.33	2507.0
2020-12-03 22:00:00	NQ	Futures	14465.33	14467.36	14459.54	14463.01	975.0
2020-12-03 23:00:00	NQ	Futures	14462.72	14468.51	14461.57	14465.04	802.0
2020-12-03 00:00:00	YM	Futures	32981.7	32996.1	32965.1	32974.0	1063.0
2020-12-03 01:00:00	YM	Futures	32972.9	33002.7	32970.7	33000.5	849.0
2020-12-03 02:00:00	YM	Futures	32999.4	33034.8	32992.8	33033.7	2098.0
2020-12-03 03:00:00	YM	Futures	33032.6	33060.2	32967.4	32976.2	3033.0

> showing 50 of 1,903 rows — these rows as CSV

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