PREVIEW / futures_1hour / 2022-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-20.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
2022-07-20 00:00:00	ES	Futures	4487.59	4490.42	4482.77	4486.45	5618.0
2022-07-20 01:00:00	ES	Futures	4486.45	4486.45	4477.96	4481.07	7804.0
2022-07-20 02:00:00	ES	Futures	4481.07	4484.19	4475.97	4480.22	9528.0
2022-07-20 03:00:00	ES	Futures	4480.22	4485.89	4462.94	4463.79	29602.0
2022-07-20 04:00:00	ES	Futures	4463.79	4475.69	4462.94	4466.91	18054.0
2022-07-20 05:00:00	ES	Futures	4466.91	4473.14	4466.06	4470.87	10034.0
2022-07-20 06:00:00	ES	Futures	4470.59	4472.29	4445.95	4454.16	31662.0
2022-07-20 07:00:00	ES	Futures	4454.16	4457.56	4448.78	4452.18	16790.0
2022-07-20 08:00:00	ES	Futures	4452.18	4461.53	4444.25	4456.71	53315.0
2022-07-20 09:00:00	ES	Futures	4456.43	4468.32	4449.91	4451.89	163365.0
2022-07-20 10:00:00	ES	Futures	4451.89	4503.45	4447.08	4502.88	253982.0
2022-07-20 11:00:00	ES	Futures	4503.17	4503.45	4488.15	4501.18	192945.0
2022-07-20 12:00:00	ES	Futures	4501.18	4506.57	4473.14	4488.15	182603.0
2022-07-20 13:00:00	ES	Futures	4488.44	4489.29	4462.66	4464.08	213734.0
2022-07-20 14:00:00	ES	Futures	4464.08	4490.7	4463.23	4486.74	153046.0
2022-07-20 15:00:00	ES	Futures	4486.74	4501.18	4484.47	4489.85	228549.0
2022-07-20 16:00:00	ES	Futures	4489.85	4495.8	4479.94	4479.94	61350.0
2022-07-20 18:00:00	ES	Futures	4480.22	4483.05	4475.69	4477.67	8424.0
2022-07-20 19:00:00	ES	Futures	4477.67	4487.59	4477.11	4483.05	6328.0
2022-07-20 20:00:00	ES	Futures	4483.05	4484.19	4476.26	4483.05	7929.0
2022-07-20 21:00:00	ES	Futures	4483.05	4483.05	4470.31	4476.82	9824.0
2022-07-20 22:00:00	ES	Futures	4476.54	4483.05	4475.12	4480.51	4524.0
2022-07-20 23:00:00	ES	Futures	4480.51	4485.89	4479.09	4482.77	4612.0
2022-07-20 00:00:00	NQ	Futures	14285.81	14295.06	14266.14	14278.57	3180.0
2022-07-20 01:00:00	NQ	Futures	14278.57	14278.57	14241.26	14257.46	5095.0
2022-07-20 02:00:00	NQ	Futures	14256.88	14280.02	14244.73	14263.25	4813.0
2022-07-20 03:00:00	NQ	Futures	14262.09	14278.0	14202.79	14210.89	13717.0
2022-07-20 04:00:00	NQ	Futures	14210.31	14249.94	14205.4	14230.56	9506.0
2022-07-20 05:00:00	NQ	Futures	14229.98	14258.04	14229.11	14249.36	5491.0
2022-07-20 06:00:00	NQ	Futures	14249.07	14253.12	14159.41	14192.09	11847.0
2022-07-20 07:00:00	NQ	Futures	14191.51	14201.06	14172.71	14180.52	7676.0
2022-07-20 08:00:00	NQ	Futures	14180.52	14209.45	14156.23	14193.54	20995.0
2022-07-20 09:00:00	NQ	Futures	14192.38	14290.43	14181.39	14213.79	76303.0
2022-07-20 10:00:00	NQ	Futures	14214.07	14446.33	14198.17	14446.04	105721.0
2022-07-20 11:00:00	NQ	Futures	14446.04	14471.5	14389.64	14456.75	71363.0
2022-07-20 12:00:00	NQ	Futures	14457.04	14482.2	14347.7	14414.23	70067.0
2022-07-20 13:00:00	NQ	Futures	14414.52	14421.75	14297.66	14320.8	71302.0
2022-07-20 14:00:00	NQ	Futures	14321.38	14421.46	14316.75	14408.73	47707.0
2022-07-20 15:00:00	NQ	Futures	14408.15	14463.11	14399.48	14422.62	62399.0
2022-07-20 16:00:00	NQ	Futures	14422.33	14457.32	14369.4	14378.65	24169.0
2022-07-20 18:00:00	NQ	Futures	14392.54	14397.16	14358.69	14370.84	4624.0
2022-07-20 19:00:00	NQ	Futures	14371.71	14402.37	14369.97	14387.33	3149.0
2022-07-20 20:00:00	NQ	Futures	14387.04	14398.9	14366.5	14394.56	3715.0
2022-07-20 21:00:00	NQ	Futures	14393.69	14394.56	14341.05	14357.25	7040.0
2022-07-20 22:00:00	NQ	Futures	14356.96	14385.3	14351.75	14367.66	3593.0
2022-07-20 23:00:00	NQ	Futures	14367.66	14390.22	14363.61	14383.57	2677.0
2022-07-20 00:00:00	YM	Futures	36052.8	36076.5	36023.5	36048.3	774.0
2022-07-20 01:00:00	YM	Futures	36048.3	36050.6	35989.6	36004.3	1480.0
2022-07-20 02:00:00	YM	Futures	36004.3	36025.8	35967.1	36000.9	2072.0
2022-07-20 03:00:00	YM	Futures	36002.1	36049.4	35874.6	35883.6	5479.0

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

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