PREVIEW / futures_1hour / 2023-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-04.parquet
  size:    68 KB
  rows:    2,071

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-04-04 00:00:00	ES	Futures	4606.56	4609.61	4604.62	4606.56	4804.0
2023-04-04 01:00:00	ES	Futures	4606.84	4607.39	4603.51	4605.45	3726.0
2023-04-04 02:00:00	ES	Futures	4605.45	4609.34	4602.4	4608.78	6384.0
2023-04-04 03:00:00	ES	Futures	4609.06	4610.72	4602.4	4604.34	16247.0
2023-04-04 04:00:00	ES	Futures	4604.62	4613.77	4604.34	4609.34	16311.0
2023-04-04 05:00:00	ES	Futures	4609.34	4623.76	4609.34	4622.09	20372.0
2023-04-04 06:00:00	ES	Futures	4622.09	4628.2	4619.32	4624.31	20918.0
2023-04-04 07:00:00	ES	Futures	4624.59	4625.7	4620.15	4621.54	15240.0
2023-04-04 08:00:00	ES	Futures	4621.26	4624.04	4616.82	4619.88	20007.0
2023-04-04 09:00:00	ES	Futures	4620.15	4620.71	4602.4	4608.5	156638.0
2023-04-04 10:00:00	ES	Futures	4609.06	4618.77	4591.59	4593.53	321402.0
2023-04-04 11:00:00	ES	Futures	4593.53	4593.53	4576.61	4577.16	222123.0
2023-04-04 12:00:00	ES	Futures	4577.44	4580.21	4565.51	4577.72	176014.0
2023-04-04 13:00:00	ES	Futures	4578.0	4588.53	4575.22	4581.88	114390.0
2023-04-04 14:00:00	ES	Futures	4581.6	4584.93	4570.78	4572.45	123170.0
2023-04-04 15:00:00	ES	Futures	4572.45	4582.16	4568.01	4582.16	215324.0
2023-04-04 16:00:00	ES	Futures	4581.88	4585.48	4580.77	4585.21	48432.0
2023-04-04 18:00:00	ES	Futures	4586.32	4586.87	4583.54	4585.21	4202.0
2023-04-04 19:00:00	ES	Futures	4585.21	4587.7	4584.93	4586.04	3172.0
2023-04-04 20:00:00	ES	Futures	4585.76	4587.98	4584.37	4584.65	6221.0
2023-04-04 21:00:00	ES	Futures	4584.65	4586.59	4581.88	4581.88	5790.0
2023-04-04 22:00:00	ES	Futures	4581.88	4586.32	4581.6	4585.76	4516.0
2023-04-04 23:00:00	ES	Futures	4585.76	4586.04	4582.71	4582.99	2978.0
2023-04-04 00:00:00	NQ	Futures	14916.12	14935.54	14911.61	14922.03	3206.0
2023-04-04 01:00:00	NQ	Futures	14922.31	14923.44	14905.7	14913.3	2805.0
2023-04-04 02:00:00	NQ	Futures	14913.3	14930.76	14903.16	14928.5	3922.0
2023-04-04 03:00:00	NQ	Futures	14929.35	14938.92	14903.45	14910.48	7502.0
2023-04-04 04:00:00	NQ	Futures	14910.48	14945.68	14909.08	14940.89	7585.0
2023-04-04 05:00:00	NQ	Futures	14940.89	15033.52	14940.33	15028.74	15744.0
2023-04-04 06:00:00	NQ	Futures	15028.74	15032.12	15007.62	15007.9	10803.0
2023-04-04 07:00:00	NQ	Futures	15008.47	15016.91	14992.98	15005.37	8194.0
2023-04-04 08:00:00	NQ	Futures	15005.09	15013.53	14972.43	14982.56	10994.0
2023-04-04 09:00:00	NQ	Futures	14982.84	14983.13	14899.79	14956.94	66021.0
2023-04-04 10:00:00	NQ	Futures	14956.94	15008.75	14918.65	14939.2	112368.0
2023-04-04 11:00:00	NQ	Futures	14939.2	14940.05	14873.04	14900.91	76147.0
2023-04-04 12:00:00	NQ	Futures	14901.19	14909.64	14848.54	14888.81	56058.0
2023-04-04 13:00:00	NQ	Futures	14889.37	14921.18	14873.88	14898.94	41649.0
2023-04-04 14:00:00	NQ	Futures	14898.94	14907.95	14844.6	14853.05	44219.0
2023-04-04 15:00:00	NQ	Futures	14853.05	14892.47	14830.24	14892.47	72011.0
2023-04-04 16:00:00	NQ	Futures	14892.18	14903.73	14888.81	14901.19	14817.0
2023-04-04 18:00:00	NQ	Futures	14899.79	14906.54	14894.44	14902.04	2348.0
2023-04-04 19:00:00	NQ	Futures	14902.04	14918.37	14901.47	14912.17	2361.0
2023-04-04 20:00:00	NQ	Futures	14911.61	14919.21	14899.5	14902.88	3507.0
2023-04-04 21:00:00	NQ	Futures	14902.6	14912.17	14892.18	14892.18	3697.0
2023-04-04 22:00:00	NQ	Futures	14891.9	14908.23	14891.06	14906.26	2812.0
2023-04-04 23:00:00	NQ	Futures	14906.82	14908.51	14894.15	14895.28	2352.0
2023-04-04 00:00:00	YM	Futures	37341.7	37360.5	37329.6	37345.1	1084.0
2023-04-04 01:00:00	YM	Futures	37346.2	37350.6	37321.8	37335.1	772.0
2023-04-04 02:00:00	YM	Futures	37336.2	37365.0	37308.6	37350.6	1770.0
2023-04-04 03:00:00	YM	Futures	37351.7	37367.2	37292.0	37317.4	3536.0

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

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