PREVIEW / futures_1hour / 2023-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-14.parquet
  size:    70 KB
  rows:    2,042

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-14 00:00:00	ES	Futures	4336.7	4340.03	4334.2	4335.87	4942.0
2023-03-14 01:00:00	ES	Futures	4335.87	4339.47	4324.49	4328.38	7470.0
2023-03-14 02:00:00	ES	Futures	4328.38	4330.04	4312.29	4326.44	19439.0
2023-03-14 03:00:00	ES	Futures	4326.44	4335.31	4318.95	4326.44	20187.0
2023-03-14 04:00:00	ES	Futures	4326.44	4340.03	4323.38	4339.47	41325.0
2023-03-14 05:00:00	ES	Futures	4339.19	4340.03	4322.0	4331.71	25550.0
2023-03-14 06:00:00	ES	Futures	4331.71	4337.53	4326.16	4333.09	19847.0
2023-03-14 07:00:00	ES	Futures	4333.09	4350.29	4331.98	4345.3	36253.0
2023-03-14 08:00:00	ES	Futures	4345.3	4370.53	4310.07	4364.16	162785.0
2023-03-14 09:00:00	ES	Futures	4363.88	4390.23	4361.1	4380.8	305405.0
2023-03-14 10:00:00	ES	Futures	4381.07	4402.15	4374.42	4390.78	294595.0
2023-03-14 11:00:00	ES	Futures	4390.78	4407.15	4389.39	4396.05	150497.0
2023-03-14 12:00:00	ES	Futures	4396.05	4399.66	4379.69	4383.02	154313.0
2023-03-14 13:00:00	ES	Futures	4383.29	4386.34	4350.57	4357.5	258584.0
2023-03-14 14:00:00	ES	Futures	4357.78	4366.93	4341.41	4354.17	197697.0
2023-03-14 15:00:00	ES	Futures	4354.17	4390.5	4332.81	4385.23	376481.0
2023-03-14 16:00:00	ES	Futures	4385.23	4390.23	4378.3	4387.73	72922.0
2023-03-14 18:00:00	ES	Futures	4386.34	4387.45	4379.96	4380.8	7980.0
2023-03-14 19:00:00	ES	Futures	4380.8	4386.34	4380.52	4384.68	8307.0
2023-03-14 20:00:00	ES	Futures	4384.68	4386.07	4378.86	4381.91	11190.0
2023-03-14 21:00:00	ES	Futures	4381.63	4388.01	4380.8	4386.62	9501.0
2023-03-14 22:00:00	ES	Futures	4386.62	4397.72	4386.34	4396.05	12427.0
2023-03-14 23:00:00	ES	Futures	4396.05	4396.61	4390.5	4391.61	5683.0
2023-03-14 00:00:00	NQ	Futures	13644.9	13657.86	13635.33	13641.81	1292.0
2023-03-14 01:00:00	NQ	Futures	13642.93	13654.76	13603.52	13617.59	2322.0
2023-03-14 02:00:00	NQ	Futures	13619.28	13631.95	13576.2	13624.07	5756.0
2023-03-14 03:00:00	NQ	Futures	13627.17	13655.32	13588.59	13609.99	5973.0
2023-03-14 04:00:00	NQ	Futures	13607.74	13658.42	13601.26	13652.22	13042.0
2023-03-14 05:00:00	NQ	Futures	13651.66	13653.91	13607.18	13617.03	7553.0
2023-03-14 06:00:00	NQ	Futures	13616.75	13638.99	13595.63	13631.95	6326.0
2023-03-14 07:00:00	NQ	Futures	13630.83	13687.14	13626.32	13660.95	8137.0
2023-03-14 08:00:00	NQ	Futures	13661.52	13743.17	13550.87	13722.05	44616.0
2023-03-14 09:00:00	NQ	Futures	13721.49	13842.27	13713.32	13807.92	80927.0
2023-03-14 10:00:00	NQ	Futures	13808.49	13883.1	13791.59	13842.27	80601.0
2023-03-14 11:00:00	NQ	Futures	13842.55	13916.04	13842.27	13890.42	55598.0
2023-03-14 12:00:00	NQ	Futures	13890.98	13905.62	13855.79	13874.37	48854.0
2023-03-14 13:00:00	NQ	Futures	13874.09	13885.07	13771.04	13789.34	72967.0
2023-03-14 14:00:00	NQ	Futures	13789.9	13819.47	13731.34	13779.77	66102.0
2023-03-14 15:00:00	NQ	Futures	13780.05	13903.09	13704.31	13885.91	101696.0
2023-03-14 16:00:00	NQ	Futures	13885.07	13894.08	13864.23	13892.95	19537.0
2023-03-14 18:00:00	NQ	Futures	13885.91	13894.36	13865.92	13870.43	4012.0
2023-03-14 19:00:00	NQ	Futures	13870.43	13894.64	13870.43	13882.82	3542.0
2023-03-14 20:00:00	NQ	Futures	13881.69	13886.19	13864.8	13878.59	4229.0
2023-03-14 21:00:00	NQ	Futures	13878.59	13901.68	13876.06	13893.8	4116.0
2023-03-14 22:00:00	NQ	Futures	13894.08	13936.03	13891.26	13927.58	6092.0
2023-03-14 23:00:00	NQ	Futures	13928.15	13930.68	13901.12	13907.59	3201.0
2023-03-14 00:00:00	YM	Futures	35597.6	35609.7	35574.4	35583.2	879.0
2023-03-14 01:00:00	YM	Futures	35582.1	35609.7	35506.9	35537.9	1196.0
2023-03-14 02:00:00	YM	Futures	35537.9	35547.8	35408.6	35509.1	3196.0
2023-03-14 03:00:00	YM	Futures	35513.6	35576.6	35476.0	35543.4	2882.0

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

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