PREVIEW / futures_1hour / 2023-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-17.parquet
  size:    68 KB
  rows:    2,062

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-08-17 00:00:00	ES	Futures	4856.66	4858.03	4855.28	4855.28	4886.0
2023-08-17 01:00:00	ES	Futures	4855.56	4855.83	4846.22	4851.17	8853.0
2023-08-17 02:00:00	ES	Futures	4851.17	4860.77	4850.34	4859.4	11646.0
2023-08-17 03:00:00	ES	Futures	4859.68	4862.97	4852.54	4857.75	20186.0
2023-08-17 04:00:00	ES	Futures	4858.03	4864.62	4856.66	4859.13	12407.0
2023-08-17 05:00:00	ES	Futures	4859.13	4864.07	4856.93	4863.24	11773.0
2023-08-17 06:00:00	ES	Futures	4863.24	4865.71	4858.58	4861.32	16506.0
2023-08-17 07:00:00	ES	Futures	4861.32	4865.99	4859.95	4865.44	20011.0
2023-08-17 08:00:00	ES	Futures	4865.71	4871.75	4862.15	4869.83	41828.0
2023-08-17 09:00:00	ES	Futures	4869.83	4870.93	4853.09	4859.4	195173.0
2023-08-17 10:00:00	ES	Futures	4859.13	4863.24	4848.15	4854.19	206754.0
2023-08-17 11:00:00	ES	Futures	4854.46	4855.83	4843.48	4850.07	157872.0
2023-08-17 12:00:00	ES	Futures	4850.34	4861.6	4843.75	4860.22	116950.0
2023-08-17 13:00:00	ES	Futures	4860.5	4861.6	4838.26	4841.83	126622.0
2023-08-17 14:00:00	ES	Futures	4841.56	4842.66	4821.24	4823.71	157822.0
2023-08-17 15:00:00	ES	Futures	4823.71	4826.46	4807.79	4813.28	321109.0
2023-08-17 16:00:00	ES	Futures	4813.28	4814.93	4806.97	4807.79	73484.0
2023-08-17 18:00:00	ES	Futures	4808.62	4812.73	4804.22	4808.34	10009.0
2023-08-17 19:00:00	ES	Futures	4808.34	4814.11	4808.07	4811.09	7252.0
2023-08-17 20:00:00	ES	Futures	4811.09	4816.3	4807.79	4814.93	9089.0
2023-08-17 21:00:00	ES	Futures	4814.93	4820.15	4813.56	4818.77	9629.0
2023-08-17 22:00:00	ES	Futures	4818.77	4820.69	4814.66	4816.85	6363.0
2023-08-17 23:00:00	ES	Futures	4816.85	4817.4	4811.09	4814.66	6822.0
2023-08-17 00:00:00	NQ	Futures	16628.9	16633.63	16621.12	16622.79	2965.0
2023-08-17 01:00:00	NQ	Futures	16623.34	16625.29	16582.46	16603.32	6306.0
2023-08-17 02:00:00	NQ	Futures	16603.59	16644.2	16600.81	16639.2	7659.0
2023-08-17 03:00:00	NQ	Futures	16639.75	16657.55	16614.72	16635.3	10994.0
2023-08-17 04:00:00	NQ	Futures	16635.86	16667.84	16628.35	16645.31	9082.0
2023-08-17 05:00:00	NQ	Futures	16645.04	16664.51	16640.59	16659.5	6591.0
2023-08-17 06:00:00	NQ	Futures	16660.06	16670.07	16639.2	16644.48	6447.0
2023-08-17 07:00:00	NQ	Futures	16644.2	16672.85	16635.58	16670.9	9302.0
2023-08-17 08:00:00	NQ	Futures	16670.35	16708.17	16657.83	16699.55	18769.0
2023-08-17 09:00:00	NQ	Futures	16699.55	16703.72	16585.52	16608.6	91763.0
2023-08-17 10:00:00	NQ	Futures	16608.6	16625.29	16528.5	16565.49	100827.0
2023-08-17 11:00:00	NQ	Futures	16566.05	16585.79	16530.72	16583.29	80833.0
2023-08-17 12:00:00	NQ	Futures	16583.01	16635.86	16548.8	16634.47	54771.0
2023-08-17 13:00:00	NQ	Futures	16635.3	16640.59	16532.95	16552.42	52210.0
2023-08-17 14:00:00	NQ	Futures	16552.97	16557.42	16465.64	16479.27	64677.0
2023-08-17 15:00:00	NQ	Futures	16478.99	16490.95	16414.74	16434.21	98692.0
2023-08-17 16:00:00	NQ	Futures	16434.21	16438.94	16396.67	16402.51	18858.0
2023-08-17 18:00:00	NQ	Futures	16407.51	16420.03	16389.16	16404.17	6267.0
2023-08-17 19:00:00	NQ	Futures	16404.17	16424.76	16404.17	16415.02	4026.0
2023-08-17 20:00:00	NQ	Futures	16414.47	16438.11	16400.56	16434.77	6037.0
2023-08-17 21:00:00	NQ	Futures	16434.77	16454.52	16428.65	16447.56	5545.0
2023-08-17 22:00:00	NQ	Futures	16447.56	16455.35	16421.14	16430.6	4448.0
2023-08-17 23:00:00	NQ	Futures	16430.88	16436.16	16406.4	16422.53	5012.0
2023-08-17 00:00:00	YM	Futures	38209.3	38219.2	38200.6	38203.9	562.0
2023-08-17 01:00:00	YM	Futures	38203.9	38204.9	38144.7	38177.6	1297.0
2023-08-17 02:00:00	YM	Futures	38178.7	38242.2	38172.1	38229.1	1991.0
2023-08-17 03:00:00	YM	Futures	38228.0	38246.6	38180.8	38211.5	3121.0

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

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