PREVIEW / futures_1hour / 2023-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-04.parquet
  size:    57 KB
  rows:    1,658

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-04 00:00:00	ES	Futures	4981.01	4982.93	4980.73	4982.38	2166.0
2023-08-04 01:00:00	ES	Futures	4982.11	4990.62	4981.01	4989.24	7992.0
2023-08-04 02:00:00	ES	Futures	4989.24	4990.07	4985.13	4985.95	9077.0
2023-08-04 03:00:00	ES	Futures	4985.95	4987.6	4974.42	4986.77	23965.0
2023-08-04 04:00:00	ES	Futures	4986.77	4992.81	4981.83	4983.75	17735.0
2023-08-04 05:00:00	ES	Futures	4983.75	4989.52	4982.66	4983.48	16517.0
2023-08-04 06:00:00	ES	Futures	4983.48	4983.75	4973.6	4974.97	16256.0
2023-08-04 07:00:00	ES	Futures	4975.24	4975.79	4962.62	4967.56	28450.0
2023-08-04 08:00:00	ES	Futures	4967.56	4985.68	4956.85	4981.83	121952.0
2023-08-04 09:00:00	ES	Futures	4981.56	4996.93	4977.17	4978.81	251508.0
2023-08-04 10:00:00	ES	Futures	4979.09	4991.72	4961.79	4990.07	285562.0
2023-08-04 11:00:00	ES	Futures	4990.34	4997.21	4988.15	4996.11	137730.0
2023-08-04 12:00:00	ES	Futures	4995.83	5007.91	4992.54	5005.99	121349.0
2023-08-04 13:00:00	ES	Futures	5006.26	5006.81	4982.66	4984.3	135732.0
2023-08-04 14:00:00	ES	Futures	4984.03	4984.3	4939.83	4943.4	338899.0
2023-08-04 15:00:00	ES	Futures	4943.4	4950.54	4934.34	4940.38	305048.0
2023-08-04 16:00:00	ES	Futures	4940.38	4944.22	4938.46	4939.01	80025.0
2023-08-04 00:00:00	NQ	Futures	17258.32	17270.0	17257.76	17261.93	1707.0
2023-08-04 01:00:00	NQ	Futures	17261.37	17313.66	17253.87	17303.37	6112.0
2023-08-04 02:00:00	NQ	Futures	17303.37	17306.71	17278.9	17282.23	5078.0
2023-08-04 03:00:00	NQ	Futures	17282.23	17283.07	17228.83	17275.0	10956.0
2023-08-04 04:00:00	NQ	Futures	17275.0	17308.94	17256.65	17266.1	9461.0
2023-08-04 05:00:00	NQ	Futures	17266.66	17295.31	17264.43	17271.94	6785.0
2023-08-04 06:00:00	NQ	Futures	17271.39	17271.39	17223.27	17232.73	7006.0
2023-08-04 07:00:00	NQ	Futures	17233.01	17235.79	17168.48	17192.4	14252.0
2023-08-04 08:00:00	NQ	Futures	17192.4	17285.02	17134.83	17259.98	53003.0
2023-08-04 09:00:00	NQ	Futures	17258.59	17337.03	17177.38	17186.84	121357.0
2023-08-04 10:00:00	NQ	Futures	17187.67	17275.84	17124.81	17265.27	115095.0
2023-08-04 11:00:00	NQ	Futures	17265.27	17334.52	17256.65	17322.29	66432.0
2023-08-04 12:00:00	NQ	Futures	17322.84	17366.79	17297.81	17350.38	45064.0
2023-08-04 13:00:00	NQ	Futures	17350.1	17353.44	17261.93	17271.94	53734.0
2023-08-04 14:00:00	NQ	Futures	17271.94	17271.94	17087.26	17103.95	110375.0
2023-08-04 15:00:00	NQ	Futures	17104.23	17142.89	17062.23	17086.15	85410.0
2023-08-04 16:00:00	NQ	Futures	17086.43	17107.57	17085.6	17091.44	16150.0
2023-08-04 00:00:00	YM	Futures	38749.4	38761.5	38748.3	38757.1	498.0
2023-08-04 01:00:00	YM	Futures	38754.9	38802.0	38749.4	38791.1	1314.0
2023-08-04 02:00:00	YM	Futures	38791.1	38797.6	38764.8	38767.0	1616.0
2023-08-04 03:00:00	YM	Futures	38768.1	38791.1	38702.3	38781.2	4679.0
2023-08-04 04:00:00	YM	Futures	38784.5	38815.2	38745.1	38756.0	4614.0
2023-08-04 05:00:00	YM	Futures	38756.0	38790.0	38735.2	38744.0	2245.0
2023-08-04 06:00:00	YM	Futures	38741.8	38752.7	38688.1	38697.9	3640.0
2023-08-04 07:00:00	YM	Futures	38697.9	38699.0	38633.3	38657.4	3189.0
2023-08-04 08:00:00	YM	Futures	38656.3	38771.3	38612.5	38741.8	12921.0
2023-08-04 09:00:00	YM	Futures	38740.7	38909.4	38724.2	38818.5	30062.0
2023-08-04 10:00:00	YM	Futures	38818.5	38925.8	38707.8	38895.1	23988.0
2023-08-04 11:00:00	YM	Futures	38895.1	38932.4	38859.0	38921.4	9848.0
2023-08-04 12:00:00	YM	Futures	38921.4	39001.4	38895.1	38997.0	8625.0
2023-08-04 13:00:00	YM	Futures	38998.1	39003.6	38846.9	38856.8	10320.0
2023-08-04 14:00:00	YM	Futures	38855.7	38856.8	38510.6	38541.3	31110.0
2023-08-04 15:00:00	YM	Futures	38539.1	38576.3	38472.3	38525.9	22312.0

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

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