PREVIEW / futures_1hour / 2022-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-12-27.parquet
  size:    62 KB
  rows:    1,866

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
2022-12-27 00:00:00	ES	Futures	4356.27	4357.39	4354.31	4355.99	2560.0
2022-12-27 01:00:00	ES	Futures	4355.99	4356.83	4352.08	4356.27	4451.0
2022-12-27 02:00:00	ES	Futures	4356.55	4357.67	4350.68	4355.99	8686.0
2022-12-27 03:00:00	ES	Futures	4355.99	4362.42	4355.43	4355.99	11646.0
2022-12-27 04:00:00	ES	Futures	4355.99	4358.79	4348.16	4357.95	8856.0
2022-12-27 05:00:00	ES	Futures	4357.95	4361.02	4356.83	4357.39	6954.0
2022-12-27 06:00:00	ES	Futures	4357.39	4358.51	4354.03	4355.43	6416.0
2022-12-27 07:00:00	ES	Futures	4355.43	4355.99	4343.41	4346.2	16598.0
2022-12-27 08:00:00	ES	Futures	4346.2	4350.12	4329.71	4330.27	32815.0
2022-12-27 09:00:00	ES	Futures	4330.27	4334.46	4296.15	4301.75	136356.0
2022-12-27 10:00:00	ES	Futures	4301.75	4331.66	4291.68	4317.68	186182.0
2022-12-27 11:00:00	ES	Futures	4317.96	4328.87	4314.05	4322.16	102197.0
2022-12-27 12:00:00	ES	Futures	4322.16	4331.39	4312.37	4319.36	75731.0
2022-12-27 13:00:00	ES	Futures	4319.64	4325.79	4307.06	4309.02	68049.0
2022-12-27 14:00:00	ES	Futures	4309.3	4314.89	4301.19	4310.69	87390.0
2022-12-27 15:00:00	ES	Futures	4310.97	4322.44	4308.18	4312.37	150531.0
2022-12-27 16:00:00	ES	Futures	4312.37	4316.57	4311.53	4312.65	31278.0
2022-12-27 18:00:00	ES	Futures	4314.89	4316.85	4310.69	4311.53	4553.0
2022-12-27 19:00:00	ES	Futures	4312.09	4315.73	4306.78	4308.46	8540.0
2022-12-27 20:00:00	ES	Futures	4308.18	4318.24	4307.06	4317.68	7128.0
2022-12-27 21:00:00	ES	Futures	4317.4	4318.8	4312.09	4312.37	5619.0
2022-12-27 22:00:00	ES	Futures	4312.09	4315.73	4310.97	4313.21	3590.0
2022-12-27 23:00:00	ES	Futures	4313.49	4316.01	4312.93	4315.73	2905.0
2022-12-27 00:00:00	NQ	Futures	12703.51	12708.07	12697.25	12701.52	1401.0
2022-12-27 01:00:00	NQ	Futures	12700.67	12704.94	12687.87	12701.52	2548.0
2022-12-27 02:00:00	NQ	Futures	12702.38	12702.94	12680.75	12698.39	3522.0
2022-12-27 03:00:00	NQ	Futures	12699.53	12719.16	12692.42	12692.42	5480.0
2022-12-27 04:00:00	NQ	Futures	12692.99	12694.13	12650.6	12681.32	6623.0
2022-12-27 05:00:00	NQ	Futures	12681.89	12692.42	12672.22	12674.49	4533.0
2022-12-27 06:00:00	NQ	Futures	12674.21	12683.88	12660.55	12669.37	3997.0
2022-12-27 07:00:00	NQ	Futures	12669.94	12670.23	12606.5	12617.88	9664.0
2022-12-27 08:00:00	NQ	Futures	12618.45	12636.94	12563.54	12580.61	16482.0
2022-12-27 09:00:00	NQ	Futures	12580.61	12605.08	12409.35	12438.36	74521.0
2022-12-27 10:00:00	NQ	Futures	12438.08	12537.94	12399.39	12486.44	93083.0
2022-12-27 11:00:00	NQ	Futures	12486.73	12514.32	12459.42	12477.63	53202.0
2022-12-27 12:00:00	NQ	Futures	12478.48	12513.19	12435.8	12461.69	45978.0
2022-12-27 13:00:00	NQ	Futures	12461.98	12482.18	12417.31	12424.99	35812.0
2022-12-27 14:00:00	NQ	Futures	12425.28	12446.9	12403.66	12430.4	41582.0
2022-12-27 15:00:00	NQ	Futures	12430.68	12470.8	12413.9	12425.28	65387.0
2022-12-27 16:00:00	NQ	Futures	12425.28	12442.06	12417.31	12417.6	11567.0
2022-12-27 18:00:00	NQ	Futures	12421.86	12433.24	12413.61	12418.73	2619.0
2022-12-27 19:00:00	NQ	Futures	12419.3	12432.96	12394.27	12399.96	4563.0
2022-12-27 20:00:00	NQ	Futures	12399.1	12447.18	12396.26	12445.19	4283.0
2022-12-27 21:00:00	NQ	Futures	12444.91	12447.47	12425.85	12426.42	3231.0
2022-12-27 22:00:00	NQ	Futures	12427.27	12437.23	12420.44	12426.99	2220.0
2022-12-27 23:00:00	NQ	Futures	12427.55	12435.52	12425.56	12432.11	1444.0
2022-12-27 00:00:00	YM	Futures	37373.0	37378.6	37357.4	37364.1	438.0
2022-12-27 01:00:00	YM	Futures	37363.0	37374.1	37336.2	37371.9	757.0
2022-12-27 02:00:00	YM	Futures	37371.9	37381.9	37332.9	37364.1	1385.0
2022-12-27 03:00:00	YM	Futures	37366.3	37419.8	37359.6	37385.3	2084.0

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

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