PREVIEW / futures_1hour / 2023-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-07.parquet
  size:    65 KB
  rows:    2,009

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
2023-08-07 00:00:00	ES	Futures	4958.22	4958.22	4954.66	4956.3	4303.0
2023-08-07 01:00:00	ES	Futures	4956.03	4959.05	4953.83	4957.68	7200.0
2023-08-07 02:00:00	ES	Futures	4957.68	4959.32	4951.64	4954.11	10484.0
2023-08-07 03:00:00	ES	Futures	4954.11	4965.36	4952.73	4964.81	24616.0
2023-08-07 04:00:00	ES	Futures	4964.81	4964.81	4950.26	4954.66	19523.0
2023-08-07 05:00:00	ES	Futures	4954.66	4958.5	4951.09	4956.58	13058.0
2023-08-07 06:00:00	ES	Futures	4956.3	4957.95	4946.42	4951.09	16286.0
2023-08-07 07:00:00	ES	Futures	4951.36	4953.83	4949.17	4951.64	20054.0
2023-08-07 08:00:00	ES	Futures	4951.64	4961.52	4946.7	4960.97	28490.0
2023-08-07 09:00:00	ES	Futures	4960.97	4971.68	4956.03	4958.5	225734.0
2023-08-07 10:00:00	ES	Futures	4958.77	4974.15	4952.73	4965.09	214504.0
2023-08-07 11:00:00	ES	Futures	4964.81	4971.13	4955.75	4970.03	153823.0
2023-08-07 12:00:00	ES	Futures	4970.03	4973.05	4963.72	4971.4	105741.0
2023-08-07 13:00:00	ES	Futures	4971.4	4977.72	4969.48	4977.44	94782.0
2023-08-07 14:00:00	ES	Futures	4977.72	4981.01	4969.48	4976.34	107672.0
2023-08-07 15:00:00	ES	Futures	4976.34	4984.85	4970.85	4983.21	200056.0
2023-08-07 16:00:00	ES	Futures	4982.93	4987.05	4981.56	4985.13	54151.0
2023-08-07 18:00:00	ES	Futures	4984.58	4986.23	4982.38	4982.93	3543.0
2023-08-07 19:00:00	ES	Futures	4983.21	4984.3	4982.11	4983.48	2321.0
2023-08-07 20:00:00	ES	Futures	4983.75	4984.58	4981.01	4982.11	5634.0
2023-08-07 21:00:00	ES	Futures	4981.83	4982.11	4970.85	4971.4	17814.0
2023-08-07 22:00:00	ES	Futures	4971.4	4976.62	4970.03	4974.7	9247.0
2023-08-07 23:00:00	ES	Futures	4974.97	4976.07	4970.85	4971.68	6065.0
2023-08-07 00:00:00	NQ	Futures	17171.82	17175.99	17160.14	17170.98	3814.0
2023-08-07 01:00:00	NQ	Futures	17170.98	17178.21	17152.9	17172.37	4778.0
2023-08-07 02:00:00	NQ	Futures	17172.37	17178.77	17137.33	17153.46	6636.0
2023-08-07 03:00:00	NQ	Futures	17153.18	17206.86	17146.78	17201.3	10980.0
2023-08-07 04:00:00	NQ	Futures	17201.3	17204.64	17139.0	17156.8	10374.0
2023-08-07 05:00:00	NQ	Futures	17156.52	17180.16	17146.23	17168.2	6448.0
2023-08-07 06:00:00	NQ	Futures	17167.92	17174.32	17127.04	17150.96	8647.0
2023-08-07 07:00:00	NQ	Futures	17151.51	17158.74	17140.67	17149.29	6419.0
2023-08-07 08:00:00	NQ	Futures	17149.01	17180.72	17126.2	17179.6	12687.0
2023-08-07 09:00:00	NQ	Futures	17179.05	17214.37	17103.4	17118.42	97632.0
2023-08-07 10:00:00	NQ	Futures	17118.42	17181.27	17085.04	17127.32	102535.0
2023-08-07 11:00:00	NQ	Futures	17126.76	17153.18	17059.73	17149.29	77705.0
2023-08-07 12:00:00	NQ	Futures	17149.84	17165.14	17123.7	17159.58	48136.0
2023-08-07 13:00:00	NQ	Futures	17160.41	17185.72	17144.0	17184.05	38027.0
2023-08-07 14:00:00	NQ	Futures	17184.33	17200.74	17156.52	17186.84	39639.0
2023-08-07 15:00:00	NQ	Futures	17187.95	17234.4	17172.37	17229.11	54776.0
2023-08-07 16:00:00	NQ	Futures	17228.83	17239.12	17221.6	17233.56	11790.0
2023-08-07 18:00:00	NQ	Futures	17238.57	17241.63	17222.99	17228.28	2934.0
2023-08-07 19:00:00	NQ	Futures	17228.28	17232.17	17223.55	17230.5	1690.0
2023-08-07 20:00:00	NQ	Futures	17230.5	17234.95	17215.21	17221.32	3385.0
2023-08-07 21:00:00	NQ	Futures	17220.77	17221.88	17162.36	17165.14	10069.0
2023-08-07 22:00:00	NQ	Futures	17165.14	17184.61	17155.69	17180.44	5462.0
2023-08-07 23:00:00	NQ	Futures	17180.72	17187.95	17164.03	17170.15	3748.0
2023-08-07 00:00:00	YM	Futures	38621.3	38621.3	38593.9	38601.5	566.0
2023-08-07 01:00:00	YM	Futures	38601.5	38622.4	38586.2	38613.6	1261.0
2023-08-07 02:00:00	YM	Futures	38613.6	38631.1	38589.5	38600.4	1965.0
2023-08-07 03:00:00	YM	Futures	38601.5	38676.0	38592.8	38673.8	3701.0

> showing 50 of 2,009 rows — these rows as CSV

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