PREVIEW / futures_1hour / 2023-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-18.parquet
  size:    55 KB
  rows:    1,645

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-18 00:00:00	ES	Futures	4814.38	4816.3	4812.73	4814.38	3312.0
2023-08-18 01:00:00	ES	Futures	4814.38	4814.66	4809.17	4814.11	6554.0
2023-08-18 02:00:00	ES	Futures	4814.11	4819.05	4813.28	4817.13	10238.0
2023-08-18 03:00:00	ES	Futures	4816.85	4819.05	4804.77	4808.34	24373.0
2023-08-18 04:00:00	ES	Futures	4808.62	4814.38	4806.69	4811.91	15077.0
2023-08-18 05:00:00	ES	Futures	4811.64	4812.73	4801.48	4805.6	18569.0
2023-08-18 06:00:00	ES	Futures	4805.6	4810.26	4802.03	4803.67	17006.0
2023-08-18 07:00:00	ES	Futures	4803.95	4805.6	4786.66	4789.95	37947.0
2023-08-18 08:00:00	ES	Futures	4789.95	4793.79	4780.07	4786.11	55354.0
2023-08-18 09:00:00	ES	Futures	4785.83	4801.48	4776.5	4790.22	251722.0
2023-08-18 10:00:00	ES	Futures	4789.95	4799.56	4781.44	4799.01	234104.0
2023-08-18 11:00:00	ES	Futures	4799.01	4815.75	4795.44	4814.38	206757.0
2023-08-18 12:00:00	ES	Futures	4814.38	4815.75	4805.32	4808.07	125918.0
2023-08-18 13:00:00	ES	Futures	4808.07	4811.36	4795.44	4808.62	132834.0
2023-08-18 14:00:00	ES	Futures	4808.62	4817.95	4803.95	4808.89	126124.0
2023-08-18 15:00:00	ES	Futures	4809.17	4827.01	4802.3	4814.66	263180.0
2023-08-18 16:00:00	ES	Futures	4814.66	4820.42	4808.62	4809.44	66979.0
2023-08-18 00:00:00	NQ	Futures	16423.09	16432.82	16417.52	16424.48	2538.0
2023-08-18 01:00:00	NQ	Futures	16425.31	16426.15	16400.0	16418.36	4370.0
2023-08-18 02:00:00	NQ	Futures	16418.92	16436.99	16415.58	16427.54	6115.0
2023-08-18 03:00:00	NQ	Futures	16427.54	16439.5	16380.81	16402.51	14295.0
2023-08-18 04:00:00	NQ	Futures	16403.06	16425.59	16396.11	16414.74	7830.0
2023-08-18 05:00:00	NQ	Futures	16413.91	16420.03	16373.86	16388.04	9043.0
2023-08-18 06:00:00	NQ	Futures	16388.6	16401.95	16360.23	16368.02	10153.0
2023-08-18 07:00:00	NQ	Futures	16367.74	16373.58	16288.47	16311.28	21820.0
2023-08-18 08:00:00	NQ	Futures	16311.28	16326.02	16276.23	16297.37	26081.0
2023-08-18 09:00:00	NQ	Futures	16297.37	16350.77	16265.11	16288.47	111938.0
2023-08-18 10:00:00	NQ	Futures	16288.19	16353.55	16253.15	16332.42	105339.0
2023-08-18 11:00:00	NQ	Futures	16332.69	16401.12	16296.26	16394.44	89212.0
2023-08-18 12:00:00	NQ	Futures	16394.44	16410.85	16358.56	16369.69	62738.0
2023-08-18 13:00:00	NQ	Futures	16370.52	16392.77	16317.4	16387.76	63397.0
2023-08-18 14:00:00	NQ	Futures	16387.76	16442.0	16370.52	16408.9	57678.0
2023-08-18 15:00:00	NQ	Futures	16408.9	16468.42	16378.86	16410.02	81319.0
2023-08-18 16:00:00	NQ	Futures	16410.29	16432.82	16396.39	16403.06	15444.0
2023-08-18 00:00:00	YM	Futures	37868.6	37874.1	37855.5	37865.3	377.0
2023-08-18 01:00:00	YM	Futures	37867.5	37867.5	37832.5	37858.8	974.0
2023-08-18 02:00:00	YM	Futures	37859.9	37896.0	37853.3	37875.2	1684.0
2023-08-18 03:00:00	YM	Futures	37874.1	37881.8	37776.6	37801.8	4518.0
2023-08-18 04:00:00	YM	Futures	37804.0	37845.6	37785.4	37823.7	3039.0
2023-08-18 05:00:00	YM	Futures	37821.5	37830.3	37748.1	37785.4	3584.0
2023-08-18 06:00:00	YM	Futures	37785.4	37813.8	37768.9	37783.2	3236.0
2023-08-18 07:00:00	YM	Futures	37781.0	37791.9	37664.8	37675.8	5521.0
2023-08-18 08:00:00	YM	Futures	37678.0	37703.2	37613.4	37653.9	7014.0
2023-08-18 09:00:00	YM	Futures	37653.9	37812.7	37607.9	37756.9	29356.0
2023-08-18 10:00:00	YM	Futures	37754.7	37823.7	37692.2	37821.5	19130.0
2023-08-18 11:00:00	YM	Futures	37822.6	37913.5	37816.0	37909.2	18722.0
2023-08-18 12:00:00	YM	Futures	37910.2	37925.6	37859.9	37876.3	9570.0
2023-08-18 13:00:00	YM	Futures	37877.4	37896.0	37788.6	37853.3	10837.0
2023-08-18 14:00:00	YM	Futures	37855.5	37891.6	37818.2	37831.4	9188.0
2023-08-18 15:00:00	YM	Futures	37833.6	37971.6	37786.5	37886.1	16751.0

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

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