PREVIEW / futures_1hour / 2021-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-10.parquet
  size:    68 KB
  rows:    2,029

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-11-10 00:00:00	ES	Futures	5262.13	5266.08	5261.29	5264.67	5502.0
2021-11-10 01:00:00	ES	Futures	5264.67	5274.83	5263.83	5273.7	7962.0
2021-11-10 02:00:00	ES	Futures	5273.99	5281.89	5272.57	5279.35	11273.0
2021-11-10 03:00:00	ES	Futures	5279.35	5283.3	5274.55	5274.83	14504.0
2021-11-10 04:00:00	ES	Futures	5274.83	5277.94	5268.62	5275.68	15206.0
2021-11-10 05:00:00	ES	Futures	5275.68	5276.81	5264.39	5268.34	12886.0
2021-11-10 06:00:00	ES	Futures	5268.34	5270.32	5261.85	5263.26	13950.0
2021-11-10 07:00:00	ES	Futures	5263.26	5270.6	5262.98	5268.91	15619.0
2021-11-10 08:00:00	ES	Futures	5268.91	5272.57	5256.77	5262.98	64079.0
2021-11-10 09:00:00	ES	Futures	5263.26	5279.63	5258.18	5278.22	187148.0
2021-11-10 10:00:00	ES	Futures	5277.94	5281.61	5272.86	5274.27	146699.0
2021-11-10 11:00:00	ES	Futures	5274.27	5280.48	5268.34	5274.83	114799.0
2021-11-10 12:00:00	ES	Futures	5274.83	5276.53	5260.44	5266.08	102088.0
2021-11-10 13:00:00	ES	Futures	5266.08	5267.21	5242.38	5245.48	238901.0
2021-11-10 14:00:00	ES	Futures	5245.48	5246.33	5221.21	5229.11	261444.0
2021-11-10 15:00:00	ES	Futures	5229.11	5246.61	5225.44	5239.27	257722.0
2021-11-10 16:00:00	ES	Futures	5239.27	5244.07	5237.86	5242.66	58626.0
2021-11-10 18:00:00	ES	Futures	5243.51	5244.07	5235.6	5239.84	8107.0
2021-11-10 19:00:00	ES	Futures	5239.84	5248.87	5239.56	5246.33	11995.0
2021-11-10 20:00:00	ES	Futures	5246.05	5252.25	5240.97	5252.25	11947.0
2021-11-10 21:00:00	ES	Futures	5252.25	5253.67	5247.74	5248.59	8908.0
2021-11-10 22:00:00	ES	Futures	5248.3	5250.28	5244.35	5245.2	6417.0
2021-11-10 23:00:00	ES	Futures	5245.2	5245.76	5238.43	5241.25	7675.0
2021-11-10 00:00:00	NQ	Futures	18731.46	18749.72	18729.72	18741.9	3220.0
2021-11-10 01:00:00	NQ	Futures	18741.9	18801.6	18737.26	18789.14	4849.0
2021-11-10 02:00:00	NQ	Futures	18789.43	18830.0	18783.63	18821.31	5389.0
2021-11-10 03:00:00	NQ	Futures	18821.31	18828.84	18778.99	18781.31	6036.0
2021-11-10 04:00:00	NQ	Futures	18781.6	18794.93	18748.56	18776.67	7241.0
2021-11-10 05:00:00	NQ	Futures	18777.25	18782.47	18701.9	18723.35	9151.0
2021-11-10 06:00:00	NQ	Futures	18721.9	18733.49	18678.43	18694.08	8339.0
2021-11-10 07:00:00	NQ	Futures	18694.37	18721.9	18689.15	18702.48	8074.0
2021-11-10 08:00:00	NQ	Futures	18702.19	18736.68	18642.78	18669.15	31949.0
2021-11-10 09:00:00	NQ	Futures	18669.73	18756.1	18596.7	18748.27	94317.0
2021-11-10 10:00:00	NQ	Futures	18748.56	18804.5	18725.09	18738.42	86466.0
2021-11-10 11:00:00	NQ	Futures	18738.42	18774.65	18680.74	18727.12	57386.0
2021-11-10 12:00:00	NQ	Futures	18726.83	18736.97	18660.75	18696.68	39577.0
2021-11-10 13:00:00	NQ	Futures	18696.39	18702.48	18555.25	18571.77	84163.0
2021-11-10 14:00:00	NQ	Futures	18571.48	18583.08	18428.31	18461.35	90122.0
2021-11-10 15:00:00	NQ	Futures	18461.06	18557.28	18451.5	18522.79	82648.0
2021-11-10 16:00:00	NQ	Futures	18522.79	18536.71	18500.19	18532.36	11843.0
2021-11-10 18:00:00	NQ	Futures	18535.55	18543.95	18520.48	18537.28	4708.0
2021-11-10 19:00:00	NQ	Futures	18537.86	18581.34	18535.26	18571.48	6693.0
2021-11-10 20:00:00	NQ	Futures	18570.9	18597.57	18548.59	18596.41	5859.0
2021-11-10 21:00:00	NQ	Futures	18596.7	18600.46	18570.32	18577.57	3498.0
2021-11-10 22:00:00	NQ	Futures	18576.7	18581.34	18550.62	18555.83	3016.0
2021-11-10 23:00:00	NQ	Futures	18556.41	18559.89	18525.4	18546.27	4759.0
2021-11-10 00:00:00	YM	Futures	40445.7	40477.1	40436.7	40465.9	1253.0
2021-11-10 01:00:00	YM	Futures	40467.0	40521.9	40463.6	40517.4	1596.0
2021-11-10 02:00:00	YM	Futures	40516.3	40586.9	40507.4	40554.4	2750.0
2021-11-10 03:00:00	YM	Futures	40553.3	40591.4	40534.3	40536.5	2567.0

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

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