PREVIEW / futures_1hour / 2022-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-28.parquet
  size:    73 KB
  rows:    2,090

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-09-28 00:00:00	ES	Futures	4102.68	4113.11	4096.76	4102.96	14334.0
2022-09-28 01:00:00	ES	Futures	4102.96	4112.55	4095.07	4112.55	18119.0
2022-09-28 02:00:00	ES	Futures	4112.83	4119.87	4094.5	4095.91	26833.0
2022-09-28 03:00:00	ES	Futures	4095.91	4114.52	4085.2	4108.32	55390.0
2022-09-28 04:00:00	ES	Futures	4108.32	4110.85	4090.84	4100.42	32592.0
2022-09-28 05:00:00	ES	Futures	4100.42	4102.12	4073.93	4078.72	53801.0
2022-09-28 06:00:00	ES	Futures	4078.44	4132.84	4075.62	4114.52	137162.0
2022-09-28 07:00:00	ES	Futures	4114.8	4118.75	4096.2	4103.53	61283.0
2022-09-28 08:00:00	ES	Futures	4103.53	4150.6	4102.68	4138.76	111130.0
2022-09-28 09:00:00	ES	Futures	4139.04	4148.35	4118.18	4138.2	335734.0
2022-09-28 10:00:00	ES	Futures	4138.48	4174.84	4124.95	4163.57	363930.0
2022-09-28 11:00:00	ES	Futures	4163.85	4185.56	4159.06	4184.43	289903.0
2022-09-28 12:00:00	ES	Futures	4184.43	4198.24	4181.89	4190.91	210461.0
2022-09-28 13:00:00	ES	Futures	4191.19	4203.6	4183.02	4188.66	184537.0
2022-09-28 14:00:00	ES	Futures	4188.66	4201.34	4184.99	4197.68	171609.0
2022-09-28 15:00:00	ES	Futures	4197.68	4229.81	4196.27	4208.67	397555.0
2022-09-28 16:00:00	ES	Futures	4208.67	4213.18	4204.44	4205.57	84469.0
2022-09-28 18:00:00	ES	Futures	4206.13	4212.62	4198.52	4201.62	10522.0
2022-09-28 19:00:00	ES	Futures	4201.62	4205.01	4200.21	4203.32	6438.0
2022-09-28 20:00:00	ES	Futures	4203.6	4212.62	4201.34	4206.13	15835.0
2022-09-28 21:00:00	ES	Futures	4205.85	4207.83	4200.78	4201.34	11871.0
2022-09-28 22:00:00	ES	Futures	4201.62	4204.16	4193.17	4197.96	14470.0
2022-09-28 23:00:00	ES	Futures	4197.68	4207.54	4196.55	4205.85	10208.0
2022-09-28 00:00:00	NQ	Futures	12912.14	12945.47	12889.15	12910.7	7325.0
2022-09-28 01:00:00	NQ	Futures	12910.41	12941.45	12881.68	12940.58	8652.0
2022-09-28 02:00:00	NQ	Futures	12941.16	12967.02	12875.07	12879.96	15167.0
2022-09-28 03:00:00	NQ	Futures	12879.67	12952.65	12835.71	12926.79	29750.0
2022-09-28 04:00:00	NQ	Futures	12927.08	12935.7	12851.51	12890.01	20697.0
2022-09-28 05:00:00	NQ	Futures	12890.01	12895.47	12809.56	12816.46	21788.0
2022-09-28 06:00:00	NQ	Futures	12816.46	13000.63	12804.97	12930.24	54178.0
2022-09-28 07:00:00	NQ	Futures	12929.95	12940.58	12863.01	12892.03	27874.0
2022-09-28 08:00:00	NQ	Futures	12891.74	13050.92	12889.73	13011.84	42329.0
2022-09-28 09:00:00	NQ	Futures	13012.41	13048.04	12948.05	13000.63	102505.0
2022-09-28 10:00:00	NQ	Futures	13000.92	13139.41	12954.66	13099.19	116181.0
2022-09-28 11:00:00	NQ	Futures	13099.76	13196.02	13083.1	13193.43	77408.0
2022-09-28 12:00:00	NQ	Futures	13193.72	13231.64	13164.12	13190.84	59906.0
2022-09-28 13:00:00	NQ	Futures	13191.13	13238.83	13170.44	13190.27	59433.0
2022-09-28 14:00:00	NQ	Futures	13190.56	13249.17	13184.24	13237.39	52820.0
2022-09-28 15:00:00	NQ	Futures	13237.68	13347.44	13232.51	13278.77	100776.0
2022-09-28 16:00:00	NQ	Futures	13278.48	13294.57	13258.08	13262.1	18479.0
2022-09-28 18:00:00	NQ	Futures	13267.56	13292.56	13240.84	13253.19	4959.0
2022-09-28 19:00:00	NQ	Futures	13252.91	13264.11	13242.85	13254.92	3843.0
2022-09-28 20:00:00	NQ	Futures	13256.07	13294.28	13248.02	13263.25	7883.0
2022-09-28 21:00:00	NQ	Futures	13262.96	13271.01	13244.86	13246.87	4835.0
2022-09-28 22:00:00	NQ	Futures	13246.59	13257.79	13217.57	13233.66	5967.0
2022-09-28 23:00:00	NQ	Futures	13234.23	13267.27	13226.76	13258.37	4292.0
2022-09-28 00:00:00	YM	Futures	32606.5	32668.2	32568.3	32609.9	2207.0
2022-09-28 01:00:00	YM	Futures	32606.5	32682.8	32549.3	32682.8	1824.0
2022-09-28 02:00:00	YM	Futures	32681.7	32734.4	32554.9	32559.4	3655.0
2022-09-28 03:00:00	YM	Futures	32562.7	32683.9	32487.5	32649.1	6482.0

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

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