PREVIEW / futures_1hour / 2023-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-24.parquet
  size:    57 KB
  rows:    1,631

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-02-24 00:00:00	ES	Futures	4490.2	4493.0	4489.64	4490.76	3857.0
2023-02-24 01:00:00	ES	Futures	4490.76	4492.72	4488.24	4491.04	4725.0
2023-02-24 02:00:00	ES	Futures	4491.32	4491.32	4484.05	4485.45	8351.0
2023-02-24 03:00:00	ES	Futures	4485.17	4487.96	4481.53	4481.53	20735.0
2023-02-24 04:00:00	ES	Futures	4481.53	4486.01	4479.58	4480.14	13722.0
2023-02-24 05:00:00	ES	Futures	4480.14	4482.65	4474.54	4477.06	14187.0
2023-02-24 06:00:00	ES	Futures	4477.06	4477.06	4464.2	4466.99	27197.0
2023-02-24 07:00:00	ES	Futures	4467.27	4468.11	4463.36	4464.48	25027.0
2023-02-24 08:00:00	ES	Futures	4464.2	4464.76	4432.04	4437.36	128859.0
2023-02-24 09:00:00	ES	Futures	4437.36	4446.86	4420.86	4424.77	282267.0
2023-02-24 10:00:00	ES	Futures	4424.21	4435.12	4414.99	4420.3	324227.0
2023-02-24 11:00:00	ES	Futures	4420.3	4449.66	4418.9	4440.15	247091.0
2023-02-24 12:00:00	ES	Futures	4440.43	4442.95	4425.33	4426.17	144620.0
2023-02-24 13:00:00	ES	Futures	4426.45	4440.43	4422.26	4436.8	129104.0
2023-02-24 14:00:00	ES	Futures	4437.08	4453.85	4431.76	4450.78	162764.0
2023-02-24 15:00:00	ES	Futures	4450.78	4455.81	4431.2	4446.58	337487.0
2023-02-24 16:00:00	ES	Futures	4446.3	4446.86	4442.95	4445.18	55063.0
2023-02-24 00:00:00	NQ	Futures	13856.85	13869.09	13855.71	13857.14	1907.0
2023-02-24 01:00:00	NQ	Futures	13857.99	13864.82	13844.9	13858.27	2163.0
2023-02-24 02:00:00	NQ	Futures	13859.13	13859.13	13826.98	13831.82	5056.0
2023-02-24 03:00:00	NQ	Futures	13830.96	13840.92	13808.49	13810.76	7949.0
2023-02-24 04:00:00	NQ	Futures	13811.05	13824.14	13794.83	13799.38	5619.0
2023-02-24 05:00:00	NQ	Futures	13799.1	13808.2	13779.47	13793.98	5653.0
2023-02-24 06:00:00	NQ	Futures	13793.41	13793.41	13748.46	13768.66	9341.0
2023-02-24 07:00:00	NQ	Futures	13768.94	13779.75	13756.14	13766.67	8083.0
2023-02-24 08:00:00	NQ	Futures	13766.1	13774.06	13626.41	13654.29	50236.0
2023-02-24 09:00:00	NQ	Futures	13653.72	13704.65	13604.79	13628.97	92479.0
2023-02-24 10:00:00	NQ	Futures	13625.56	13647.46	13568.09	13582.6	98654.0
2023-02-24 11:00:00	NQ	Futures	13583.17	13676.48	13568.94	13645.19	75928.0
2023-02-24 12:00:00	NQ	Futures	13645.47	13653.72	13584.88	13593.13	50964.0
2023-02-24 13:00:00	NQ	Futures	13593.41	13627.27	13577.19	13616.74	44824.0
2023-02-24 14:00:00	NQ	Futures	13617.02	13670.79	13595.12	13662.54	52738.0
2023-02-24 15:00:00	NQ	Futures	13662.54	13679.61	13593.41	13653.44	87874.0
2023-02-24 16:00:00	NQ	Futures	13653.44	13661.69	13643.48	13655.43	11301.0
2023-02-24 00:00:00	YM	Futures	36929.6	36946.3	36925.1	36932.9	387.0
2023-02-24 01:00:00	YM	Futures	36934.0	36950.7	36920.6	36938.5	668.0
2023-02-24 02:00:00	YM	Futures	36938.5	36938.5	36897.2	36901.7	1210.0
2023-02-24 03:00:00	YM	Futures	36899.5	36930.7	36885.0	36887.2	2554.0
2023-02-24 04:00:00	YM	Futures	36887.2	36924.0	36886.1	36896.1	1510.0
2023-02-24 05:00:00	YM	Futures	36893.9	36910.6	36848.2	36863.8	2125.0
2023-02-24 06:00:00	YM	Futures	36863.8	36863.8	36759.1	36773.6	3471.0
2023-02-24 07:00:00	YM	Futures	36774.7	36778.0	36743.5	36751.3	3355.0
2023-02-24 08:00:00	YM	Futures	36749.1	36755.7	36535.1	36555.2	13377.0
2023-02-24 09:00:00	YM	Futures	36554.1	36610.9	36422.6	36453.8	28448.0
2023-02-24 10:00:00	YM	Futures	36446.0	36544.0	36375.8	36437.1	27051.0
2023-02-24 11:00:00	YM	Futures	36438.2	36642.1	36427.1	36568.6	21082.0
2023-02-24 12:00:00	YM	Futures	36568.6	36584.2	36457.1	36466.1	13252.0
2023-02-24 13:00:00	YM	Futures	36466.1	36574.1	36427.1	36545.2	13746.0
2023-02-24 14:00:00	YM	Futures	36546.3	36671.1	36509.5	36646.6	14537.0
2023-02-24 15:00:00	YM	Futures	36646.6	36684.4	36483.9	36575.2	22769.0

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

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