PREVIEW / futures_1hour / 2022-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-23.parquet
  size:    68 KB
  rows:    2,036

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-03-23 00:00:00	ES	Futures	5111.56	5115.81	5110.43	5115.25	2099.0
2022-03-23 01:00:00	ES	Futures	5115.25	5117.51	5111.56	5116.38	3620.0
2022-03-23 02:00:00	ES	Futures	5116.66	5117.23	5110.99	5112.98	4978.0
2022-03-23 03:00:00	ES	Futures	5113.26	5113.54	5105.61	5107.31	6293.0
2022-03-23 04:00:00	ES	Futures	5107.31	5108.73	5096.25	5101.07	18240.0
2022-03-23 05:00:00	ES	Futures	5101.36	5103.06	5087.47	5089.74	19718.0
2022-03-23 06:00:00	ES	Futures	5089.74	5093.14	5085.2	5090.02	12077.0
2022-03-23 07:00:00	ES	Futures	5090.02	5091.44	5079.25	5084.63	21761.0
2022-03-23 08:00:00	ES	Futures	5084.35	5089.17	5075.28	5078.68	27629.0
2022-03-23 09:00:00	ES	Futures	5078.4	5083.78	5062.53	5067.34	165645.0
2022-03-23 10:00:00	ES	Futures	5067.34	5088.89	5063.09	5080.67	180860.0
2022-03-23 11:00:00	ES	Futures	5080.67	5091.44	5079.53	5086.62	102720.0
2022-03-23 12:00:00	ES	Futures	5086.62	5094.84	5068.19	5075.85	129845.0
2022-03-23 13:00:00	ES	Futures	5075.85	5077.26	5052.32	5063.94	121407.0
2022-03-23 14:00:00	ES	Futures	5063.94	5070.18	5051.75	5058.84	104672.0
2022-03-23 15:00:00	ES	Futures	5058.84	5066.21	5040.7	5041.55	234350.0
2022-03-23 16:00:00	ES	Futures	5041.27	5044.95	5039.28	5044.1	62230.0
2022-03-23 18:00:00	ES	Futures	5044.39	5047.5	5041.55	5045.8	4952.0
2022-03-23 19:00:00	ES	Futures	5046.09	5049.77	5044.67	5048.07	3850.0
2022-03-23 20:00:00	ES	Futures	5048.07	5054.87	5043.54	5048.07	8536.0
2022-03-23 21:00:00	ES	Futures	5048.07	5049.77	5040.42	5047.5	8733.0
2022-03-23 22:00:00	ES	Futures	5047.5	5053.17	5045.8	5050.9	4512.0
2022-03-23 23:00:00	ES	Futures	5051.19	5056.86	5048.35	5056.86	4471.0
2022-03-23 00:00:00	NQ	Futures	16994.86	17009.65	16987.61	17006.75	1594.0
2022-03-23 01:00:00	NQ	Futures	17006.46	17013.42	16993.12	17010.52	1652.0
2022-03-23 02:00:00	NQ	Futures	17011.1	17022.7	16999.5	17005.01	2283.0
2022-03-23 03:00:00	NQ	Futures	17005.3	17007.62	16975.72	16996.02	3724.0
2022-03-23 04:00:00	NQ	Futures	16994.57	17004.14	16951.36	16973.11	7557.0
2022-03-23 05:00:00	NQ	Futures	16972.53	16981.52	16914.53	16925.26	7661.0
2022-03-23 06:00:00	NQ	Futures	16925.55	16936.28	16886.7	16902.94	6955.0
2022-03-23 07:00:00	NQ	Futures	16903.23	16913.37	16852.48	16869.01	8925.0
2022-03-23 08:00:00	NQ	Futures	16869.59	16892.5	16841.75	16851.61	12705.0
2022-03-23 09:00:00	NQ	Futures	16851.61	16887.86	16773.03	16809.85	82569.0
2022-03-23 10:00:00	NQ	Futures	16809.56	16945.27	16775.35	16921.78	92376.0
2022-03-23 11:00:00	NQ	Futures	16921.78	16997.18	16909.02	16995.44	57521.0
2022-03-23 12:00:00	NQ	Futures	16995.73	17029.94	16892.21	16933.09	57990.0
2022-03-23 13:00:00	NQ	Futures	16934.25	16943.53	16809.27	16855.67	52875.0
2022-03-23 14:00:00	NQ	Futures	16855.67	16881.48	16780.57	16820.0	47092.0
2022-03-23 15:00:00	NQ	Futures	16820.0	16854.22	16750.12	16753.6	65840.0
2022-03-23 16:00:00	NQ	Futures	16753.31	16776.51	16750.99	16776.51	12795.0
2022-03-23 18:00:00	NQ	Futures	16775.35	16786.95	16765.78	16779.99	2497.0
2022-03-23 19:00:00	NQ	Futures	16780.57	16797.38	16775.06	16788.98	2279.0
2022-03-23 20:00:00	NQ	Futures	16789.27	16819.42	16767.52	16784.05	4882.0
2022-03-23 21:00:00	NQ	Futures	16784.05	16802.89	16758.53	16795.35	4144.0
2022-03-23 22:00:00	NQ	Futures	16795.64	16812.75	16786.66	16809.27	2649.0
2022-03-23 23:00:00	NQ	Futures	16809.27	16840.59	16797.67	16840.3	2608.0
2022-03-23 00:00:00	YM	Futures	39174.7	39198.4	39163.5	39196.2	631.0
2022-03-23 01:00:00	YM	Futures	39195.0	39213.1	39171.4	39201.8	688.0
2022-03-23 02:00:00	YM	Futures	39204.1	39208.6	39162.3	39177.0	1106.0
2022-03-23 03:00:00	YM	Futures	39177.0	39179.3	39116.1	39122.9	1710.0

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

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