PREVIEW / futures_1hour / 2023-01-04

all futures 1-hour files

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

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-01-04 00:00:00	ES	Futures	4309.58	4310.97	4304.82	4308.18	5906.0
2023-01-04 01:00:00	ES	Futures	4308.18	4310.69	4302.87	4309.58	5698.0
2023-01-04 02:00:00	ES	Futures	4309.58	4314.89	4308.18	4314.05	13676.0
2023-01-04 03:00:00	ES	Futures	4314.05	4324.12	4313.21	4318.24	35070.0
2023-01-04 04:00:00	ES	Futures	4318.52	4320.2	4312.93	4317.68	18425.0
2023-01-04 05:00:00	ES	Futures	4317.96	4323.0	4309.86	4314.33	13512.0
2023-01-04 06:00:00	ES	Futures	4314.33	4322.72	4313.77	4316.85	15310.0
2023-01-04 07:00:00	ES	Futures	4316.85	4318.24	4306.78	4311.53	19971.0
2023-01-04 08:00:00	ES	Futures	4311.81	4328.31	4310.14	4324.12	41401.0
2023-01-04 09:00:00	ES	Futures	4324.12	4338.1	4312.37	4328.03	216476.0
2023-01-04 10:00:00	ES	Futures	4327.47	4339.49	4290.84	4324.67	327766.0
2023-01-04 11:00:00	ES	Futures	4324.67	4357.67	4317.13	4353.19	207438.0
2023-01-04 12:00:00	ES	Futures	4353.47	4356.27	4340.05	4340.05	125751.0
2023-01-04 13:00:00	ES	Futures	4340.33	4351.52	4332.5	4339.21	120268.0
2023-01-04 14:00:00	ES	Futures	4338.93	4354.31	4303.7	4327.47	319277.0
2023-01-04 15:00:00	ES	Futures	4327.75	4337.26	4303.98	4332.5	269609.0
2023-01-04 16:00:00	ES	Futures	4332.5	4335.02	4325.79	4329.71	56796.0
2023-01-04 18:00:00	ES	Futures	4329.43	4334.74	4327.19	4331.11	8103.0
2023-01-04 19:00:00	ES	Futures	4331.39	4333.62	4328.31	4328.59	7596.0
2023-01-04 20:00:00	ES	Futures	4328.59	4333.62	4326.63	4329.15	13547.0
2023-01-04 21:00:00	ES	Futures	4329.15	4329.43	4314.05	4319.36	15678.0
2023-01-04 22:00:00	ES	Futures	4319.64	4323.56	4317.96	4321.04	6692.0
2023-01-04 23:00:00	ES	Futures	4321.04	4332.5	4320.76	4331.11	8358.0
2023-01-04 00:00:00	NQ	Futures	12498.39	12504.94	12481.89	12492.42	2310.0
2023-01-04 01:00:00	NQ	Futures	12491.85	12499.53	12477.91	12497.82	2433.0
2023-01-04 02:00:00	NQ	Futures	12497.54	12522.29	12491.28	12514.89	4664.0
2023-01-04 03:00:00	NQ	Futures	12515.18	12576.06	12511.2	12539.64	13519.0
2023-01-04 04:00:00	NQ	Futures	12540.21	12544.77	12511.2	12521.15	10660.0
2023-01-04 05:00:00	NQ	Futures	12522.29	12545.9	12486.73	12512.33	8851.0
2023-01-04 06:00:00	NQ	Futures	12512.05	12550.17	12510.06	12529.4	7662.0
2023-01-04 07:00:00	NQ	Futures	12530.26	12531.68	12486.73	12507.5	10636.0
2023-01-04 08:00:00	NQ	Futures	12508.07	12572.36	12502.66	12545.9	19502.0
2023-01-04 09:00:00	NQ	Futures	12545.62	12570.65	12465.96	12495.55	103761.0
2023-01-04 10:00:00	NQ	Futures	12496.69	12538.51	12362.4	12477.91	132723.0
2023-01-04 11:00:00	NQ	Futures	12478.19	12595.69	12450.6	12571.51	85261.0
2023-01-04 12:00:00	NQ	Futures	12571.22	12585.45	12520.87	12521.72	45809.0
2023-01-04 13:00:00	NQ	Futures	12522.01	12569.52	12490.71	12532.53	47791.0
2023-01-04 14:00:00	NQ	Futures	12536.23	12590.57	12405.65	12510.06	124733.0
2023-01-04 15:00:00	NQ	Futures	12511.2	12542.49	12411.05	12513.76	96226.0
2023-01-04 16:00:00	NQ	Futures	12513.47	12522.86	12487.3	12499.25	14454.0
2023-01-04 18:00:00	NQ	Futures	12504.65	12525.14	12502.09	12513.47	3976.0
2023-01-04 19:00:00	NQ	Futures	12513.47	12516.89	12496.12	12497.54	3246.0
2023-01-04 20:00:00	NQ	Futures	12497.26	12512.9	12490.43	12495.55	3610.0
2023-01-04 21:00:00	NQ	Futures	12495.26	12496.12	12442.63	12464.25	5342.0
2023-01-04 22:00:00	NQ	Futures	12463.97	12475.92	12449.74	12463.68	3005.0
2023-01-04 23:00:00	NQ	Futures	12463.97	12503.51	12463.68	12499.25	3496.0
2023-01-04 00:00:00	YM	Futures	37117.9	37126.8	37087.8	37108.9	754.0
2023-01-04 01:00:00	YM	Futures	37110.1	37127.9	37067.7	37114.5	921.0
2023-01-04 02:00:00	YM	Futures	37113.4	37154.6	37102.3	37139.0	1816.0
2023-01-04 03:00:00	YM	Futures	37137.9	37212.6	37134.6	37180.2	5105.0

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

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