PREVIEW / futures_1hour / 2021-07-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	4941.2	4944.58	4940.92	4942.89	2467.0
2021-07-29 01:00:00	ES	Futures	4942.89	4948.24	4941.77	4947.4	5767.0
2021-07-29 02:00:00	ES	Futures	4947.4	4954.72	4946.27	4953.31	10849.0
2021-07-29 03:00:00	ES	Futures	4953.59	4957.82	4949.93	4953.59	20375.0
2021-07-29 04:00:00	ES	Futures	4953.59	4956.97	4951.34	4955.0	10692.0
2021-07-29 05:00:00	ES	Futures	4954.72	4958.94	4953.31	4958.66	8336.0
2021-07-29 06:00:00	ES	Futures	4958.94	4959.23	4951.62	4956.41	12509.0
2021-07-29 07:00:00	ES	Futures	4956.13	4958.38	4952.75	4956.41	19957.0
2021-07-29 08:00:00	ES	Futures	4956.41	4959.51	4955.28	4958.1	27341.0
2021-07-29 09:00:00	ES	Futures	4958.38	4973.31	4957.82	4969.36	161397.0
2021-07-29 10:00:00	ES	Futures	4969.64	4978.09	4965.14	4977.53	132080.0
2021-07-29 11:00:00	ES	Futures	4977.81	4980.34	4973.59	4974.43	103240.0
2021-07-29 12:00:00	ES	Futures	4974.71	4980.63	4974.43	4976.4	61873.0
2021-07-29 13:00:00	ES	Futures	4976.68	4981.19	4976.12	4978.09	64688.0
2021-07-29 14:00:00	ES	Futures	4978.37	4979.5	4971.62	4974.15	68565.0
2021-07-29 15:00:00	ES	Futures	4974.15	4974.15	4968.52	4969.08	140384.0
2021-07-29 16:00:00	ES	Futures	4969.36	4969.93	4949.09	4952.47	88175.0
2021-07-29 18:00:00	ES	Futures	4949.37	4955.85	4949.37	4951.62	7508.0
2021-07-29 19:00:00	ES	Futures	4951.62	4952.47	4940.36	4941.2	10672.0
2021-07-29 20:00:00	ES	Futures	4941.2	4944.58	4927.69	4932.19	27828.0
2021-07-29 21:00:00	ES	Futures	4932.19	4935.29	4927.69	4927.97	16245.0
2021-07-29 22:00:00	ES	Futures	4927.97	4938.11	4927.69	4935.01	12800.0
2021-07-29 23:00:00	ES	Futures	4935.29	4937.26	4929.94	4931.91	6532.0
2021-07-29 00:00:00	NQ	Futures	17340.03	17353.36	17336.84	17346.98	1812.0
2021-07-29 01:00:00	NQ	Futures	17347.27	17369.87	17345.53	17363.78	3244.0
2021-07-29 02:00:00	NQ	Futures	17364.36	17387.83	17356.25	17382.32	5258.0
2021-07-29 03:00:00	NQ	Futures	17383.19	17409.55	17380.59	17393.04	7818.0
2021-07-29 04:00:00	NQ	Futures	17392.17	17393.91	17366.97	17378.27	5316.0
2021-07-29 05:00:00	NQ	Futures	17377.4	17390.72	17371.03	17385.8	3648.0
2021-07-29 06:00:00	NQ	Futures	17385.8	17386.96	17334.82	17353.07	7562.0
2021-07-29 07:00:00	NQ	Futures	17352.49	17378.85	17351.33	17376.82	6477.0
2021-07-29 08:00:00	NQ	Futures	17377.11	17403.18	17361.18	17372.76	11604.0
2021-07-29 09:00:00	NQ	Futures	17373.05	17472.99	17360.31	17443.74	67718.0
2021-07-29 10:00:00	NQ	Futures	17444.03	17473.86	17405.5	17463.14	70845.0
2021-07-29 11:00:00	NQ	Futures	17463.14	17478.21	17436.2	17440.26	44773.0
2021-07-29 12:00:00	NQ	Futures	17440.26	17472.41	17431.86	17443.16	31438.0
2021-07-29 13:00:00	NQ	Futures	17443.45	17464.88	17437.94	17455.03	28012.0
2021-07-29 14:00:00	NQ	Futures	17455.61	17461.7	17428.09	17443.16	25165.0
2021-07-29 15:00:00	NQ	Futures	17443.45	17445.18	17415.93	17421.72	39552.0
2021-07-29 16:00:00	NQ	Futures	17421.72	17434.76	17270.8	17276.3	28834.0
2021-07-29 18:00:00	NQ	Futures	17271.09	17307.88	17266.45	17290.78	6515.0
2021-07-29 19:00:00	NQ	Futures	17290.21	17292.81	17221.26	17231.4	9030.0
2021-07-29 20:00:00	NQ	Futures	17231.11	17244.73	17173.46	17192.0	13286.0
2021-07-29 21:00:00	NQ	Futures	17192.58	17205.04	17185.34	17192.87	6332.0
2021-07-29 22:00:00	NQ	Futures	17192.87	17229.37	17187.37	17209.67	6022.0
2021-07-29 23:00:00	NQ	Futures	17210.54	17220.1	17191.13	17199.25	4280.0
2021-07-29 00:00:00	YM	Futures	38910.5	38938.5	38909.4	38922.8	517.0
2021-07-29 01:00:00	YM	Futures	38927.3	38970.9	38912.8	38961.9	1112.0
2021-07-29 02:00:00	YM	Futures	38964.2	39027.8	38956.3	39016.7	2519.0
2021-07-29 03:00:00	YM	Futures	39014.4	39055.8	38977.6	39021.1	5224.0

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

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