PREVIEW / futures_1hour / 2022-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-18.parquet
  size:    57 KB
  rows:    1,638

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-03-18 00:00:00	ES	Futures	4957.37	4960.49	4955.67	4958.5	4101.0
2022-03-18 01:00:00	ES	Futures	4958.22	4970.41	4956.52	4968.42	8353.0
2022-03-18 02:00:00	ES	Futures	4968.14	4982.03	4967.57	4972.67	8471.0
2022-03-18 03:00:00	ES	Futures	4972.67	4976.08	4962.75	4975.23	9325.0
2022-03-18 04:00:00	ES	Futures	4975.23	4976.93	4958.22	4965.59	17194.0
2022-03-18 05:00:00	ES	Futures	4965.59	4968.71	4954.82	4962.47	19316.0
2022-03-18 06:00:00	ES	Futures	4962.47	4967.57	4952.55	4958.22	14469.0
2022-03-18 07:00:00	ES	Futures	4958.5	4961.34	4948.3	4952.55	22563.0
2022-03-18 08:00:00	ES	Futures	4952.27	4965.59	4951.7	4959.35	35395.0
2022-03-18 09:00:00	ES	Futures	4959.07	4987.98	4953.68	4986.85	191317.0
2022-03-18 10:00:00	ES	Futures	4986.85	5006.69	4979.76	4991.95	168834.0
2022-03-18 11:00:00	ES	Futures	4992.23	5008.67	4987.7	4997.33	144349.0
2022-03-18 12:00:00	ES	Futures	4997.62	5017.46	4992.52	5014.34	91545.0
2022-03-18 13:00:00	ES	Futures	5014.34	5027.1	5011.51	5021.14	81770.0
2022-03-18 14:00:00	ES	Futures	5021.14	5028.8	5015.19	5027.1	78567.0
2022-03-18 15:00:00	ES	Futures	5027.1	5053.17	5024.83	5048.35	267061.0
2022-03-18 16:00:00	ES	Futures	5048.64	5063.09	5046.09	5062.24	87967.0
2022-03-18 00:00:00	NQ	Futures	16230.19	16232.8	16214.82	16226.71	1837.0
2022-03-18 01:00:00	NQ	Futures	16225.26	16243.24	16215.4	16237.15	4690.0
2022-03-18 02:00:00	NQ	Futures	16234.54	16310.52	16234.54	16267.89	5830.0
2022-03-18 03:00:00	NQ	Futures	16264.7	16290.8	16231.06	16290.8	6708.0
2022-03-18 04:00:00	NQ	Futures	16290.22	16300.08	16240.05	16273.69	8450.0
2022-03-18 05:00:00	NQ	Futures	16274.56	16285.58	16235.99	16269.05	6474.0
2022-03-18 06:00:00	NQ	Futures	16268.18	16285.87	16233.09	16250.2	6280.0
2022-03-18 07:00:00	NQ	Futures	16250.78	16256.87	16211.92	16229.9	9274.0
2022-03-18 08:00:00	NQ	Futures	16229.03	16271.66	16213.37	16244.4	13837.0
2022-03-18 09:00:00	NQ	Futures	16243.82	16414.91	16228.45	16413.46	79067.0
2022-03-18 10:00:00	NQ	Futures	16414.33	16523.07	16399.54	16478.41	86792.0
2022-03-18 11:00:00	NQ	Futures	16480.15	16560.76	16470.0	16517.85	66770.0
2022-03-18 12:00:00	NQ	Futures	16517.56	16599.62	16499.0	16582.22	50163.0
2022-03-18 13:00:00	NQ	Futures	16582.8	16614.7	16565.98	16594.69	41527.0
2022-03-18 14:00:00	NQ	Futures	16595.56	16630.94	16568.59	16628.04	36025.0
2022-03-18 15:00:00	NQ	Futures	16627.75	16730.4	16614.7	16714.45	76910.0
2022-03-18 16:00:00	NQ	Futures	16714.74	16752.15	16697.34	16743.45	18261.0
2022-03-18 00:00:00	YM	Futures	38517.5	38542.3	38513.0	38520.9	735.0
2022-03-18 01:00:00	YM	Futures	38518.6	38624.6	38510.7	38619.0	1918.0
2022-03-18 02:00:00	YM	Futures	38617.8	38695.6	38608.8	38625.7	2193.0
2022-03-18 03:00:00	YM	Futures	38623.5	38651.7	38557.0	38635.9	2163.0
2022-03-18 04:00:00	YM	Futures	38637.0	38656.2	38504.0	38558.1	3634.0
2022-03-18 05:00:00	YM	Futures	38559.2	38584.0	38485.9	38550.2	4569.0
2022-03-18 06:00:00	YM	Futures	38546.8	38584.0	38472.4	38511.9	2140.0
2022-03-18 07:00:00	YM	Futures	38515.3	38543.4	38446.5	38479.2	3788.0
2022-03-18 08:00:00	YM	Futures	38476.9	38581.8	38472.4	38544.6	4615.0
2022-03-18 09:00:00	YM	Futures	38540.1	38661.8	38505.1	38610.0	23019.0
2022-03-18 10:00:00	YM	Futures	38613.3	38739.6	38543.4	38595.3	20315.0
2022-03-18 11:00:00	YM	Futures	38597.6	38695.6	38554.7	38617.8	15691.0
2022-03-18 12:00:00	YM	Futures	38619.0	38768.9	38580.6	38743.0	10684.0
2022-03-18 13:00:00	YM	Futures	38745.2	38882.8	38726.1	38844.4	9911.0
2022-03-18 14:00:00	YM	Futures	38844.4	38865.9	38790.3	38829.8	8598.0
2022-03-18 15:00:00	YM	Futures	38828.7	39062.0	38816.3	39032.7	20963.0

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

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