PREVIEW / futures_1hour / 2021-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-26.parquet
  size:    64 KB
  rows:    1,985

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-26 00:00:00	ES	Futures	5158.0	5160.25	5157.43	5158.84	2589.0
2021-10-26 01:00:00	ES	Futures	5158.84	5159.41	5154.33	5154.89	5265.0
2021-10-26 02:00:00	ES	Futures	5154.89	5162.23	5154.33	5159.97	6130.0
2021-10-26 03:00:00	ES	Futures	5159.97	5165.9	5156.87	5165.33	16271.0
2021-10-26 04:00:00	ES	Futures	5165.33	5170.98	5163.08	5166.46	17695.0
2021-10-26 05:00:00	ES	Futures	5166.46	5167.03	5163.64	5166.74	8580.0
2021-10-26 06:00:00	ES	Futures	5166.74	5167.31	5163.36	5166.74	10291.0
2021-10-26 07:00:00	ES	Futures	5166.74	5168.44	5164.49	5165.33	14764.0
2021-10-26 08:00:00	ES	Futures	5165.62	5167.31	5163.36	5166.18	13493.0
2021-10-26 09:00:00	ES	Futures	5165.9	5173.52	5161.95	5169.28	168433.0
2021-10-26 10:00:00	ES	Futures	5169.28	5181.42	5166.74	5177.47	170073.0
2021-10-26 11:00:00	ES	Futures	5177.19	5180.01	5165.9	5166.18	136355.0
2021-10-26 12:00:00	ES	Futures	5166.18	5167.59	5148.4	5155.46	191648.0
2021-10-26 13:00:00	ES	Futures	5155.74	5163.92	5151.22	5159.97	112110.0
2021-10-26 14:00:00	ES	Futures	5159.97	5166.46	5159.12	5165.05	83202.0
2021-10-26 15:00:00	ES	Futures	5165.33	5169.28	5151.51	5152.92	173149.0
2021-10-26 16:00:00	ES	Futures	5152.92	5156.87	5150.09	5151.22	50423.0
2021-10-26 18:00:00	ES	Futures	5151.79	5160.82	5151.22	5159.12	8049.0
2021-10-26 19:00:00	ES	Futures	5158.84	5162.23	5155.17	5158.28	5465.0
2021-10-26 20:00:00	ES	Futures	5158.28	5160.82	5152.07	5152.63	7703.0
2021-10-26 21:00:00	ES	Futures	5152.92	5155.46	5149.25	5149.81	7155.0
2021-10-26 22:00:00	ES	Futures	5149.81	5154.33	5149.81	5153.2	4552.0
2021-10-26 23:00:00	ES	Futures	5153.2	5155.46	5152.35	5153.76	3353.0
2021-10-26 00:00:00	NQ	Futures	18046.62	18061.41	18045.47	18055.61	2124.0
2021-10-26 01:00:00	NQ	Futures	18056.19	18062.27	18046.33	18047.49	2799.0
2021-10-26 02:00:00	NQ	Futures	18047.49	18074.45	18046.33	18064.3	4182.0
2021-10-26 03:00:00	NQ	Futures	18064.01	18090.1	18047.78	18086.91	10969.0
2021-10-26 04:00:00	NQ	Futures	18086.04	18098.79	18072.42	18081.69	8762.0
2021-10-26 05:00:00	NQ	Futures	18081.4	18088.07	18073.87	18083.14	4793.0
2021-10-26 06:00:00	NQ	Futures	18083.43	18086.62	18055.9	18066.33	7381.0
2021-10-26 07:00:00	NQ	Futures	18066.33	18079.37	18062.56	18069.81	6255.0
2021-10-26 08:00:00	NQ	Futures	18069.81	18079.66	18057.64	18069.52	8244.0
2021-10-26 09:00:00	NQ	Futures	18069.52	18152.41	18061.41	18129.8	87909.0
2021-10-26 10:00:00	NQ	Futures	18130.67	18201.68	18124.87	18164.29	81146.0
2021-10-26 11:00:00	NQ	Futures	18164.87	18175.3	18065.46	18073.29	77285.0
2021-10-26 12:00:00	NQ	Futures	18073.29	18086.62	17972.14	18011.85	81444.0
2021-10-26 13:00:00	NQ	Futures	18011.27	18067.2	17990.98	18037.35	56948.0
2021-10-26 14:00:00	NQ	Futures	18037.64	18064.3	18024.31	18057.64	36188.0
2021-10-26 15:00:00	NQ	Futures	18057.93	18077.92	18012.72	18020.83	56433.0
2021-10-26 16:00:00	NQ	Futures	18020.83	18034.16	17988.37	17995.04	20421.0
2021-10-26 18:00:00	NQ	Futures	18006.05	18051.84	18003.15	18042.28	4923.0
2021-10-26 19:00:00	NQ	Futures	18041.12	18050.39	18028.37	18038.8	2952.0
2021-10-26 20:00:00	NQ	Futures	18038.51	18047.2	18006.34	18009.53	5093.0
2021-10-26 21:00:00	NQ	Futures	18008.66	18019.96	17992.14	18000.83	5415.0
2021-10-26 22:00:00	NQ	Futures	18000.54	18016.77	17999.96	18007.21	3631.0
2021-10-26 23:00:00	NQ	Futures	18007.5	18016.77	18006.92	18012.14	2907.0
2021-10-26 00:00:00	YM	Futures	39979.4	39989.5	39974.9	39977.2	545.0
2021-10-26 01:00:00	YM	Futures	39978.3	39983.9	39940.2	39946.9	1480.0
2021-10-26 02:00:00	YM	Futures	39945.8	40002.9	39941.3	39986.1	1802.0
2021-10-26 03:00:00	YM	Futures	39983.9	40023.1	39967.1	40018.6	3426.0

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

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