PREVIEW / futures_1hour / 2021-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-23.parquet
  size:    64 KB
  rows:    1,935

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
2021-02-23 00:00:00	ES	Futures	4371.94	4373.9	4369.98	4370.26	7690.0
2021-02-23 01:00:00	ES	Futures	4370.26	4371.66	4363.24	4366.89	8197.0
2021-02-23 02:00:00	ES	Futures	4366.89	4369.13	4362.68	4368.85	9134.0
2021-02-23 03:00:00	ES	Futures	4368.85	4369.41	4350.33	4352.01	32675.0
2021-02-23 04:00:00	ES	Futures	4351.73	4352.01	4328.44	4330.68	52485.0
2021-02-23 05:00:00	ES	Futures	4330.68	4332.65	4311.04	4318.33	70256.0
2021-02-23 06:00:00	ES	Futures	4318.05	4332.09	4312.16	4330.4	52765.0
2021-02-23 07:00:00	ES	Futures	4330.4	4333.49	4325.63	4332.09	34889.0
2021-02-23 08:00:00	ES	Futures	4331.8	4332.09	4322.26	4326.75	43948.0
2021-02-23 09:00:00	ES	Futures	4327.03	4327.31	4271.46	4294.2	388845.0
2021-02-23 10:00:00	ES	Futures	4294.2	4333.21	4285.5	4328.16	393682.0
2021-02-23 11:00:00	ES	Futures	4328.16	4338.26	4311.88	4314.12	205398.0
2021-02-23 12:00:00	ES	Futures	4313.84	4321.42	4298.13	4300.65	208397.0
2021-02-23 13:00:00	ES	Futures	4300.65	4330.96	4297.28	4327.03	166924.0
2021-02-23 14:00:00	ES	Futures	4327.31	4344.72	4322.54	4344.72	156893.0
2021-02-23 15:00:00	ES	Futures	4344.43	4369.69	4343.03	4353.7	273275.0
2021-02-23 16:00:00	ES	Futures	4353.7	4358.47	4348.08	4351.45	45447.0
2021-02-23 18:00:00	ES	Futures	4351.73	4355.38	4339.66	4348.64	20653.0
2021-02-23 19:00:00	ES	Futures	4348.64	4353.98	4343.03	4348.93	13665.0
2021-02-23 20:00:00	ES	Futures	4348.93	4366.89	4348.93	4360.99	23969.0
2021-02-23 21:00:00	ES	Futures	4361.27	4363.8	4348.64	4351.73	17600.0
2021-02-23 22:00:00	ES	Futures	4351.73	4357.91	4341.63	4346.96	20748.0
2021-02-23 23:00:00	ES	Futures	4347.24	4352.01	4343.59	4346.68	8346.0
2021-02-23 00:00:00	NQ	Futures	15430.0	15439.26	15405.11	15408.87	4998.0
2021-02-23 01:00:00	NQ	Futures	15409.16	15414.66	15378.19	15396.43	5319.0
2021-02-23 02:00:00	NQ	Futures	15397.59	15414.37	15383.69	15412.93	5511.0
2021-02-23 03:00:00	NQ	Futures	15412.64	15412.64	15290.78	15297.15	17385.0
2021-02-23 04:00:00	NQ	Futures	15296.57	15296.86	15143.17	15161.12	30060.0
2021-02-23 05:00:00	NQ	Futures	15161.41	15168.64	14988.62	15029.43	37114.0
2021-02-23 06:00:00	NQ	Futures	15030.0	15093.39	14997.88	15076.02	19354.0
2021-02-23 07:00:00	NQ	Futures	15076.89	15107.86	15063.29	15085.29	14290.0
2021-02-23 08:00:00	NQ	Futures	15085.87	15086.15	15015.53	15074.0	23205.0
2021-02-23 09:00:00	NQ	Futures	15074.29	15077.47	14769.51	14917.7	143677.0
2021-02-23 10:00:00	NQ	Futures	14917.41	15166.04	14891.08	15137.38	137910.0
2021-02-23 11:00:00	NQ	Futures	15137.09	15188.61	15013.8	15023.35	78995.0
2021-02-23 12:00:00	NQ	Futures	15021.61	15068.5	14918.57	14935.36	80985.0
2021-02-23 13:00:00	NQ	Futures	14935.94	15123.2	14917.41	15103.81	52347.0
2021-02-23 14:00:00	NQ	Futures	15103.23	15199.61	15087.31	15199.61	47088.0
2021-02-23 15:00:00	NQ	Futures	15199.61	15348.38	15186.59	15268.21	89232.0
2021-02-23 16:00:00	NQ	Futures	15269.08	15280.65	15224.79	15232.9	15301.0
2021-02-23 18:00:00	NQ	Futures	15248.24	15268.79	15208.01	15246.5	8083.0
2021-02-23 19:00:00	NQ	Futures	15246.5	15270.52	15227.4	15243.32	7614.0
2021-02-23 20:00:00	NQ	Futures	15243.9	15355.04	15243.9	15320.89	13763.0
2021-02-23 21:00:00	NQ	Futures	15321.17	15329.86	15247.66	15261.84	10287.0
2021-02-23 22:00:00	NQ	Futures	15263.0	15299.76	15193.25	15231.74	13283.0
2021-02-23 23:00:00	NQ	Futures	15232.32	15256.92	15208.3	15234.06	6977.0
2021-02-23 00:00:00	YM	Futures	35046.1	35067.2	35045.0	35052.8	1900.0
2021-02-23 01:00:00	YM	Futures	35053.9	35063.9	35004.0	35023.9	1877.0
2021-02-23 02:00:00	YM	Futures	35023.9	35026.2	34986.2	35022.8	2112.0
2021-02-23 03:00:00	YM	Futures	35025.1	35033.9	34921.9	34948.5	7411.0

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

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