PREVIEW / futures_1hour / 2021-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-26.parquet
  size:    64 KB
  rows:    1,957

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-26 00:00:00	ES	Futures	4944.3	4946.84	4944.3	4945.43	3067.0
2021-07-26 01:00:00	ES	Futures	4945.71	4946.55	4940.92	4944.3	6827.0
2021-07-26 02:00:00	ES	Futures	4944.02	4947.12	4941.2	4945.15	12151.0
2021-07-26 03:00:00	ES	Futures	4945.43	4947.96	4935.29	4936.7	28764.0
2021-07-26 04:00:00	ES	Futures	4936.98	4940.36	4928.25	4938.11	33643.0
2021-07-26 05:00:00	ES	Futures	4938.11	4949.37	4937.54	4947.68	20033.0
2021-07-26 06:00:00	ES	Futures	4947.68	4951.9	4944.02	4944.3	13003.0
2021-07-26 07:00:00	ES	Futures	4944.3	4953.88	4944.02	4951.34	15262.0
2021-07-26 08:00:00	ES	Futures	4951.34	4953.31	4945.43	4946.27	20015.0
2021-07-26 09:00:00	ES	Futures	4946.27	4964.01	4944.87	4960.63	133022.0
2021-07-26 10:00:00	ES	Futures	4960.63	4962.04	4952.47	4957.25	141890.0
2021-07-26 11:00:00	ES	Futures	4957.25	4969.64	4954.16	4969.08	104409.0
2021-07-26 12:00:00	ES	Futures	4969.08	4970.77	4960.35	4962.89	68023.0
2021-07-26 13:00:00	ES	Futures	4963.17	4969.08	4962.89	4964.86	52697.0
2021-07-26 14:00:00	ES	Futures	4964.86	4968.8	4962.89	4967.96	56383.0
2021-07-26 15:00:00	ES	Futures	4967.96	4972.74	4966.27	4972.18	115545.0
2021-07-26 16:00:00	ES	Futures	4971.9	4974.71	4971.62	4972.74	36406.0
2021-07-26 18:00:00	ES	Futures	4973.59	4973.87	4970.49	4971.33	2984.0
2021-07-26 19:00:00	ES	Futures	4971.05	4972.46	4968.52	4968.8	3109.0
2021-07-26 20:00:00	ES	Futures	4968.8	4970.49	4964.01	4965.7	7266.0
2021-07-26 21:00:00	ES	Futures	4965.7	4967.67	4963.45	4964.86	7770.0
2021-07-26 22:00:00	ES	Futures	4965.14	4966.55	4961.48	4966.27	6821.0
2021-07-26 23:00:00	ES	Futures	4966.27	4966.55	4963.17	4964.58	3754.0
2021-07-26 00:00:00	NQ	Futures	17479.37	17484.0	17477.05	17479.08	1297.0
2021-07-26 01:00:00	NQ	Futures	17478.5	17480.24	17465.75	17476.76	3068.0
2021-07-26 02:00:00	NQ	Futures	17476.18	17503.99	17471.55	17499.07	6223.0
2021-07-26 03:00:00	NQ	Futures	17499.07	17504.28	17467.78	17474.15	8494.0
2021-07-26 04:00:00	NQ	Futures	17474.15	17476.18	17425.78	17454.45	10571.0
2021-07-26 05:00:00	NQ	Futures	17454.74	17487.48	17452.72	17476.47	6516.0
2021-07-26 06:00:00	NQ	Futures	17476.76	17485.74	17452.72	17453.01	4780.0
2021-07-26 07:00:00	NQ	Futures	17453.01	17492.69	17453.01	17477.63	6663.0
2021-07-26 08:00:00	NQ	Futures	17477.92	17483.71	17446.34	17455.61	8373.0
2021-07-26 09:00:00	NQ	Futures	17455.61	17498.2	17427.51	17496.17	69843.0
2021-07-26 10:00:00	NQ	Futures	17495.88	17522.24	17476.18	17487.48	71149.0
2021-07-26 11:00:00	NQ	Futures	17487.19	17530.35	17477.92	17528.32	37645.0
2021-07-26 12:00:00	NQ	Futures	17528.61	17536.14	17477.92	17493.27	30035.0
2021-07-26 13:00:00	NQ	Futures	17492.98	17521.08	17491.82	17502.83	25265.0
2021-07-26 14:00:00	NQ	Futures	17502.83	17521.95	17488.06	17518.18	23300.0
2021-07-26 15:00:00	NQ	Futures	17517.89	17525.14	17492.69	17516.45	38020.0
2021-07-26 16:00:00	NQ	Futures	17516.45	17530.06	17510.36	17525.14	11349.0
2021-07-26 18:00:00	NQ	Futures	17526.01	17526.87	17512.68	17520.21	1738.0
2021-07-26 19:00:00	NQ	Futures	17520.5	17523.4	17508.62	17510.94	1262.0
2021-07-26 20:00:00	NQ	Futures	17510.65	17517.03	17497.91	17503.12	2958.0
2021-07-26 21:00:00	NQ	Futures	17503.12	17509.49	17491.82	17498.49	3384.0
2021-07-26 22:00:00	NQ	Futures	17499.64	17506.02	17485.45	17501.09	2615.0
2021-07-26 23:00:00	NQ	Futures	17501.38	17502.25	17488.64	17495.3	1819.0
2021-07-26 00:00:00	YM	Futures	38877.0	38898.2	38877.0	38891.5	921.0
2021-07-26 01:00:00	YM	Futures	38889.3	38901.6	38849.1	38870.3	1971.0
2021-07-26 02:00:00	YM	Futures	38869.2	38882.6	38829.0	38861.4	3425.0
2021-07-26 03:00:00	YM	Futures	38861.4	38900.5	38787.6	38794.3	6397.0

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

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