PREVIEW / futures_1hour / 2020-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-01.parquet
  size:    60 KB
  rows:    1,833

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
2020-06-01 00:00:00	ES	Futures	3332.21	3339.9	3331.94	3338.8	5666.0
2020-06-01 01:00:00	ES	Futures	3338.8	3342.64	3332.76	3337.98	9694.0
2020-06-01 02:00:00	ES	Futures	3337.98	3353.07	3334.96	3350.32	20887.0
2020-06-01 03:00:00	ES	Futures	3350.32	3353.62	3346.76	3347.58	26535.0
2020-06-01 04:00:00	ES	Futures	3347.58	3348.4	3315.47	3331.66	61404.0
2020-06-01 05:00:00	ES	Futures	3331.94	3334.68	3325.35	3327.27	21126.0
2020-06-01 06:00:00	ES	Futures	3327.55	3337.43	3323.16	3337.15	17982.0
2020-06-01 07:00:00	ES	Futures	3337.43	3344.84	3336.88	3339.07	22210.0
2020-06-01 08:00:00	ES	Futures	3339.35	3342.64	3328.37	3331.39	48212.0
2020-06-01 09:00:00	ES	Futures	3331.39	3341.54	3322.61	3335.51	151428.0
2020-06-01 10:00:00	ES	Futures	3335.51	3347.58	3332.49	3345.11	181962.0
2020-06-01 11:00:00	ES	Futures	3345.11	3345.93	3336.05	3344.29	117505.0
2020-06-01 12:00:00	ES	Futures	3344.01	3351.7	3341.27	3350.05	63576.0
2020-06-01 13:00:00	ES	Futures	3350.05	3357.73	3349.5	3353.89	70538.0
2020-06-01 14:00:00	ES	Futures	3354.17	3355.54	3349.5	3354.99	61351.0
2020-06-01 15:00:00	ES	Futures	3354.99	3356.64	3347.03	3350.87	171515.0
2020-06-01 16:00:00	ES	Futures	3350.87	3353.62	3346.21	3351.7	52681.0
2020-06-01 18:00:00	ES	Futures	3350.87	3353.07	3339.07	3343.19	15519.0
2020-06-01 19:00:00	ES	Futures	3343.19	3343.19	3331.39	3334.96	23426.0
2020-06-01 20:00:00	ES	Futures	3334.96	3343.46	3333.04	3341.54	16728.0
2020-06-01 21:00:00	ES	Futures	3341.54	3343.19	3332.76	3334.13	16276.0
2020-06-01 22:00:00	ES	Futures	3334.41	3337.15	3331.39	3332.76	14107.0
2020-06-01 23:00:00	ES	Futures	3332.76	3338.52	3332.76	3337.98	6472.0
2020-06-01 00:00:00	NQ	Futures	10904.9	10933.18	10902.9	10929.75	2634.0
2020-06-01 01:00:00	NQ	Futures	10930.32	10934.32	10906.9	10920.33	3570.0
2020-06-01 02:00:00	NQ	Futures	10919.47	10955.46	10908.62	10946.32	5739.0
2020-06-01 03:00:00	NQ	Futures	10947.18	10953.75	10924.9	10927.75	7647.0
2020-06-01 04:00:00	NQ	Futures	10928.61	10932.9	10832.92	10877.2	17940.0
2020-06-01 05:00:00	NQ	Futures	10877.48	10884.34	10847.49	10859.77	6305.0
2020-06-01 06:00:00	NQ	Futures	10859.2	10887.48	10846.06	10887.19	6984.0
2020-06-01 07:00:00	NQ	Futures	10887.48	10911.47	10886.05	10896.9	7311.0
2020-06-01 08:00:00	NQ	Futures	10896.33	10906.62	10871.48	10877.77	14104.0
2020-06-01 09:00:00	NQ	Futures	10876.91	10930.9	10860.91	10911.76	50201.0
2020-06-01 10:00:00	NQ	Futures	10912.33	10951.46	10902.62	10937.18	54592.0
2020-06-01 11:00:00	NQ	Futures	10937.18	10941.18	10894.91	10926.33	31147.0
2020-06-01 12:00:00	NQ	Futures	10926.33	10961.17	10912.04	10947.46	20583.0
2020-06-01 13:00:00	NQ	Futures	10947.46	10975.17	10947.46	10962.03	18867.0
2020-06-01 14:00:00	NQ	Futures	10962.32	10967.17	10946.03	10961.46	14968.0
2020-06-01 15:00:00	NQ	Futures	10961.17	10970.31	10940.04	10961.17	29354.0
2020-06-01 16:00:00	NQ	Futures	10960.89	10967.74	10943.18	10960.03	7637.0
2020-06-01 18:00:00	NQ	Futures	10957.17	10964.89	10929.47	10942.32	3147.0
2020-06-01 19:00:00	NQ	Futures	10941.75	10943.46	10916.04	10929.18	5717.0
2020-06-01 20:00:00	NQ	Futures	10930.04	10953.18	10922.9	10950.89	5727.0
2020-06-01 21:00:00	NQ	Futures	10950.61	10956.03	10923.47	10930.32	5663.0
2020-06-01 22:00:00	NQ	Futures	10929.47	10942.04	10921.47	10932.61	4359.0
2020-06-01 23:00:00	NQ	Futures	10932.04	10945.46	10931.75	10942.89	2383.0
2020-06-01 00:00:00	YM	Futures	27764.1	27828.7	27760.8	27805.7	1324.0
2020-06-01 01:00:00	YM	Futures	27809.0	27833.1	27751.0	27804.6	2275.0
2020-06-01 02:00:00	YM	Futures	27803.5	27939.4	27779.4	27914.2	4486.0
2020-06-01 03:00:00	YM	Futures	27916.4	27951.4	27894.5	27903.2	5616.0

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

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