PREVIEW / futures_1hour / 2023-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-19.parquet
  size:    69 KB
  rows:    2,090

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-10-19 00:00:00	ES	Futures	4706.38	4710.72	4706.11	4709.64	4528.0
2023-10-19 01:00:00	ES	Futures	4709.91	4711.27	4703.93	4705.83	8059.0
2023-10-19 02:00:00	ES	Futures	4705.83	4712.08	4703.93	4709.64	14563.0
2023-10-19 03:00:00	ES	Futures	4709.37	4716.15	4693.34	4699.86	39218.0
2023-10-19 04:00:00	ES	Futures	4699.86	4706.11	4698.23	4700.95	24167.0
2023-10-19 05:00:00	ES	Futures	4701.22	4714.8	4699.59	4714.52	18608.0
2023-10-19 06:00:00	ES	Futures	4714.25	4722.67	4712.62	4721.59	24477.0
2023-10-19 07:00:00	ES	Futures	4721.59	4722.4	4707.74	4710.18	30807.0
2023-10-19 08:00:00	ES	Futures	4710.18	4726.74	4708.55	4724.3	65615.0
2023-10-19 09:00:00	ES	Futures	4724.57	4727.83	4713.98	4720.5	205605.0
2023-10-19 10:00:00	ES	Futures	4720.23	4724.3	4697.42	4700.4	305846.0
2023-10-19 11:00:00	ES	Futures	4700.4	4719.96	4694.97	4712.08	210885.0
2023-10-19 12:00:00	ES	Futures	4712.08	4743.04	4687.1	4723.49	614579.0
2023-10-19 13:00:00	ES	Futures	4723.49	4738.42	4700.95	4706.11	327976.0
2023-10-19 14:00:00	ES	Futures	4705.83	4712.08	4674.61	4678.14	286960.0
2023-10-19 15:00:00	ES	Futures	4678.14	4685.2	4665.1	4672.43	341851.0
2023-10-19 16:00:00	ES	Futures	4672.16	4673.52	4662.93	4667.0	82424.0
2023-10-19 18:00:00	ES	Futures	4665.37	4668.63	4662.39	4663.47	9510.0
2023-10-19 19:00:00	ES	Futures	4663.47	4665.92	4660.48	4665.37	7747.0
2023-10-19 20:00:00	ES	Futures	4665.37	4667.0	4660.48	4665.1	13875.0
2023-10-19 21:00:00	ES	Futures	4664.83	4665.64	4657.5	4663.74	12209.0
2023-10-19 22:00:00	ES	Futures	4663.47	4669.45	4662.66	4669.45	9241.0
2023-10-19 23:00:00	ES	Futures	4669.17	4669.45	4665.92	4667.0	6840.0
2023-10-19 00:00:00	NQ	Futures	16475.18	16494.41	16475.18	16493.31	3306.0
2023-10-19 01:00:00	NQ	Futures	16493.58	16495.23	16460.9	16469.14	6071.0
2023-10-19 02:00:00	NQ	Futures	16468.86	16491.39	16458.98	16482.32	7091.0
2023-10-19 03:00:00	NQ	Futures	16482.87	16517.21	16410.64	16452.66	20331.0
2023-10-19 04:00:00	NQ	Futures	16452.11	16488.37	16447.17	16468.86	13792.0
2023-10-19 05:00:00	NQ	Futures	16468.86	16528.74	16463.65	16527.37	9067.0
2023-10-19 06:00:00	NQ	Futures	16526.54	16556.21	16517.21	16547.69	12301.0
2023-10-19 07:00:00	NQ	Futures	16547.69	16551.54	16504.02	16516.38	13319.0
2023-10-19 08:00:00	NQ	Futures	16516.66	16578.73	16505.67	16571.04	30420.0
2023-10-19 09:00:00	NQ	Futures	16571.04	16599.61	16503.2	16543.57	101724.0
2023-10-19 10:00:00	NQ	Futures	16542.75	16597.68	16475.18	16495.78	125828.0
2023-10-19 11:00:00	NQ	Futures	16496.33	16550.17	16442.77	16520.78	86667.0
2023-10-19 12:00:00	NQ	Futures	16521.05	16631.74	16397.73	16541.1	209554.0
2023-10-19 13:00:00	NQ	Futures	16541.1	16610.04	16448.27	16469.96	117356.0
2023-10-19 14:00:00	NQ	Futures	16469.69	16501.0	16352.96	16361.75	97021.0
2023-10-19 15:00:00	NQ	Futures	16362.02	16401.85	16317.52	16354.33	98834.0
2023-10-19 16:00:00	NQ	Futures	16354.6	16357.9	16303.52	16315.6	22322.0
2023-10-19 18:00:00	NQ	Futures	16315.05	16320.0	16290.33	16296.38	5496.0
2023-10-19 19:00:00	NQ	Futures	16296.38	16309.29	16283.19	16307.91	4069.0
2023-10-19 20:00:00	NQ	Futures	16307.91	16320.55	16290.61	16313.13	5947.0
2023-10-19 21:00:00	NQ	Futures	16312.86	16315.05	16279.35	16299.95	6390.0
2023-10-19 22:00:00	NQ	Futures	16300.22	16320.55	16296.65	16320.0	5106.0
2023-10-19 23:00:00	NQ	Futures	16319.72	16321.92	16307.09	16311.76	3279.0
2023-10-19 00:00:00	YM	Futures	36608.5	36633.5	36605.3	36629.1	864.0
2023-10-19 01:00:00	YM	Futures	36629.1	36638.9	36597.7	36608.5	1352.0
2023-10-19 02:00:00	YM	Futures	36608.5	36654.1	36598.8	36631.3	2425.0
2023-10-19 03:00:00	YM	Futures	36631.3	36670.4	36534.8	36558.6	6369.0

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

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