PREVIEW / futures_1hour / 2023-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-21.parquet
  size:    54 KB
  rows:    1,615

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-07-21 00:00:00	ES	Futures	5017.52	5019.44	5016.42	5018.34	2732.0
2023-07-21 01:00:00	ES	Futures	5018.07	5019.17	5016.15	5018.62	3863.0
2023-07-21 02:00:00	ES	Futures	5018.89	5021.36	5016.15	5020.81	6621.0
2023-07-21 03:00:00	ES	Futures	5020.81	5024.66	5018.62	5019.99	18508.0
2023-07-21 04:00:00	ES	Futures	5019.99	5025.21	5018.89	5024.11	11882.0
2023-07-21 05:00:00	ES	Futures	5023.83	5024.93	5019.99	5023.56	10041.0
2023-07-21 06:00:00	ES	Futures	5023.56	5027.68	5023.28	5026.85	12415.0
2023-07-21 07:00:00	ES	Futures	5026.85	5027.13	5020.81	5021.64	12458.0
2023-07-21 08:00:00	ES	Futures	5021.64	5036.74	5021.64	5036.46	33693.0
2023-07-21 09:00:00	ES	Futures	5036.74	5040.03	5015.6	5018.34	216805.0
2023-07-21 10:00:00	ES	Futures	5018.62	5026.85	5011.48	5021.36	215410.0
2023-07-21 11:00:00	ES	Futures	5021.36	5032.07	5020.81	5028.23	144974.0
2023-07-21 12:00:00	ES	Futures	5028.23	5028.23	5016.15	5020.26	115129.0
2023-07-21 13:00:00	ES	Futures	5020.26	5033.44	5019.44	5032.34	104507.0
2023-07-21 14:00:00	ES	Futures	5032.34	5032.89	5021.36	5022.46	105536.0
2023-07-21 15:00:00	ES	Futures	5022.74	5023.28	5011.21	5011.21	253535.0
2023-07-21 16:00:00	ES	Futures	5011.48	5013.13	5009.56	5011.48	72318.0
2023-07-21 00:00:00	NQ	Futures	17357.61	17364.01	17350.93	17355.38	2258.0
2023-07-21 01:00:00	NQ	Futures	17355.66	17361.78	17344.54	17361.5	2507.0
2023-07-21 02:00:00	NQ	Futures	17361.22	17379.58	17347.87	17376.24	4499.0
2023-07-21 03:00:00	NQ	Futures	17375.69	17401.27	17368.18	17387.92	8395.0
2023-07-21 04:00:00	NQ	Futures	17388.2	17427.7	17380.69	17415.74	8854.0
2023-07-21 05:00:00	NQ	Futures	17415.46	17418.24	17387.65	17407.39	6519.0
2023-07-21 06:00:00	NQ	Futures	17407.39	17436.88	17404.06	17434.93	7066.0
2023-07-21 07:00:00	NQ	Futures	17434.93	17440.77	17406.28	17409.06	8609.0
2023-07-21 08:00:00	NQ	Futures	17408.78	17466.08	17407.95	17464.13	17690.0
2023-07-21 09:00:00	NQ	Futures	17463.58	17488.05	17379.02	17380.14	103844.0
2023-07-21 10:00:00	NQ	Futures	17379.86	17408.78	17298.64	17335.36	125537.0
2023-07-21 11:00:00	NQ	Futures	17336.19	17402.67	17326.74	17365.67	82844.0
2023-07-21 12:00:00	NQ	Futures	17365.95	17373.18	17305.32	17330.63	59356.0
2023-07-21 13:00:00	NQ	Futures	17330.91	17416.02	17325.9	17408.51	59480.0
2023-07-21 14:00:00	NQ	Futures	17408.51	17411.29	17324.79	17328.13	54676.0
2023-07-21 15:00:00	NQ	Futures	17328.4	17331.19	17268.88	17285.85	98053.0
2023-07-21 16:00:00	NQ	Futures	17285.85	17306.99	17285.85	17305.32	17252.0
2023-07-21 00:00:00	YM	Futures	38833.8	38846.9	38827.2	38843.7	503.0
2023-07-21 01:00:00	YM	Futures	38842.6	38845.8	38827.2	38843.7	778.0
2023-07-21 02:00:00	YM	Futures	38844.7	38857.9	38813.0	38854.6	3300.0
2023-07-21 03:00:00	YM	Futures	38853.5	38872.1	38826.1	38832.7	2585.0
2023-07-21 04:00:00	YM	Futures	38831.6	38839.3	38811.9	38825.0	3404.0
2023-07-21 05:00:00	YM	Futures	38826.1	38834.9	38807.5	38827.2	1817.0
2023-07-21 06:00:00	YM	Futures	38827.2	38841.5	38819.5	38830.5	1768.0
2023-07-21 07:00:00	YM	Futures	38829.4	38830.5	38763.7	38768.1	3864.0
2023-07-21 08:00:00	YM	Futures	38768.1	38896.2	38767.0	38889.7	5066.0
2023-07-21 09:00:00	YM	Futures	38888.6	38907.2	38725.3	38797.6	29961.0
2023-07-21 10:00:00	YM	Futures	38797.6	38880.9	38769.2	38845.8	23890.0
2023-07-21 11:00:00	YM	Futures	38846.9	38895.1	38840.4	38882.0	11952.0
2023-07-21 12:00:00	YM	Futures	38882.0	38882.0	38816.3	38830.5	9347.0
2023-07-21 13:00:00	YM	Futures	38830.5	38909.4	38827.2	38895.1	9084.0
2023-07-21 14:00:00	YM	Futures	38897.3	38900.6	38844.7	38862.3	8248.0
2023-07-21 15:00:00	YM	Futures	38864.5	38864.5	38771.3	38774.6	18999.0

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

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