PREVIEW / futures_1hour / 2021-10-08

all futures 1-hour files

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

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-10-08 00:00:00	ES	Futures	4958.47	4960.73	4956.21	4957.06	5186.0
2021-10-08 01:00:00	ES	Futures	4957.06	4959.6	4952.55	4953.67	8513.0
2021-10-08 02:00:00	ES	Futures	4953.67	4960.17	4952.55	4959.6	9271.0
2021-10-08 03:00:00	ES	Futures	4959.6	4968.91	4952.55	4957.34	27388.0
2021-10-08 04:00:00	ES	Futures	4957.34	4959.6	4946.9	4948.59	25502.0
2021-10-08 05:00:00	ES	Futures	4948.59	4956.5	4946.9	4956.21	18498.0
2021-10-08 06:00:00	ES	Futures	4956.21	4961.58	4954.8	4956.21	13444.0
2021-10-08 07:00:00	ES	Futures	4956.5	4962.99	4956.5	4960.45	14708.0
2021-10-08 08:00:00	ES	Futures	4960.17	4975.69	4947.18	4967.5	125500.0
2021-10-08 09:00:00	ES	Futures	4967.5	4973.15	4948.59	4953.39	225188.0
2021-10-08 10:00:00	ES	Futures	4953.39	4968.35	4950.01	4957.91	186461.0
2021-10-08 11:00:00	ES	Futures	4957.63	4965.53	4951.42	4953.11	119960.0
2021-10-08 12:00:00	ES	Futures	4953.39	4957.06	4946.9	4951.42	112358.0
2021-10-08 13:00:00	ES	Futures	4951.42	4954.24	4940.13	4949.72	98612.0
2021-10-08 14:00:00	ES	Futures	4949.72	4964.4	4948.88	4957.63	85987.0
2021-10-08 15:00:00	ES	Futures	4957.91	4962.42	4943.51	4947.75	184032.0
2021-10-08 16:00:00	ES	Futures	4948.03	4948.31	4940.69	4944.93	49350.0
2021-10-08 00:00:00	NQ	Futures	17258.32	17263.25	17243.25	17247.02	2585.0
2021-10-08 01:00:00	NQ	Futures	17247.6	17257.74	17215.43	17218.04	6387.0
2021-10-08 02:00:00	NQ	Futures	17217.75	17257.74	17217.75	17252.24	5070.0
2021-10-08 03:00:00	NQ	Futures	17253.1	17289.04	17198.33	17231.37	14752.0
2021-10-08 04:00:00	NQ	Futures	17231.37	17238.9	17201.81	17208.76	6950.0
2021-10-08 05:00:00	NQ	Futures	17209.63	17252.24	17202.97	17248.18	5707.0
2021-10-08 06:00:00	NQ	Futures	17247.89	17258.61	17231.37	17244.99	5539.0
2021-10-08 07:00:00	NQ	Futures	17245.86	17279.48	17245.86	17274.26	6884.0
2021-10-08 08:00:00	NQ	Futures	17274.84	17384.39	17251.95	17351.93	51293.0
2021-10-08 09:00:00	NQ	Futures	17352.22	17357.73	17210.21	17213.98	96041.0
2021-10-08 10:00:00	NQ	Futures	17214.27	17285.27	17175.72	17216.3	91499.0
2021-10-08 11:00:00	NQ	Futures	17216.59	17245.28	17167.61	17185.58	56169.0
2021-10-08 12:00:00	NQ	Futures	17185.87	17225.28	17172.83	17195.14	41133.0
2021-10-08 13:00:00	NQ	Futures	17194.85	17206.73	17146.45	17189.35	38818.0
2021-10-08 14:00:00	NQ	Futures	17188.77	17238.9	17185.87	17214.27	31119.0
2021-10-08 15:00:00	NQ	Futures	17214.27	17228.18	17151.67	17169.93	50031.0
2021-10-08 16:00:00	NQ	Futures	17170.51	17174.27	17148.48	17163.55	8996.0
2021-10-08 00:00:00	YM	Futures	38870.8	38888.8	38849.5	38856.3	1008.0
2021-10-08 01:00:00	YM	Futures	38854.0	38892.1	38833.8	38851.8	1679.0
2021-10-08 02:00:00	YM	Futures	38854.0	38882.0	38829.4	38877.6	2091.0
2021-10-08 03:00:00	YM	Futures	38878.7	38939.2	38837.2	38867.5	4993.0
2021-10-08 04:00:00	YM	Futures	38866.3	38880.9	38783.4	38791.2	4273.0
2021-10-08 05:00:00	YM	Futures	38792.4	38843.9	38769.9	38839.4	3050.0
2021-10-08 06:00:00	YM	Futures	38838.3	38891.0	38832.7	38841.7	2509.0
2021-10-08 07:00:00	YM	Futures	38841.7	38878.7	38841.7	38855.1	2196.0
2021-10-08 08:00:00	YM	Futures	38854.0	38914.5	38718.4	38840.6	16324.0
2021-10-08 09:00:00	YM	Futures	38839.4	38908.9	38707.2	38790.1	29214.0
2021-10-08 10:00:00	YM	Futures	38790.1	38900.0	38777.8	38837.2	22609.0
2021-10-08 11:00:00	YM	Futures	38836.1	38894.4	38804.7	38819.3	12792.0
2021-10-08 12:00:00	YM	Futures	38821.5	38852.9	38773.3	38819.3	9485.0
2021-10-08 13:00:00	YM	Futures	38822.6	38840.6	38738.6	38806.9	9162.0
2021-10-08 14:00:00	YM	Futures	38806.9	38919.0	38799.1	38866.3	9295.0
2021-10-08 15:00:00	YM	Futures	38867.5	38911.2	38792.4	38818.1	13869.0

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

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