PREVIEW / futures_1hour / 2021-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-08.parquet
  size:    65 KB
  rows:    1,951

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-07-08 00:00:00	ES	Futures	4889.68	4891.08	4887.99	4889.96	4383.0
2021-07-08 01:00:00	ES	Futures	4889.96	4891.36	4887.14	4887.7	5979.0
2021-07-08 02:00:00	ES	Futures	4887.99	4889.68	4871.94	4873.91	21369.0
2021-07-08 03:00:00	ES	Futures	4874.19	4876.16	4851.38	4861.24	61789.0
2021-07-08 04:00:00	ES	Futures	4861.24	4863.21	4845.75	4854.2	53031.0
2021-07-08 05:00:00	ES	Futures	4854.48	4855.32	4838.99	4842.65	34625.0
2021-07-08 06:00:00	ES	Futures	4842.65	4842.65	4820.97	4836.46	70035.0
2021-07-08 07:00:00	ES	Futures	4836.46	4839.84	4827.45	4829.42	48415.0
2021-07-08 08:00:00	ES	Futures	4829.42	4839.27	4819.84	4832.51	66160.0
2021-07-08 09:00:00	ES	Futures	4832.51	4844.62	4822.38	4842.93	293932.0
2021-07-08 10:00:00	ES	Futures	4842.65	4842.93	4820.97	4827.73	328721.0
2021-07-08 11:00:00	ES	Futures	4827.73	4861.52	4826.04	4859.26	208753.0
2021-07-08 12:00:00	ES	Futures	4859.26	4868.84	4856.17	4866.59	108810.0
2021-07-08 13:00:00	ES	Futures	4866.59	4867.43	4858.7	4859.83	110313.0
2021-07-08 14:00:00	ES	Futures	4859.83	4860.67	4847.16	4851.94	125643.0
2021-07-08 15:00:00	ES	Futures	4851.66	4861.24	4839.55	4860.67	323184.0
2021-07-08 16:00:00	ES	Futures	4860.67	4861.8	4851.66	4854.76	58646.0
2021-07-08 18:00:00	ES	Futures	4854.76	4857.29	4851.66	4852.79	5603.0
2021-07-08 19:00:00	ES	Futures	4852.79	4857.57	4851.66	4852.79	5977.0
2021-07-08 20:00:00	ES	Futures	4852.79	4860.67	4847.72	4848.28	16847.0
2021-07-08 21:00:00	ES	Futures	4848.56	4849.13	4838.99	4840.4	15873.0
2021-07-08 22:00:00	ES	Futures	4840.4	4846.31	4835.61	4845.47	13695.0
2021-07-08 23:00:00	ES	Futures	4845.75	4851.94	4844.9	4845.47	9852.0
2021-07-08 00:00:00	NQ	Futures	17132.91	17135.81	17121.03	17130.3	2259.0
2021-07-08 01:00:00	NQ	Futures	17129.43	17138.99	17119.58	17127.11	3086.0
2021-07-08 02:00:00	NQ	Futures	17127.11	17142.47	17102.49	17105.1	8089.0
2021-07-08 03:00:00	NQ	Futures	17105.97	17113.21	16990.96	17028.91	26062.0
2021-07-08 04:00:00	NQ	Futures	17028.62	17030.94	16958.81	16982.56	22151.0
2021-07-08 05:00:00	NQ	Futures	16982.85	16988.07	16927.81	16944.04	15688.0
2021-07-08 06:00:00	NQ	Futures	16943.17	16958.23	16882.04	16955.62	20882.0
2021-07-08 07:00:00	NQ	Futures	16955.04	16964.02	16896.53	16901.45	14277.0
2021-07-08 08:00:00	NQ	Futures	16900.58	16932.74	16852.5	16913.62	25610.0
2021-07-08 09:00:00	NQ	Futures	16912.75	16965.47	16848.44	16962.0	107113.0
2021-07-08 10:00:00	NQ	Futures	16961.13	16984.01	16891.31	16894.5	105406.0
2021-07-08 11:00:00	NQ	Futures	16894.5	17017.9	16877.99	17009.79	72133.0
2021-07-08 12:00:00	NQ	Futures	17010.37	17060.2	16989.52	17044.56	42167.0
2021-07-08 13:00:00	NQ	Futures	17044.56	17096.99	17032.39	17072.94	39310.0
2021-07-08 14:00:00	NQ	Futures	17072.94	17077.58	17017.33	17043.4	36967.0
2021-07-08 15:00:00	NQ	Futures	17043.69	17061.65	16986.33	17059.62	57646.0
2021-07-08 16:00:00	NQ	Futures	17060.2	17063.67	17029.78	17048.32	11677.0
2021-07-08 18:00:00	NQ	Futures	17045.13	17051.22	17023.12	17030.07	2718.0
2021-07-08 19:00:00	NQ	Futures	17030.94	17043.11	17019.64	17023.99	2212.0
2021-07-08 20:00:00	NQ	Futures	17023.41	17052.38	16993.86	16994.15	6474.0
2021-07-08 21:00:00	NQ	Futures	16995.89	17014.43	16975.03	16981.12	5969.0
2021-07-08 22:00:00	NQ	Futures	16981.41	17009.5	16964.6	17004.58	5205.0
2021-07-08 23:00:00	NQ	Futures	17004.58	17026.6	17000.23	17004.29	4104.0
2021-07-08 00:00:00	YM	Futures	38522.8	38539.6	38513.9	38530.7	722.0
2021-07-08 01:00:00	YM	Futures	38528.4	38536.3	38503.9	38509.4	1115.0
2021-07-08 02:00:00	YM	Futures	38509.4	38520.6	38334.0	38348.6	4653.0
2021-07-08 03:00:00	YM	Futures	38350.8	38363.1	38156.4	38236.8	12971.0

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

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