PREVIEW / futures_1hour / 2023-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-20.parquet
  size:    67 KB
  rows:    2,031

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-07-20 00:00:00	ES	Futures	5039.75	5042.77	5039.75	5040.58	4613.0
2023-07-20 01:00:00	ES	Futures	5040.85	5042.23	5040.03	5041.95	5055.0
2023-07-20 02:00:00	ES	Futures	5041.95	5043.6	5032.89	5033.72	13285.0
2023-07-20 03:00:00	ES	Futures	5033.99	5040.3	5033.17	5040.03	24214.0
2023-07-20 04:00:00	ES	Futures	5040.3	5043.05	5038.38	5040.3	16553.0
2023-07-20 05:00:00	ES	Futures	5040.03	5040.58	5036.19	5040.03	11384.0
2023-07-20 06:00:00	ES	Futures	5040.03	5044.15	5039.48	5042.23	10613.0
2023-07-20 07:00:00	ES	Futures	5041.95	5042.5	5038.11	5041.4	14280.0
2023-07-20 08:00:00	ES	Futures	5041.4	5041.68	5032.62	5033.17	31503.0
2023-07-20 09:00:00	ES	Futures	5033.17	5044.7	5028.23	5041.4	168229.0
2023-07-20 10:00:00	ES	Futures	5041.4	5042.77	5018.89	5028.23	259831.0
2023-07-20 11:00:00	ES	Futures	5028.23	5036.19	5025.75	5032.62	143792.0
2023-07-20 12:00:00	ES	Futures	5032.89	5040.85	5024.66	5026.3	128412.0
2023-07-20 13:00:00	ES	Futures	5026.58	5030.15	5023.28	5025.21	94495.0
2023-07-20 14:00:00	ES	Futures	5025.21	5026.58	5010.93	5015.32	155829.0
2023-07-20 15:00:00	ES	Futures	5015.6	5018.34	5004.07	5012.58	275274.0
2023-07-20 16:00:00	ES	Futures	5012.58	5016.15	5011.75	5013.95	55440.0
2023-07-20 18:00:00	ES	Futures	5013.95	5016.42	5011.21	5012.3	5011.0
2023-07-20 19:00:00	ES	Futures	5012.3	5014.77	5012.03	5012.85	2608.0
2023-07-20 20:00:00	ES	Futures	5013.13	5014.23	5009.01	5013.68	6358.0
2023-07-20 21:00:00	ES	Futures	5013.68	5016.97	5011.21	5015.6	6628.0
2023-07-20 22:00:00	ES	Futures	5015.6	5019.17	5015.32	5018.34	5810.0
2023-07-20 23:00:00	ES	Futures	5018.62	5019.72	5017.24	5017.52	3548.0
2023-07-20 00:00:00	NQ	Futures	17671.06	17679.96	17669.12	17677.18	2772.0
2023-07-20 01:00:00	NQ	Futures	17677.46	17687.75	17673.84	17686.64	2869.0
2023-07-20 02:00:00	NQ	Futures	17686.36	17693.87	17627.95	17635.46	7794.0
2023-07-20 03:00:00	NQ	Futures	17634.9	17644.36	17619.33	17633.79	9794.0
2023-07-20 04:00:00	NQ	Futures	17633.51	17644.64	17602.09	17614.05	11852.0
2023-07-20 05:00:00	NQ	Futures	17613.77	17617.94	17597.08	17615.16	6434.0
2023-07-20 06:00:00	NQ	Futures	17614.88	17650.76	17613.77	17644.36	8070.0
2023-07-20 07:00:00	NQ	Futures	17644.64	17655.76	17619.89	17653.82	9498.0
2023-07-20 08:00:00	NQ	Futures	17654.37	17659.1	17598.47	17613.77	17662.0
2023-07-20 09:00:00	NQ	Futures	17613.49	17683.58	17583.73	17645.75	97418.0
2023-07-20 10:00:00	NQ	Futures	17646.31	17650.76	17465.8	17495.84	152402.0
2023-07-20 11:00:00	NQ	Futures	17495.28	17561.2	17490.83	17515.59	82529.0
2023-07-20 12:00:00	NQ	Futures	17515.59	17557.86	17449.39	17459.13	74912.0
2023-07-20 13:00:00	NQ	Futures	17459.4	17483.05	17443.55	17454.95	57069.0
2023-07-20 14:00:00	NQ	Futures	17454.95	17455.23	17361.22	17362.06	85383.0
2023-07-20 15:00:00	NQ	Futures	17362.34	17378.19	17296.42	17342.03	117334.0
2023-07-20 16:00:00	NQ	Futures	17342.03	17360.11	17341.2	17351.21	16743.0
2023-07-20 18:00:00	NQ	Futures	17345.09	17357.89	17327.85	17334.52	4339.0
2023-07-20 19:00:00	NQ	Futures	17334.52	17346.76	17329.8	17333.13	2830.0
2023-07-20 20:00:00	NQ	Futures	17333.69	17341.2	17304.76	17340.64	6319.0
2023-07-20 21:00:00	NQ	Futures	17339.81	17355.38	17323.12	17345.37	5315.0
2023-07-20 22:00:00	NQ	Futures	17345.65	17365.95	17344.81	17361.5	4334.0
2023-07-20 23:00:00	NQ	Futures	17362.06	17368.18	17352.88	17358.44	3076.0
2023-07-20 00:00:00	YM	Futures	38620.2	38644.3	38620.2	38621.3	765.0
2023-07-20 01:00:00	YM	Futures	38622.4	38630.0	38607.0	38622.4	2442.0
2023-07-20 02:00:00	YM	Futures	38622.4	38632.2	38574.1	38585.1	3488.0
2023-07-20 03:00:00	YM	Futures	38585.1	38651.9	38577.4	38650.8	5750.0

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

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