PREVIEW / futures_1hour / 2023-09-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	4958.11	4959.74	4957.3	4958.38	3342.0
2023-09-15 01:00:00	ES	Futures	4958.38	4959.74	4956.48	4958.66	6649.0
2023-09-15 02:00:00	ES	Futures	4958.38	4958.66	4954.85	4957.3	8807.0
2023-09-15 03:00:00	ES	Futures	4957.3	4958.93	4949.97	4953.77	25795.0
2023-09-15 04:00:00	ES	Futures	4953.77	4954.58	4949.69	4950.24	14939.0
2023-09-15 05:00:00	ES	Futures	4950.51	4954.04	4949.42	4953.22	13890.0
2023-09-15 06:00:00	ES	Futures	4953.22	4955.13	4951.32	4954.85	10874.0
2023-09-15 07:00:00	ES	Futures	4954.85	4955.13	4949.69	4950.24	12621.0
2023-09-15 08:00:00	ES	Futures	4950.24	4954.58	4939.38	4940.19	48268.0
2023-09-15 09:00:00	ES	Futures	4939.92	4942.91	4915.21	4919.55	292711.0
2023-09-15 10:00:00	ES	Futures	4919.82	4925.8	4899.46	4899.73	304240.0
2023-09-15 11:00:00	ES	Futures	4899.73	4908.42	4896.47	4905.7	181899.0
2023-09-15 12:00:00	ES	Futures	4905.97	4908.96	4902.71	4906.79	92917.0
2023-09-15 13:00:00	ES	Futures	4906.52	4906.79	4882.62	4893.21	154774.0
2023-09-15 14:00:00	ES	Futures	4893.48	4893.75	4884.52	4892.12	120081.0
2023-09-15 15:00:00	ES	Futures	4892.4	4893.48	4881.53	4885.61	268553.0
2023-09-15 16:00:00	ES	Futures	4885.61	4891.04	4884.79	4886.96	86199.0
2023-09-15 00:00:00	NQ	Futures	17260.17	17270.61	17257.98	17264.29	2750.0
2023-09-15 01:00:00	NQ	Futures	17264.57	17269.79	17252.76	17263.19	3911.0
2023-09-15 02:00:00	NQ	Futures	17262.64	17262.92	17247.81	17252.48	4831.0
2023-09-15 03:00:00	NQ	Futures	17252.48	17259.35	17197.27	17222.27	12542.0
2023-09-15 04:00:00	NQ	Futures	17222.54	17226.94	17195.35	17199.47	8204.0
2023-09-15 05:00:00	NQ	Futures	17200.02	17209.91	17185.19	17202.77	8967.0
2023-09-15 06:00:00	NQ	Futures	17202.49	17217.05	17193.98	17214.03	5522.0
2023-09-15 07:00:00	NQ	Futures	17214.03	17218.97	17193.98	17196.45	6291.0
2023-09-15 08:00:00	NQ	Futures	17195.9	17218.15	17158.55	17162.39	20070.0
2023-09-15 09:00:00	NQ	Futures	17162.94	17175.85	17017.09	17042.91	114505.0
2023-09-15 10:00:00	NQ	Futures	17042.64	17064.89	16944.86	16945.41	121975.0
2023-09-15 11:00:00	NQ	Futures	16945.68	16973.7	16932.5	16955.3	75808.0
2023-09-15 12:00:00	NQ	Futures	16955.84	16994.02	16945.96	16987.43	50651.0
2023-09-15 13:00:00	NQ	Futures	16987.71	16989.35	16880.86	16914.37	62359.0
2023-09-15 14:00:00	NQ	Futures	16914.64	16916.29	16871.8	16893.22	54512.0
2023-09-15 15:00:00	NQ	Futures	16893.77	16934.42	16875.09	16909.15	87301.0
2023-09-15 16:00:00	NQ	Futures	16909.7	16920.96	16900.64	16900.64	17932.0
2023-09-15 00:00:00	YM	Futures	38332.3	38339.9	38326.8	38332.3	430.0
2023-09-15 01:00:00	YM	Futures	38332.3	38342.0	38325.8	38335.5	662.0
2023-09-15 02:00:00	YM	Futures	38334.4	38338.8	38309.5	38323.6	1830.0
2023-09-15 03:00:00	YM	Futures	38324.7	38344.2	38294.3	38317.1	5568.0
2023-09-15 04:00:00	YM	Futures	38317.1	38334.4	38301.9	38319.2	2768.0
2023-09-15 05:00:00	YM	Futures	38318.2	38351.8	38317.1	38342.0	2556.0
2023-09-15 06:00:00	YM	Futures	38342.0	38355.0	38332.3	38354.0	1750.0
2023-09-15 07:00:00	YM	Futures	38352.9	38352.9	38312.7	38316.0	2257.0
2023-09-15 08:00:00	YM	Futures	38317.1	38338.8	38211.9	38215.1	5709.0
2023-09-15 09:00:00	YM	Futures	38216.2	38235.7	38070.8	38140.3	32905.0
2023-09-15 10:00:00	YM	Futures	38141.3	38201.0	38000.3	38004.7	27535.0
2023-09-15 11:00:00	YM	Futures	38005.7	38057.8	37954.8	38012.2	20103.0
2023-09-15 12:00:00	YM	Futures	38014.4	38037.2	37985.1	38014.4	8930.0
2023-09-15 13:00:00	YM	Futures	38013.3	38013.3	37845.2	37940.7	16844.0
2023-09-15 14:00:00	YM	Futures	37941.7	37965.6	37892.9	37962.3	10060.0
2023-09-15 15:00:00	YM	Futures	37962.3	37962.3	37852.8	37891.8	18221.0

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

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