PREVIEW / futures_1hour / 2020-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-31.parquet
  size:    58 KB
  rows:    1,752

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-08-31 00:00:00	ES	Futures	3935.38	3935.94	3932.31	3932.59	3847.0
2020-08-31 01:00:00	ES	Futures	3932.59	3932.87	3927.84	3928.12	8628.0
2020-08-31 02:00:00	ES	Futures	3928.4	3930.07	3924.21	3927.28	13360.0
2020-08-31 03:00:00	ES	Futures	3927.0	3930.35	3925.33	3928.4	16449.0
2020-08-31 04:00:00	ES	Futures	3928.4	3930.35	3924.21	3928.4	12046.0
2020-08-31 05:00:00	ES	Futures	3928.4	3928.96	3925.05	3925.61	7620.0
2020-08-31 06:00:00	ES	Futures	3925.88	3926.16	3921.7	3923.37	12809.0
2020-08-31 07:00:00	ES	Futures	3923.37	3925.88	3920.86	3922.81	11885.0
2020-08-31 08:00:00	ES	Futures	3922.81	3923.37	3915.83	3917.23	26615.0
2020-08-31 09:00:00	ES	Futures	3917.23	3917.51	3907.18	3909.13	148339.0
2020-08-31 10:00:00	ES	Futures	3909.13	3916.39	3906.9	3916.11	148410.0
2020-08-31 11:00:00	ES	Futures	3915.83	3917.79	3898.52	3910.53	173152.0
2020-08-31 12:00:00	ES	Futures	3910.53	3916.67	3908.57	3914.71	79692.0
2020-08-31 13:00:00	ES	Futures	3914.71	3918.62	3912.48	3915.83	76022.0
2020-08-31 14:00:00	ES	Futures	3915.55	3918.62	3910.81	3917.23	88834.0
2020-08-31 15:00:00	ES	Futures	3917.23	3923.93	3900.75	3901.03	380829.0
2020-08-31 16:00:00	ES	Futures	3901.03	3908.57	3898.24	3902.71	110903.0
2020-08-31 18:00:00	ES	Futures	3901.87	3904.38	3891.82	3896.01	16710.0
2020-08-31 19:00:00	ES	Futures	3896.28	3907.45	3896.28	3905.5	11707.0
2020-08-31 20:00:00	ES	Futures	3905.5	3913.04	3903.55	3904.66	20513.0
2020-08-31 21:00:00	ES	Futures	3904.66	3914.16	3902.99	3913.32	14175.0
2020-08-31 22:00:00	ES	Futures	3913.6	3915.55	3911.08	3913.6	9620.0
2020-08-31 23:00:00	ES	Futures	3913.6	3914.71	3909.69	3911.64	5056.0
2020-08-31 00:00:00	NQ	Futures	13982.94	13985.25	13975.71	13975.71	1964.0
2020-08-31 01:00:00	NQ	Futures	13976.29	13976.29	13950.55	13951.42	4553.0
2020-08-31 02:00:00	NQ	Futures	13951.71	13960.67	13937.83	13944.19	4281.0
2020-08-31 03:00:00	NQ	Futures	13944.77	13960.38	13928.0	13942.74	7882.0
2020-08-31 04:00:00	NQ	Futures	13942.45	13944.19	13907.17	13925.68	5373.0
2020-08-31 05:00:00	NQ	Futures	13926.26	13928.86	13914.4	13925.68	2410.0
2020-08-31 06:00:00	NQ	Futures	13925.97	13938.41	13911.8	13934.36	3835.0
2020-08-31 07:00:00	NQ	Futures	13934.65	13936.38	13898.21	13909.49	6790.0
2020-08-31 08:00:00	NQ	Futures	13908.91	13917.3	13882.3	13890.69	12184.0
2020-08-31 09:00:00	NQ	Futures	13890.69	13937.25	13866.98	13921.05	76616.0
2020-08-31 10:00:00	NQ	Futures	13921.34	13984.38	13906.02	13979.76	64842.0
2020-08-31 11:00:00	NQ	Futures	13979.18	13997.11	13899.37	13956.33	70823.0
2020-08-31 12:00:00	NQ	Futures	13956.33	14003.76	13948.24	14003.47	38001.0
2020-08-31 13:00:00	NQ	Futures	14003.47	14051.19	13996.82	14043.09	34678.0
2020-08-31 14:00:00	NQ	Futures	14043.67	14061.02	14020.24	14058.7	30492.0
2020-08-31 15:00:00	NQ	Futures	14058.99	14071.43	13986.99	13987.85	64373.0
2020-08-31 16:00:00	NQ	Futures	13988.43	14022.56	13976.0	14003.18	19703.0
2020-08-31 18:00:00	NQ	Futures	14007.52	14026.03	13988.14	13991.9	4153.0
2020-08-31 19:00:00	NQ	Futures	13993.06	14030.65	13993.06	14025.74	3559.0
2020-08-31 20:00:00	NQ	Futures	14026.32	14051.19	14026.03	14034.41	5452.0
2020-08-31 21:00:00	NQ	Futures	14033.83	14072.01	14028.63	14067.96	5381.0
2020-08-31 22:00:00	NQ	Futures	14068.25	14082.42	14061.6	14070.85	5438.0
2020-08-31 23:00:00	NQ	Futures	14070.85	14074.03	14055.23	14062.17	2417.0
2020-08-31 00:00:00	YM	Futures	31679.8	31680.9	31650.1	31650.1	770.0
2020-08-31 01:00:00	YM	Futures	31651.2	31652.3	31609.3	31617.0	1951.0
2020-08-31 02:00:00	YM	Futures	31618.1	31633.5	31567.5	31592.8	3279.0
2020-08-31 03:00:00	YM	Futures	31593.9	31629.1	31573.0	31604.9	3661.0

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

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