PREVIEW / futures_1hour / 2023-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-21.parquet
  size:    67 KB
  rows:    2,043

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-09-21 00:00:00	ES	Futures	4817.99	4818.53	4815.27	4816.63	6041.0
2023-09-21 01:00:00	ES	Futures	4816.63	4817.45	4813.1	4815.27	8320.0
2023-09-21 02:00:00	ES	Futures	4815.54	4822.06	4815.0	4820.7	11240.0
2023-09-21 03:00:00	ES	Futures	4820.98	4822.06	4808.76	4818.53	30646.0
2023-09-21 04:00:00	ES	Futures	4818.8	4821.25	4808.76	4810.38	22043.0
2023-09-21 05:00:00	ES	Futures	4810.66	4813.64	4804.41	4805.77	19538.0
2023-09-21 06:00:00	ES	Futures	4805.77	4806.04	4797.89	4800.88	29491.0
2023-09-21 07:00:00	ES	Futures	4801.15	4803.32	4790.56	4792.19	42059.0
2023-09-21 08:00:00	ES	Futures	4792.19	4793.82	4782.96	4790.56	69762.0
2023-09-21 09:00:00	ES	Futures	4790.83	4799.52	4779.43	4779.7	255176.0
2023-09-21 10:00:00	ES	Futures	4779.7	4795.45	4778.07	4779.43	284881.0
2023-09-21 11:00:00	ES	Futures	4779.16	4784.32	4774.0	4776.98	183944.0
2023-09-21 12:00:00	ES	Futures	4776.98	4779.97	4771.28	4772.91	131658.0
2023-09-21 13:00:00	ES	Futures	4773.18	4787.85	4772.1	4782.69	140683.0
2023-09-21 14:00:00	ES	Futures	4782.96	4783.5	4767.75	4768.02	145294.0
2023-09-21 15:00:00	ES	Futures	4768.02	4771.55	4747.65	4750.1	375890.0
2023-09-21 16:00:00	ES	Futures	4750.1	4752.54	4743.04	4745.75	84891.0
2023-09-21 18:00:00	ES	Futures	4747.11	4752.0	4746.84	4750.1	7550.0
2023-09-21 19:00:00	ES	Futures	4750.1	4750.64	4745.21	4746.57	5659.0
2023-09-21 20:00:00	ES	Futures	4746.57	4749.56	4742.5	4748.47	11061.0
2023-09-21 21:00:00	ES	Futures	4748.2	4752.54	4745.21	4751.46	10565.0
2023-09-21 22:00:00	ES	Futures	4751.19	4754.44	4749.83	4750.91	14516.0
2023-09-21 23:00:00	ES	Futures	4750.91	4758.25	4750.64	4757.16	12150.0
2023-09-21 00:00:00	NQ	Futures	16585.05	16588.34	16574.89	16580.93	2925.0
2023-09-21 01:00:00	NQ	Futures	16581.2	16587.52	16567.47	16575.71	4385.0
2023-09-21 02:00:00	NQ	Futures	16575.71	16600.15	16574.06	16595.76	5564.0
2023-09-21 03:00:00	NQ	Futures	16595.21	16602.9	16543.57	16584.5	12114.0
2023-09-21 04:00:00	NQ	Futures	16585.32	16596.86	16535.61	16543.85	13342.0
2023-09-21 05:00:00	NQ	Futures	16543.3	16559.5	16520.78	16526.54	9180.0
2023-09-21 06:00:00	NQ	Futures	16526.82	16528.74	16499.08	16512.26	11861.0
2023-09-21 07:00:00	NQ	Futures	16511.71	16520.23	16458.98	16464.47	21027.0
2023-09-21 08:00:00	NQ	Futures	16465.02	16471.61	16416.4	16437.55	31929.0
2023-09-21 09:00:00	NQ	Futures	16437.55	16502.1	16402.12	16406.79	119283.0
2023-09-21 10:00:00	NQ	Futures	16407.07	16500.45	16390.86	16438.38	111698.0
2023-09-21 11:00:00	NQ	Futures	16438.38	16465.57	16410.36	16420.52	64832.0
2023-09-21 12:00:00	NQ	Futures	16419.7	16449.36	16393.06	16422.72	48996.0
2023-09-21 13:00:00	NQ	Futures	16422.72	16480.95	16418.88	16455.96	43121.0
2023-09-21 14:00:00	NQ	Futures	16456.51	16460.08	16392.51	16396.9	45287.0
2023-09-21 15:00:00	NQ	Futures	16397.18	16412.83	16325.22	16327.96	86241.0
2023-09-21 16:00:00	NQ	Futures	16327.41	16336.75	16305.17	16314.78	18852.0
2023-09-21 18:00:00	NQ	Futures	16320.0	16338.67	16316.43	16332.63	3388.0
2023-09-21 19:00:00	NQ	Futures	16332.08	16334.0	16309.29	16316.43	3622.0
2023-09-21 20:00:00	NQ	Futures	16316.7	16334.28	16299.95	16322.74	5958.0
2023-09-21 21:00:00	NQ	Futures	16322.74	16344.44	16307.64	16338.4	5007.0
2023-09-21 22:00:00	NQ	Futures	16339.22	16357.08	16337.85	16344.17	5957.0
2023-09-21 23:00:00	NQ	Futures	16343.89	16371.36	16341.7	16365.32	5169.0
2023-09-21 00:00:00	YM	Futures	37617.4	37617.4	37598.9	37608.7	609.0
2023-09-21 01:00:00	YM	Futures	37607.6	37614.1	37580.5	37600.0	1070.0
2023-09-21 02:00:00	YM	Futures	37600.0	37640.2	37590.3	37629.3	2520.0
2023-09-21 03:00:00	YM	Futures	37630.4	37638.0	37570.7	37628.2	4698.0

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

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