PREVIEW / futures_1hour / 2022-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-25.parquet
  size:    67 KB
  rows:    2,033

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-25 00:00:00	ES	Futures	4488.44	4490.14	4485.6	4486.74	2907.0
2022-07-25 01:00:00	ES	Futures	4487.02	4488.15	4481.07	4484.19	4589.0
2022-07-25 02:00:00	ES	Futures	4484.47	4490.14	4481.92	4488.72	7401.0
2022-07-25 03:00:00	ES	Futures	4488.72	4493.25	4478.24	4486.45	17702.0
2022-07-25 04:00:00	ES	Futures	4486.74	4504.3	4485.6	4501.18	14088.0
2022-07-25 05:00:00	ES	Futures	4501.18	4515.06	4500.62	4514.5	14711.0
2022-07-25 06:00:00	ES	Futures	4514.5	4517.05	4510.25	4517.05	11659.0
2022-07-25 07:00:00	ES	Futures	4517.05	4519.6	4509.12	4512.51	17807.0
2022-07-25 08:00:00	ES	Futures	4512.51	4515.91	4504.58	4507.42	23159.0
2022-07-25 09:00:00	ES	Futures	4507.42	4509.68	4480.51	4497.22	186548.0
2022-07-25 10:00:00	ES	Futures	4497.5	4501.47	4476.82	4494.1	273382.0
2022-07-25 11:00:00	ES	Futures	4494.1	4506.28	4483.34	4501.75	167094.0
2022-07-25 12:00:00	ES	Futures	4502.03	4508.55	4488.15	4500.62	125133.0
2022-07-25 13:00:00	ES	Futures	4500.9	4506.85	4485.32	4485.6	112837.0
2022-07-25 14:00:00	ES	Futures	4485.89	4488.72	4476.26	4477.96	137338.0
2022-07-25 15:00:00	ES	Futures	4477.96	4500.9	4471.16	4498.35	235463.0
2022-07-25 16:00:00	ES	Futures	4498.35	4504.87	4488.15	4489.57	64042.0
2022-07-25 18:00:00	ES	Futures	4485.89	4486.74	4481.07	4485.04	6526.0
2022-07-25 19:00:00	ES	Futures	4485.04	4485.89	4479.66	4482.49	4969.0
2022-07-25 20:00:00	ES	Futures	4482.77	4484.75	4475.69	4478.52	9105.0
2022-07-25 21:00:00	ES	Futures	4478.24	4487.02	4478.24	4482.49	7314.0
2022-07-25 22:00:00	ES	Futures	4482.49	4489.57	4479.66	4486.45	5524.0
2022-07-25 23:00:00	ES	Futures	4486.74	4489.0	4484.47	4486.45	3461.0
2022-07-25 00:00:00	NQ	Futures	14365.06	14377.49	14358.98	14365.35	1475.0
2022-07-25 01:00:00	NQ	Futures	14364.77	14369.11	14341.05	14354.93	2542.0
2022-07-25 02:00:00	NQ	Futures	14356.09	14379.52	14348.86	14368.82	3315.0
2022-07-25 03:00:00	NQ	Futures	14369.11	14388.2	14331.79	14363.61	7384.0
2022-07-25 04:00:00	NQ	Futures	14364.19	14426.67	14361.01	14410.76	7837.0
2022-07-25 05:00:00	NQ	Futures	14411.34	14455.88	14406.71	14455.01	7828.0
2022-07-25 06:00:00	NQ	Futures	14454.43	14459.06	14431.87	14449.52	5234.0
2022-07-25 07:00:00	NQ	Futures	14448.94	14460.22	14420.01	14432.45	7206.0
2022-07-25 08:00:00	NQ	Futures	14432.45	14443.73	14391.38	14406.13	10487.0
2022-07-25 09:00:00	NQ	Futures	14405.84	14413.94	14296.22	14331.51	79305.0
2022-07-25 10:00:00	NQ	Futures	14332.08	14350.02	14216.68	14293.33	94516.0
2022-07-25 11:00:00	NQ	Futures	14293.62	14332.37	14233.74	14313.57	53896.0
2022-07-25 12:00:00	NQ	Futures	14313.86	14354.36	14266.14	14321.67	39574.0
2022-07-25 13:00:00	NQ	Futures	14322.54	14341.34	14254.28	14255.15	29544.0
2022-07-25 14:00:00	NQ	Futures	14256.01	14265.85	14212.05	14221.31	37115.0
2022-07-25 15:00:00	NQ	Futures	14221.31	14298.53	14191.8	14294.77	58962.0
2022-07-25 16:00:00	NQ	Futures	14295.06	14318.2	14249.94	14262.38	18279.0
2022-07-25 18:00:00	NQ	Futures	14243.58	14249.07	14230.85	14240.68	2401.0
2022-07-25 19:00:00	NQ	Futures	14240.97	14241.55	14214.94	14228.83	3055.0
2022-07-25 20:00:00	NQ	Futures	14229.11	14237.5	14203.95	14218.41	3651.0
2022-07-25 21:00:00	NQ	Futures	14219.28	14246.47	14215.23	14227.38	3821.0
2022-07-25 22:00:00	NQ	Futures	14227.38	14253.7	14218.12	14239.53	3316.0
2022-07-25 23:00:00	NQ	Futures	14240.68	14250.81	14232.3	14242.42	1749.0
2022-07-25 00:00:00	YM	Futures	35935.5	35941.1	35914.0	35920.8	469.0
2022-07-25 01:00:00	YM	Futures	35919.7	35925.3	35881.3	35902.8	704.0
2022-07-25 02:00:00	YM	Futures	35905.0	35944.5	35884.7	35933.2	1360.0
2022-07-25 03:00:00	YM	Futures	35935.5	35967.1	35861.0	35923.1	3146.0

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

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