PREVIEW / futures_1hour / 2021-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-20.parquet
  size:    66 KB
  rows:    2,008

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-20 00:00:00	ES	Futures	4953.67	4955.37	4946.9	4954.24	8334.0
2021-09-20 01:00:00	ES	Futures	4954.52	4958.75	4951.7	4957.34	10746.0
2021-09-20 02:00:00	ES	Futures	4957.34	4959.88	4935.61	4942.1	31324.0
2021-09-20 03:00:00	ES	Futures	4942.1	4947.47	4934.77	4937.59	41507.0
2021-09-20 04:00:00	ES	Futures	4937.59	4939.56	4927.71	4933.07	44046.0
2021-09-20 05:00:00	ES	Futures	4932.79	4933.64	4917.55	4922.07	48399.0
2021-09-20 06:00:00	ES	Futures	4922.07	4929.69	4920.94	4922.91	33731.0
2021-09-20 07:00:00	ES	Futures	4922.91	4927.15	4910.5	4911.34	53997.0
2021-09-20 08:00:00	ES	Futures	4911.06	4915.58	4899.21	4906.83	89255.0
2021-09-20 09:00:00	ES	Futures	4906.83	4934.48	4902.59	4925.17	327918.0
2021-09-20 10:00:00	ES	Futures	4925.45	4926.3	4904.0	4907.39	351511.0
2021-09-20 11:00:00	ES	Futures	4907.67	4919.53	4892.72	4893.0	248896.0
2021-09-20 12:00:00	ES	Futures	4892.72	4894.41	4878.32	4878.89	222151.0
2021-09-20 13:00:00	ES	Futures	4878.61	4887.35	4868.16	4882.84	189622.0
2021-09-20 14:00:00	ES	Futures	4883.12	4886.79	4850.67	4856.88	255341.0
2021-09-20 15:00:00	ES	Futures	4857.16	4910.5	4847.0	4906.54	472548.0
2021-09-20 16:00:00	ES	Futures	4906.54	4909.65	4893.56	4902.59	92821.0
2021-09-20 18:00:00	ES	Futures	4902.03	4910.21	4901.18	4907.11	11126.0
2021-09-20 19:00:00	ES	Futures	4907.11	4917.83	4900.34	4916.99	14295.0
2021-09-20 20:00:00	ES	Futures	4917.27	4928.56	4913.04	4918.96	21089.0
2021-09-20 21:00:00	ES	Futures	4919.24	4925.74	4914.45	4924.04	18577.0
2021-09-20 22:00:00	ES	Futures	4924.32	4931.1	4921.5	4930.82	10039.0
2021-09-20 23:00:00	ES	Futures	4930.82	4937.59	4924.32	4936.18	12327.0
2021-09-20 00:00:00	NQ	Futures	17666.09	17669.57	17635.66	17666.67	3655.0
2021-09-20 01:00:00	NQ	Futures	17666.96	17694.5	17658.27	17683.48	4701.0
2021-09-20 02:00:00	NQ	Futures	17682.61	17689.86	17608.42	17635.66	10834.0
2021-09-20 03:00:00	NQ	Futures	17637.11	17652.18	17596.54	17620.88	17234.0
2021-09-20 04:00:00	NQ	Futures	17622.62	17626.68	17568.72	17586.68	18070.0
2021-09-20 05:00:00	NQ	Futures	17585.24	17593.64	17543.21	17564.66	11372.0
2021-09-20 06:00:00	NQ	Futures	17564.37	17595.09	17555.96	17569.3	9171.0
2021-09-20 07:00:00	NQ	Futures	17569.88	17579.15	17489.89	17501.48	19275.0
2021-09-20 08:00:00	NQ	Futures	17502.35	17518.87	17444.96	17470.47	25930.0
2021-09-20 09:00:00	NQ	Futures	17470.18	17564.37	17429.89	17513.65	107481.0
2021-09-20 10:00:00	NQ	Futures	17512.78	17518.0	17376.57	17386.13	125492.0
2021-09-20 11:00:00	NQ	Futures	17385.84	17439.75	17336.28	17339.47	87483.0
2021-09-20 12:00:00	NQ	Futures	17339.47	17344.98	17284.12	17293.68	67131.0
2021-09-20 13:00:00	NQ	Futures	17293.39	17329.33	17254.55	17302.08	54081.0
2021-09-20 14:00:00	NQ	Futures	17302.95	17316.29	17170.51	17201.52	82564.0
2021-09-20 15:00:00	NQ	Futures	17201.81	17405.55	17165.87	17394.25	129748.0
2021-09-20 16:00:00	NQ	Futures	17394.83	17407.29	17354.25	17378.6	23560.0
2021-09-20 18:00:00	NQ	Futures	17379.76	17405.84	17377.15	17392.51	4143.0
2021-09-20 19:00:00	NQ	Futures	17391.64	17426.13	17367.87	17422.36	6543.0
2021-09-20 20:00:00	NQ	Futures	17422.65	17464.96	17409.32	17433.95	8468.0
2021-09-20 21:00:00	NQ	Futures	17434.82	17448.15	17402.65	17443.23	10038.0
2021-09-20 22:00:00	NQ	Futures	17443.51	17472.21	17435.69	17471.05	4478.0
2021-09-20 23:00:00	NQ	Futures	17471.34	17492.49	17445.83	17484.38	5971.0
2021-09-20 00:00:00	YM	Futures	38270.0	38276.7	38217.3	38265.5	1713.0
2021-09-20 01:00:00	YM	Futures	38264.4	38296.9	38239.8	38280.1	3108.0
2021-09-20 02:00:00	YM	Futures	38281.2	38302.5	38073.9	38133.3	9810.0
2021-09-20 03:00:00	YM	Futures	38134.4	38183.7	38082.8	38104.1	10815.0

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

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