PREVIEW / futures_1hour / 2023-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-12.parquet
  size:    63 KB
  rows:    1,944

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-06-12 00:00:00	ES	Futures	4781.3	4781.57	4779.35	4781.02	1761.0
2023-06-12 01:00:00	ES	Futures	4781.02	4784.07	4780.74	4784.07	2552.0
2023-06-12 02:00:00	ES	Futures	4783.79	4789.06	4782.13	4788.51	3755.0
2023-06-12 03:00:00	ES	Futures	4788.51	4792.39	4784.35	4791.83	11595.0
2023-06-12 04:00:00	ES	Futures	4792.11	4794.89	4789.89	4793.78	8999.0
2023-06-12 05:00:00	ES	Futures	4793.78	4795.99	4786.29	4787.67	6944.0
2023-06-12 06:00:00	ES	Futures	4787.67	4787.67	4780.46	4783.79	9595.0
2023-06-12 07:00:00	ES	Futures	4784.07	4790.17	4781.85	4788.51	6921.0
2023-06-12 08:00:00	ES	Futures	4788.51	4791.28	4782.96	4790.45	13879.0
2023-06-12 09:00:00	ES	Futures	4790.17	4791.28	4779.35	4787.12	64616.0
2023-06-12 10:00:00	ES	Futures	4787.12	4787.4	4778.24	4781.85	81233.0
2023-06-12 11:00:00	ES	Futures	4781.57	4789.89	4779.91	4788.51	41304.0
2023-06-12 12:00:00	ES	Futures	4788.51	4793.22	4787.12	4792.39	23309.0
2023-06-12 13:00:00	ES	Futures	4792.11	4796.55	4789.06	4795.99	26032.0
2023-06-12 14:00:00	ES	Futures	4795.99	4804.59	4793.78	4804.04	35007.0
2023-06-12 15:00:00	ES	Futures	4804.04	4820.12	4802.93	4818.74	114240.0
2023-06-12 16:00:00	ES	Futures	4818.74	4822.07	4814.02	4821.23	59048.0
2023-06-12 18:00:00	ES	Futures	4820.4	4824.01	4818.46	4822.9	1709.0
2023-06-12 19:00:00	ES	Futures	4823.18	4823.45	4817.63	4819.57	2510.0
2023-06-12 20:00:00	ES	Futures	4819.57	4821.23	4817.63	4818.18	2193.0
2023-06-12 21:00:00	ES	Futures	4818.18	4822.07	4817.63	4821.79	2538.0
2023-06-12 22:00:00	ES	Futures	4821.79	4822.9	4819.57	4822.62	1251.0
2023-06-12 23:00:00	ES	Futures	4822.62	4829.83	4822.07	4828.45	2873.0
2023-06-12 00:00:00	NQ	Futures	16429.46	16430.87	16417.64	16426.37	1244.0
2023-06-12 01:00:00	NQ	Futures	16426.93	16441.57	16424.68	16441.29	1625.0
2023-06-12 02:00:00	NQ	Futures	16440.44	16459.59	16433.97	16458.46	2158.0
2023-06-12 03:00:00	NQ	Futures	16457.62	16469.73	16441.29	16469.16	3438.0
2023-06-12 04:00:00	NQ	Futures	16469.44	16490.56	16460.15	16486.62	3872.0
2023-06-12 05:00:00	NQ	Futures	16487.46	16503.51	16465.5	16472.82	3454.0
2023-06-12 06:00:00	NQ	Futures	16472.82	16473.39	16444.1	16463.25	4192.0
2023-06-12 07:00:00	NQ	Futures	16463.25	16480.14	16453.11	16477.05	3445.0
2023-06-12 08:00:00	NQ	Futures	16475.64	16490.0	16446.92	16482.11	5820.0
2023-06-12 09:00:00	NQ	Futures	16482.4	16485.77	16443.26	16459.03	37431.0
2023-06-12 10:00:00	NQ	Futures	16459.31	16500.41	16423.83	16461.84	40744.0
2023-06-12 11:00:00	NQ	Futures	16461.0	16526.88	16446.07	16520.4	24083.0
2023-06-12 12:00:00	NQ	Futures	16520.69	16533.07	16498.73	16523.78	16253.0
2023-06-12 13:00:00	NQ	Futures	16523.5	16569.96	16518.43	16568.27	15439.0
2023-06-12 14:00:00	NQ	Futures	16568.27	16613.88	16555.88	16610.78	15836.0
2023-06-12 15:00:00	NQ	Futures	16611.06	16673.01	16598.96	16670.47	43411.0
2023-06-12 16:00:00	NQ	Futures	16670.75	16698.35	16659.49	16697.22	11262.0
2023-06-12 18:00:00	NQ	Futures	16694.97	16712.14	16683.42	16709.89	1447.0
2023-06-12 19:00:00	NQ	Futures	16710.45	16712.14	16684.55	16691.31	1686.0
2023-06-12 20:00:00	NQ	Futures	16690.18	16699.47	16681.73	16684.27	1452.0
2023-06-12 21:00:00	NQ	Futures	16684.83	16703.7	16682.02	16703.13	1431.0
2023-06-12 22:00:00	NQ	Futures	16703.7	16710.45	16694.12	16707.92	1568.0
2023-06-12 23:00:00	NQ	Futures	16707.07	16748.18	16703.98	16742.55	2670.0
2023-06-12 00:00:00	YM	Futures	37470.9	37472.0	37454.5	37468.7	472.0
2023-06-12 01:00:00	YM	Futures	37468.7	37486.3	37466.6	37483.0	853.0
2023-06-12 02:00:00	YM	Futures	37483.0	37520.2	37473.1	37518.0	974.0
2023-06-12 03:00:00	YM	Futures	37518.0	37570.6	37487.4	37558.6	2889.0

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

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