PREVIEW / futures_1hour / 2023-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-24.parquet
  size:    66 KB
  rows:    2,044

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-04-24 00:00:00	ES	Futures	4597.41	4597.96	4594.91	4596.02	3314.0
2023-04-24 01:00:00	ES	Futures	4596.02	4596.3	4591.03	4591.59	7984.0
2023-04-24 02:00:00	ES	Futures	4591.86	4592.14	4585.76	4589.64	14177.0
2023-04-24 03:00:00	ES	Futures	4589.64	4594.91	4586.04	4593.53	15642.0
2023-04-24 04:00:00	ES	Futures	4593.53	4597.13	4591.31	4593.8	9649.0
2023-04-24 05:00:00	ES	Futures	4593.53	4603.23	4592.69	4601.29	13579.0
2023-04-24 06:00:00	ES	Futures	4601.57	4605.73	4599.91	4605.18	9419.0
2023-04-24 07:00:00	ES	Futures	4605.18	4611.0	4604.07	4607.67	19924.0
2023-04-24 08:00:00	ES	Futures	4607.39	4611.83	4604.62	4610.17	21077.0
2023-04-24 09:00:00	ES	Futures	4610.17	4618.77	4607.12	4615.99	152616.0
2023-04-24 10:00:00	ES	Futures	4615.99	4619.88	4600.74	4603.23	240495.0
2023-04-24 11:00:00	ES	Futures	4603.23	4604.62	4594.08	4595.19	162526.0
2023-04-24 12:00:00	ES	Futures	4595.19	4604.9	4591.86	4604.34	115282.0
2023-04-24 13:00:00	ES	Futures	4604.34	4611.0	4600.74	4609.89	101101.0
2023-04-24 14:00:00	ES	Futures	4609.89	4612.39	4604.34	4608.78	119692.0
2023-04-24 15:00:00	ES	Futures	4608.78	4615.72	4608.78	4615.72	194386.0
2023-04-24 16:00:00	ES	Futures	4615.44	4617.1	4611.28	4612.39	52549.0
2023-04-24 18:00:00	ES	Futures	4612.11	4613.5	4609.89	4610.17	4482.0
2023-04-24 19:00:00	ES	Futures	4610.17	4612.66	4609.89	4610.72	2776.0
2023-04-24 20:00:00	ES	Futures	4610.45	4613.22	4608.78	4609.34	5135.0
2023-04-24 21:00:00	ES	Futures	4609.06	4612.11	4607.12	4607.39	5731.0
2023-04-24 22:00:00	ES	Futures	4607.12	4607.67	4604.34	4605.18	6187.0
2023-04-24 23:00:00	ES	Futures	4605.18	4606.84	4601.57	4602.12	6172.0
2023-04-24 00:00:00	NQ	Futures	14699.04	14700.45	14687.78	14692.28	2179.0
2023-04-24 01:00:00	NQ	Futures	14691.72	14692.84	14671.45	14673.14	3627.0
2023-04-24 02:00:00	NQ	Futures	14673.14	14681.58	14656.81	14673.7	5593.0
2023-04-24 03:00:00	NQ	Futures	14674.54	14692.56	14659.62	14685.81	6314.0
2023-04-24 04:00:00	NQ	Futures	14686.09	14693.69	14668.07	14679.89	4665.0
2023-04-24 05:00:00	NQ	Futures	14679.05	14733.67	14674.54	14720.44	8791.0
2023-04-24 06:00:00	NQ	Futures	14720.15	14730.29	14705.8	14729.73	6179.0
2023-04-24 07:00:00	NQ	Futures	14729.45	14749.72	14724.94	14729.45	9106.0
2023-04-24 08:00:00	NQ	Futures	14728.88	14752.81	14721.0	14746.62	10301.0
2023-04-24 09:00:00	NQ	Futures	14746.62	14791.67	14701.57	14753.66	75429.0
2023-04-24 10:00:00	NQ	Futures	14753.66	14757.04	14650.05	14667.79	110936.0
2023-04-24 11:00:00	NQ	Futures	14668.07	14675.95	14603.87	14616.82	74196.0
2023-04-24 12:00:00	NQ	Futures	14617.11	14658.78	14608.1	14655.12	50878.0
2023-04-24 13:00:00	NQ	Futures	14655.4	14697.35	14643.57	14691.72	43455.0
2023-04-24 14:00:00	NQ	Futures	14691.44	14717.06	14673.7	14699.6	60180.0
2023-04-24 15:00:00	NQ	Futures	14699.88	14713.96	14684.68	14707.48	69401.0
2023-04-24 16:00:00	NQ	Futures	14707.77	14716.49	14692.84	14696.5	12975.0
2023-04-24 18:00:00	NQ	Futures	14697.35	14703.82	14688.62	14692.56	2301.0
2023-04-24 19:00:00	NQ	Futures	14692.84	14705.8	14690.59	14696.5	1987.0
2023-04-24 20:00:00	NQ	Futures	14696.5	14707.77	14684.4	14686.93	3725.0
2023-04-24 21:00:00	NQ	Futures	14686.65	14694.82	14673.7	14675.67	3512.0
2023-04-24 22:00:00	NQ	Futures	14675.95	14677.64	14663.56	14668.35	4245.0
2023-04-24 23:00:00	NQ	Futures	14668.07	14673.7	14653.43	14654.27	3708.0
2023-04-24 00:00:00	YM	Futures	37402.5	37405.8	37388.2	37393.7	772.0
2023-04-24 01:00:00	YM	Futures	37393.7	37399.2	37373.8	37379.3	1468.0
2023-04-24 02:00:00	YM	Futures	37379.3	37382.6	37335.1	37358.3	2841.0
2023-04-24 03:00:00	YM	Futures	37356.1	37390.4	37331.8	37384.8	2367.0

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

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