PREVIEW / futures_1hour / 2020-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-19.parquet
  size:    62 KB
  rows:    1,915

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-19 00:00:00	ES	Futures	3991.35	3999.19	3989.95	3996.11	6973.0
2020-11-19 01:00:00	ES	Futures	3996.11	4003.67	3994.15	4002.55	7134.0
2020-11-19 02:00:00	ES	Futures	4002.83	4003.95	3993.87	3993.87	9635.0
2020-11-19 03:00:00	ES	Futures	3993.87	3998.35	3970.62	3975.66	33010.0
2020-11-19 04:00:00	ES	Futures	3975.66	3984.62	3971.18	3976.22	23323.0
2020-11-19 05:00:00	ES	Futures	3976.22	3982.94	3968.94	3980.98	17510.0
2020-11-19 06:00:00	ES	Futures	3980.98	3989.67	3974.54	3987.99	20112.0
2020-11-19 07:00:00	ES	Futures	3987.99	3993.31	3987.99	3989.95	17565.0
2020-11-19 08:00:00	ES	Futures	3989.67	3992.47	3979.86	3989.11	37003.0
2020-11-19 09:00:00	ES	Futures	3988.83	3993.03	3968.66	3990.23	181924.0
2020-11-19 10:00:00	ES	Futures	3989.95	3996.95	3975.38	3987.99	207943.0
2020-11-19 11:00:00	ES	Futures	3987.71	3992.19	3981.26	3987.99	106419.0
2020-11-19 12:00:00	ES	Futures	3987.71	3991.63	3979.86	3983.5	83577.0
2020-11-19 13:00:00	ES	Futures	3983.5	3996.39	3982.1	3994.71	78741.0
2020-11-19 14:00:00	ES	Futures	3994.71	4012.63	3993.03	4007.59	118301.0
2020-11-19 15:00:00	ES	Futures	4007.59	4014.03	4001.71	4008.71	181950.0
2020-11-19 16:00:00	ES	Futures	4008.43	4012.63	3989.39	3991.07	51737.0
2020-11-19 18:00:00	ES	Futures	3988.55	3988.55	3970.62	3975.66	28674.0
2020-11-19 19:00:00	ES	Futures	3975.38	3988.27	3975.38	3980.7	14936.0
2020-11-19 20:00:00	ES	Futures	3980.7	3987.71	3979.58	3984.06	10132.0
2020-11-19 21:00:00	ES	Futures	3984.34	3985.74	3979.3	3985.46	7632.0
2020-11-19 22:00:00	ES	Futures	3985.18	3989.67	3982.66	3984.34	6802.0
2020-11-19 23:00:00	ES	Futures	3984.34	3996.39	3982.94	3993.87	10819.0
2020-11-19 00:00:00	NQ	Futures	13728.34	13762.21	13716.47	13754.68	4390.0
2020-11-19 01:00:00	NQ	Futures	13754.97	13776.39	13749.76	13769.74	3238.0
2020-11-19 02:00:00	NQ	Futures	13769.74	13782.18	13745.71	13746.58	5007.0
2020-11-19 03:00:00	NQ	Futures	13747.16	13757.87	13671.03	13673.34	10854.0
2020-11-19 04:00:00	NQ	Futures	13673.63	13715.9	13668.13	13705.47	8659.0
2020-11-19 05:00:00	NQ	Futures	13705.19	13725.16	13682.9	13714.16	4908.0
2020-11-19 06:00:00	NQ	Futures	13714.45	13742.24	13691.0	13735.58	5587.0
2020-11-19 07:00:00	NQ	Futures	13735.87	13761.34	13732.97	13754.68	6005.0
2020-11-19 08:00:00	NQ	Futures	13754.68	13763.66	13734.71	13752.08	23588.0
2020-11-19 09:00:00	NQ	Futures	13751.79	13806.5	13711.26	13800.42	69839.0
2020-11-19 10:00:00	NQ	Futures	13800.13	13840.95	13759.03	13818.95	59582.0
2020-11-19 11:00:00	NQ	Futures	13818.37	13850.21	13799.84	13830.53	47105.0
2020-11-19 12:00:00	NQ	Futures	13830.53	13853.39	13791.45	13803.31	39102.0
2020-11-19 13:00:00	NQ	Futures	13803.6	13856.29	13797.53	13851.08	30547.0
2020-11-19 14:00:00	NQ	Futures	13851.08	13887.55	13832.55	13886.1	27988.0
2020-11-19 15:00:00	NQ	Futures	13885.52	13894.5	13856.58	13872.79	39320.0
2020-11-19 16:00:00	NQ	Futures	13873.08	13888.71	13846.16	13853.68	9689.0
2020-11-19 18:00:00	NQ	Futures	13848.18	13849.92	13805.92	13823.58	7742.0
2020-11-19 19:00:00	NQ	Futures	13822.71	13847.89	13822.13	13838.34	4570.0
2020-11-19 20:00:00	NQ	Futures	13838.34	13868.73	13829.37	13859.18	5398.0
2020-11-19 21:00:00	NQ	Futures	13859.47	13869.6	13847.6	13865.26	3274.0
2020-11-19 22:00:00	NQ	Futures	13864.97	13884.66	13864.68	13871.92	3586.0
2020-11-19 23:00:00	NQ	Futures	13871.92	13910.71	13869.02	13900.87	5116.0
2020-11-19 00:00:00	YM	Futures	32468.7	32531.7	32455.5	32505.2	1942.0
2020-11-19 01:00:00	YM	Futures	32507.4	32567.1	32486.4	32560.5	3540.0
2020-11-19 02:00:00	YM	Futures	32560.5	32589.2	32499.7	32499.7	4645.0
2020-11-19 03:00:00	YM	Futures	32500.8	32531.7	32318.4	32341.6	9218.0

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

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