PREVIEW / futures_1hour / 2020-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-21.parquet
  size:    61 KB
  rows:    1,861

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-07-21 00:00:00	ES	Futures	3630.17	3634.63	3629.89	3634.08	8572.0
2020-07-21 01:00:00	ES	Futures	3633.8	3647.76	3632.4	3646.08	19141.0
2020-07-21 02:00:00	ES	Futures	3646.08	3649.15	3641.34	3642.17	21619.0
2020-07-21 03:00:00	ES	Futures	3642.17	3647.48	3639.1	3645.8	45083.0
2020-07-21 04:00:00	ES	Futures	3645.8	3651.95	3643.29	3649.43	22991.0
2020-07-21 05:00:00	ES	Futures	3649.43	3651.95	3647.2	3649.71	17202.0
2020-07-21 06:00:00	ES	Futures	3649.71	3654.18	3648.6	3649.99	20803.0
2020-07-21 07:00:00	ES	Futures	3649.71	3656.14	3646.36	3652.51	27281.0
2020-07-21 08:00:00	ES	Futures	3652.51	3653.62	3647.76	3648.6	21333.0
2020-07-21 09:00:00	ES	Futures	3648.6	3651.11	3639.38	3648.6	165379.0
2020-07-21 10:00:00	ES	Futures	3648.88	3651.11	3634.63	3645.52	225875.0
2020-07-21 11:00:00	ES	Futures	3645.24	3648.6	3636.31	3641.06	156382.0
2020-07-21 12:00:00	ES	Futures	3641.06	3644.41	3636.31	3644.13	93206.0
2020-07-21 13:00:00	ES	Futures	3644.13	3648.6	3638.54	3646.64	77136.0
2020-07-21 14:00:00	ES	Futures	3646.92	3650.27	3643.85	3645.52	76991.0
2020-07-21 15:00:00	ES	Futures	3645.52	3646.64	3618.16	3629.33	329273.0
2020-07-21 16:00:00	ES	Futures	3629.61	3634.08	3628.21	3629.89	43477.0
2020-07-21 18:00:00	ES	Futures	3629.33	3639.94	3628.49	3638.54	8331.0
2020-07-21 19:00:00	ES	Futures	3638.54	3639.66	3634.08	3637.43	7322.0
2020-07-21 20:00:00	ES	Futures	3637.71	3642.73	3633.52	3633.8	13926.0
2020-07-21 21:00:00	ES	Futures	3633.8	3641.34	3632.4	3640.5	9951.0
2020-07-21 22:00:00	ES	Futures	3640.22	3647.76	3639.38	3645.8	10673.0
2020-07-21 23:00:00	ES	Futures	3645.8	3647.48	3643.57	3644.41	5553.0
2020-07-21 00:00:00	NQ	Futures	12738.31	12748.15	12730.51	12740.63	3728.0
2020-07-21 01:00:00	NQ	Futures	12740.05	12788.63	12732.24	12779.09	7070.0
2020-07-21 02:00:00	NQ	Futures	12779.67	12788.05	12760.87	12768.39	6682.0
2020-07-21 03:00:00	NQ	Futures	12768.39	12784.87	12748.15	12774.75	12088.0
2020-07-21 04:00:00	NQ	Futures	12773.59	12790.95	12767.52	12774.46	5562.0
2020-07-21 05:00:00	NQ	Futures	12774.75	12786.9	12757.69	12777.35	5293.0
2020-07-21 06:00:00	NQ	Futures	12777.64	12789.21	12760.0	12765.79	5628.0
2020-07-21 07:00:00	NQ	Futures	12765.21	12784.0	12747.28	12771.57	9155.0
2020-07-21 08:00:00	NQ	Futures	12771.57	12775.33	12742.36	12745.83	10544.0
2020-07-21 09:00:00	NQ	Futures	12745.83	12746.41	12614.84	12658.5	94034.0
2020-07-21 10:00:00	NQ	Futures	12658.5	12672.38	12563.36	12606.74	99992.0
2020-07-21 11:00:00	NQ	Futures	12606.74	12622.93	12528.37	12549.77	66053.0
2020-07-21 12:00:00	NQ	Futures	12550.06	12573.19	12524.9	12571.75	45216.0
2020-07-21 13:00:00	NQ	Futures	12571.75	12622.64	12530.11	12607.03	38839.0
2020-07-21 14:00:00	NQ	Futures	12607.61	12648.38	12595.17	12608.47	39738.0
2020-07-21 15:00:00	NQ	Futures	12608.47	12613.68	12474.87	12517.09	87722.0
2020-07-21 16:00:00	NQ	Futures	12519.7	12564.23	12515.94	12545.14	11978.0
2020-07-21 18:00:00	NQ	Futures	12551.22	12588.52	12542.54	12585.63	3995.0
2020-07-21 19:00:00	NQ	Futures	12585.92	12587.94	12570.01	12577.24	3235.0
2020-07-21 20:00:00	NQ	Futures	12577.82	12585.92	12548.61	12550.35	5614.0
2020-07-21 21:00:00	NQ	Futures	12550.35	12586.21	12545.14	12583.6	4634.0
2020-07-21 22:00:00	NQ	Futures	12583.31	12626.98	12577.82	12620.33	5641.0
2020-07-21 23:00:00	NQ	Futures	12619.75	12622.64	12597.48	12602.98	3790.0
2020-07-21 00:00:00	YM	Futures	29331.1	29365.2	29326.7	29363.0	1349.0
2020-07-21 01:00:00	YM	Futures	29359.7	29477.5	29347.6	29468.7	3963.0
2020-07-21 02:00:00	YM	Futures	29467.6	29502.8	29436.8	29450.0	4062.0
2020-07-21 03:00:00	YM	Futures	29450.0	29492.9	29423.6	29464.3	6402.0

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

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