PREVIEW / futures_1hour / 2023-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-25.parquet
  size:    66 KB
  rows:    2,014

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-05-25 00:00:00	ES	Futures	4593.8	4596.3	4592.97	4593.25	2974.0
2023-05-25 01:00:00	ES	Futures	4593.25	4597.69	4591.86	4595.47	6764.0
2023-05-25 02:00:00	ES	Futures	4595.19	4608.78	4594.36	4606.29	17326.0
2023-05-25 03:00:00	ES	Futures	4606.29	4606.84	4587.98	4591.86	35175.0
2023-05-25 04:00:00	ES	Futures	4591.86	4604.62	4591.03	4604.34	21485.0
2023-05-25 05:00:00	ES	Futures	4604.34	4611.0	4604.34	4610.17	20216.0
2023-05-25 06:00:00	ES	Futures	4610.17	4611.0	4603.23	4603.23	15149.0
2023-05-25 07:00:00	ES	Futures	4603.23	4607.67	4599.07	4607.12	25982.0
2023-05-25 08:00:00	ES	Futures	4606.84	4621.82	4605.45	4619.32	74457.0
2023-05-25 09:00:00	ES	Futures	4619.6	4622.65	4592.14	4598.24	303154.0
2023-05-25 10:00:00	ES	Futures	4598.24	4607.95	4590.2	4605.18	274438.0
2023-05-25 11:00:00	ES	Futures	4605.18	4615.16	4592.42	4597.96	212937.0
2023-05-25 12:00:00	ES	Futures	4598.24	4614.33	4597.96	4604.62	150976.0
2023-05-25 13:00:00	ES	Futures	4604.62	4620.43	4601.57	4619.04	120304.0
2023-05-25 14:00:00	ES	Futures	4618.77	4632.36	4606.29	4609.34	211904.0
2023-05-25 15:00:00	ES	Futures	4609.34	4626.81	4608.78	4615.16	246043.0
2023-05-25 16:00:00	ES	Futures	4614.88	4616.82	4612.66	4613.77	66250.0
2023-05-25 18:00:00	ES	Futures	4611.83	4614.88	4607.67	4610.72	7298.0
2023-05-25 19:00:00	ES	Futures	4610.72	4611.55	4606.29	4606.84	5585.0
2023-05-25 20:00:00	ES	Futures	4607.12	4609.06	4605.18	4609.06	6904.0
2023-05-25 21:00:00	ES	Futures	4608.78	4609.89	4599.63	4607.39	9997.0
2023-05-25 22:00:00	ES	Futures	4607.67	4609.34	4604.34	4605.45	5305.0
2023-05-25 23:00:00	ES	Futures	4605.73	4608.23	4604.34	4605.45	4250.0
2023-05-25 00:00:00	NQ	Futures	15583.68	15590.44	15577.2	15578.89	1931.0
2023-05-25 01:00:00	NQ	Futures	15578.89	15591.0	15572.7	15577.77	4132.0
2023-05-25 02:00:00	NQ	Futures	15577.2	15626.76	15571.57	15621.97	9255.0
2023-05-25 03:00:00	NQ	Futures	15622.25	15623.66	15571.85	15589.31	12273.0
2023-05-25 04:00:00	NQ	Futures	15589.87	15638.02	15589.03	15636.89	11567.0
2023-05-25 05:00:00	NQ	Futures	15636.89	15662.79	15635.2	15660.82	11094.0
2023-05-25 06:00:00	NQ	Futures	15660.82	15679.69	15644.21	15647.87	11321.0
2023-05-25 07:00:00	NQ	Futures	15647.87	15690.1	15642.24	15689.82	17609.0
2023-05-25 08:00:00	NQ	Futures	15689.82	15733.46	15680.53	15725.58	34163.0
2023-05-25 09:00:00	NQ	Futures	15726.14	15739.94	15599.44	15627.6	138809.0
2023-05-25 10:00:00	NQ	Futures	15627.6	15693.77	15601.7	15690.95	115428.0
2023-05-25 11:00:00	NQ	Futures	15690.67	15752.05	15678.0	15703.34	100081.0
2023-05-25 12:00:00	NQ	Futures	15703.62	15771.76	15702.21	15737.97	72078.0
2023-05-25 13:00:00	NQ	Futures	15738.25	15770.35	15728.96	15756.83	44990.0
2023-05-25 14:00:00	NQ	Futures	15757.11	15802.16	15700.8	15708.69	74215.0
2023-05-25 15:00:00	NQ	Futures	15708.97	15793.72	15707.56	15742.47	82656.0
2023-05-25 16:00:00	NQ	Futures	15742.19	15759.37	15736.84	15746.13	17624.0
2023-05-25 18:00:00	NQ	Futures	15741.91	15753.45	15726.43	15736.56	3806.0
2023-05-25 19:00:00	NQ	Futures	15736.28	15739.38	15724.17	15728.11	2449.0
2023-05-25 20:00:00	NQ	Futures	15728.11	15732.06	15714.6	15731.49	3759.0
2023-05-25 21:00:00	NQ	Futures	15731.49	15734.87	15681.94	15719.67	7274.0
2023-05-25 22:00:00	NQ	Futures	15719.39	15727.83	15707.84	15715.16	3340.0
2023-05-25 23:00:00	NQ	Futures	15715.44	15721.36	15706.15	15712.07	2149.0
2023-05-25 00:00:00	YM	Futures	36223.2	36237.5	36206.6	36209.9	560.0
2023-05-25 01:00:00	YM	Futures	36211.0	36242.0	36204.4	36230.9	1088.0
2023-05-25 02:00:00	YM	Futures	36232.0	36322.6	36224.3	36291.7	2852.0
2023-05-25 03:00:00	YM	Futures	36292.8	36296.1	36140.3	36166.8	5185.0

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

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