PREVIEW / futures_1hour / 2020-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-13.parquet
  size:    52 KB
  rows:    1,516

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-13 00:00:00	ES	Futures	3960.54	3961.66	3955.49	3958.3	5675.0
2020-11-13 01:00:00	ES	Futures	3958.58	3969.78	3957.46	3966.14	7650.0
2020-11-13 02:00:00	ES	Futures	3966.14	3971.18	3957.18	3970.9	10350.0
2020-11-13 03:00:00	ES	Futures	3971.18	3985.18	3968.94	3980.14	24300.0
2020-11-13 04:00:00	ES	Futures	3979.86	3994.15	3979.58	3993.03	17812.0
2020-11-13 05:00:00	ES	Futures	3992.75	3998.63	3989.67	3993.87	18625.0
2020-11-13 06:00:00	ES	Futures	3993.59	3995.27	3982.38	3988.83	16303.0
2020-11-13 07:00:00	ES	Futures	3988.55	3988.83	3981.82	3983.22	16486.0
2020-11-13 08:00:00	ES	Futures	3983.22	3989.11	3982.38	3986.3	28157.0
2020-11-13 09:00:00	ES	Futures	3986.02	3992.19	3980.14	3989.67	130838.0
2020-11-13 10:00:00	ES	Futures	3989.67	3990.79	3974.54	3980.42	199345.0
2020-11-13 11:00:00	ES	Futures	3980.42	3993.87	3980.14	3992.47	136738.0
2020-11-13 12:00:00	ES	Futures	3992.19	3997.79	3990.23	3997.79	63342.0
2020-11-13 13:00:00	ES	Futures	3997.79	4002.27	3994.99	3996.11	108587.0
2020-11-13 14:00:00	ES	Futures	3996.11	4009.83	3994.15	4008.15	129840.0
2020-11-13 15:00:00	ES	Futures	4008.15	4022.16	4000.03	4012.91	258020.0
2020-11-13 16:00:00	ES	Futures	4012.91	4015.99	4010.11	4013.19	55044.0
2020-11-13 00:00:00	NQ	Futures	13736.74	13742.53	13710.68	13722.26	3393.0
2020-11-13 01:00:00	NQ	Futures	13722.26	13772.63	13717.63	13758.74	5289.0
2020-11-13 02:00:00	NQ	Futures	13758.16	13778.42	13738.76	13774.95	5776.0
2020-11-13 03:00:00	NQ	Futures	13776.97	13801.29	13756.13	13775.53	10330.0
2020-11-13 04:00:00	NQ	Futures	13776.1	13821.55	13766.84	13810.84	7564.0
2020-11-13 05:00:00	NQ	Futures	13810.55	13817.5	13786.53	13792.32	5665.0
2020-11-13 06:00:00	NQ	Futures	13793.18	13803.89	13766.26	13779.29	5680.0
2020-11-13 07:00:00	NQ	Futures	13778.71	13801.0	13761.05	13769.74	6687.0
2020-11-13 08:00:00	NQ	Futures	13768.87	13794.92	13767.42	13779.87	17880.0
2020-11-13 09:00:00	NQ	Futures	13779.0	13806.21	13744.84	13757.58	57010.0
2020-11-13 10:00:00	NQ	Futures	13757.87	13763.95	13664.95	13684.34	71430.0
2020-11-13 11:00:00	NQ	Futures	13684.63	13760.18	13684.34	13748.89	45990.0
2020-11-13 12:00:00	NQ	Futures	13749.18	13779.58	13739.05	13777.55	27028.0
2020-11-13 13:00:00	NQ	Futures	13777.55	13783.34	13730.95	13737.03	38426.0
2020-11-13 14:00:00	NQ	Futures	13736.16	13786.82	13717.63	13781.03	38753.0
2020-11-13 15:00:00	NQ	Futures	13781.03	13839.79	13761.05	13816.34	59676.0
2020-11-13 16:00:00	NQ	Futures	13817.21	13834.87	13803.89	13831.1	10326.0
2020-11-13 00:00:00	YM	Futures	32032.0	32040.9	31994.4	32023.2	1553.0
2020-11-13 01:00:00	YM	Futures	32024.3	32106.1	32011.0	32078.4	3738.0
2020-11-13 02:00:00	YM	Futures	32077.3	32103.9	31997.7	32099.4	5576.0
2020-11-13 03:00:00	YM	Futures	32103.9	32242.1	32079.5	32194.5	8725.0
2020-11-13 04:00:00	YM	Futures	32194.5	32316.1	32193.4	32299.6	6056.0
2020-11-13 05:00:00	YM	Futures	32299.6	32390.2	32285.2	32364.8	5725.0
2020-11-13 06:00:00	YM	Futures	32363.7	32377.0	32274.1	32328.3	4363.0
2020-11-13 07:00:00	YM	Futures	32326.1	32326.1	32260.9	32271.9	3748.0
2020-11-13 08:00:00	YM	Futures	32275.2	32328.3	32266.4	32310.6	3690.0
2020-11-13 09:00:00	YM	Futures	32310.6	32360.4	32237.7	32349.3	15380.0
2020-11-13 10:00:00	YM	Futures	32346.0	32352.6	32212.2	32270.8	18103.0
2020-11-13 11:00:00	YM	Futures	32270.8	32388.0	32270.8	32373.6	11863.0
2020-11-13 12:00:00	YM	Futures	32373.6	32421.2	32349.3	32416.8	5835.0
2020-11-13 13:00:00	YM	Futures	32417.9	32455.5	32389.1	32435.6	11593.0
2020-11-13 14:00:00	YM	Futures	32436.7	32521.8	32415.7	32507.4	10297.0
2020-11-13 15:00:00	YM	Futures	32508.5	32597.0	32437.8	32510.7	20001.0

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

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