PREVIEW / futures_1hour / 2022-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-27.parquet
  size:    55 KB
  rows:    1,628

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-05-27 00:00:00	ES	Futures	4590.03	4596.83	4589.18	4594.28	2861.0
2022-05-27 01:00:00	ES	Futures	4594.0	4597.68	4586.63	4591.73	5552.0
2022-05-27 02:00:00	ES	Futures	4591.73	4599.1	4586.35	4598.25	9841.0
2022-05-27 03:00:00	ES	Futures	4597.97	4602.5	4590.88	4595.7	18218.0
2022-05-27 04:00:00	ES	Futures	4595.7	4615.26	4593.43	4612.42	23324.0
2022-05-27 05:00:00	ES	Futures	4612.42	4622.06	4604.49	4618.94	16245.0
2022-05-27 06:00:00	ES	Futures	4619.23	4619.23	4607.89	4615.82	15289.0
2022-05-27 07:00:00	ES	Futures	4615.54	4615.54	4599.1	4600.52	35156.0
2022-05-27 08:00:00	ES	Futures	4600.52	4633.68	4598.53	4631.13	65984.0
2022-05-27 09:00:00	ES	Futures	4631.41	4669.68	4623.48	4663.44	222991.0
2022-05-27 10:00:00	ES	Futures	4663.16	4677.9	4658.91	4662.59	205786.0
2022-05-27 11:00:00	ES	Futures	4662.59	4681.87	4657.49	4680.45	153637.0
2022-05-27 12:00:00	ES	Futures	4680.45	4684.7	4672.23	4679.31	103049.0
2022-05-27 13:00:00	ES	Futures	4679.31	4683.85	4673.36	4677.61	97709.0
2022-05-27 14:00:00	ES	Futures	4677.61	4688.38	4673.93	4687.25	93479.0
2022-05-27 15:00:00	ES	Futures	4687.25	4713.33	4685.83	4712.19	282041.0
2022-05-27 16:00:00	ES	Futures	4712.19	4725.8	4708.79	4725.52	89584.0
2022-05-27 00:00:00	NQ	Futures	14211.97	14240.38	14209.07	14226.76	2472.0
2022-05-27 01:00:00	NQ	Futures	14225.89	14247.05	14201.53	14220.09	4311.0
2022-05-27 02:00:00	NQ	Futures	14220.09	14236.61	14189.64	14233.72	6338.0
2022-05-27 03:00:00	NQ	Futures	14231.4	14246.47	14192.54	14212.55	11642.0
2022-05-27 04:00:00	NQ	Futures	14212.26	14321.29	14201.82	14309.98	15453.0
2022-05-27 05:00:00	NQ	Futures	14309.98	14352.31	14275.18	14339.56	10079.0
2022-05-27 06:00:00	NQ	Futures	14339.85	14340.14	14291.13	14328.25	9592.0
2022-05-27 07:00:00	NQ	Futures	14327.67	14327.67	14256.04	14262.42	12232.0
2022-05-27 08:00:00	NQ	Futures	14262.71	14425.68	14252.85	14403.06	37781.0
2022-05-27 09:00:00	NQ	Futures	14402.19	14536.16	14361.01	14522.53	92247.0
2022-05-27 10:00:00	NQ	Futures	14521.37	14607.49	14501.65	14537.32	88792.0
2022-05-27 11:00:00	NQ	Futures	14537.03	14613.29	14507.45	14607.78	63182.0
2022-05-27 12:00:00	NQ	Futures	14607.78	14628.66	14568.64	14598.5	42564.0
2022-05-27 13:00:00	NQ	Futures	14598.5	14615.03	14577.05	14601.4	30582.0
2022-05-27 14:00:00	NQ	Futures	14601.69	14636.2	14582.56	14632.72	34626.0
2022-05-27 15:00:00	NQ	Futures	14632.72	14711.3	14622.57	14710.14	88866.0
2022-05-27 16:00:00	NQ	Futures	14709.56	14754.22	14697.97	14751.03	22181.0
2022-05-27 00:00:00	YM	Futures	36672.1	36719.4	36672.1	36700.3	505.0
2022-05-27 01:00:00	YM	Futures	36696.9	36712.7	36651.8	36678.8	1088.0
2022-05-27 02:00:00	YM	Futures	36678.8	36740.8	36649.5	36735.2	1960.0
2022-05-27 03:00:00	YM	Futures	36731.8	36766.8	36694.6	36726.2	3134.0
2022-05-27 04:00:00	YM	Futures	36726.2	36825.4	36711.5	36800.6	3829.0
2022-05-27 05:00:00	YM	Futures	36800.6	36861.5	36748.7	36838.9	2527.0
2022-05-27 06:00:00	YM	Futures	36838.9	36838.9	36764.5	36814.1	2256.0
2022-05-27 07:00:00	YM	Futures	36808.5	36808.5	36711.5	36720.5	2986.0
2022-05-27 08:00:00	YM	Futures	36721.7	36893.0	36710.4	36882.9	9051.0
2022-05-27 09:00:00	YM	Futures	36882.9	37054.2	36788.2	37021.5	24974.0
2022-05-27 10:00:00	YM	Futures	37020.4	37076.8	36971.9	36991.1	18321.0
2022-05-27 11:00:00	YM	Futures	36992.2	37153.4	36973.1	37142.2	13760.0
2022-05-27 12:00:00	YM	Futures	37142.2	37168.1	37108.3	37143.3	8337.0
2022-05-27 13:00:00	YM	Futures	37142.2	37179.4	37086.9	37120.7	7920.0
2022-05-27 14:00:00	YM	Futures	37121.9	37190.6	37100.5	37188.4	5933.0
2022-05-27 15:00:00	YM	Futures	37189.5	37391.3	37181.6	37387.9	19766.0

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

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