PREVIEW / futures_1hour / 2020-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-01.parquet
  size:    61 KB
  rows:    1,867

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-09-01 00:00:00	ES	Futures	3911.64	3914.71	3911.36	3913.88	3416.0
2020-09-01 01:00:00	ES	Futures	3913.6	3915.27	3911.64	3914.71	8694.0
2020-09-01 02:00:00	ES	Futures	3914.71	3919.74	3912.76	3919.74	16038.0
2020-09-01 03:00:00	ES	Futures	3919.74	3927.56	3916.11	3924.21	29458.0
2020-09-01 04:00:00	ES	Futures	3923.93	3924.49	3913.32	3914.99	24242.0
2020-09-01 05:00:00	ES	Futures	3914.71	3923.65	3913.6	3919.74	17585.0
2020-09-01 06:00:00	ES	Futures	3919.74	3923.09	3917.79	3921.7	13359.0
2020-09-01 07:00:00	ES	Futures	3921.42	3921.42	3913.32	3914.71	14485.0
2020-09-01 08:00:00	ES	Futures	3914.71	3918.9	3910.81	3912.2	27519.0
2020-09-01 09:00:00	ES	Futures	3912.48	3914.99	3900.19	3913.6	176134.0
2020-09-01 10:00:00	ES	Futures	3914.16	3924.49	3910.53	3915.83	216490.0
2020-09-01 11:00:00	ES	Futures	3915.83	3921.98	3912.76	3916.95	127746.0
2020-09-01 12:00:00	ES	Futures	3917.23	3921.98	3916.11	3921.98	61240.0
2020-09-01 13:00:00	ES	Futures	3921.98	3925.05	3917.79	3923.37	64019.0
2020-09-01 14:00:00	ES	Futures	3923.37	3929.79	3922.53	3928.96	105965.0
2020-09-01 15:00:00	ES	Futures	3928.96	3939.01	3923.93	3937.61	199180.0
2020-09-01 16:00:00	ES	Futures	3937.33	3942.92	3936.22	3942.36	59753.0
2020-09-01 18:00:00	ES	Futures	3941.8	3942.36	3938.73	3940.96	7586.0
2020-09-01 19:00:00	ES	Futures	3940.96	3949.06	3939.29	3949.06	10781.0
2020-09-01 20:00:00	ES	Futures	3949.06	3956.04	3946.55	3951.58	19509.0
2020-09-01 21:00:00	ES	Futures	3951.3	3952.97	3945.71	3946.55	14640.0
2020-09-01 22:00:00	ES	Futures	3946.55	3950.18	3945.15	3947.39	9730.0
2020-09-01 23:00:00	ES	Futures	3947.11	3949.9	3947.11	3949.34	5118.0
2020-09-01 00:00:00	NQ	Futures	14062.46	14074.32	14060.73	14069.69	2155.0
2020-09-01 01:00:00	NQ	Futures	14069.11	14080.97	14059.28	14073.45	3055.0
2020-09-01 02:00:00	NQ	Futures	14072.87	14103.24	14067.09	14103.24	5559.0
2020-09-01 03:00:00	NQ	Futures	14102.66	14152.11	14095.72	14144.01	12694.0
2020-09-01 04:00:00	NQ	Futures	14144.01	14145.75	14122.32	14128.68	9150.0
2020-09-01 05:00:00	NQ	Futures	14128.4	14168.3	14126.66	14156.45	6981.0
2020-09-01 06:00:00	NQ	Futures	14156.74	14161.94	14147.77	14159.63	4160.0
2020-09-01 07:00:00	NQ	Futures	14159.05	14159.05	14115.09	14123.19	8020.0
2020-09-01 08:00:00	NQ	Futures	14123.19	14148.35	14095.14	14099.48	20288.0
2020-09-01 09:00:00	NQ	Futures	14098.9	14128.4	14025.16	14109.02	90335.0
2020-09-01 10:00:00	NQ	Futures	14110.76	14194.33	14102.66	14137.65	99594.0
2020-09-01 11:00:00	NQ	Futures	14137.65	14169.17	14116.54	14137.07	59746.0
2020-09-01 12:00:00	NQ	Futures	14137.07	14179.0	14132.16	14171.77	32465.0
2020-09-01 13:00:00	NQ	Futures	14172.06	14209.37	14151.24	14192.59	30586.0
2020-09-01 14:00:00	NQ	Futures	14192.88	14204.45	14175.82	14198.67	34053.0
2020-09-01 15:00:00	NQ	Futures	14198.38	14228.45	14179.87	14220.64	53558.0
2020-09-01 16:00:00	NQ	Futures	14220.93	14260.84	14219.78	14260.26	12767.0
2020-09-01 18:00:00	NQ	Futures	14257.08	14263.73	14244.65	14261.13	2499.0
2020-09-01 19:00:00	NQ	Futures	14261.13	14299.88	14252.16	14297.85	5459.0
2020-09-01 20:00:00	NQ	Futures	14297.57	14363.21	14290.34	14329.09	11149.0
2020-09-01 21:00:00	NQ	Futures	14330.24	14337.76	14312.6	14317.23	7241.0
2020-09-01 22:00:00	NQ	Futures	14317.52	14331.69	14305.37	14317.52	4164.0
2020-09-01 23:00:00	NQ	Futures	14317.52	14326.48	14311.16	14321.86	2467.0
2020-09-01 00:00:00	YM	Futures	31312.0	31334.0	31306.5	31328.5	1129.0
2020-09-01 01:00:00	YM	Futures	31330.7	31341.7	31310.9	31337.3	1143.0
2020-09-01 02:00:00	YM	Futures	31337.3	31374.8	31316.4	31371.5	2673.0
2020-09-01 03:00:00	YM	Futures	31371.5	31426.5	31315.3	31371.5	7509.0

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

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