PREVIEW / futures_1hour / 2022-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-27.parquet
  size:    70 KB
  rows:    2,082

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
2022-07-27 00:00:00	ES	Futures	4478.24	4487.87	4478.24	4486.17	5327.0
2022-07-27 01:00:00	ES	Futures	4486.17	4489.0	4482.77	4484.75	5280.0
2022-07-27 02:00:00	ES	Futures	4484.47	4487.87	4480.51	4481.35	8203.0
2022-07-27 03:00:00	ES	Futures	4481.64	4490.99	4480.79	4486.17	15766.0
2022-07-27 04:00:00	ES	Futures	4486.45	4496.65	4485.89	4489.85	12914.0
2022-07-27 05:00:00	ES	Futures	4489.85	4493.25	4485.04	4487.3	9350.0
2022-07-27 06:00:00	ES	Futures	4487.02	4487.59	4479.66	4485.32	9379.0
2022-07-27 07:00:00	ES	Futures	4485.32	4485.32	4478.81	4480.51	13179.0
2022-07-27 08:00:00	ES	Futures	4480.22	4488.72	4479.66	4486.74	23375.0
2022-07-27 09:00:00	ES	Futures	4486.74	4499.48	4480.79	4495.24	181586.0
2022-07-27 10:00:00	ES	Futures	4495.24	4504.87	4490.99	4504.3	197809.0
2022-07-27 11:00:00	ES	Futures	4504.02	4512.8	4500.33	4510.25	138012.0
2022-07-27 12:00:00	ES	Futures	4510.25	4514.78	4502.6	4503.17	107005.0
2022-07-27 13:00:00	ES	Futures	4503.17	4509.12	4499.48	4506.28	96129.0
2022-07-27 14:00:00	ES	Futures	4506.28	4558.97	4496.65	4546.79	344482.0
2022-07-27 15:00:00	ES	Futures	4547.07	4580.78	4542.26	4559.54	373164.0
2022-07-27 16:00:00	ES	Futures	4559.54	4559.82	4548.21	4555.57	79305.0
2022-07-27 18:00:00	ES	Futures	4557.27	4557.27	4552.46	4554.72	4741.0
2022-07-27 19:00:00	ES	Futures	4554.72	4557.84	4552.46	4554.16	4310.0
2022-07-27 20:00:00	ES	Futures	4554.16	4556.42	4546.79	4550.19	8028.0
2022-07-27 21:00:00	ES	Futures	4549.91	4553.87	4548.21	4553.31	8585.0
2022-07-27 22:00:00	ES	Futures	4553.31	4556.71	4551.61	4554.44	4711.0
2022-07-27 23:00:00	ES	Futures	4554.72	4554.72	4548.49	4549.34	3840.0
2022-07-27 00:00:00	NQ	Futures	14204.82	14236.06	14203.37	14228.54	2823.0
2022-07-27 01:00:00	NQ	Futures	14227.96	14231.72	14211.76	14218.7	2841.0
2022-07-27 02:00:00	NQ	Futures	14216.97	14226.51	14193.54	14199.61	4221.0
2022-07-27 03:00:00	NQ	Futures	14199.9	14247.34	14195.56	14228.25	8824.0
2022-07-27 04:00:00	NQ	Futures	14228.83	14266.72	14224.49	14243.87	8089.0
2022-07-27 05:00:00	NQ	Futures	14243.58	14252.25	14218.41	14226.8	4803.0
2022-07-27 06:00:00	NQ	Futures	14226.8	14229.11	14198.74	14222.17	4981.0
2022-07-27 07:00:00	NQ	Futures	14222.46	14222.75	14188.91	14196.43	6775.0
2022-07-27 08:00:00	NQ	Futures	14195.85	14236.64	14190.07	14227.09	12345.0
2022-07-27 09:00:00	NQ	Futures	14226.8	14347.7	14203.37	14329.48	78470.0
2022-07-27 10:00:00	NQ	Futures	14330.06	14386.17	14314.44	14375.18	69702.0
2022-07-27 11:00:00	NQ	Futures	14375.18	14402.66	14352.91	14391.38	49199.0
2022-07-27 12:00:00	NQ	Futures	14391.38	14432.45	14376.34	14379.23	42716.0
2022-07-27 13:00:00	NQ	Futures	14379.81	14404.39	14364.77	14389.93	31147.0
2022-07-27 14:00:00	NQ	Futures	14390.51	14591.53	14350.88	14554.51	120530.0
2022-07-27 15:00:00	NQ	Futures	14555.38	14681.77	14533.39	14595.58	107255.0
2022-07-27 16:00:00	NQ	Futures	14595.29	14595.87	14504.76	14554.8	35596.0
2022-07-27 18:00:00	NQ	Futures	14554.51	14560.87	14542.94	14551.33	2561.0
2022-07-27 19:00:00	NQ	Futures	14551.91	14569.84	14544.39	14550.75	3334.0
2022-07-27 20:00:00	NQ	Futures	14550.46	14560.29	14522.11	14535.13	4526.0
2022-07-27 21:00:00	NQ	Futures	14535.71	14541.2	14524.14	14538.02	3973.0
2022-07-27 22:00:00	NQ	Futures	14537.73	14562.03	14533.39	14553.64	3330.0
2022-07-27 23:00:00	NQ	Futures	14553.93	14553.93	14529.63	14532.82	2128.0
2022-07-27 00:00:00	YM	Futures	35921.9	35982.9	35921.9	35972.7	1101.0
2022-07-27 01:00:00	YM	Futures	35972.7	36002.1	35959.2	35969.3	1261.0
2022-07-27 02:00:00	YM	Futures	35964.8	35994.2	35943.4	35946.8	1870.0
2022-07-27 03:00:00	YM	Futures	35947.9	36014.5	35947.9	35961.4	3173.0

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

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