PREVIEW / futures_1hour / 2023-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-27.parquet
  size:    68 KB
  rows:    2,051

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-03-27 00:00:00	ES	Futures	4462.34	4462.89	4458.18	4461.23	4603.0
2023-03-27 01:00:00	ES	Futures	4460.95	4465.39	4458.46	4462.89	9300.0
2023-03-27 02:00:00	ES	Futures	4462.89	4467.05	4459.01	4462.89	13769.0
2023-03-27 03:00:00	ES	Futures	4462.89	4467.33	4434.88	4441.26	35554.0
2023-03-27 04:00:00	ES	Futures	4441.54	4456.24	4440.43	4452.63	20536.0
2023-03-27 05:00:00	ES	Futures	4452.63	4460.4	4449.58	4458.18	12937.0
2023-03-27 06:00:00	ES	Futures	4457.9	4468.72	4457.9	4464.56	17182.0
2023-03-27 07:00:00	ES	Futures	4464.28	4475.1	4464.0	4469.55	29978.0
2023-03-27 08:00:00	ES	Futures	4469.83	4472.88	4463.73	4465.11	24742.0
2023-03-27 09:00:00	ES	Futures	4465.39	4475.65	4458.18	4465.39	165408.0
2023-03-27 10:00:00	ES	Futures	4465.67	4467.61	4445.14	4446.81	190262.0
2023-03-27 11:00:00	ES	Futures	4447.36	4452.63	4437.93	4442.37	136217.0
2023-03-27 12:00:00	ES	Futures	4442.37	4453.74	4438.21	4447.64	101410.0
2023-03-27 13:00:00	ES	Futures	4447.92	4460.4	4443.2	4452.08	95607.0
2023-03-27 14:00:00	ES	Futures	4452.08	4467.05	4447.08	4465.94	89821.0
2023-03-27 15:00:00	ES	Futures	4465.94	4468.44	4441.54	4449.03	196683.0
2023-03-27 16:00:00	ES	Futures	4448.75	4454.57	4447.64	4454.3	39064.0
2023-03-27 18:00:00	ES	Futures	4452.63	4453.46	4449.03	4452.91	3123.0
2023-03-27 19:00:00	ES	Futures	4452.91	4455.13	4452.35	4454.3	3121.0
2023-03-27 20:00:00	ES	Futures	4454.3	4454.57	4449.3	4451.8	5006.0
2023-03-27 21:00:00	ES	Futures	4451.8	4454.57	4448.19	4448.75	7523.0
2023-03-27 22:00:00	ES	Futures	4448.75	4453.46	4446.53	4452.08	6253.0
2023-03-27 23:00:00	ES	Futures	4452.35	4454.02	4452.08	4452.63	2795.0
2023-03-27 00:00:00	NQ	Futures	14585.29	14588.39	14566.15	14575.44	2417.0
2023-03-27 01:00:00	NQ	Futures	14575.15	14623.3	14568.4	14597.4	5832.0
2023-03-27 02:00:00	NQ	Futures	14597.4	14600.78	14566.15	14578.82	6394.0
2023-03-27 03:00:00	NQ	Futures	14579.1	14585.29	14470.42	14494.35	15399.0
2023-03-27 04:00:00	NQ	Futures	14494.63	14546.44	14491.25	14539.12	9058.0
2023-03-27 05:00:00	NQ	Futures	14538.83	14563.89	14525.04	14548.13	6773.0
2023-03-27 06:00:00	NQ	Futures	14548.13	14575.72	14547.56	14560.51	6476.0
2023-03-27 07:00:00	NQ	Futures	14560.23	14592.89	14558.54	14577.69	10615.0
2023-03-27 08:00:00	NQ	Futures	14578.25	14586.14	14540.81	14545.59	11544.0
2023-03-27 09:00:00	NQ	Futures	14545.87	14601.62	14506.46	14564.46	76579.0
2023-03-27 10:00:00	NQ	Futures	14564.74	14582.48	14481.4	14485.9	76585.0
2023-03-27 11:00:00	NQ	Futures	14485.9	14493.5	14386.8	14394.68	64773.0
2023-03-27 12:00:00	NQ	Futures	14395.24	14436.35	14376.66	14404.82	58630.0
2023-03-27 13:00:00	NQ	Futures	14405.38	14454.37	14379.76	14422.83	47560.0
2023-03-27 14:00:00	NQ	Futures	14422.27	14483.09	14403.13	14478.86	43668.0
2023-03-27 15:00:00	NQ	Futures	14478.86	14492.94	14388.77	14415.51	72992.0
2023-03-27 16:00:00	NQ	Futures	14415.23	14436.07	14412.42	14431.56	12791.0
2023-03-27 18:00:00	NQ	Futures	14427.34	14434.1	14417.49	14432.69	2021.0
2023-03-27 19:00:00	NQ	Futures	14432.41	14445.08	14430.72	14441.14	2095.0
2023-03-27 20:00:00	NQ	Futures	14441.14	14441.98	14424.52	14428.75	2171.0
2023-03-27 21:00:00	NQ	Futures	14429.31	14441.42	14413.54	14413.83	4087.0
2023-03-27 22:00:00	NQ	Futures	14414.39	14430.16	14405.38	14429.31	3351.0
2023-03-27 23:00:00	NQ	Futures	14428.75	14432.69	14422.83	14425.93	1916.0
2023-03-27 00:00:00	YM	Futures	36015.4	36019.8	35987.7	36005.4	687.0
2023-03-27 01:00:00	YM	Futures	36005.4	36023.1	35984.4	36006.5	1568.0
2023-03-27 02:00:00	YM	Futures	36007.6	36056.3	36001.0	36028.6	2766.0
2023-03-27 03:00:00	YM	Futures	36027.5	36083.9	35831.9	35879.4	6422.0

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

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