PREVIEW / futures_1hour / 2022-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-03.parquet
  size:    68 KB
  rows:    2,030

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-08-03 00:00:00	ES	Futures	4644.8	4651.32	4643.95	4646.22	5382.0
2022-08-03 01:00:00	ES	Futures	4646.22	4653.3	4645.94	4650.47	5828.0
2022-08-03 02:00:00	ES	Futures	4650.18	4654.43	4646.22	4648.77	5849.0
2022-08-03 03:00:00	ES	Futures	4648.49	4649.9	4639.14	4642.54	16821.0
2022-08-03 04:00:00	ES	Futures	4642.82	4651.32	4637.15	4647.92	11215.0
2022-08-03 05:00:00	ES	Futures	4647.64	4660.67	4646.5	4655.85	13192.0
2022-08-03 06:00:00	ES	Futures	4655.57	4659.53	4652.17	4655.85	8918.0
2022-08-03 07:00:00	ES	Futures	4655.85	4663.22	4653.87	4660.67	16839.0
2022-08-03 08:00:00	ES	Futures	4660.1	4671.15	4657.55	4666.9	27541.0
2022-08-03 09:00:00	ES	Futures	4667.18	4679.36	4659.82	4677.38	185212.0
2022-08-03 10:00:00	ES	Futures	4677.1	4687.86	4661.8	4677.95	291586.0
2022-08-03 11:00:00	ES	Futures	4677.95	4699.76	4675.96	4698.62	198116.0
2022-08-03 12:00:00	ES	Futures	4698.62	4713.35	4690.69	4709.67	176809.0
2022-08-03 13:00:00	ES	Futures	4709.67	4715.05	4705.42	4711.94	120166.0
2022-08-03 14:00:00	ES	Futures	4712.22	4719.87	4708.54	4715.34	129981.0
2022-08-03 15:00:00	ES	Futures	4715.05	4724.97	4707.12	4710.24	302738.0
2022-08-03 16:00:00	ES	Futures	4709.96	4710.52	4702.59	4705.14	62685.0
2022-08-03 18:00:00	ES	Futures	4702.59	4706.56	4701.46	4705.99	5867.0
2022-08-03 19:00:00	ES	Futures	4705.71	4705.99	4702.31	4702.59	2455.0
2022-08-03 20:00:00	ES	Futures	4702.31	4710.8	4700.04	4710.8	8180.0
2022-08-03 21:00:00	ES	Futures	4710.8	4713.07	4706.84	4709.11	6692.0
2022-08-03 22:00:00	ES	Futures	4709.11	4710.8	4702.31	4707.69	5163.0
2022-08-03 23:00:00	ES	Futures	4707.69	4708.26	4701.17	4703.72	5644.0
2022-08-03 00:00:00	NQ	Futures	14955.97	14979.11	14948.45	14951.06	4235.0
2022-08-03 01:00:00	NQ	Futures	14952.5	14984.32	14950.77	14973.33	3574.0
2022-08-03 02:00:00	NQ	Futures	14971.59	14988.08	14955.68	14967.25	3403.0
2022-08-03 03:00:00	NQ	Futures	14965.81	14968.7	14916.35	14936.59	10279.0
2022-08-03 04:00:00	NQ	Futures	14937.17	14973.91	14916.35	14964.07	6935.0
2022-08-03 05:00:00	NQ	Futures	14963.78	15034.93	14957.71	15008.04	10081.0
2022-08-03 06:00:00	NQ	Futures	15007.17	15015.56	14987.79	15001.67	5648.0
2022-08-03 07:00:00	NQ	Futures	15001.38	15037.54	14995.89	15022.21	9306.0
2022-08-03 08:00:00	NQ	Futures	15022.21	15059.81	15006.59	15040.43	14233.0
2022-08-03 09:00:00	NQ	Futures	15040.72	15187.94	15027.99	15172.61	82633.0
2022-08-03 10:00:00	NQ	Futures	15172.61	15240.87	15110.72	15203.56	116478.0
2022-08-03 11:00:00	NQ	Futures	15203.85	15299.88	15191.12	15295.25	89898.0
2022-08-03 12:00:00	NQ	Futures	15295.54	15360.33	15256.78	15338.35	76166.0
2022-08-03 13:00:00	NQ	Futures	15338.64	15362.64	15325.62	15350.49	54173.0
2022-08-03 14:00:00	NQ	Futures	15350.49	15382.89	15334.01	15363.22	58735.0
2022-08-03 15:00:00	NQ	Futures	15363.51	15399.38	15344.71	15354.83	88916.0
2022-08-03 16:00:00	NQ	Futures	15354.83	15355.7	15320.99	15327.36	20060.0
2022-08-03 18:00:00	NQ	Futures	15326.2	15332.56	15305.95	15321.86	3281.0
2022-08-03 19:00:00	NQ	Futures	15322.15	15323.02	15311.16	15311.45	1642.0
2022-08-03 20:00:00	NQ	Futures	15311.16	15349.05	15303.35	15347.89	4104.0
2022-08-03 21:00:00	NQ	Futures	15347.6	15355.12	15332.85	15339.21	3017.0
2022-08-03 22:00:00	NQ	Futures	15340.08	15345.58	15321.86	15335.45	2363.0
2022-08-03 23:00:00	NQ	Futures	15335.45	15335.45	15305.95	15316.65	2711.0
2022-08-03 00:00:00	YM	Futures	36599.0	36641.8	36593.3	36612.5	1147.0
2022-08-03 01:00:00	YM	Futures	36614.7	36659.9	36614.7	36637.3	1014.0
2022-08-03 02:00:00	YM	Futures	36636.2	36664.4	36611.4	36623.8	1387.0
2022-08-03 03:00:00	YM	Futures	36623.8	36650.9	36579.8	36602.3	4073.0

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

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