PREVIEW / futures_1hour / 2021-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-27.parquet
  size:    66 KB
  rows:    2,010

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-27 00:00:00	ES	Futures	5153.48	5156.3	5153.2	5156.3	2445.0
2021-10-27 01:00:00	ES	Futures	5156.3	5161.66	5155.46	5161.38	5596.0
2021-10-27 02:00:00	ES	Futures	5161.66	5161.95	5157.15	5159.12	4852.0
2021-10-27 03:00:00	ES	Futures	5159.41	5165.9	5158.56	5161.66	14748.0
2021-10-27 04:00:00	ES	Futures	5161.95	5163.92	5152.63	5153.48	13316.0
2021-10-27 05:00:00	ES	Futures	5153.48	5153.76	5145.3	5147.55	21123.0
2021-10-27 06:00:00	ES	Futures	5147.55	5153.2	5143.6	5147.55	11928.0
2021-10-27 07:00:00	ES	Futures	5147.27	5154.61	5147.27	5147.84	16182.0
2021-10-27 08:00:00	ES	Futures	5148.12	5159.97	5147.55	5157.43	29335.0
2021-10-27 09:00:00	ES	Futures	5157.43	5165.05	5145.3	5164.49	189257.0
2021-10-27 10:00:00	ES	Futures	5164.77	5166.46	5147.84	5150.09	207469.0
2021-10-27 11:00:00	ES	Futures	5150.38	5158.28	5148.68	5152.35	102237.0
2021-10-27 12:00:00	ES	Futures	5152.35	5158.84	5150.66	5155.46	76622.0
2021-10-27 13:00:00	ES	Futures	5155.17	5164.2	5154.33	5163.92	67858.0
2021-10-27 14:00:00	ES	Futures	5164.2	5165.9	5155.17	5155.46	77556.0
2021-10-27 15:00:00	ES	Futures	5155.17	5156.3	5129.21	5129.49	279893.0
2021-10-27 16:00:00	ES	Futures	5129.77	5134.57	5129.49	5133.73	55416.0
2021-10-27 18:00:00	ES	Futures	5134.85	5139.09	5134.01	5138.52	6911.0
2021-10-27 19:00:00	ES	Futures	5138.52	5141.35	5136.55	5140.5	4649.0
2021-10-27 20:00:00	ES	Futures	5140.5	5141.35	5135.14	5139.09	7822.0
2021-10-27 21:00:00	ES	Futures	5139.09	5140.5	5135.98	5139.09	5645.0
2021-10-27 22:00:00	ES	Futures	5138.81	5140.22	5133.16	5137.68	7079.0
2021-10-27 23:00:00	ES	Futures	5137.68	5139.37	5136.27	5138.52	2590.0
2021-10-27 00:00:00	NQ	Futures	18012.43	18024.31	18010.4	18023.73	1740.0
2021-10-27 01:00:00	NQ	Futures	18023.44	18050.68	18023.15	18050.1	3884.0
2021-10-27 02:00:00	NQ	Futures	18050.39	18057.35	18040.83	18045.75	3283.0
2021-10-27 03:00:00	NQ	Futures	18046.33	18076.19	18045.47	18055.32	6553.0
2021-10-27 04:00:00	NQ	Futures	18055.61	18069.52	18028.37	18030.68	5841.0
2021-10-27 05:00:00	NQ	Futures	18030.39	18031.26	17988.95	17993.88	9935.0
2021-10-27 06:00:00	NQ	Futures	17993.3	18013.01	17977.07	17987.79	7848.0
2021-10-27 07:00:00	NQ	Futures	17987.5	18013.01	17982.0	17984.31	10434.0
2021-10-27 08:00:00	NQ	Futures	17984.31	18055.32	17984.31	18044.02	15849.0
2021-10-27 09:00:00	NQ	Futures	18043.73	18137.63	18036.77	18133.28	86738.0
2021-10-27 10:00:00	NQ	Futures	18133.57	18154.44	18040.83	18107.2	100758.0
2021-10-27 11:00:00	NQ	Futures	18106.62	18158.2	18099.37	18148.06	52231.0
2021-10-27 12:00:00	NQ	Futures	18148.35	18184.29	18143.71	18173.27	39633.0
2021-10-27 13:00:00	NQ	Futures	18173.27	18220.8	18169.22	18212.69	37534.0
2021-10-27 14:00:00	NQ	Futures	18212.69	18218.2	18179.65	18179.65	27591.0
2021-10-27 15:00:00	NQ	Futures	18179.65	18186.61	18063.72	18067.2	81721.0
2021-10-27 16:00:00	NQ	Futures	18066.91	18087.49	18063.14	18076.48	13036.0
2021-10-27 18:00:00	NQ	Futures	18078.79	18105.46	18078.79	18102.27	3773.0
2021-10-27 19:00:00	NQ	Futures	18102.85	18120.24	18098.21	18114.73	3560.0
2021-10-27 20:00:00	NQ	Futures	18115.31	18118.79	18094.15	18108.36	3841.0
2021-10-27 21:00:00	NQ	Futures	18108.36	18115.31	18095.02	18104.88	3205.0
2021-10-27 22:00:00	NQ	Futures	18105.17	18111.25	18080.53	18096.18	3610.0
2021-10-27 23:00:00	NQ	Futures	18096.18	18104.59	18092.42	18102.27	1765.0
2021-10-27 00:00:00	YM	Futures	39950.3	39972.7	39946.9	39972.7	819.0
2021-10-27 01:00:00	YM	Futures	39970.4	40008.5	39968.2	40000.7	1925.0
2021-10-27 02:00:00	YM	Futures	40002.9	40005.2	39970.4	39992.9	2445.0
2021-10-27 03:00:00	YM	Futures	39994.0	40033.2	39988.4	40016.4	4002.0

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

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