PREVIEW / futures_1hour / 2020-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-08.parquet
  size:    60 KB
  rows:    1,897

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-08 00:00:00	ES	Futures	4124.39	4126.35	4124.39	4125.23	4445.0
2020-12-08 01:00:00	ES	Futures	4124.95	4128.59	4121.31	4122.71	5126.0
2020-12-08 02:00:00	ES	Futures	4122.71	4124.95	4117.39	4122.15	9905.0
2020-12-08 03:00:00	ES	Futures	4121.87	4127.19	4119.91	4125.51	14859.0
2020-12-08 04:00:00	ES	Futures	4125.51	4131.39	4118.23	4120.47	19206.0
2020-12-08 05:00:00	ES	Futures	4120.47	4122.15	4117.39	4120.19	10803.0
2020-12-08 06:00:00	ES	Futures	4119.91	4119.91	4105.35	4107.59	27390.0
2020-12-08 07:00:00	ES	Futures	4107.87	4116.55	4107.87	4115.15	23448.0
2020-12-08 08:00:00	ES	Futures	4114.87	4121.31	4114.87	4119.07	24331.0
2020-12-08 09:00:00	ES	Futures	4119.07	4128.87	4115.43	4128.03	157226.0
2020-12-08 10:00:00	ES	Futures	4128.31	4134.47	4119.63	4134.47	186426.0
2020-12-08 11:00:00	ES	Futures	4134.47	4143.16	4133.91	4141.2	113605.0
2020-12-08 12:00:00	ES	Futures	4141.2	4149.04	4140.08	4145.68	81001.0
2020-12-08 13:00:00	ES	Futures	4145.68	4149.88	4144.84	4146.24	59042.0
2020-12-08 14:00:00	ES	Futures	4146.52	4154.36	4144.56	4148.2	91284.0
2020-12-08 15:00:00	ES	Futures	4148.48	4150.16	4144.56	4147.36	142717.0
2020-12-08 16:00:00	ES	Futures	4147.36	4150.16	4145.96	4148.76	32337.0
2020-12-08 18:00:00	ES	Futures	4154.08	4161.92	4151.84	4152.68	15535.0
2020-12-08 19:00:00	ES	Futures	4152.68	4160.24	4151.84	4157.44	15312.0
2020-12-08 20:00:00	ES	Futures	4157.44	4159.68	4150.72	4151.56	13524.0
2020-12-08 21:00:00	ES	Futures	4151.56	4156.32	4151.28	4156.04	5231.0
2020-12-08 22:00:00	ES	Futures	4156.32	4157.16	4154.92	4154.92	3516.0
2020-12-08 23:00:00	ES	Futures	4154.92	4158.28	4154.64	4157.72	2714.0
2020-12-08 00:00:00	NQ	Futures	14551.01	14565.2	14551.01	14562.88	2304.0
2020-12-08 01:00:00	NQ	Futures	14561.72	14571.85	14547.25	14554.78	2536.0
2020-12-08 02:00:00	NQ	Futures	14554.49	14568.96	14542.04	14562.01	3406.0
2020-12-08 03:00:00	NQ	Futures	14562.01	14579.96	14558.83	14574.46	4812.0
2020-12-08 04:00:00	NQ	Futures	14574.75	14588.64	14561.43	14573.59	5254.0
2020-12-08 05:00:00	NQ	Futures	14573.88	14583.72	14569.25	14576.78	2120.0
2020-12-08 06:00:00	NQ	Futures	14576.78	14578.22	14505.28	14511.07	12128.0
2020-12-08 07:00:00	NQ	Futures	14511.64	14536.83	14511.07	14535.67	6910.0
2020-12-08 08:00:00	NQ	Futures	14535.09	14552.75	14529.3	14550.72	10055.0
2020-12-08 09:00:00	NQ	Futures	14551.01	14574.46	14501.22	14533.36	63537.0
2020-12-08 10:00:00	NQ	Futures	14533.07	14553.04	14475.75	14540.3	63894.0
2020-12-08 11:00:00	NQ	Futures	14540.59	14573.88	14524.38	14571.56	41767.0
2020-12-08 12:00:00	NQ	Futures	14571.85	14591.25	14564.33	14590.09	29352.0
2020-12-08 13:00:00	NQ	Futures	14590.38	14630.91	14586.04	14623.96	28715.0
2020-12-08 14:00:00	NQ	Futures	14623.96	14650.01	14616.72	14636.98	24879.0
2020-12-08 15:00:00	NQ	Futures	14636.98	14646.54	14625.41	14632.06	33101.0
2020-12-08 16:00:00	NQ	Futures	14632.06	14648.56	14630.04	14644.22	7023.0
2020-12-08 18:00:00	NQ	Futures	14655.51	14676.06	14636.7	14644.8	4738.0
2020-12-08 19:00:00	NQ	Futures	14644.22	14665.06	14641.62	14656.38	4488.0
2020-12-08 20:00:00	NQ	Futures	14655.51	14659.56	14628.88	14633.22	4886.0
2020-12-08 21:00:00	NQ	Futures	14633.8	14643.35	14633.51	14638.14	2076.0
2020-12-08 22:00:00	NQ	Futures	14638.43	14646.54	14635.83	14637.85	1576.0
2020-12-08 23:00:00	NQ	Futures	14637.56	14647.12	14637.27	14646.54	1386.0
2020-12-08 00:00:00	YM	Futures	33157.5	33175.2	33156.4	33165.3	903.0
2020-12-08 01:00:00	YM	Futures	33163.1	33205.1	33135.4	33149.8	1900.0
2020-12-08 02:00:00	YM	Futures	33150.9	33165.3	33095.6	33136.5	2923.0
2020-12-08 03:00:00	YM	Futures	33136.5	33188.5	33116.6	33174.1	3429.0

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

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