PREVIEW / futures_1hour / 2021-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-23.parquet
  size:    52 KB
  rows:    1,559

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-07-23 00:00:00	ES	Futures	4922.34	4923.47	4919.8	4922.62	2374.0
2021-07-23 01:00:00	ES	Futures	4922.9	4923.18	4920.93	4922.62	2592.0
2021-07-23 02:00:00	ES	Futures	4922.62	4927.41	4922.06	4925.72	8104.0
2021-07-23 03:00:00	ES	Futures	4925.72	4929.1	4922.34	4929.1	18849.0
2021-07-23 04:00:00	ES	Futures	4929.1	4931.91	4927.69	4930.22	13617.0
2021-07-23 05:00:00	ES	Futures	4929.94	4936.7	4929.94	4933.04	13001.0
2021-07-23 06:00:00	ES	Futures	4933.32	4935.01	4932.48	4934.45	9104.0
2021-07-23 07:00:00	ES	Futures	4934.17	4934.45	4929.66	4932.19	13628.0
2021-07-23 08:00:00	ES	Futures	4931.91	4934.73	4930.22	4931.35	18402.0
2021-07-23 09:00:00	ES	Futures	4931.07	4934.73	4924.87	4927.13	136930.0
2021-07-23 10:00:00	ES	Futures	4927.13	4942.89	4926.84	4942.05	155774.0
2021-07-23 11:00:00	ES	Futures	4942.33	4955.85	4941.49	4946.84	174741.0
2021-07-23 12:00:00	ES	Futures	4947.12	4954.44	4946.84	4954.16	78662.0
2021-07-23 13:00:00	ES	Futures	4954.16	4962.04	4953.88	4958.94	101779.0
2021-07-23 14:00:00	ES	Futures	4958.94	4961.48	4956.41	4958.38	73830.0
2021-07-23 15:00:00	ES	Futures	4958.38	4965.14	4951.9	4960.07	209858.0
2021-07-23 16:00:00	ES	Futures	4960.07	4960.07	4953.59	4955.0	56626.0
2021-07-23 00:00:00	NQ	Futures	17349.01	17353.07	17340.61	17349.59	1596.0
2021-07-23 01:00:00	NQ	Futures	17349.88	17351.33	17341.77	17348.72	2027.0
2021-07-23 02:00:00	NQ	Futures	17349.59	17366.39	17346.69	17360.31	3044.0
2021-07-23 03:00:00	NQ	Futures	17360.89	17373.92	17340.9	17371.61	5605.0
2021-07-23 04:00:00	NQ	Futures	17371.9	17391.88	17369.58	17378.56	8515.0
2021-07-23 05:00:00	NQ	Futures	17378.27	17398.84	17376.53	17386.96	4092.0
2021-07-23 06:00:00	NQ	Futures	17386.67	17389.57	17377.98	17382.61	3761.0
2021-07-23 07:00:00	NQ	Futures	17382.32	17383.77	17351.04	17361.47	6929.0
2021-07-23 08:00:00	NQ	Futures	17361.18	17366.97	17345.82	17349.3	8630.0
2021-07-23 09:00:00	NQ	Futures	17349.01	17373.92	17304.69	17353.94	75152.0
2021-07-23 10:00:00	NQ	Futures	17353.65	17404.05	17347.27	17399.13	73397.0
2021-07-23 11:00:00	NQ	Futures	17399.13	17474.15	17392.75	17461.12	61505.0
2021-07-23 12:00:00	NQ	Futures	17461.41	17478.79	17448.95	17476.76	36839.0
2021-07-23 13:00:00	NQ	Futures	17477.05	17512.68	17470.68	17493.56	36071.0
2021-07-23 14:00:00	NQ	Futures	17493.85	17512.97	17490.38	17497.91	25773.0
2021-07-23 15:00:00	NQ	Futures	17498.2	17516.74	17476.76	17495.3	59416.0
2021-07-23 16:00:00	NQ	Futures	17495.01	17498.49	17481.39	17486.61	11330.0
2021-07-23 00:00:00	YM	Futures	38835.7	38843.5	38814.5	38840.1	607.0
2021-07-23 01:00:00	YM	Futures	38841.3	38846.9	38826.7	38836.8	724.0
2021-07-23 02:00:00	YM	Futures	38834.6	38878.1	38831.2	38865.8	1945.0
2021-07-23 03:00:00	YM	Futures	38865.8	38906.1	38853.6	38901.6	4496.0
2021-07-23 04:00:00	YM	Futures	38901.6	38929.5	38890.4	38912.8	2808.0
2021-07-23 05:00:00	YM	Futures	38912.8	38970.9	38912.8	38942.9	2448.0
2021-07-23 06:00:00	YM	Futures	38942.9	38970.9	38936.2	38964.2	1796.0
2021-07-23 07:00:00	YM	Futures	38963.0	38973.1	38944.1	38969.8	2972.0
2021-07-23 08:00:00	YM	Futures	38969.8	39006.6	38966.4	38975.3	4362.0
2021-07-23 09:00:00	YM	Futures	38975.3	39048.0	38892.7	38912.8	23902.0
2021-07-23 10:00:00	YM	Futures	38913.9	39011.1	38898.2	39004.4	20000.0
2021-07-23 11:00:00	YM	Futures	39005.5	39082.6	38977.6	38978.7	17125.0
2021-07-23 12:00:00	YM	Futures	38979.8	39024.5	38979.8	39011.1	7441.0
2021-07-23 13:00:00	YM	Futures	39010.0	39072.5	39007.7	39043.5	8392.0
2021-07-23 14:00:00	YM	Futures	39043.5	39049.1	38994.3	39014.4	6369.0
2021-07-23 15:00:00	YM	Futures	39015.6	39096.0	38960.8	39052.4	17593.0

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

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