PREVIEW / futures_1hour / 2023-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-27.parquet
  size:    67 KB
  rows:    2,057

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
2023-04-27 00:00:00	ES	Futures	4531.68	4536.11	4531.68	4535.84	3406.0
2023-04-27 01:00:00	ES	Futures	4536.11	4539.44	4533.34	4538.33	6715.0
2023-04-27 02:00:00	ES	Futures	4538.33	4540.27	4536.11	4537.78	7552.0
2023-04-27 03:00:00	ES	Futures	4538.06	4545.54	4534.73	4544.44	20293.0
2023-04-27 04:00:00	ES	Futures	4544.44	4544.99	4540.27	4544.16	11497.0
2023-04-27 05:00:00	ES	Futures	4544.16	4545.54	4541.66	4543.05	7968.0
2023-04-27 06:00:00	ES	Futures	4542.77	4546.93	4540.83	4546.65	14794.0
2023-04-27 07:00:00	ES	Futures	4546.65	4549.98	4544.44	4546.93	17285.0
2023-04-27 08:00:00	ES	Futures	4546.65	4554.97	4536.95	4548.6	62107.0
2023-04-27 09:00:00	ES	Futures	4548.6	4558.03	4545.54	4554.7	207079.0
2023-04-27 10:00:00	ES	Futures	4554.42	4565.79	4552.76	4556.36	227530.0
2023-04-27 11:00:00	ES	Futures	4556.36	4573.28	4553.31	4572.73	176884.0
2023-04-27 12:00:00	ES	Futures	4572.73	4580.49	4572.73	4579.38	121179.0
2023-04-27 13:00:00	ES	Futures	4579.38	4595.19	4578.27	4590.75	130723.0
2023-04-27 14:00:00	ES	Futures	4591.03	4610.45	4590.48	4609.89	179889.0
2023-04-27 15:00:00	ES	Futures	4610.17	4612.39	4605.45	4608.5	273026.0
2023-04-27 16:00:00	ES	Futures	4608.5	4622.37	4602.4	4612.94	123027.0
2023-04-27 18:00:00	ES	Futures	4605.18	4607.39	4601.29	4603.51	12572.0
2023-04-27 19:00:00	ES	Futures	4603.79	4607.12	4602.12	4602.68	5995.0
2023-04-27 20:00:00	ES	Futures	4602.68	4604.34	4600.74	4602.68	7570.0
2023-04-27 21:00:00	ES	Futures	4602.4	4608.78	4599.35	4606.29	11186.0
2023-04-27 22:00:00	ES	Futures	4606.29	4608.5	4604.62	4606.84	4627.0
2023-04-27 23:00:00	ES	Futures	4607.12	4607.39	4601.02	4602.12	5500.0
2023-04-27 00:00:00	NQ	Futures	14587.82	14610.63	14586.42	14609.79	3059.0
2023-04-27 01:00:00	NQ	Futures	14610.07	14623.02	14599.37	14617.11	4108.0
2023-04-27 02:00:00	NQ	Futures	14617.67	14632.31	14612.6	14628.65	4283.0
2023-04-27 03:00:00	NQ	Futures	14628.93	14659.06	14621.61	14646.39	9183.0
2023-04-27 04:00:00	NQ	Futures	14645.82	14647.8	14619.92	14631.75	6859.0
2023-04-27 05:00:00	NQ	Futures	14631.75	14643.57	14622.46	14627.52	4526.0
2023-04-27 06:00:00	NQ	Futures	14626.68	14638.79	14608.94	14635.69	7757.0
2023-04-27 07:00:00	NQ	Futures	14635.97	14655.96	14631.47	14649.2	9752.0
2023-04-27 08:00:00	NQ	Futures	14648.36	14694.82	14622.17	14665.53	31756.0
2023-04-27 09:00:00	NQ	Futures	14665.25	14711.15	14655.96	14667.22	114348.0
2023-04-27 10:00:00	NQ	Futures	14667.22	14774.21	14660.47	14738.74	126575.0
2023-04-27 11:00:00	NQ	Futures	14739.02	14806.87	14735.36	14795.05	78940.0
2023-04-27 12:00:00	NQ	Futures	14795.05	14837.28	14793.36	14835.31	50593.0
2023-04-27 13:00:00	NQ	Futures	14835.31	14886.55	14824.89	14867.69	53811.0
2023-04-27 14:00:00	NQ	Futures	14867.97	14908.51	14867.97	14906.54	53429.0
2023-04-27 15:00:00	NQ	Futures	14906.82	14925.97	14892.47	14901.19	87121.0
2023-04-27 16:00:00	NQ	Futures	14901.19	15015.79	14867.13	14934.42	51223.0
2023-04-27 18:00:00	NQ	Futures	14882.89	14894.72	14856.99	14870.79	13915.0
2023-04-27 19:00:00	NQ	Futures	14871.63	14893.03	14870.79	14877.26	4887.0
2023-04-27 20:00:00	NQ	Futures	14876.7	14882.05	14864.87	14873.88	3673.0
2023-04-27 21:00:00	NQ	Futures	14873.88	14900.35	14853.61	14888.24	6283.0
2023-04-27 22:00:00	NQ	Futures	14887.4	14892.18	14881.48	14885.43	2359.0
2023-04-27 23:00:00	NQ	Futures	14884.58	14885.99	14863.47	14867.41	2439.0
2023-04-27 00:00:00	YM	Futures	36971.5	36996.9	36971.5	36992.5	997.0
2023-04-27 01:00:00	YM	Futures	36992.5	37017.9	36980.3	37004.6	1246.0
2023-04-27 02:00:00	YM	Futures	37005.7	37009.0	36981.4	36990.3	1829.0
2023-04-27 03:00:00	YM	Futures	36991.4	37044.4	36960.4	37035.6	3207.0

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

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