PREVIEW / futures_1hour / 2021-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-23.parquet
  size:    66 KB
  rows:    1,993

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-09-23 00:00:00	ES	Futures	4959.88	4962.99	4959.04	4961.86	3213.0
2021-09-23 01:00:00	ES	Futures	4961.86	4964.68	4960.73	4963.83	5366.0
2021-09-23 02:00:00	ES	Futures	4964.12	4974.28	4960.73	4972.58	16954.0
2021-09-23 03:00:00	ES	Futures	4972.86	4983.31	4966.94	4982.18	34257.0
2021-09-23 04:00:00	ES	Futures	4982.18	4985.56	4980.2	4984.72	14374.0
2021-09-23 05:00:00	ES	Futures	4984.72	4994.88	4982.46	4985.28	40220.0
2021-09-23 06:00:00	ES	Futures	4985.28	4988.1	4968.63	4975.69	47314.0
2021-09-23 07:00:00	ES	Futures	4975.4	4982.46	4972.02	4975.97	17830.0
2021-09-23 08:00:00	ES	Futures	4976.25	4982.74	4969.48	4973.43	32533.0
2021-09-23 09:00:00	ES	Futures	4973.43	5005.6	4961.58	4998.55	246600.0
2021-09-23 10:00:00	ES	Futures	4998.83	5018.02	4998.55	5015.48	211494.0
2021-09-23 11:00:00	ES	Futures	5015.76	5016.61	5005.32	5016.04	120295.0
2021-09-23 12:00:00	ES	Futures	5016.04	5020.56	5010.96	5015.76	94211.0
2021-09-23 13:00:00	ES	Futures	5016.04	5029.02	5015.76	5028.74	85820.0
2021-09-23 14:00:00	ES	Futures	5028.74	5029.02	5018.02	5021.12	87477.0
2021-09-23 15:00:00	ES	Futures	5021.12	5022.25	5007.58	5008.99	242568.0
2021-09-23 16:00:00	ES	Futures	5008.99	5014.63	5006.73	5010.96	61690.0
2021-09-23 18:00:00	ES	Futures	5010.96	5015.2	5010.12	5014.35	4488.0
2021-09-23 19:00:00	ES	Futures	5014.35	5017.17	5011.25	5013.22	7168.0
2021-09-23 20:00:00	ES	Futures	5013.22	5025.07	5012.94	5018.02	12936.0
2021-09-23 21:00:00	ES	Futures	5018.3	5020.84	5005.04	5006.73	12225.0
2021-09-23 22:00:00	ES	Futures	5007.01	5014.07	5006.45	5012.94	7910.0
2021-09-23 23:00:00	ES	Futures	5012.66	5016.89	5008.14	5012.66	6535.0
2021-09-23 00:00:00	NQ	Futures	17602.62	17619.14	17601.76	17613.64	1839.0
2021-09-23 01:00:00	NQ	Futures	17613.06	17627.84	17608.42	17614.51	3237.0
2021-09-23 02:00:00	NQ	Futures	17614.22	17647.55	17594.8	17641.17	6040.0
2021-09-23 03:00:00	NQ	Futures	17641.75	17689.57	17620.01	17686.67	12482.0
2021-09-23 04:00:00	NQ	Futures	17686.09	17707.83	17683.77	17704.93	6504.0
2021-09-23 05:00:00	NQ	Futures	17705.51	17748.4	17694.21	17713.62	13015.0
2021-09-23 06:00:00	NQ	Futures	17714.2	17721.74	17657.11	17680.01	15708.0
2021-09-23 07:00:00	NQ	Futures	17678.85	17694.21	17655.66	17667.54	7057.0
2021-09-23 08:00:00	NQ	Futures	17668.12	17688.12	17626.97	17629.58	15854.0
2021-09-23 09:00:00	NQ	Futures	17629.0	17733.04	17592.19	17708.12	101075.0
2021-09-23 10:00:00	NQ	Futures	17708.12	17781.44	17708.12	17766.66	79733.0
2021-09-23 11:00:00	NQ	Futures	17766.66	17768.11	17696.82	17752.75	60273.0
2021-09-23 12:00:00	NQ	Futures	17753.04	17756.81	17709.86	17736.52	39066.0
2021-09-23 13:00:00	NQ	Futures	17737.1	17791.3	17734.49	17788.98	30169.0
2021-09-23 14:00:00	NQ	Futures	17788.98	17789.56	17755.65	17771.59	27587.0
2021-09-23 15:00:00	NQ	Futures	17771.59	17774.2	17730.43	17736.23	51618.0
2021-09-23 16:00:00	NQ	Futures	17736.23	17755.94	17721.74	17732.17	12240.0
2021-09-23 18:00:00	NQ	Futures	17737.1	17750.14	17733.33	17747.24	2014.0
2021-09-23 19:00:00	NQ	Futures	17747.53	17756.52	17731.88	17741.74	2917.0
2021-09-23 20:00:00	NQ	Futures	17742.61	17775.07	17739.42	17755.65	4906.0
2021-09-23 21:00:00	NQ	Futures	17755.94	17764.05	17710.73	17718.26	5679.0
2021-09-23 22:00:00	NQ	Futures	17717.97	17744.63	17714.2	17739.42	4730.0
2021-09-23 23:00:00	NQ	Futures	17739.71	17750.14	17713.33	17730.14	4107.0
2021-09-23 00:00:00	YM	Futures	38369.8	38392.2	38353.0	38379.9	2481.0
2021-09-23 01:00:00	YM	Futures	38381.0	38396.7	38355.2	38392.2	1983.0
2021-09-23 02:00:00	YM	Futures	38393.3	38478.5	38375.4	38462.8	2970.0
2021-09-23 03:00:00	YM	Futures	38461.7	38525.6	38419.1	38520.0	6927.0

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

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