PREVIEW / futures_1hour / 2023-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-17.parquet
  size:    59 KB
  rows:    1,671

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-03-17 00:00:00	ES	Futures	4431.0	4436.54	4430.44	4435.44	5497.0
2023-03-17 01:00:00	ES	Futures	4435.44	4436.82	4432.38	4434.6	6018.0
2023-03-17 02:00:00	ES	Futures	4434.88	4440.71	4430.17	4439.87	8199.0
2023-03-17 03:00:00	ES	Futures	4439.87	4441.26	4433.49	4435.99	14583.0
2023-03-17 04:00:00	ES	Futures	4435.99	4447.92	4434.33	4436.82	37178.0
2023-03-17 05:00:00	ES	Futures	4436.82	4444.31	4432.38	4435.99	24723.0
2023-03-17 06:00:00	ES	Futures	4435.71	4436.54	4424.62	4426.56	26381.0
2023-03-17 07:00:00	ES	Futures	4426.56	4428.22	4413.8	4421.57	41378.0
2023-03-17 08:00:00	ES	Futures	4421.29	4423.51	4389.67	4397.16	88175.0
2023-03-17 09:00:00	ES	Futures	4397.16	4426.84	4397.16	4411.31	296245.0
2023-03-17 10:00:00	ES	Futures	4411.58	4429.33	4373.03	4381.91	352233.0
2023-03-17 11:00:00	ES	Futures	4381.91	4390.78	4363.32	4374.7	240725.0
2023-03-17 12:00:00	ES	Futures	4374.7	4399.66	4373.59	4383.57	198967.0
2023-03-17 13:00:00	ES	Futures	4383.57	4397.72	4381.35	4390.78	134584.0
2023-03-17 14:00:00	ES	Futures	4390.5	4396.05	4362.77	4374.7	186541.0
2023-03-17 15:00:00	ES	Futures	4374.7	4388.56	4369.7	4379.96	301500.0
2023-03-17 16:00:00	ES	Futures	4379.96	4388.01	4378.02	4379.69	70999.0
2023-03-17 00:00:00	NQ	Futures	14325.98	14346.82	14324.29	14345.41	3160.0
2023-03-17 01:00:00	NQ	Futures	14344.84	14355.54	14338.93	14347.94	3637.0
2023-03-17 02:00:00	NQ	Futures	14348.79	14376.66	14334.99	14374.41	4772.0
2023-03-17 03:00:00	NQ	Futures	14374.13	14379.19	14340.9	14347.66	8375.0
2023-03-17 04:00:00	NQ	Futures	14348.5	14368.5	14320.63	14331.89	18372.0
2023-03-17 05:00:00	NQ	Futures	14332.17	14351.32	14311.9	14337.52	12327.0
2023-03-17 06:00:00	NQ	Futures	14337.52	14342.59	14313.03	14326.54	9814.0
2023-03-17 07:00:00	NQ	Futures	14326.26	14346.82	14301.49	14344.28	14721.0
2023-03-17 08:00:00	NQ	Futures	14343.44	14352.73	14258.13	14277.55	29181.0
2023-03-17 09:00:00	NQ	Futures	14277.27	14374.97	14276.71	14356.67	76934.0
2023-03-17 10:00:00	NQ	Futures	14358.64	14428.18	14196.75	14238.98	138753.0
2023-03-17 11:00:00	NQ	Futures	14239.54	14266.85	14155.92	14206.6	86927.0
2023-03-17 12:00:00	NQ	Futures	14207.45	14281.78	14195.34	14231.38	67393.0
2023-03-17 13:00:00	NQ	Futures	14232.22	14295.85	14228.84	14279.81	57905.0
2023-03-17 14:00:00	NQ	Futures	14280.09	14302.05	14171.41	14213.36	63015.0
2023-03-17 15:00:00	NQ	Futures	14213.64	14266.29	14194.78	14244.05	83633.0
2023-03-17 16:00:00	NQ	Futures	14243.77	14271.36	14239.83	14244.89	16579.0
2023-03-17 00:00:00	YM	Futures	35881.6	35921.4	35878.3	35904.8	907.0
2023-03-17 01:00:00	YM	Futures	35904.8	35911.5	35882.7	35889.4	670.0
2023-03-17 02:00:00	YM	Futures	35891.6	35917.0	35849.6	35917.0	1352.0
2023-03-17 03:00:00	YM	Futures	35914.8	35926.9	35877.2	35899.3	2695.0
2023-03-17 04:00:00	YM	Futures	35900.4	36009.8	35890.5	35921.4	8823.0
2023-03-17 05:00:00	YM	Futures	35921.4	35977.8	35898.2	35913.7	3621.0
2023-03-17 06:00:00	YM	Futures	35912.6	35918.1	35792.1	35804.3	5187.0
2023-03-17 07:00:00	YM	Futures	35807.6	35812.0	35723.6	35764.5	6633.0
2023-03-17 08:00:00	YM	Futures	35763.4	35778.8	35537.9	35576.6	13685.0
2023-03-17 09:00:00	YM	Futures	35576.6	35756.7	35576.6	35635.1	33721.0
2023-03-17 10:00:00	YM	Futures	35638.5	35751.2	35396.4	35455.0	37459.0
2023-03-17 11:00:00	YM	Futures	35453.9	35523.5	35334.5	35410.8	26087.0
2023-03-17 12:00:00	YM	Futures	35413.0	35594.2	35408.6	35510.2	19351.0
2023-03-17 13:00:00	YM	Futures	35511.3	35600.9	35471.6	35527.9	14242.0
2023-03-17 14:00:00	YM	Futures	35530.1	35565.5	35313.5	35405.2	18257.0
2023-03-17 15:00:00	YM	Futures	35406.3	35494.8	35371.0	35457.2	21558.0

> showing 50 of 1,671 rows — these rows as CSV

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