PREVIEW / futures_1hour / 2022-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-23.parquet
  size:    67 KB
  rows:    2,032

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-05-23 00:00:00	ES	Futures	4455.96	4465.32	4454.83	4457.1	5621.0
2022-05-23 01:00:00	ES	Futures	4457.66	4476.65	4455.11	4468.72	13249.0
2022-05-23 02:00:00	ES	Futures	4468.43	4484.59	4465.6	4482.04	18749.0
2022-05-23 03:00:00	ES	Futures	4482.04	4484.02	4461.07	4469.0	23026.0
2022-05-23 04:00:00	ES	Futures	4468.72	4476.94	4434.99	4443.49	27635.0
2022-05-23 05:00:00	ES	Futures	4443.78	4458.8	4438.11	4447.46	19973.0
2022-05-23 06:00:00	ES	Futures	4447.46	4476.09	4445.48	4474.67	18267.0
2022-05-23 07:00:00	ES	Futures	4474.67	4476.65	4456.25	4463.33	20068.0
2022-05-23 08:00:00	ES	Futures	4463.62	4472.12	4455.68	4459.36	27338.0
2022-05-23 09:00:00	ES	Futures	4459.65	4474.95	4436.97	4449.73	221707.0
2022-05-23 10:00:00	ES	Futures	4449.73	4482.04	4429.04	4468.72	315573.0
2022-05-23 11:00:00	ES	Futures	4468.72	4505.0	4464.47	4497.91	187628.0
2022-05-23 12:00:00	ES	Futures	4498.2	4511.23	4484.87	4492.81	132638.0
2022-05-23 13:00:00	ES	Futures	4492.81	4502.45	4470.14	4501.31	145157.0
2022-05-23 14:00:00	ES	Futures	4501.03	4512.93	4493.94	4495.65	131081.0
2022-05-23 15:00:00	ES	Futures	4495.65	4507.27	4480.91	4503.3	252611.0
2022-05-23 16:00:00	ES	Futures	4503.58	4514.92	4503.3	4510.1	57749.0
2022-05-23 18:00:00	ES	Futures	4480.34	4481.47	4454.55	4472.4	22875.0
2022-05-23 19:00:00	ES	Futures	4472.69	4477.5	4465.32	4475.8	9415.0
2022-05-23 20:00:00	ES	Futures	4475.52	4478.36	4467.58	4470.42	9128.0
2022-05-23 21:00:00	ES	Futures	4470.42	4474.39	4463.62	4469.57	9529.0
2022-05-23 22:00:00	ES	Futures	4469.85	4470.42	4462.77	4467.3	6083.0
2022-05-23 23:00:00	ES	Futures	4467.3	4469.29	4463.62	4468.43	3859.0
2022-05-23 00:00:00	NQ	Futures	13871.54	13913.58	13862.55	13876.47	3751.0
2022-05-23 01:00:00	NQ	Futures	13878.21	13946.35	13864.29	13910.97	5885.0
2022-05-23 02:00:00	NQ	Futures	13911.26	13971.87	13900.24	13954.76	8044.0
2022-05-23 03:00:00	NQ	Futures	13955.34	13961.14	13864.58	13899.37	13985.0
2022-05-23 04:00:00	NQ	Futures	13898.21	13925.18	13762.22	13799.91	15742.0
2022-05-23 05:00:00	NQ	Futures	13800.49	13852.4	13776.13	13797.59	11609.0
2022-05-23 06:00:00	NQ	Futures	13797.59	13888.06	13786.28	13880.82	10227.0
2022-05-23 07:00:00	NQ	Futures	13880.24	13886.61	13804.55	13827.75	10800.0
2022-05-23 08:00:00	NQ	Futures	13828.33	13866.61	13785.12	13798.75	15677.0
2022-05-23 09:00:00	NQ	Futures	13798.75	13892.7	13707.41	13748.3	96015.0
2022-05-23 10:00:00	NQ	Futures	13748.59	13852.69	13667.97	13776.42	123378.0
2022-05-23 11:00:00	NQ	Futures	13776.71	13936.49	13759.03	13905.46	71334.0
2022-05-23 12:00:00	NQ	Futures	13906.91	13979.12	13877.34	13899.66	50179.0
2022-05-23 13:00:00	NQ	Futures	13900.24	13939.39	13822.82	13921.41	44715.0
2022-05-23 14:00:00	NQ	Futures	13922.57	13981.44	13895.31	13913.29	46263.0
2022-05-23 15:00:00	NQ	Futures	13913.87	13967.52	13868.06	13959.11	71798.0
2022-05-23 16:00:00	NQ	Futures	13959.11	14006.37	13957.95	13983.76	17456.0
2022-05-23 18:00:00	NQ	Futures	13820.21	13823.69	13710.02	13782.8	15552.0
2022-05-23 19:00:00	NQ	Futures	13783.96	13797.3	13761.06	13789.47	4809.0
2022-05-23 20:00:00	NQ	Futures	13788.6	13800.49	13765.12	13774.68	4852.0
2022-05-23 21:00:00	NQ	Futures	13775.84	13791.79	13751.49	13777.58	5124.0
2022-05-23 22:00:00	NQ	Futures	13777.87	13781.35	13747.72	13763.38	3148.0
2022-05-23 23:00:00	NQ	Futures	13763.09	13775.55	13754.97	13770.91	2014.0
2022-05-23 00:00:00	YM	Futures	35397.1	35450.0	35388.0	35403.8	839.0
2022-05-23 01:00:00	YM	Futures	35404.9	35529.0	35388.0	35480.5	2571.0
2022-05-23 02:00:00	YM	Futures	35478.2	35585.3	35461.3	35575.2	2882.0
2022-05-23 03:00:00	YM	Futures	35577.4	35588.7	35454.6	35504.2	3645.0

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

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