PREVIEW / futures_1hour / 2022-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-26.parquet
  size:    70 KB
  rows:    2,100

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
2022-01-26 00:00:00	ES	Futures	4935.18	4935.46	4922.17	4931.5	6502.0
2022-01-26 01:00:00	ES	Futures	4931.22	4935.46	4924.72	4927.54	5809.0
2022-01-26 02:00:00	ES	Futures	4927.54	4933.77	4915.38	4929.52	10811.0
2022-01-26 03:00:00	ES	Futures	4929.81	4968.55	4928.39	4959.22	38786.0
2022-01-26 04:00:00	ES	Futures	4959.22	4989.48	4956.67	4979.01	39644.0
2022-01-26 05:00:00	ES	Futures	4979.01	4988.63	4968.83	4984.1	24300.0
2022-01-26 06:00:00	ES	Futures	4984.1	4999.09	4983.26	4998.81	24307.0
2022-01-26 07:00:00	ES	Futures	4998.81	4999.38	4977.03	4983.54	31510.0
2022-01-26 08:00:00	ES	Futures	4984.1	5003.62	4982.69	4995.98	45049.0
2022-01-26 09:00:00	ES	Futures	4995.98	5010.69	4969.96	5006.16	205412.0
2022-01-26 10:00:00	ES	Futures	5006.16	5019.17	4955.82	4973.92	291160.0
2022-01-26 11:00:00	ES	Futures	4973.64	4999.94	4964.03	4992.02	173497.0
2022-01-26 12:00:00	ES	Futures	4992.02	5007.86	4989.76	5005.6	90170.0
2022-01-26 13:00:00	ES	Futures	5005.88	5007.01	4984.39	4992.02	108445.0
2022-01-26 14:00:00	ES	Futures	4991.74	5029.64	4920.76	4942.25	522540.0
2022-01-26 15:00:00	ES	Futures	4941.97	4942.53	4857.69	4909.44	548664.0
2022-01-26 16:00:00	ES	Futures	4909.44	4915.1	4893.61	4908.03	79477.0
2022-01-26 18:00:00	ES	Futures	4915.38	4941.12	4915.1	4938.86	24543.0
2022-01-26 19:00:00	ES	Futures	4938.86	4940.27	4902.09	4903.22	21241.0
2022-01-26 20:00:00	ES	Futures	4903.22	4906.05	4855.99	4860.52	44547.0
2022-01-26 21:00:00	ES	Futures	4860.52	4860.8	4837.9	4850.06	36140.0
2022-01-26 22:00:00	ES	Futures	4850.34	4858.26	4822.62	4832.24	27752.0
2022-01-26 23:00:00	ES	Futures	4832.24	4847.23	4828.28	4843.55	13683.0
2022-01-26 00:00:00	NQ	Futures	16497.55	16499.87	16439.3	16487.12	6256.0
2022-01-26 01:00:00	NQ	Futures	16485.09	16508.56	16452.92	16466.54	4914.0
2022-01-26 02:00:00	NQ	Futures	16466.54	16493.2	16404.52	16477.55	9507.0
2022-01-26 03:00:00	NQ	Futures	16477.84	16607.68	16472.05	16585.66	19390.0
2022-01-26 04:00:00	NQ	Futures	16586.82	16742.74	16577.83	16697.82	24330.0
2022-01-26 05:00:00	NQ	Futures	16697.24	16733.46	16655.21	16705.93	12013.0
2022-01-26 06:00:00	NQ	Futures	16704.48	16770.56	16703.9	16765.05	13146.0
2022-01-26 07:00:00	NQ	Futures	16764.47	16766.21	16658.98	16711.44	16351.0
2022-01-26 08:00:00	NQ	Futures	16711.44	16816.64	16703.32	16768.24	27521.0
2022-01-26 09:00:00	NQ	Futures	16769.69	16807.08	16635.79	16757.23	89421.0
2022-01-26 10:00:00	NQ	Futures	16757.23	16826.78	16607.39	16683.03	109039.0
2022-01-26 11:00:00	NQ	Futures	16681.88	16779.54	16626.23	16748.24	59882.0
2022-01-26 12:00:00	NQ	Futures	16748.82	16865.62	16741.58	16850.55	41097.0
2022-01-26 13:00:00	NQ	Futures	16850.55	16855.19	16766.5	16784.47	39607.0
2022-01-26 14:00:00	NQ	Futures	16784.47	16971.4	16451.76	16534.94	187023.0
2022-01-26 15:00:00	NQ	Futures	16533.49	16533.49	16202.23	16401.62	128677.0
2022-01-26 16:00:00	NQ	Futures	16402.2	16429.73	16294.1	16404.52	25285.0
2022-01-26 18:00:00	NQ	Futures	16454.66	16556.96	16444.52	16539.58	14632.0
2022-01-26 19:00:00	NQ	Futures	16539.29	16547.69	16407.42	16413.5	14916.0
2022-01-26 20:00:00	NQ	Futures	16412.93	16424.23	16203.97	16221.65	22725.0
2022-01-26 21:00:00	NQ	Futures	16219.33	16219.91	16104.27	16159.91	19522.0
2022-01-26 22:00:00	NQ	Futures	16160.49	16216.14	16049.49	16097.6	17132.0
2022-01-26 23:00:00	NQ	Futures	16096.44	16169.19	16086.01	16150.93	10480.0
2022-01-26 00:00:00	YM	Futures	38494.7	38498.0	38404.7	38457.6	1467.0
2022-01-26 01:00:00	YM	Futures	38455.3	38490.2	38426.1	38444.1	1190.0
2022-01-26 02:00:00	YM	Futures	38448.6	38492.4	38374.4	38464.3	3478.0
2022-01-26 03:00:00	YM	Futures	38463.2	38765.5	38456.4	38681.2	12180.0

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

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