PREVIEW / futures_1hour / 2021-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-22.parquet
  size:    64 KB
  rows:    1,966

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-22 00:00:00	ES	Futures	4907.11	4913.88	4906.54	4912.19	3944.0
2021-09-22 01:00:00	ES	Futures	4912.47	4924.61	4911.62	4918.4	9878.0
2021-09-22 02:00:00	ES	Futures	4918.68	4932.23	4917.55	4929.97	13498.0
2021-09-22 03:00:00	ES	Futures	4929.69	4936.46	4916.7	4917.55	25192.0
2021-09-22 04:00:00	ES	Futures	4918.12	4930.53	4916.7	4929.12	17070.0
2021-09-22 05:00:00	ES	Futures	4928.84	4931.1	4922.35	4927.71	11038.0
2021-09-22 06:00:00	ES	Futures	4927.71	4934.48	4927.71	4928.28	11043.0
2021-09-22 07:00:00	ES	Futures	4928.56	4930.53	4924.89	4928.56	14162.0
2021-09-22 08:00:00	ES	Futures	4928.56	4933.92	4927.71	4931.94	16063.0
2021-09-22 09:00:00	ES	Futures	4931.94	4938.15	4917.83	4937.87	175638.0
2021-09-22 10:00:00	ES	Futures	4938.15	4951.98	4935.61	4950.85	269022.0
2021-09-22 11:00:00	ES	Futures	4950.85	4969.2	4950.57	4962.14	164555.0
2021-09-22 12:00:00	ES	Futures	4962.14	4962.99	4954.52	4956.78	66292.0
2021-09-22 13:00:00	ES	Futures	4956.5	4957.06	4946.05	4951.13	78610.0
2021-09-22 14:00:00	ES	Futures	4950.85	4974.28	4935.05	4946.9	344244.0
2021-09-22 15:00:00	ES	Futures	4946.9	4970.61	4940.69	4949.16	321492.0
2021-09-22 16:00:00	ES	Futures	4948.88	4954.8	4946.05	4951.42	58348.0
2021-09-22 18:00:00	ES	Futures	4951.13	4955.37	4950.85	4954.8	5447.0
2021-09-22 19:00:00	ES	Futures	4955.09	4959.04	4953.11	4957.91	5923.0
2021-09-22 20:00:00	ES	Futures	4957.91	4962.99	4956.21	4961.29	10620.0
2021-09-22 21:00:00	ES	Futures	4961.58	4966.94	4957.34	4963.55	11954.0
2021-09-22 22:00:00	ES	Futures	4963.55	4964.68	4958.19	4961.29	7489.0
2021-09-22 23:00:00	ES	Futures	4961.58	4964.12	4959.88	4959.88	4109.0
2021-09-22 00:00:00	NQ	Futures	17418.01	17445.83	17413.95	17434.53	2730.0
2021-09-22 01:00:00	NQ	Futures	17433.08	17480.61	17431.34	17455.98	6561.0
2021-09-22 02:00:00	NQ	Futures	17457.14	17498.0	17451.34	17487.28	7027.0
2021-09-22 03:00:00	NQ	Futures	17487.28	17502.64	17440.62	17447.57	9215.0
2021-09-22 04:00:00	NQ	Futures	17446.99	17491.04	17443.23	17485.54	6338.0
2021-09-22 05:00:00	NQ	Futures	17484.96	17490.76	17452.79	17471.34	5210.0
2021-09-22 06:00:00	NQ	Futures	17471.34	17487.28	17468.73	17471.05	4092.0
2021-09-22 07:00:00	NQ	Futures	17471.05	17472.5	17452.21	17466.7	4510.0
2021-09-22 08:00:00	NQ	Futures	17466.7	17497.71	17464.38	17488.15	7429.0
2021-09-22 09:00:00	NQ	Futures	17488.73	17509.88	17406.13	17477.71	78153.0
2021-09-22 10:00:00	NQ	Futures	17478.0	17549.01	17475.97	17538.29	77940.0
2021-09-22 11:00:00	NQ	Futures	17538.29	17625.52	17538.29	17593.06	58143.0
2021-09-22 12:00:00	NQ	Futures	17593.06	17599.15	17559.15	17566.69	36736.0
2021-09-22 13:00:00	NQ	Futures	17566.69	17568.14	17520.61	17548.72	33036.0
2021-09-22 14:00:00	NQ	Futures	17545.53	17652.18	17493.65	17530.75	114792.0
2021-09-22 15:00:00	NQ	Futures	17532.2	17647.84	17508.72	17576.54	84288.0
2021-09-22 16:00:00	NQ	Futures	17576.54	17599.15	17569.59	17595.67	10543.0
2021-09-22 18:00:00	NQ	Futures	17595.67	17606.97	17593.06	17604.65	2148.0
2021-09-22 19:00:00	NQ	Futures	17604.65	17618.85	17598.86	17611.32	3533.0
2021-09-22 20:00:00	NQ	Futures	17611.61	17623.49	17603.78	17618.56	4205.0
2021-09-22 21:00:00	NQ	Futures	17619.43	17640.59	17605.81	17624.94	6201.0
2021-09-22 22:00:00	NQ	Futures	17624.65	17629.58	17596.54	17612.19	4713.0
2021-09-22 23:00:00	NQ	Futures	17612.48	17617.98	17602.33	17602.33	2426.0
2021-09-22 00:00:00	YM	Futures	37921.4	37979.7	37919.2	37971.9	1039.0
2021-09-22 01:00:00	YM	Futures	37970.7	38067.1	37966.3	38005.5	2706.0
2021-09-22 02:00:00	YM	Futures	38008.8	38129.9	38004.4	38105.2	3781.0
2021-09-22 03:00:00	YM	Futures	38103.0	38163.5	38007.7	38021.2	6225.0

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

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