PREVIEW / futures_1hour / 2022-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-19.parquet
  size:    68 KB
  rows:    2,038

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-07-19 00:00:00	ES	Futures	4352.18	4353.03	4347.37	4348.5	4238.0
2022-07-19 01:00:00	ES	Futures	4348.5	4357.57	4346.52	4354.45	5715.0
2022-07-19 02:00:00	ES	Futures	4354.45	4358.98	4350.77	4353.88	7768.0
2022-07-19 03:00:00	ES	Futures	4354.17	4366.35	4344.53	4350.48	24586.0
2022-07-19 04:00:00	ES	Futures	4350.77	4364.93	4350.2	4361.81	12763.0
2022-07-19 05:00:00	ES	Futures	4361.81	4377.68	4360.96	4373.43	18163.0
2022-07-19 06:00:00	ES	Futures	4373.15	4387.03	4372.01	4381.36	24711.0
2022-07-19 07:00:00	ES	Futures	4381.08	4382.21	4373.71	4379.66	18594.0
2022-07-19 08:00:00	ES	Futures	4379.94	4388.16	4368.9	4385.04	37318.0
2022-07-19 09:00:00	ES	Futures	4385.04	4400.34	4382.78	4399.77	208571.0
2022-07-19 10:00:00	ES	Futures	4400.06	4424.13	4392.41	4422.43	260833.0
2022-07-19 11:00:00	ES	Futures	4422.43	4434.9	4421.3	4432.35	153705.0
2022-07-19 12:00:00	ES	Futures	4432.35	4441.7	4422.15	4441.7	122168.0
2022-07-19 13:00:00	ES	Futures	4441.7	4454.73	4433.48	4454.44	96804.0
2022-07-19 14:00:00	ES	Futures	4454.16	4462.94	4447.93	4455.86	138875.0
2022-07-19 15:00:00	ES	Futures	4455.86	4468.04	4451.04	4460.39	291748.0
2022-07-19 16:00:00	ES	Futures	4460.11	4473.42	4458.69	4470.31	81255.0
2022-07-19 18:00:00	ES	Futures	4472.29	4473.42	4465.78	4470.31	4830.0
2022-07-19 19:00:00	ES	Futures	4470.59	4471.44	4465.78	4468.61	4525.0
2022-07-19 20:00:00	ES	Futures	4468.32	4482.77	4464.36	4479.37	17065.0
2022-07-19 21:00:00	ES	Futures	4479.66	4486.17	4475.12	4483.34	11159.0
2022-07-19 22:00:00	ES	Futures	4483.05	4491.84	4480.79	4489.0	9513.0
2022-07-19 23:00:00	ES	Futures	4489.0	4489.85	4484.75	4487.87	5325.0
2022-07-19 00:00:00	NQ	Futures	13797.28	13800.17	13777.03	13781.08	2644.0
2022-07-19 01:00:00	NQ	Futures	13781.37	13817.82	13775.88	13805.67	3434.0
2022-07-19 02:00:00	NQ	Futures	13804.8	13822.16	13795.26	13804.51	3941.0
2022-07-19 03:00:00	NQ	Futures	13805.38	13847.61	13755.63	13782.82	13657.0
2022-07-19 04:00:00	NQ	Futures	13783.98	13838.93	13781.95	13833.15	7410.0
2022-07-19 05:00:00	NQ	Futures	13832.86	13876.53	13829.97	13860.91	7815.0
2022-07-19 06:00:00	NQ	Futures	13860.34	13915.87	13857.15	13896.2	10238.0
2022-07-19 07:00:00	NQ	Futures	13895.62	13905.46	13872.77	13897.94	9046.0
2022-07-19 08:00:00	NQ	Futures	13898.23	13921.36	13861.78	13909.51	14235.0
2022-07-19 09:00:00	NQ	Futures	13909.51	13976.9	13875.38	13960.41	81773.0
2022-07-19 10:00:00	NQ	Futures	13960.7	14052.1	13897.65	14049.21	91445.0
2022-07-19 11:00:00	NQ	Futures	14049.5	14107.92	14046.61	14094.91	69389.0
2022-07-19 12:00:00	NQ	Futures	14095.2	14125.57	14058.75	14124.41	47584.0
2022-07-19 13:00:00	NQ	Futures	14124.12	14180.23	14098.09	14177.05	38870.0
2022-07-19 14:00:00	NQ	Futures	14177.63	14207.71	14142.92	14177.34	53681.0
2022-07-19 15:00:00	NQ	Futures	14176.76	14215.52	14161.14	14194.7	73627.0
2022-07-19 16:00:00	NQ	Futures	14194.12	14263.53	14184.86	14253.7	28354.0
2022-07-19 18:00:00	NQ	Futures	14265.85	14274.53	14238.37	14253.12	3290.0
2022-07-19 19:00:00	NQ	Futures	14253.12	14259.49	14237.5	14245.6	2833.0
2022-07-19 20:00:00	NQ	Futures	14245.31	14288.41	14228.54	14271.05	7515.0
2022-07-19 21:00:00	NQ	Futures	14271.34	14284.65	14251.1	14274.81	4901.0
2022-07-19 22:00:00	NQ	Futures	14275.68	14298.24	14266.72	14285.81	4634.0
2022-07-19 23:00:00	NQ	Futures	14286.38	14291.01	14278.0	14286.1	2557.0
2022-07-19 00:00:00	YM	Futures	35056.5	35065.5	35027.2	35032.8	700.0
2022-07-19 01:00:00	YM	Futures	35032.8	35100.5	35022.7	35077.9	1461.0
2022-07-19 02:00:00	YM	Futures	35076.8	35111.8	35052.0	35076.8	1441.0
2022-07-19 03:00:00	YM	Futures	35076.8	35170.5	35024.9	35061.0	4714.0

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

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