PREVIEW / futures_1hour / 2023-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-13.parquet
  size:    72 KB
  rows:    2,060

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-13 00:00:00	ES	Futures	4394.58	4398.21	4390.38	4393.18	4671.0
2023-03-13 01:00:00	ES	Futures	4392.9	4400.17	4389.82	4397.93	6069.0
2023-03-13 02:00:00	ES	Futures	4398.21	4405.2	4395.42	4400.17	9778.0
2023-03-13 03:00:00	ES	Futures	4399.89	4401.57	4381.71	4384.79	14457.0
2023-03-13 04:00:00	ES	Futures	4384.79	4385.91	4342.85	4343.97	47022.0
2023-03-13 05:00:00	ES	Futures	4344.25	4346.48	4308.46	4320.2	72123.0
2023-03-13 06:00:00	ES	Futures	4320.2	4345.65	4313.21	4339.21	49633.0
2023-03-13 07:00:00	ES	Futures	4339.21	4357.95	4319.36	4324.12	53116.0
2023-03-13 08:00:00	ES	Futures	4324.12	4331.39	4259.81	4288.88	116773.0
2023-03-13 09:00:00	ES	Futures	4288.88	4323.84	4261.2	4315.45	221918.0
2023-03-13 10:00:00	ES	Futures	4315.73	4342.29	4294.48	4340.61	198123.0
2023-03-13 11:00:00	ES	Futures	4340.61	4364.38	4332.78	4352.91	146107.0
2023-03-13 12:00:00	ES	Futures	4352.91	4370.81	4322.16	4328.03	133556.0
2023-03-13 13:00:00	ES	Futures	4328.03	4345.09	4314.05	4342.01	93179.0
2023-03-13 14:00:00	ES	Futures	4342.29	4361.3	4340.33	4349.28	62787.0
2023-03-13 15:00:00	ES	Futures	4349.28	4354.31	4310.97	4313.77	125999.0
2023-03-13 16:00:00	ES	Futures	4313.77	4324.12	4312.65	4320.48	33284.0
2023-03-13 18:00:00	ES	Futures	4323.56	4328.31	4317.13	4328.03	4204.0
2023-03-13 19:00:00	ES	Futures	4328.03	4328.31	4317.68	4318.52	4801.0
2023-03-13 20:00:00	ES	Futures	4318.24	4330.55	4315.45	4324.95	8241.0
2023-03-13 21:00:00	ES	Futures	4324.95	4332.5	4322.16	4327.75	6661.0
2023-03-13 22:00:00	ES	Futures	4327.47	4339.49	4327.47	4336.42	5532.0
2023-03-13 23:00:00	ES	Futures	4336.7	4339.49	4332.22	4336.7	3668.0
2023-03-13 00:00:00	NQ	Futures	13712.61	13730.25	13698.67	13709.77	3149.0
2023-03-13 01:00:00	NQ	Futures	13710.91	13739.64	13702.94	13731.96	3974.0
2023-03-13 02:00:00	NQ	Futures	13730.54	13764.68	13722.57	13742.49	4655.0
2023-03-13 03:00:00	NQ	Futures	13743.34	13751.59	13679.61	13695.83	6939.0
2023-03-13 04:00:00	NQ	Futures	13695.83	13709.48	13567.24	13574.07	17407.0
2023-03-13 05:00:00	NQ	Futures	13573.78	13604.51	13494.12	13541.92	24526.0
2023-03-13 06:00:00	NQ	Futures	13538.79	13645.19	13507.78	13617.88	13010.0
2023-03-13 07:00:00	NQ	Futures	13617.59	13660.55	13563.82	13582.6	14153.0
2023-03-13 08:00:00	NQ	Futures	13582.6	13607.35	13285.02	13408.49	33939.0
2023-03-13 09:00:00	NQ	Futures	13408.49	13566.67	13320.01	13527.98	61169.0
2023-03-13 10:00:00	NQ	Futures	13529.4	13609.06	13477.91	13595.69	65539.0
2023-03-13 11:00:00	NQ	Futures	13595.97	13725.99	13578.62	13696.11	67629.0
2023-03-13 12:00:00	NQ	Futures	13696.4	13743.34	13609.63	13628.12	54303.0
2023-03-13 13:00:00	NQ	Futures	13628.69	13676.77	13575.49	13664.25	31988.0
2023-03-13 14:00:00	NQ	Futures	13663.97	13753.58	13662.26	13708.63	36559.0
2023-03-13 15:00:00	NQ	Futures	13708.92	13731.11	13572.93	13576.34	42211.0
2023-03-13 16:00:00	NQ	Futures	13576.63	13608.2	13567.52	13599.67	7710.0
2023-03-13 18:00:00	NQ	Futures	13610.2	13623.85	13576.34	13619.3	1373.0
2023-03-13 19:00:00	NQ	Futures	13620.15	13626.13	13588.86	13595.12	1621.0
2023-03-13 20:00:00	NQ	Futures	13597.39	13645.76	13582.6	13619.3	3768.0
2023-03-13 21:00:00	NQ	Futures	13618.45	13647.75	13603.37	13628.4	3380.0
2023-03-13 22:00:00	NQ	Futures	13627.83	13670.51	13625.84	13654.86	3080.0
2023-03-13 23:00:00	NQ	Futures	13654.58	13661.12	13636.94	13644.9	1492.0
2023-03-13 00:00:00	YM	Futures	35987.7	36008.7	35956.8	35966.7	717.0
2023-03-13 01:00:00	YM	Futures	35970.1	36014.3	35950.2	36002.1	1232.0
2023-03-13 02:00:00	YM	Futures	36001.0	36020.9	35971.2	35996.6	1805.0
2023-03-13 03:00:00	YM	Futures	35997.7	36004.3	35881.6	35917.0	3268.0

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

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