PREVIEW / futures_1hour / 2023-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-26.parquet
  size:    68 KB
  rows:    2,076

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-04-26 00:00:00	ES	Futures	4559.14	4561.08	4558.03	4560.52	6283.0
2023-04-26 01:00:00	ES	Futures	4560.52	4565.79	4559.97	4564.68	6991.0
2023-04-26 02:00:00	ES	Futures	4564.96	4565.24	4559.97	4562.74	8921.0
2023-04-26 03:00:00	ES	Futures	4562.74	4563.57	4549.43	4555.53	26645.0
2023-04-26 04:00:00	ES	Futures	4555.53	4561.63	4547.76	4560.24	22217.0
2023-04-26 05:00:00	ES	Futures	4560.24	4562.19	4550.81	4554.42	15650.0
2023-04-26 06:00:00	ES	Futures	4554.7	4558.86	4544.71	4547.49	22880.0
2023-04-26 07:00:00	ES	Futures	4547.49	4553.87	4536.67	4544.99	56550.0
2023-04-26 08:00:00	ES	Futures	4544.71	4555.53	4543.05	4554.14	29920.0
2023-04-26 09:00:00	ES	Futures	4554.42	4556.64	4542.49	4548.87	203974.0
2023-04-26 10:00:00	ES	Futures	4549.15	4549.98	4527.79	4541.38	283051.0
2023-04-26 11:00:00	ES	Futures	4541.66	4556.36	4541.38	4553.87	190151.0
2023-04-26 12:00:00	ES	Futures	4553.87	4559.41	4544.44	4546.65	137270.0
2023-04-26 13:00:00	ES	Futures	4546.65	4549.98	4527.52	4530.84	150179.0
2023-04-26 14:00:00	ES	Futures	4530.84	4531.4	4517.53	4520.58	203370.0
2023-04-26 15:00:00	ES	Futures	4520.31	4527.24	4513.93	4520.58	256806.0
2023-04-26 16:00:00	ES	Futures	4520.58	4533.9	4519.47	4532.51	72756.0
2023-04-26 18:00:00	ES	Futures	4532.51	4533.62	4528.9	4531.68	4626.0
2023-04-26 19:00:00	ES	Futures	4531.68	4532.79	4529.46	4532.23	3379.0
2023-04-26 20:00:00	ES	Futures	4532.51	4532.51	4528.35	4530.57	5360.0
2023-04-26 21:00:00	ES	Futures	4530.29	4532.23	4527.24	4530.84	4863.0
2023-04-26 22:00:00	ES	Futures	4530.84	4534.17	4529.74	4532.79	4479.0
2023-04-26 23:00:00	ES	Futures	4532.79	4533.62	4531.12	4531.68	2702.0
2023-04-26 00:00:00	NQ	Futures	14607.53	14611.48	14601.62	14609.22	3905.0
2023-04-26 01:00:00	NQ	Futures	14609.22	14632.31	14608.38	14632.03	3747.0
2023-04-26 02:00:00	NQ	Futures	14631.75	14634.84	14604.72	14615.98	5065.0
2023-04-26 03:00:00	NQ	Futures	14615.98	14616.26	14580.22	14603.59	11487.0
2023-04-26 04:00:00	NQ	Futures	14603.03	14616.82	14574.31	14610.07	10435.0
2023-04-26 05:00:00	NQ	Futures	14610.91	14614.85	14592.89	14607.82	6576.0
2023-04-26 06:00:00	NQ	Futures	14608.1	14613.73	14554.32	14562.49	10238.0
2023-04-26 07:00:00	NQ	Futures	14562.77	14570.37	14511.52	14520.82	24081.0
2023-04-26 08:00:00	NQ	Futures	14520.25	14589.51	14518.56	14582.48	18269.0
2023-04-26 09:00:00	NQ	Futures	14582.76	14601.06	14527.29	14596.55	102478.0
2023-04-26 10:00:00	NQ	Futures	14596.55	14604.15	14524.19	14575.44	110397.0
2023-04-26 11:00:00	NQ	Futures	14575.72	14636.82	14572.34	14625.83	84354.0
2023-04-26 12:00:00	NQ	Futures	14626.12	14654.55	14580.79	14590.36	66211.0
2023-04-26 13:00:00	NQ	Futures	14590.64	14605.28	14534.89	14552.07	61667.0
2023-04-26 14:00:00	NQ	Futures	14552.35	14556.01	14503.64	14514.06	69927.0
2023-04-26 15:00:00	NQ	Futures	14514.34	14537.71	14487.31	14508.43	78142.0
2023-04-26 16:00:00	NQ	Futures	14508.15	14609.79	14506.17	14596.27	32290.0
2023-04-26 18:00:00	NQ	Futures	14601.34	14606.41	14583.88	14590.64	3625.0
2023-04-26 19:00:00	NQ	Futures	14590.64	14594.02	14577.97	14591.77	2039.0
2023-04-26 20:00:00	NQ	Futures	14592.61	14592.61	14573.75	14580.22	3201.0
2023-04-26 21:00:00	NQ	Futures	14580.22	14588.39	14568.68	14583.32	3231.0
2023-04-26 22:00:00	NQ	Futures	14582.48	14596.27	14579.1	14590.36	3162.0
2023-04-26 23:00:00	NQ	Futures	14590.36	14594.86	14586.14	14587.26	1793.0
2023-04-26 00:00:00	YM	Futures	37233.4	37247.8	37226.8	37246.7	923.0
2023-04-26 01:00:00	YM	Futures	37245.6	37278.7	37235.6	37267.7	1371.0
2023-04-26 02:00:00	YM	Futures	37266.6	37273.2	37235.6	37256.6	1771.0
2023-04-26 03:00:00	YM	Futures	37257.7	37273.2	37128.4	37183.7	4872.0

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

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