PREVIEW / futures_1hour / 2023-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-08.parquet
  size:    54 KB
  rows:    1,613

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-09-08 00:00:00	ES	Futures	4894.81	4894.81	4890.97	4891.24	2786.0
2023-09-08 01:00:00	ES	Futures	4891.24	4901.4	4891.24	4900.3	6141.0
2023-09-08 02:00:00	ES	Futures	4900.58	4905.24	4898.38	4903.6	9343.0
2023-09-08 03:00:00	ES	Futures	4903.6	4907.17	4893.99	4900.3	17367.0
2023-09-08 04:00:00	ES	Futures	4900.58	4903.05	4884.93	4884.93	24674.0
2023-09-08 05:00:00	ES	Futures	4884.93	4885.75	4878.62	4881.36	20677.0
2023-09-08 06:00:00	ES	Futures	4881.36	4889.05	4879.99	4888.5	14899.0
2023-09-08 07:00:00	ES	Futures	4888.5	4889.6	4880.54	4886.03	14281.0
2023-09-08 08:00:00	ES	Futures	4886.03	4896.73	4884.66	4891.24	23079.0
2023-09-08 09:00:00	ES	Futures	4891.24	4905.52	4890.42	4902.22	146395.0
2023-09-08 10:00:00	ES	Futures	4902.5	4916.5	4901.4	4903.05	169352.0
2023-09-08 11:00:00	ES	Futures	4903.05	4914.3	4901.68	4906.07	105666.0
2023-09-08 12:00:00	ES	Futures	4906.07	4912.93	4899.2	4905.24	89423.0
2023-09-08 13:00:00	ES	Futures	4905.24	4906.34	4898.93	4902.77	70730.0
2023-09-08 14:00:00	ES	Futures	4903.05	4906.89	4891.52	4892.34	106998.0
2023-09-08 15:00:00	ES	Futures	4892.07	4900.3	4887.95	4898.93	183467.0
2023-09-08 16:00:00	ES	Futures	4898.93	4905.24	4897.56	4901.13	50433.0
2023-09-08 00:00:00	NQ	Futures	17008.28	17008.55	16996.32	16997.15	1998.0
2023-09-08 01:00:00	NQ	Futures	16997.98	17043.32	16997.43	17040.82	4830.0
2023-09-08 02:00:00	NQ	Futures	17041.37	17063.9	17034.7	17051.94	6659.0
2023-09-08 03:00:00	NQ	Futures	17051.66	17070.3	17009.94	17043.88	10183.0
2023-09-08 04:00:00	NQ	Futures	17044.15	17054.72	16978.24	16980.18	13102.0
2023-09-08 05:00:00	NQ	Futures	16980.74	16983.24	16941.8	16948.76	14775.0
2023-09-08 06:00:00	NQ	Futures	16947.92	16981.57	16943.47	16979.35	11843.0
2023-09-08 07:00:00	NQ	Futures	16979.63	16986.58	16935.96	16961.83	10543.0
2023-09-08 08:00:00	NQ	Futures	16962.38	17011.61	16955.99	16991.03	14884.0
2023-09-08 09:00:00	NQ	Futures	16990.75	17101.45	16986.86	17058.06	83667.0
2023-09-08 10:00:00	NQ	Futures	17058.34	17122.59	17019.12	17019.12	92211.0
2023-09-08 11:00:00	NQ	Futures	17019.4	17099.22	17007.44	17067.8	56265.0
2023-09-08 12:00:00	NQ	Futures	17067.24	17092.83	17024.13	17053.61	45138.0
2023-09-08 13:00:00	NQ	Futures	17053.89	17061.95	17022.74	17051.66	37819.0
2023-09-08 14:00:00	NQ	Futures	17051.94	17068.91	16987.42	16988.81	50197.0
2023-09-08 15:00:00	NQ	Futures	16989.08	17022.18	16972.4	17016.34	52758.0
2023-09-08 16:00:00	NQ	Futures	17016.34	17055.56	17014.95	17036.09	14797.0
2023-09-08 00:00:00	YM	Futures	37858.8	37858.8	37833.6	37836.8	566.0
2023-09-08 01:00:00	YM	Futures	37836.8	37886.1	37836.8	37884.0	828.0
2023-09-08 02:00:00	YM	Futures	37885.0	37916.8	37871.9	37914.6	1823.0
2023-09-08 03:00:00	YM	Futures	37915.7	37936.5	37850.0	37882.9	3210.0
2023-09-08 04:00:00	YM	Futures	37884.0	37902.6	37768.9	37770.0	4910.0
2023-09-08 05:00:00	YM	Futures	37770.0	37778.8	37733.9	37750.3	4354.0
2023-09-08 06:00:00	YM	Futures	37751.4	37799.6	37742.6	37790.8	2934.0
2023-09-08 07:00:00	YM	Futures	37791.9	37800.7	37748.1	37783.2	2360.0
2023-09-08 08:00:00	YM	Futures	37784.3	37848.9	37777.7	37806.2	3053.0
2023-09-08 09:00:00	YM	Futures	37805.1	37864.2	37796.3	37851.1	15588.0
2023-09-08 10:00:00	YM	Futures	37852.2	37961.7	37844.5	37924.5	19609.0
2023-09-08 11:00:00	YM	Futures	37924.5	37971.6	37885.0	37902.6	9919.0
2023-09-08 12:00:00	YM	Futures	37902.6	37959.5	37882.9	37926.7	9512.0
2023-09-08 13:00:00	YM	Futures	37926.7	37957.4	37898.2	37930.0	6341.0
2023-09-08 14:00:00	YM	Futures	37928.9	37951.9	37852.2	37857.7	9163.0
2023-09-08 15:00:00	YM	Futures	37856.6	37922.3	37819.3	37910.2	11989.0

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

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