PREVIEW / futures_1hour / 2025-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2025/2025-01-20.parquet
  size:    59 KB
  rows:    1,740

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
2025-01-20 00:00:00	ES	Futures	6185.88	6187.16	6185.11	6186.14	1889.0
2025-01-20 01:00:00	ES	Futures	6186.14	6190.75	6184.85	6188.96	3304.0
2025-01-20 02:00:00	ES	Futures	6189.21	6195.88	6188.19	6195.62	5090.0
2025-01-20 03:00:00	ES	Futures	6195.36	6197.67	6185.88	6191.01	10131.0
2025-01-20 04:00:00	ES	Futures	6191.26	6195.11	6189.98	6192.54	4822.0
2025-01-20 05:00:00	ES	Futures	6192.54	6194.08	6188.19	6191.52	5189.0
2025-01-20 06:00:00	ES	Futures	6191.26	6193.06	6189.21	6189.98	4089.0
2025-01-20 07:00:00	ES	Futures	6190.24	6190.49	6179.47	6181.78	9650.0
2025-01-20 08:00:00	ES	Futures	6181.78	6213.05	6171.52	6211.77	48451.0
2025-01-20 09:00:00	ES	Futures	6211.77	6233.31	6204.34	6222.54	56103.0
2025-01-20 10:00:00	ES	Futures	6222.28	6222.28	6197.16	6208.18	37905.0
2025-01-20 11:00:00	ES	Futures	6208.18	6216.13	6207.93	6209.98	22149.0
2025-01-20 12:00:00	ES	Futures	6210.23	6216.64	6190.49	6209.72	35247.0
2025-01-20 18:00:00	ES	Futures	6215.11	6223.82	6211.26	6222.8	12709.0
2025-01-20 19:00:00	ES	Futures	6223.05	6225.36	6160.24	6164.34	37319.0
2025-01-20 20:00:00	ES	Futures	6164.09	6199.72	6147.42	6190.49	48384.0
2025-01-20 21:00:00	ES	Futures	6190.75	6197.93	6188.44	6193.31	11029.0
2025-01-20 22:00:00	ES	Futures	6193.06	6205.11	6192.8	6199.98	8648.0
2025-01-20 23:00:00	ES	Futures	6200.24	6201.52	6194.85	6195.62	4425.0
2025-01-20 00:00:00	NQ	Futures	22198.72	22205.42	22195.89	22203.36	1119.0
2025-01-20 01:00:00	NQ	Futures	22203.87	22239.9	22198.72	22229.09	2767.0
2025-01-20 02:00:00	NQ	Futures	22230.12	22267.18	22220.6	22256.88	3781.0
2025-01-20 03:00:00	NQ	Futures	22256.63	22273.87	22222.92	22252.51	6192.0
2025-01-20 04:00:00	NQ	Futures	22253.54	22268.72	22245.05	22257.66	2807.0
2025-01-20 05:00:00	NQ	Futures	22258.17	22272.07	22242.22	22260.49	2807.0
2025-01-20 06:00:00	NQ	Futures	22260.23	22266.66	22245.05	22259.72	2530.0
2025-01-20 07:00:00	NQ	Futures	22259.72	22262.29	22204.64	22217.77	5842.0
2025-01-20 08:00:00	NQ	Futures	22217.25	22330.74	22170.93	22325.34	21549.0
2025-01-20 09:00:00	NQ	Futures	22325.85	22418.76	22295.74	22381.96	28997.0
2025-01-20 10:00:00	NQ	Futures	22380.93	22380.93	22277.22	22319.42	24473.0
2025-01-20 11:00:00	NQ	Futures	22319.93	22369.35	22319.16	22334.6	13733.0
2025-01-20 12:00:00	NQ	Futures	22334.09	22355.19	22255.34	22320.19	15420.0
2025-01-20 18:00:00	NQ	Futures	22324.57	22378.61	22309.64	22369.09	5850.0
2025-01-20 19:00:00	NQ	Futures	22370.37	22385.3	22082.66	22099.13	13566.0
2025-01-20 20:00:00	NQ	Futures	22102.22	22261.52	22005.97	22219.57	16853.0
2025-01-20 21:00:00	NQ	Futures	22222.4	22246.08	22194.61	22222.4	4603.0
2025-01-20 22:00:00	NQ	Futures	22221.11	22283.91	22218.54	22259.2	4824.0
2025-01-20 23:00:00	NQ	Futures	22261.77	22265.89	22235.01	22239.13	1901.0
2025-01-20 00:00:00	YM	Futures	44985.1	44991.3	44980.0	44983.0	233.0
2025-01-20 01:00:00	YM	Futures	44985.1	45006.7	44967.6	44997.5	409.0
2025-01-20 02:00:00	YM	Futures	44996.4	45038.6	44978.9	45035.5	771.0
2025-01-20 03:00:00	YM	Futures	45034.5	45040.7	44977.9	44997.5	1270.0
2025-01-20 04:00:00	YM	Futures	44998.5	45018.0	44984.1	44996.4	592.0
2025-01-20 05:00:00	YM	Futures	44996.4	45007.7	44969.7	44996.4	479.0
2025-01-20 06:00:00	YM	Futures	44994.4	45028.3	44990.3	44996.4	835.0
2025-01-20 07:00:00	YM	Futures	44997.5	44999.5	44937.8	44958.3	880.0
2025-01-20 08:00:00	YM	Futures	44957.3	45169.3	44906.9	45161.1	6208.0
2025-01-20 09:00:00	YM	Futures	45156.0	45287.7	45106.6	45233.2	4653.0
2025-01-20 10:00:00	YM	Futures	45233.2	45234.2	45023.2	45097.3	4775.0
2025-01-20 11:00:00	YM	Futures	45097.3	45170.4	45095.2	45140.5	2903.0

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

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