PREVIEW / futures_1hour / 2023-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-26.parquet
  size:    56 KB
  rows:    1,623

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-26 00:00:00	ES	Futures	4605.45	4607.95	4604.07	4606.56	3815.0
2023-05-26 01:00:00	ES	Futures	4606.84	4609.61	4604.9	4607.67	4670.0
2023-05-26 02:00:00	ES	Futures	4607.39	4617.38	4606.29	4615.44	9667.0
2023-05-26 03:00:00	ES	Futures	4615.44	4618.49	4602.12	4604.9	21900.0
2023-05-26 04:00:00	ES	Futures	4604.9	4613.77	4604.62	4611.28	11272.0
2023-05-26 05:00:00	ES	Futures	4611.28	4612.66	4605.45	4608.5	9636.0
2023-05-26 06:00:00	ES	Futures	4608.5	4624.04	4605.73	4623.48	17534.0
2023-05-26 07:00:00	ES	Futures	4623.48	4628.2	4622.09	4625.15	21084.0
2023-05-26 08:00:00	ES	Futures	4625.42	4627.64	4610.17	4622.65	52917.0
2023-05-26 09:00:00	ES	Futures	4622.37	4645.67	4620.98	4640.95	214973.0
2023-05-26 10:00:00	ES	Futures	4641.23	4672.57	4639.84	4667.3	320174.0
2023-05-26 11:00:00	ES	Futures	4667.58	4671.46	4655.1	4663.97	213029.0
2023-05-26 12:00:00	ES	Futures	4663.97	4674.24	4662.87	4671.46	126264.0
2023-05-26 13:00:00	ES	Futures	4671.74	4674.79	4665.08	4669.8	104134.0
2023-05-26 14:00:00	ES	Futures	4669.8	4679.78	4663.97	4676.18	126510.0
2023-05-26 15:00:00	ES	Futures	4676.18	4683.11	4672.3	4674.51	273535.0
2023-05-26 16:00:00	ES	Futures	4674.51	4682.28	4673.68	4680.89	91973.0
2023-05-26 00:00:00	NQ	Futures	15712.07	15718.82	15702.49	15714.6	2121.0
2023-05-26 01:00:00	NQ	Futures	15715.16	15730.37	15711.78	15723.61	2947.0
2023-05-26 02:00:00	NQ	Futures	15723.89	15757.68	15719.39	15747.82	6493.0
2023-05-26 03:00:00	NQ	Futures	15748.1	15749.51	15703.62	15716.57	9205.0
2023-05-26 04:00:00	NQ	Futures	15717.13	15762.46	15717.13	15755.14	7393.0
2023-05-26 05:00:00	NQ	Futures	15755.43	15757.4	15736.0	15744.44	4529.0
2023-05-26 06:00:00	NQ	Futures	15743.88	15794.28	15728.68	15789.77	10606.0
2023-05-26 07:00:00	NQ	Futures	15789.49	15817.37	15784.14	15801.04	11089.0
2023-05-26 08:00:00	NQ	Futures	15801.6	15813.43	15742.76	15792.31	24736.0
2023-05-26 09:00:00	NQ	Futures	15792.03	15906.62	15783.58	15900.43	99054.0
2023-05-26 10:00:00	NQ	Futures	15900.71	16070.2	15892.82	16053.87	139001.0
2023-05-26 11:00:00	NQ	Futures	16054.15	16106.52	16013.61	16089.63	101817.0
2023-05-26 12:00:00	NQ	Futures	16089.91	16135.8	16081.75	16127.92	62112.0
2023-05-26 13:00:00	NQ	Futures	16128.2	16146.22	16108.49	16125.67	49061.0
2023-05-26 14:00:00	NQ	Futures	16126.23	16163.11	16098.36	16146.22	50519.0
2023-05-26 15:00:00	NQ	Futures	16146.22	16181.98	16132.99	16142.0	89962.0
2023-05-26 16:00:00	NQ	Futures	16142.0	16182.54	16137.77	16180.57	21875.0
2023-05-26 00:00:00	YM	Futures	36209.9	36219.9	36197.7	36216.5	297.0
2023-05-26 01:00:00	YM	Futures	36216.5	36230.9	36202.2	36217.6	705.0
2023-05-26 02:00:00	YM	Futures	36216.5	36292.8	36208.8	36278.4	1980.0
2023-05-26 03:00:00	YM	Futures	36279.5	36317.1	36188.9	36211.0	3853.0
2023-05-26 04:00:00	YM	Futures	36209.9	36265.2	36203.3	36225.4	2366.0
2023-05-26 05:00:00	YM	Futures	36225.4	36238.6	36181.2	36202.2	1976.0
2023-05-26 06:00:00	YM	Futures	36201.1	36319.3	36188.9	36318.2	3141.0
2023-05-26 07:00:00	YM	Futures	36317.1	36339.2	36307.2	36327.1	3571.0
2023-05-26 08:00:00	YM	Futures	36328.2	36356.9	36242.0	36312.7	6640.0
2023-05-26 09:00:00	YM	Futures	36310.5	36569.1	36282.9	36480.7	28646.0
2023-05-26 10:00:00	YM	Futures	36480.7	36698.4	36435.4	36633.2	35311.0
2023-05-26 11:00:00	YM	Futures	36633.2	36660.9	36522.7	36560.3	19417.0
2023-05-26 12:00:00	YM	Futures	36562.5	36639.9	36557.0	36587.9	12155.0
2023-05-26 13:00:00	YM	Futures	36589.0	36606.7	36534.9	36581.3	8682.0
2023-05-26 14:00:00	YM	Futures	36582.4	36653.1	36548.1	36621.1	9751.0
2023-05-26 15:00:00	YM	Futures	36622.2	36666.4	36601.2	36616.7	19045.0

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

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