PREVIEW / futures_1hour / 2021-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-20.parquet
  size:    54 KB
  rows:    1,574

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-08-20 00:00:00	ES	Futures	4951.62	4952.75	4948.24	4950.78	3864.0
2021-08-20 01:00:00	ES	Futures	4950.5	4950.78	4940.36	4947.68	13444.0
2021-08-20 02:00:00	ES	Futures	4947.96	4951.06	4941.49	4944.87	11656.0
2021-08-20 03:00:00	ES	Futures	4944.87	4946.55	4924.03	4930.5	39121.0
2021-08-20 04:00:00	ES	Futures	4930.5	4937.83	4926.28	4934.45	22315.0
2021-08-20 05:00:00	ES	Futures	4934.45	4944.87	4931.07	4939.23	18885.0
2021-08-20 06:00:00	ES	Futures	4939.23	4940.92	4933.6	4937.54	14764.0
2021-08-20 07:00:00	ES	Futures	4937.26	4943.18	4931.63	4936.14	20092.0
2021-08-20 08:00:00	ES	Futures	4936.14	4956.13	4935.29	4956.13	36453.0
2021-08-20 09:00:00	ES	Futures	4955.85	4983.16	4953.59	4980.34	227242.0
2021-08-20 10:00:00	ES	Futures	4980.63	4993.86	4979.22	4984.29	214120.0
2021-08-20 11:00:00	ES	Futures	4984.29	4991.33	4981.75	4987.1	100742.0
2021-08-20 12:00:00	ES	Futures	4987.1	4999.77	4985.69	4996.11	96343.0
2021-08-20 13:00:00	ES	Futures	4996.11	4999.49	4990.2	4991.04	67971.0
2021-08-20 14:00:00	ES	Futures	4991.04	4995.83	4987.1	4991.61	78879.0
2021-08-20 15:00:00	ES	Futures	4991.33	5001.46	4990.2	4996.96	183349.0
2021-08-20 16:00:00	ES	Futures	4996.68	4998.93	4993.02	4998.08	69957.0
2021-08-20 00:00:00	NQ	Futures	17291.07	17296.29	17280.07	17287.89	2284.0
2021-08-20 01:00:00	NQ	Futures	17287.89	17287.89	17256.02	17281.51	5519.0
2021-08-20 02:00:00	NQ	Futures	17282.09	17289.92	17268.77	17276.88	4956.0
2021-08-20 03:00:00	NQ	Futures	17277.17	17288.18	17208.23	17231.69	12697.0
2021-08-20 04:00:00	NQ	Futures	17232.27	17256.31	17220.1	17246.46	8708.0
2021-08-20 05:00:00	NQ	Futures	17246.46	17277.17	17232.56	17261.24	7754.0
2021-08-20 06:00:00	NQ	Futures	17260.37	17267.9	17243.57	17254.57	5620.0
2021-08-20 07:00:00	NQ	Futures	17254.86	17281.51	17238.35	17266.16	7383.0
2021-08-20 08:00:00	NQ	Futures	17266.74	17331.92	17263.55	17331.05	13005.0
2021-08-20 09:00:00	NQ	Futures	17331.05	17433.6	17323.23	17428.38	86667.0
2021-08-20 10:00:00	NQ	Futures	17428.67	17494.43	17423.46	17460.25	81466.0
2021-08-20 11:00:00	NQ	Futures	17459.09	17465.17	17382.61	17399.99	62660.0
2021-08-20 12:00:00	NQ	Futures	17399.99	17464.01	17391.3	17456.77	45371.0
2021-08-20 13:00:00	NQ	Futures	17457.93	17470.1	17435.63	17443.45	26997.0
2021-08-20 14:00:00	NQ	Futures	17443.45	17462.86	17438.23	17457.06	27956.0
2021-08-20 15:00:00	NQ	Futures	17456.77	17496.75	17453.59	17477.63	58874.0
2021-08-20 16:00:00	NQ	Futures	17477.63	17492.69	17471.55	17490.95	11705.0
2021-08-20 00:00:00	YM	Futures	38862.5	38867.0	38829.0	38846.9	739.0
2021-08-20 01:00:00	YM	Futures	38845.7	38845.7	38763.1	38821.2	2857.0
2021-08-20 02:00:00	YM	Futures	38822.3	38859.1	38770.9	38810.0	3106.0
2021-08-20 03:00:00	YM	Futures	38805.5	38813.3	38622.3	38686.0	10256.0
2021-08-20 04:00:00	YM	Futures	38687.1	38756.4	38655.8	38724.0	4871.0
2021-08-20 05:00:00	YM	Futures	38722.8	38805.5	38689.3	38757.5	3801.0
2021-08-20 06:00:00	YM	Futures	38756.4	38774.2	38709.4	38744.1	2618.0
2021-08-20 07:00:00	YM	Futures	38742.9	38783.2	38696.0	38720.6	3259.0
2021-08-20 08:00:00	YM	Futures	38721.7	38872.5	38711.7	38870.3	5019.0
2021-08-20 09:00:00	YM	Futures	38868.1	39080.4	38852.4	39045.7	30929.0
2021-08-20 10:00:00	YM	Futures	39046.8	39151.9	39032.3	39070.3	23612.0
2021-08-20 11:00:00	YM	Futures	39069.2	39150.7	39049.1	39149.6	11276.0
2021-08-20 12:00:00	YM	Futures	39149.6	39237.9	39140.7	39179.8	13466.0
2021-08-20 13:00:00	YM	Futures	39180.9	39213.3	39140.7	39145.2	7149.0
2021-08-20 14:00:00	YM	Futures	39145.2	39180.9	39096.0	39135.1	8585.0
2021-08-20 15:00:00	YM	Futures	39134.0	39210.0	39127.3	39166.4	13538.0

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

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