PREVIEW / futures_1hour / 2023-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-12.parquet
  size:    67 KB
  rows:    2,054

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-12 00:00:00	ES	Futures	4589.92	4592.14	4589.37	4590.48	3144.0
2023-04-12 01:00:00	ES	Futures	4590.75	4592.42	4590.2	4592.14	3753.0
2023-04-12 02:00:00	ES	Futures	4592.42	4592.69	4586.04	4587.98	9644.0
2023-04-12 03:00:00	ES	Futures	4587.98	4592.97	4586.87	4591.86	15205.0
2023-04-12 04:00:00	ES	Futures	4591.86	4598.24	4591.59	4593.25	12413.0
2023-04-12 05:00:00	ES	Futures	4593.25	4598.52	4591.31	4597.69	10081.0
2023-04-12 06:00:00	ES	Futures	4597.41	4600.18	4594.91	4595.75	10699.0
2023-04-12 07:00:00	ES	Futures	4595.75	4599.63	4593.53	4599.07	13131.0
2023-04-12 08:00:00	ES	Futures	4599.07	4634.85	4587.43	4615.44	138874.0
2023-04-12 09:00:00	ES	Futures	4615.72	4619.88	4593.8	4600.46	239104.0
2023-04-12 10:00:00	ES	Futures	4600.46	4612.94	4581.88	4582.71	279203.0
2023-04-12 11:00:00	ES	Futures	4582.99	4597.41	4571.89	4596.02	188705.0
2023-04-12 12:00:00	ES	Futures	4596.02	4603.23	4594.91	4602.12	113950.0
2023-04-12 13:00:00	ES	Futures	4602.12	4609.06	4597.41	4601.85	116218.0
2023-04-12 14:00:00	ES	Futures	4601.85	4609.06	4575.5	4581.05	272880.0
2023-04-12 15:00:00	ES	Futures	4581.32	4585.76	4563.57	4571.62	297136.0
2023-04-12 16:00:00	ES	Futures	4571.62	4573.0	4566.9	4567.73	51800.0
2023-04-12 18:00:00	ES	Futures	4568.01	4568.29	4561.35	4562.46	8178.0
2023-04-12 19:00:00	ES	Futures	4562.46	4564.96	4559.97	4561.35	6882.0
2023-04-12 20:00:00	ES	Futures	4561.35	4567.18	4560.8	4566.9	8241.0
2023-04-12 21:00:00	ES	Futures	4566.9	4569.67	4564.96	4569.12	7720.0
2023-04-12 22:00:00	ES	Futures	4569.12	4573.28	4568.84	4571.34	7247.0
2023-04-12 23:00:00	ES	Futures	4571.62	4574.11	4571.62	4573.0	4077.0
2023-04-12 00:00:00	NQ	Futures	14722.97	14736.48	14719.87	14725.5	2145.0
2023-04-12 01:00:00	NQ	Futures	14725.22	14730.57	14721.0	14727.19	1984.0
2023-04-12 02:00:00	NQ	Futures	14726.91	14728.88	14695.1	14707.2	5946.0
2023-04-12 03:00:00	NQ	Futures	14706.92	14713.12	14684.12	14710.58	7121.0
2023-04-12 04:00:00	NQ	Futures	14710.86	14743.52	14708.89	14727.76	7487.0
2023-04-12 05:00:00	NQ	Futures	14727.48	14747.75	14716.49	14741.55	5445.0
2023-04-12 06:00:00	NQ	Futures	14742.4	14754.22	14717.62	14720.15	5844.0
2023-04-12 07:00:00	NQ	Futures	14721.0	14747.47	14712.55	14745.21	7180.0
2023-04-12 08:00:00	NQ	Futures	14744.65	14913.02	14697.63	14836.72	56839.0
2023-04-12 09:00:00	NQ	Futures	14837.0	14855.02	14678.48	14714.24	103471.0
2023-04-12 10:00:00	NQ	Futures	14713.96	14786.04	14647.51	14650.89	111489.0
2023-04-12 11:00:00	NQ	Futures	14651.46	14729.16	14613.45	14721.28	74658.0
2023-04-12 12:00:00	NQ	Futures	14721.56	14744.37	14711.43	14737.05	47055.0
2023-04-12 13:00:00	NQ	Futures	14737.33	14763.51	14705.8	14715.93	45634.0
2023-04-12 14:00:00	NQ	Futures	14715.93	14743.52	14622.46	14643.01	85429.0
2023-04-12 15:00:00	NQ	Futures	14643.01	14660.75	14570.65	14593.74	83176.0
2023-04-12 16:00:00	NQ	Futures	14594.02	14599.65	14586.42	14592.89	13272.0
2023-04-12 18:00:00	NQ	Futures	14592.33	14592.89	14563.33	14569.81	3768.0
2023-04-12 19:00:00	NQ	Futures	14570.09	14583.88	14556.85	14563.33	3334.0
2023-04-12 20:00:00	NQ	Futures	14564.17	14594.86	14561.92	14593.74	4500.0
2023-04-12 21:00:00	NQ	Futures	14593.17	14599.09	14584.16	14597.4	3706.0
2023-04-12 22:00:00	NQ	Futures	14597.68	14615.98	14595.43	14605.28	3318.0
2023-04-12 23:00:00	NQ	Futures	14605.28	14615.42	14603.31	14610.35	1713.0
2023-04-12 00:00:00	YM	Futures	37435.7	37450.1	37435.7	37441.2	649.0
2023-04-12 01:00:00	YM	Futures	37442.3	37458.9	37442.3	37457.8	666.0
2023-04-12 02:00:00	YM	Futures	37456.7	37461.1	37424.6	37439.0	2137.0
2023-04-12 03:00:00	YM	Futures	37440.1	37488.7	37429.1	37472.2	3489.0

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

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