PREVIEW / futures_1hour / 2022-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-26.parquet
  size:    68 KB
  rows:    2,053

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-26 00:00:00	ES	Futures	4486.45	4487.02	4482.49	4485.6	2002.0
2022-07-26 01:00:00	ES	Futures	4485.6	4487.87	4481.92	4486.17	3858.0
2022-07-26 02:00:00	ES	Futures	4486.17	4489.0	4481.64	4484.47	5458.0
2022-07-26 03:00:00	ES	Futures	4484.47	4491.27	4481.07	4489.57	12479.0
2022-07-26 04:00:00	ES	Futures	4489.57	4490.42	4482.2	4486.74	9375.0
2022-07-26 05:00:00	ES	Futures	4486.74	4492.12	4482.2	4487.87	9039.0
2022-07-26 06:00:00	ES	Futures	4487.87	4490.42	4475.69	4481.64	17951.0
2022-07-26 07:00:00	ES	Futures	4481.92	4485.6	4477.39	4480.22	17111.0
2022-07-26 08:00:00	ES	Futures	4480.22	4486.74	4475.69	4480.22	28898.0
2022-07-26 09:00:00	ES	Futures	4480.22	4483.34	4463.79	4471.44	208205.0
2022-07-26 10:00:00	ES	Futures	4472.01	4477.67	4458.69	4467.19	240226.0
2022-07-26 11:00:00	ES	Futures	4467.47	4469.74	4440.28	4441.13	217467.0
2022-07-26 12:00:00	ES	Futures	4441.41	4455.01	4438.86	4453.03	147739.0
2022-07-26 13:00:00	ES	Futures	4453.03	4461.81	4449.06	4449.35	128183.0
2022-07-26 14:00:00	ES	Futures	4449.35	4461.53	4437.16	4442.83	132964.0
2022-07-26 15:00:00	ES	Futures	4442.83	4451.89	4434.05	4445.1	232274.0
2022-07-26 16:00:00	ES	Futures	4445.1	4463.79	4436.03	4463.51	94181.0
2022-07-26 18:00:00	ES	Futures	4463.51	4485.89	4462.94	4471.44	18980.0
2022-07-26 19:00:00	ES	Futures	4471.16	4483.05	4470.02	4480.22	8530.0
2022-07-26 20:00:00	ES	Futures	4479.94	4483.05	4475.69	4478.52	8866.0
2022-07-26 21:00:00	ES	Futures	4478.52	4480.22	4472.57	4476.26	7035.0
2022-07-26 22:00:00	ES	Futures	4476.26	4478.81	4474.27	4477.39	3995.0
2022-07-26 23:00:00	ES	Futures	4477.67	4481.07	4477.11	4478.24	3258.0
2022-07-26 00:00:00	NQ	Futures	14242.71	14244.16	14231.43	14240.97	1085.0
2022-07-26 01:00:00	NQ	Futures	14240.4	14249.36	14228.25	14243.87	1872.0
2022-07-26 02:00:00	NQ	Futures	14245.6	14256.59	14224.78	14238.95	3090.0
2022-07-26 03:00:00	NQ	Futures	14237.5	14267.87	14231.14	14260.06	5482.0
2022-07-26 04:00:00	NQ	Futures	14260.64	14263.25	14228.83	14245.02	4275.0
2022-07-26 05:00:00	NQ	Futures	14245.31	14269.9	14238.95	14259.2	4894.0
2022-07-26 06:00:00	NQ	Futures	14260.06	14268.16	14202.22	14227.09	10214.0
2022-07-26 07:00:00	NQ	Futures	14227.67	14246.76	14208.87	14220.73	8000.0
2022-07-26 08:00:00	NQ	Futures	14221.59	14247.92	14189.78	14208.29	13342.0
2022-07-26 09:00:00	NQ	Futures	14208.0	14226.51	14110.24	14155.65	81390.0
2022-07-26 10:00:00	NQ	Futures	14153.33	14184.28	14066.27	14109.37	77734.0
2022-07-26 11:00:00	NQ	Futures	14109.95	14119.2	14009.58	14014.5	66845.0
2022-07-26 12:00:00	NQ	Futures	14015.08	14059.62	14006.11	14045.45	45765.0
2022-07-26 13:00:00	NQ	Futures	14044.87	14072.64	14019.13	14021.44	39030.0
2022-07-26 14:00:00	NQ	Futures	14022.02	14072.35	13982.1	14004.67	47670.0
2022-07-26 15:00:00	NQ	Futures	14004.09	14037.06	13969.96	14011.03	62307.0
2022-07-26 16:00:00	NQ	Futures	14011.03	14112.55	13966.78	14110.53	37811.0
2022-07-26 18:00:00	NQ	Futures	14105.61	14238.37	14105.32	14172.13	16066.0
2022-07-26 19:00:00	NQ	Futures	14171.56	14219.86	14166.93	14207.71	5764.0
2022-07-26 20:00:00	NQ	Futures	14208.0	14218.99	14196.43	14205.4	4090.0
2022-07-26 21:00:00	NQ	Futures	14204.82	14211.18	14181.1	14195.27	3900.0
2022-07-26 22:00:00	NQ	Futures	14195.56	14204.53	14188.62	14200.48	2004.0
2022-07-26 23:00:00	NQ	Futures	14200.77	14210.03	14197.01	14204.53	1534.0
2022-07-26 00:00:00	YM	Futures	35944.5	35945.6	35917.4	35934.4	491.0
2022-07-26 01:00:00	YM	Futures	35935.5	35951.3	35912.9	35938.9	881.0
2022-07-26 02:00:00	YM	Futures	35940.0	35961.4	35910.7	35928.7	1440.0
2022-07-26 03:00:00	YM	Futures	35927.6	35972.7	35899.4	35958.1	2982.0

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

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