PREVIEW / futures_1hour / 2021-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-06.parquet
  size:    67 KB
  rows:    2,015

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-06 00:00:00	ES	Futures	4873.53	4874.94	4862.24	4870.14	10004.0
2021-10-06 01:00:00	ES	Futures	4870.14	4877.76	4866.47	4870.42	11883.0
2021-10-06 02:00:00	ES	Futures	4870.14	4875.78	4862.8	4873.53	15087.0
2021-10-06 03:00:00	ES	Futures	4873.53	4873.53	4842.48	4845.59	66950.0
2021-10-06 04:00:00	ES	Futures	4845.87	4850.95	4837.97	4839.66	45291.0
2021-10-06 05:00:00	ES	Futures	4839.38	4839.94	4824.42	4832.32	46931.0
2021-10-06 06:00:00	ES	Futures	4832.32	4837.4	4827.81	4833.45	23042.0
2021-10-06 07:00:00	ES	Futures	4833.45	4844.18	4832.04	4842.2	45549.0
2021-10-06 08:00:00	ES	Futures	4841.92	4855.18	4839.1	4846.43	71424.0
2021-10-06 09:00:00	ES	Futures	4846.43	4873.81	4843.33	4846.15	257329.0
2021-10-06 10:00:00	ES	Futures	4846.15	4876.07	4830.91	4869.57	379901.0
2021-10-06 11:00:00	ES	Futures	4869.57	4874.94	4848.13	4870.7	208534.0
2021-10-06 12:00:00	ES	Futures	4870.7	4872.4	4848.69	4859.13	157111.0
2021-10-06 13:00:00	ES	Futures	4858.85	4891.02	4849.82	4887.92	205792.0
2021-10-06 14:00:00	ES	Futures	4888.2	4910.21	4881.71	4896.1	222243.0
2021-10-06 15:00:00	ES	Futures	4896.1	4916.99	4893.28	4914.45	229538.0
2021-10-06 16:00:00	ES	Futures	4914.45	4918.96	4910.5	4916.42	57363.0
2021-10-06 18:00:00	ES	Futures	4916.42	4930.25	4916.14	4928.28	10752.0
2021-10-06 19:00:00	ES	Futures	4928.28	4934.77	4924.32	4927.99	13785.0
2021-10-06 20:00:00	ES	Futures	4927.99	4936.18	4924.89	4931.38	16336.0
2021-10-06 21:00:00	ES	Futures	4931.66	4942.95	4928.56	4939.28	15543.0
2021-10-06 22:00:00	ES	Futures	4939.56	4947.47	4938.43	4942.95	10122.0
2021-10-06 23:00:00	ES	Futures	4942.95	4943.51	4937.59	4940.13	6815.0
2021-10-06 00:00:00	NQ	Futures	16914.31	16920.68	16867.36	16898.66	6714.0
2021-10-06 01:00:00	NQ	Futures	16898.37	16924.74	16876.63	16888.51	6514.0
2021-10-06 02:00:00	NQ	Futures	16888.8	16916.92	16858.66	16909.09	10340.0
2021-10-06 03:00:00	NQ	Futures	16908.22	16908.51	16778.09	16795.19	25247.0
2021-10-06 04:00:00	NQ	Futures	16795.19	16811.42	16763.31	16771.43	15852.0
2021-10-06 05:00:00	NQ	Futures	16771.14	16772.59	16719.55	16750.27	13342.0
2021-10-06 06:00:00	NQ	Futures	16750.56	16771.43	16727.09	16751.43	9068.0
2021-10-06 07:00:00	NQ	Futures	16750.85	16803.02	16745.92	16795.48	13960.0
2021-10-06 08:00:00	NQ	Futures	16795.19	16839.54	16775.2	16818.67	22442.0
2021-10-06 09:00:00	NQ	Futures	16817.8	16969.95	16814.32	16853.45	98232.0
2021-10-06 10:00:00	NQ	Futures	16854.03	17027.63	16790.56	16993.43	157407.0
2021-10-06 11:00:00	NQ	Futures	16993.14	17009.95	16903.59	16994.3	81285.0
2021-10-06 12:00:00	NQ	Futures	16993.72	16996.33	16900.11	16927.35	56081.0
2021-10-06 13:00:00	NQ	Futures	16926.77	17047.04	16887.65	17031.11	58059.0
2021-10-06 14:00:00	NQ	Futures	17031.39	17098.63	17008.5	17046.18	59708.0
2021-10-06 15:00:00	NQ	Futures	17045.89	17116.6	17021.83	17103.85	62403.0
2021-10-06 16:00:00	NQ	Futures	17103.56	17122.4	17096.89	17117.18	11848.0
2021-10-06 18:00:00	NQ	Futures	17120.08	17172.25	17118.92	17168.19	5260.0
2021-10-06 19:00:00	NQ	Futures	17167.9	17191.66	17152.54	17167.9	5920.0
2021-10-06 20:00:00	NQ	Futures	17167.9	17201.81	17155.15	17180.94	7856.0
2021-10-06 21:00:00	NQ	Futures	17181.52	17231.37	17169.93	17217.46	7301.0
2021-10-06 22:00:00	NQ	Futures	17217.17	17259.19	17216.01	17249.34	7113.0
2021-10-06 23:00:00	NQ	Futures	17249.63	17251.08	17222.09	17231.08	3245.0
2021-10-06 00:00:00	YM	Futures	38215.1	38231.9	38125.4	38194.9	2367.0
2021-10-06 01:00:00	YM	Futures	38194.9	38251.0	38163.5	38196.0	2324.0
2021-10-06 02:00:00	YM	Futures	38196.0	38238.6	38142.2	38219.6	3259.0
2021-10-06 03:00:00	YM	Futures	38219.6	38220.7	37986.4	38017.8	12015.0

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

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