PREVIEW / futures_1hour / 2023-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-16.parquet
  size:    70 KB
  rows:    2,077

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-03-16 00:00:00	ES	Futures	4368.04	4375.53	4368.04	4375.25	7587.0
2023-03-16 01:00:00	ES	Futures	4375.25	4375.53	4369.43	4369.98	7708.0
2023-03-16 02:00:00	ES	Futures	4370.26	4372.2	4356.39	4358.33	13362.0
2023-03-16 03:00:00	ES	Futures	4358.33	4371.37	4351.95	4370.26	26686.0
2023-03-16 04:00:00	ES	Futures	4370.26	4374.97	4355.56	4355.83	41082.0
2023-03-16 05:00:00	ES	Futures	4355.56	4358.33	4340.3	4349.18	31677.0
2023-03-16 06:00:00	ES	Futures	4349.46	4353.62	4342.8	4352.78	20032.0
2023-03-16 07:00:00	ES	Futures	4352.78	4353.34	4335.59	4346.68	35370.0
2023-03-16 08:00:00	ES	Futures	4346.68	4357.5	4335.87	4340.3	72474.0
2023-03-16 09:00:00	ES	Futures	4340.3	4347.79	4321.17	4347.24	255876.0
2023-03-16 10:00:00	ES	Futures	4347.24	4386.62	4324.49	4381.35	350505.0
2023-03-16 11:00:00	ES	Futures	4381.35	4414.08	4372.48	4407.7	311414.0
2023-03-16 12:00:00	ES	Futures	4407.42	4426.01	4391.06	4423.23	258609.0
2023-03-16 13:00:00	ES	Futures	4423.51	4433.49	4412.97	4421.01	197810.0
2023-03-16 14:00:00	ES	Futures	4421.01	4423.79	4405.48	4423.23	144580.0
2023-03-16 15:00:00	ES	Futures	4423.51	4436.54	4421.29	4431.83	292917.0
2023-03-16 16:00:00	ES	Futures	4432.11	4437.65	4428.78	4433.49	85634.0
2023-03-16 18:00:00	ES	Futures	4432.11	4432.38	4424.34	4430.72	10792.0
2023-03-16 19:00:00	ES	Futures	4431.0	4435.16	4429.61	4431.28	7403.0
2023-03-16 20:00:00	ES	Futures	4431.28	4431.55	4424.06	4425.45	10048.0
2023-03-16 21:00:00	ES	Futures	4425.45	4429.89	4424.9	4428.5	7261.0
2023-03-16 22:00:00	ES	Futures	4428.5	4431.83	4427.67	4428.78	6299.0
2023-03-16 23:00:00	ES	Futures	4428.5	4432.66	4427.95	4430.72	5854.0
2023-03-16 00:00:00	NQ	Futures	13998.82	14021.34	13997.97	14018.24	3207.0
2023-03-16 01:00:00	NQ	Futures	14018.81	14020.21	13993.47	13999.94	3203.0
2023-03-16 02:00:00	NQ	Futures	14000.22	14006.42	13962.78	13970.38	4558.0
2023-03-16 03:00:00	NQ	Futures	13970.66	14026.41	13951.52	14015.15	9264.0
2023-03-16 04:00:00	NQ	Futures	14014.3	14028.94	13975.73	13984.18	14189.0
2023-03-16 05:00:00	NQ	Futures	13984.74	13994.59	13938.56	13967.56	11969.0
2023-03-16 06:00:00	NQ	Futures	13967.56	13987.27	13949.54	13983.33	8839.0
2023-03-16 07:00:00	NQ	Futures	13982.77	13998.25	13942.22	13978.26	13196.0
2023-03-16 08:00:00	NQ	Futures	13978.54	13996.56	13908.72	13935.75	24508.0
2023-03-16 09:00:00	NQ	Futures	13934.9	13985.86	13868.18	13984.46	69606.0
2023-03-16 10:00:00	NQ	Futures	13983.89	14118.19	13923.36	14098.77	110582.0
2023-03-16 11:00:00	NQ	Futures	14099.61	14265.73	14077.93	14240.11	119094.0
2023-03-16 12:00:00	NQ	Futures	14240.11	14284.31	14178.45	14273.05	78890.0
2023-03-16 13:00:00	NQ	Futures	14273.05	14289.94	14227.72	14260.66	48112.0
2023-03-16 14:00:00	NQ	Futures	14261.22	14294.45	14227.44	14290.5	43967.0
2023-03-16 15:00:00	NQ	Futures	14291.07	14343.16	14283.18	14321.48	78534.0
2023-03-16 16:00:00	NQ	Futures	14320.91	14332.17	14298.11	14315.84	17525.0
2023-03-16 18:00:00	NQ	Futures	14311.9	14325.14	14294.73	14322.04	4268.0
2023-03-16 19:00:00	NQ	Futures	14322.32	14336.96	14318.94	14329.08	2814.0
2023-03-16 20:00:00	NQ	Futures	14328.8	14330.77	14305.15	14311.06	4163.0
2023-03-16 21:00:00	NQ	Futures	14310.78	14321.48	14305.43	14314.16	3283.0
2023-03-16 22:00:00	NQ	Futures	14314.72	14324.57	14310.5	14313.87	2404.0
2023-03-16 23:00:00	NQ	Futures	14313.87	14329.92	14310.5	14325.7	2526.0
2023-03-16 00:00:00	YM	Futures	35561.1	35610.8	35558.9	35608.6	1052.0
2023-03-16 01:00:00	YM	Futures	35608.6	35609.7	35571.0	35574.4	1106.0
2023-03-16 02:00:00	YM	Futures	35574.4	35592.0	35481.5	35493.7	2306.0
2023-03-16 03:00:00	YM	Futures	35493.7	35577.7	35442.8	35572.1	5067.0

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

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