PREVIEW / futures_1hour / 2023-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-20.parquet
  size:    56 KB
  rows:    1,637

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-01-20 00:00:00	ES	Futures	4388.98	4391.22	4387.87	4390.66	4651.0
2023-01-20 01:00:00	ES	Futures	4390.66	4391.78	4387.03	4389.26	4790.0
2023-01-20 02:00:00	ES	Futures	4388.98	4398.77	4387.87	4396.25	10542.0
2023-01-20 03:00:00	ES	Futures	4396.25	4396.81	4382.83	4387.31	21384.0
2023-01-20 04:00:00	ES	Futures	4387.59	4388.7	4378.64	4381.16	15420.0
2023-01-20 05:00:00	ES	Futures	4381.16	4388.15	4375.0	4386.19	19456.0
2023-01-20 06:00:00	ES	Futures	4386.47	4386.47	4379.48	4383.11	11838.0
2023-01-20 07:00:00	ES	Futures	4383.11	4394.58	4380.6	4392.34	19720.0
2023-01-20 08:00:00	ES	Futures	4392.34	4396.53	4383.39	4383.95	33777.0
2023-01-20 09:00:00	ES	Futures	4383.95	4397.37	4375.56	4390.66	216643.0
2023-01-20 10:00:00	ES	Futures	4390.94	4407.44	4386.19	4401.57	191555.0
2023-01-20 11:00:00	ES	Futures	4401.57	4422.54	4401.01	4414.43	162409.0
2023-01-20 12:00:00	ES	Futures	4414.43	4420.86	4413.87	4415.27	74085.0
2023-01-20 13:00:00	ES	Futures	4415.55	4435.4	4406.88	4433.16	172549.0
2023-01-20 14:00:00	ES	Futures	4433.44	4443.79	4430.93	4443.23	118607.0
2023-01-20 15:00:00	ES	Futures	4443.23	4463.08	4443.23	4460.0	342658.0
2023-01-20 16:00:00	ES	Futures	4460.0	4461.12	4455.53	4460.28	73025.0
2023-01-20 00:00:00	NQ	Futures	12971.79	12980.9	12966.39	12978.33	1643.0
2023-01-20 01:00:00	NQ	Futures	12978.05	12983.74	12970.94	12977.77	1765.0
2023-01-20 02:00:00	NQ	Futures	12977.48	13010.48	12971.79	13001.95	4587.0
2023-01-20 03:00:00	NQ	Futures	13001.95	13003.65	12950.17	12968.66	9402.0
2023-01-20 04:00:00	NQ	Futures	12968.66	12974.92	12936.51	12953.01	7528.0
2023-01-20 05:00:00	NQ	Futures	12952.73	12986.02	12933.38	12981.18	8897.0
2023-01-20 06:00:00	NQ	Futures	12981.46	12989.43	12958.7	12982.89	5578.0
2023-01-20 07:00:00	NQ	Futures	12983.17	13024.14	12975.49	13015.03	10084.0
2023-01-20 08:00:00	NQ	Futures	13014.75	13028.12	12982.32	12983.46	14885.0
2023-01-20 09:00:00	NQ	Futures	12983.17	13056.0	12954.15	13028.97	84598.0
2023-01-20 10:00:00	NQ	Futures	13028.69	13085.02	13000.24	13045.76	77411.0
2023-01-20 11:00:00	NQ	Futures	13046.33	13134.81	13043.2	13114.32	70689.0
2023-01-20 12:00:00	NQ	Futures	13114.61	13146.76	13112.9	13124.28	39363.0
2023-01-20 13:00:00	NQ	Futures	13124.56	13205.65	13093.84	13200.24	62369.0
2023-01-20 14:00:00	NQ	Futures	13200.81	13236.66	13194.27	13230.4	42676.0
2023-01-20 15:00:00	NQ	Futures	13230.68	13299.24	13230.11	13287.3	94469.0
2023-01-20 16:00:00	NQ	Futures	13287.01	13289.29	13267.1	13289.0	17278.0
2023-01-20 00:00:00	YM	Futures	36967.4	36981.9	36960.8	36977.5	962.0
2023-01-20 01:00:00	YM	Futures	36977.5	36986.4	36959.6	36968.6	930.0
2023-01-20 02:00:00	YM	Futures	36968.6	37045.4	36960.8	37035.4	2177.0
2023-01-20 03:00:00	YM	Futures	37033.2	37035.4	36941.8	36969.7	3726.0
2023-01-20 04:00:00	YM	Futures	36970.8	36973.0	36897.2	36909.5	3149.0
2023-01-20 05:00:00	YM	Futures	36907.3	36939.6	36864.9	36927.3	4660.0
2023-01-20 06:00:00	YM	Futures	36927.3	36927.3	36862.7	36879.4	2225.0
2023-01-20 07:00:00	YM	Futures	36879.4	36950.7	36858.2	36938.5	3340.0
2023-01-20 08:00:00	YM	Futures	36937.4	36969.7	36880.5	36881.6	4108.0
2023-01-20 09:00:00	YM	Futures	36881.6	36986.4	36802.5	36856.0	23399.0
2023-01-20 10:00:00	YM	Futures	36857.1	36992.0	36834.9	36957.4	18292.0
2023-01-20 11:00:00	YM	Futures	36957.4	37142.4	36950.7	37006.4	22716.0
2023-01-20 12:00:00	YM	Futures	37006.4	37068.8	36998.6	37023.1	8967.0
2023-01-20 13:00:00	YM	Futures	37024.3	37130.1	36945.2	37100.0	17033.0
2023-01-20 14:00:00	YM	Futures	37098.9	37175.8	37078.9	37169.1	11749.0
2023-01-20 15:00:00	YM	Futures	37168.0	37305.0	37168.0	37293.9	23830.0

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

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