PREVIEW / futures_1hour / 2023-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-17.parquet
  size:    57 KB
  rows:    1,675

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-11-17 00:00:00	ES	Futures	4919.01	4919.01	4914.66	4916.84	4840.0
2023-11-17 01:00:00	ES	Futures	4916.84	4918.19	4915.48	4917.65	4943.0
2023-11-17 02:00:00	ES	Futures	4917.65	4918.47	4914.12	4917.11	6706.0
2023-11-17 03:00:00	ES	Futures	4917.38	4925.8	4915.75	4922.81	20427.0
2023-11-17 04:00:00	ES	Futures	4922.81	4926.61	4919.28	4921.18	16802.0
2023-11-17 05:00:00	ES	Futures	4921.18	4927.43	4920.37	4925.25	16371.0
2023-11-17 06:00:00	ES	Futures	4925.25	4925.53	4920.09	4923.62	15946.0
2023-11-17 07:00:00	ES	Futures	4923.9	4927.7	4921.72	4924.71	15245.0
2023-11-17 08:00:00	ES	Futures	4924.98	4930.96	4920.91	4922.54	42153.0
2023-11-17 09:00:00	ES	Futures	4922.54	4924.71	4903.53	4911.13	235400.0
2023-11-17 10:00:00	ES	Futures	4910.86	4913.85	4904.07	4910.32	175202.0
2023-11-17 11:00:00	ES	Futures	4910.59	4912.22	4901.9	4911.95	130604.0
2023-11-17 12:00:00	ES	Futures	4911.95	4917.11	4909.78	4914.66	97472.0
2023-11-17 13:00:00	ES	Futures	4914.66	4921.72	4912.22	4920.91	89340.0
2023-11-17 14:00:00	ES	Futures	4921.18	4924.98	4916.56	4920.09	81031.0
2023-11-17 15:00:00	ES	Futures	4920.09	4925.53	4911.95	4918.74	215122.0
2023-11-17 16:00:00	ES	Futures	4918.47	4919.55	4913.31	4913.85	47087.0
2023-11-17 00:00:00	NQ	Futures	17461.78	17462.05	17443.37	17453.81	3704.0
2023-11-17 01:00:00	NQ	Futures	17452.99	17456.56	17448.59	17455.18	2510.0
2023-11-17 02:00:00	NQ	Futures	17455.46	17458.21	17441.45	17455.18	3831.0
2023-11-17 03:00:00	NQ	Futures	17455.46	17482.1	17448.32	17468.92	11190.0
2023-11-17 04:00:00	NQ	Futures	17469.19	17489.24	17459.3	17465.35	10094.0
2023-11-17 05:00:00	NQ	Futures	17465.07	17484.85	17460.4	17475.78	8060.0
2023-11-17 06:00:00	NQ	Futures	17475.78	17476.88	17447.49	17468.92	8546.0
2023-11-17 07:00:00	NQ	Futures	17468.64	17485.4	17460.95	17470.02	9079.0
2023-11-17 08:00:00	NQ	Futures	17470.02	17490.34	17450.24	17457.93	20382.0
2023-11-17 09:00:00	NQ	Futures	17457.11	17465.62	17393.38	17439.53	88319.0
2023-11-17 10:00:00	NQ	Futures	17439.53	17443.1	17388.44	17427.44	84521.0
2023-11-17 11:00:00	NQ	Futures	17427.99	17446.94	17386.24	17446.39	66571.0
2023-11-17 12:00:00	NQ	Futures	17446.39	17465.9	17428.54	17460.68	49522.0
2023-11-17 13:00:00	NQ	Futures	17460.68	17491.17	17454.09	17479.63	43816.0
2023-11-17 14:00:00	NQ	Futures	17479.9	17512.59	17464.8	17479.9	47150.0
2023-11-17 15:00:00	NQ	Futures	17480.45	17498.31	17436.51	17465.9	68837.0
2023-11-17 16:00:00	NQ	Futures	17466.17	17468.37	17439.53	17440.35	12938.0
2023-11-17 00:00:00	YM	Futures	38030.7	38030.7	38004.7	38014.4	598.0
2023-11-17 01:00:00	YM	Futures	38014.4	38022.0	38005.7	38016.6	721.0
2023-11-17 02:00:00	YM	Futures	38017.7	38023.1	37992.7	38007.9	1827.0
2023-11-17 03:00:00	YM	Futures	38009.0	38091.4	38003.6	38066.5	4872.0
2023-11-17 04:00:00	YM	Futures	38065.4	38087.1	38043.7	38062.1	4272.0
2023-11-17 05:00:00	YM	Futures	38062.1	38107.7	38058.9	38093.6	3681.0
2023-11-17 06:00:00	YM	Futures	38094.7	38094.7	38061.1	38079.5	4936.0
2023-11-17 07:00:00	YM	Futures	38079.5	38105.5	38069.7	38088.2	4135.0
2023-11-17 08:00:00	YM	Futures	38088.2	38150.0	38088.2	38099.0	6197.0
2023-11-17 09:00:00	YM	Futures	38099.0	38114.2	37917.9	37977.5	25139.0
2023-11-17 10:00:00	YM	Futures	37977.5	37998.1	37929.8	37949.3	13222.0
2023-11-17 11:00:00	YM	Futures	37949.3	37975.4	37907.0	37958.0	9043.0
2023-11-17 12:00:00	YM	Futures	37958.0	37993.8	37938.5	37953.7	5963.0
2023-11-17 13:00:00	YM	Futures	37954.8	38019.8	37934.1	38017.7	5944.0
2023-11-17 14:00:00	YM	Futures	38017.7	38028.5	37971.0	37996.0	5465.0
2023-11-17 15:00:00	YM	Futures	37997.1	38024.2	37937.4	37986.2	12959.0

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

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