PREVIEW / futures_1hour / 2021-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-17.parquet
  size:    53 KB
  rows:    1,571

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-17 00:00:00	ES	Futures	5039.18	5044.26	5038.62	5043.98	6219.0
2021-09-17 01:00:00	ES	Futures	5043.7	5045.96	5042.01	5045.39	8200.0
2021-09-17 02:00:00	ES	Futures	5045.11	5046.8	5043.42	5044.55	8464.0
2021-09-17 03:00:00	ES	Futures	5044.83	5048.78	5037.21	5041.72	19094.0
2021-09-17 04:00:00	ES	Futures	5041.72	5042.01	5038.06	5040.31	8787.0
2021-09-17 05:00:00	ES	Futures	5040.31	5040.6	5025.92	5029.02	23479.0
2021-09-17 06:00:00	ES	Futures	5028.74	5030.72	5021.41	5026.77	33488.0
2021-09-17 07:00:00	ES	Futures	5026.49	5029.31	5023.1	5027.05	24855.0
2021-09-17 08:00:00	ES	Futures	5027.05	5037.49	5027.05	5035.52	39766.0
2021-09-17 09:00:00	ES	Futures	5035.23	5038.9	5008.71	5013.22	239547.0
2021-09-17 10:00:00	ES	Futures	5013.22	5016.33	4995.72	5001.09	286848.0
2021-09-17 11:00:00	ES	Futures	5001.37	5008.99	4992.06	4999.39	250974.0
2021-09-17 12:00:00	ES	Futures	4999.39	5010.68	4997.98	5004.47	143627.0
2021-09-17 13:00:00	ES	Futures	5004.47	5004.75	4985.28	4991.21	153142.0
2021-09-17 14:00:00	ES	Futures	4991.21	4997.13	4985.28	4992.62	145625.0
2021-09-17 15:00:00	ES	Futures	4992.62	4999.11	4986.41	4989.52	304564.0
2021-09-17 16:00:00	ES	Futures	4989.52	4990.64	4974.28	4976.25	124121.0
2021-09-17 00:00:00	NQ	Futures	17983.15	17995.33	17981.13	17992.72	2046.0
2021-09-17 01:00:00	NQ	Futures	17992.72	18001.41	17985.18	17999.09	3184.0
2021-09-17 02:00:00	NQ	Futures	17998.8	17999.96	17988.37	17991.27	2456.0
2021-09-17 03:00:00	NQ	Futures	17991.56	18000.83	17962.29	17979.1	6046.0
2021-09-17 04:00:00	NQ	Futures	17978.81	17979.39	17966.63	17975.91	3145.0
2021-09-17 05:00:00	NQ	Futures	17975.33	17976.49	17932.73	17941.71	6807.0
2021-09-17 06:00:00	NQ	Futures	17942.0	17953.3	17922.29	17936.49	8297.0
2021-09-17 07:00:00	NQ	Futures	17937.07	17944.61	17920.26	17939.97	5588.0
2021-09-17 08:00:00	NQ	Futures	17939.97	17984.02	17939.1	17969.82	11828.0
2021-09-17 09:00:00	NQ	Futures	17969.53	17976.2	17834.19	17855.92	86895.0
2021-09-17 10:00:00	NQ	Futures	17856.21	17860.56	17777.38	17793.03	98615.0
2021-09-17 11:00:00	NQ	Futures	17793.61	17809.26	17724.93	17748.98	100565.0
2021-09-17 12:00:00	NQ	Futures	17748.69	17811.0	17748.69	17790.72	59905.0
2021-09-17 13:00:00	NQ	Futures	17791.01	17791.59	17709.57	17731.59	61091.0
2021-09-17 14:00:00	NQ	Futures	17731.01	17756.23	17709.28	17744.92	51712.0
2021-09-17 15:00:00	NQ	Futures	17744.63	17782.89	17722.9	17762.31	81261.0
2021-09-17 16:00:00	NQ	Futures	17762.31	17766.66	17713.91	17716.81	19413.0
2021-09-17 00:00:00	YM	Futures	38815.9	38852.9	38813.7	38848.4	912.0
2021-09-17 01:00:00	YM	Futures	38847.3	38864.1	38833.8	38856.3	1591.0
2021-09-17 02:00:00	YM	Futures	38851.8	38882.0	38841.7	38866.3	1889.0
2021-09-17 03:00:00	YM	Futures	38867.5	38906.7	38822.6	38854.0	3688.0
2021-09-17 04:00:00	YM	Futures	38854.0	38859.6	38830.5	38848.4	1722.0
2021-09-17 05:00:00	YM	Futures	38848.4	38850.7	38730.7	38757.6	4522.0
2021-09-17 06:00:00	YM	Futures	38755.4	38771.1	38685.9	38735.2	6543.0
2021-09-17 07:00:00	YM	Futures	38735.2	38758.7	38706.1	38738.6	3224.0
2021-09-17 08:00:00	YM	Futures	38738.6	38813.7	38734.1	38782.3	4774.0
2021-09-17 09:00:00	YM	Futures	38781.2	38840.6	38667.9	38711.7	31601.0
2021-09-17 10:00:00	YM	Futures	38709.4	38749.8	38564.8	38595.1	29078.0
2021-09-17 11:00:00	YM	Futures	38596.2	38665.7	38542.4	38605.2	20368.0
2021-09-17 12:00:00	YM	Futures	38604.1	38707.2	38582.8	38671.3	11499.0
2021-09-17 13:00:00	YM	Futures	38672.4	38674.7	38545.8	38588.4	14183.0
2021-09-17 14:00:00	YM	Futures	38587.2	38642.2	38565.9	38606.3	12472.0
2021-09-17 15:00:00	YM	Futures	38608.5	38663.5	38573.8	38614.1	19407.0

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

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