PREVIEW / futures_1hour / 2023-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-04.parquet
  size:    69 KB
  rows:    2,070

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-04 00:00:00	ES	Futures	4562.46	4568.57	4559.14	4565.79	8102.0
2023-05-04 01:00:00	ES	Futures	4565.79	4568.29	4563.57	4566.62	7224.0
2023-05-04 02:00:00	ES	Futures	4566.62	4567.46	4557.47	4562.74	11204.0
2023-05-04 03:00:00	ES	Futures	4563.02	4566.07	4546.65	4563.85	32398.0
2023-05-04 04:00:00	ES	Futures	4563.85	4564.13	4552.48	4554.14	17535.0
2023-05-04 05:00:00	ES	Futures	4554.14	4558.86	4549.43	4550.81	17883.0
2023-05-04 06:00:00	ES	Futures	4550.54	4554.14	4541.66	4544.99	23695.0
2023-05-04 07:00:00	ES	Futures	4544.99	4545.82	4538.61	4542.22	25765.0
2023-05-04 08:00:00	ES	Futures	4541.94	4550.26	4533.34	4543.33	47766.0
2023-05-04 09:00:00	ES	Futures	4543.05	4548.6	4519.47	4527.52	240034.0
2023-05-04 10:00:00	ES	Futures	4527.52	4531.95	4508.1	4519.2	388797.0
2023-05-04 11:00:00	ES	Futures	4519.47	4538.06	4511.98	4513.93	208347.0
2023-05-04 12:00:00	ES	Futures	4513.65	4530.57	4506.72	4530.29	162752.0
2023-05-04 13:00:00	ES	Futures	4530.01	4545.27	4527.24	4534.17	170936.0
2023-05-04 14:00:00	ES	Futures	4534.17	4535.28	4516.7	4523.91	158486.0
2023-05-04 15:00:00	ES	Futures	4523.63	4535.56	4516.42	4523.36	270441.0
2023-05-04 16:00:00	ES	Futures	4523.08	4531.12	4516.98	4520.31	66910.0
2023-05-04 18:00:00	ES	Futures	4523.36	4535.56	4522.8	4535.28	11802.0
2023-05-04 19:00:00	ES	Futures	4535.28	4538.06	4532.79	4534.73	5936.0
2023-05-04 20:00:00	ES	Futures	4534.73	4541.38	4529.74	4538.61	7831.0
2023-05-04 21:00:00	ES	Futures	4538.61	4540.83	4536.11	4539.72	7010.0
2023-05-04 22:00:00	ES	Futures	4539.72	4540.0	4533.9	4536.95	6185.0
2023-05-04 23:00:00	ES	Futures	4536.95	4540.55	4536.67	4540.27	3477.0
2023-05-04 00:00:00	NQ	Futures	14808.84	14829.96	14797.02	14819.26	4622.0
2023-05-04 01:00:00	NQ	Futures	14819.54	14828.83	14809.97	14819.26	3735.0
2023-05-04 02:00:00	NQ	Futures	14819.54	14822.92	14788.57	14805.47	5713.0
2023-05-04 03:00:00	NQ	Futures	14806.31	14835.59	14755.07	14810.25	14896.0
2023-05-04 04:00:00	NQ	Futures	14809.97	14810.81	14777.03	14789.7	8051.0
2023-05-04 05:00:00	NQ	Futures	14789.42	14802.09	14763.51	14771.12	6329.0
2023-05-04 06:00:00	NQ	Futures	14771.12	14786.88	14753.94	14764.64	8171.0
2023-05-04 07:00:00	NQ	Futures	14766.05	14766.61	14740.99	14750.28	9636.0
2023-05-04 08:00:00	NQ	Futures	14751.13	14753.94	14709.74	14729.16	21565.0
2023-05-04 09:00:00	NQ	Futures	14728.88	14757.04	14671.16	14687.49	95988.0
2023-05-04 10:00:00	NQ	Futures	14687.78	14715.37	14642.73	14690.31	112718.0
2023-05-04 11:00:00	NQ	Futures	14690.59	14761.54	14680.17	14697.07	63300.0
2023-05-04 12:00:00	NQ	Futures	14696.79	14743.52	14675.39	14742.68	48135.0
2023-05-04 13:00:00	NQ	Futures	14742.68	14788.57	14730.57	14764.36	57782.0
2023-05-04 14:00:00	NQ	Futures	14764.08	14766.33	14688.62	14708.89	53073.0
2023-05-04 15:00:00	NQ	Futures	14708.89	14745.21	14684.4	14694.82	79848.0
2023-05-04 16:00:00	NQ	Futures	14694.82	14746.06	14670.32	14693.13	24151.0
2023-05-04 18:00:00	NQ	Futures	14708.33	14737.61	14703.54	14737.05	4821.0
2023-05-04 19:00:00	NQ	Futures	14737.05	14750.84	14729.16	14746.34	3372.0
2023-05-04 20:00:00	NQ	Futures	14746.34	14768.02	14731.42	14763.51	4369.0
2023-05-04 21:00:00	NQ	Futures	14763.23	14769.15	14754.5	14763.23	3255.0
2023-05-04 22:00:00	NQ	Futures	14764.08	14765.2	14746.62	14754.5	3071.0
2023-05-04 23:00:00	NQ	Futures	14755.35	14766.33	14753.1	14765.77	1318.0
2023-05-04 00:00:00	YM	Futures	37052.1	37089.7	37024.5	37072.0	2014.0
2023-05-04 01:00:00	YM	Futures	37072.0	37086.4	37055.5	37075.4	1202.0
2023-05-04 02:00:00	YM	Futures	37075.4	37082.0	37009.0	37049.9	2188.0
2023-05-04 03:00:00	YM	Futures	37051.0	37096.4	36931.7	37068.7	7339.0

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

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