PREVIEW / futures_1hour / 2021-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-29.parquet
  size:    67 KB
  rows:    2,038

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-29 00:00:00	ES	Futures	5227.7	5231.09	5218.11	5224.6	15606.0
2021-11-29 01:00:00	ES	Futures	5224.88	5238.43	5222.34	5237.58	11074.0
2021-11-29 02:00:00	ES	Futures	5237.58	5238.99	5228.27	5231.65	20900.0
2021-11-29 03:00:00	ES	Futures	5231.65	5238.14	5216.98	5222.62	43605.0
2021-11-29 04:00:00	ES	Futures	5222.62	5232.22	5215.29	5215.85	34861.0
2021-11-29 05:00:00	ES	Futures	5215.57	5233.91	5215.57	5230.81	21575.0
2021-11-29 06:00:00	ES	Futures	5231.37	5236.17	5227.7	5227.7	17833.0
2021-11-29 07:00:00	ES	Futures	5227.42	5231.37	5220.65	5229.96	23509.0
2021-11-29 08:00:00	ES	Futures	5229.96	5245.2	5223.75	5242.38	53149.0
2021-11-29 09:00:00	ES	Futures	5242.38	5249.15	5225.16	5237.02	311603.0
2021-11-29 10:00:00	ES	Futures	5236.73	5240.68	5216.7	5226.57	310529.0
2021-11-29 11:00:00	ES	Futures	5226.57	5248.59	5222.62	5248.02	185272.0
2021-11-29 12:00:00	ES	Futures	5248.02	5268.62	5247.46	5266.65	154319.0
2021-11-29 13:00:00	ES	Futures	5266.65	5271.45	5260.72	5267.78	113098.0
2021-11-29 14:00:00	ES	Futures	5267.78	5268.34	5258.46	5261.85	102484.0
2021-11-29 15:00:00	ES	Futures	5261.57	5269.47	5246.05	5249.72	282093.0
2021-11-29 16:00:00	ES	Futures	5249.43	5257.62	5247.46	5255.64	77617.0
2021-11-29 18:00:00	ES	Futures	5257.33	5266.08	5256.49	5263.54	9013.0
2021-11-29 19:00:00	ES	Futures	5263.83	5268.06	5261.0	5266.93	7892.0
2021-11-29 20:00:00	ES	Futures	5267.21	5268.91	5264.39	5265.52	6941.0
2021-11-29 21:00:00	ES	Futures	5265.52	5266.65	5256.77	5261.57	8233.0
2021-11-29 22:00:00	ES	Futures	5261.29	5261.85	5253.1	5257.62	5982.0
2021-11-29 23:00:00	ES	Futures	5257.62	5260.44	5252.82	5256.77	5659.0
2021-11-29 00:00:00	NQ	Futures	18805.95	18814.06	18771.75	18790.58	7517.0
2021-11-29 01:00:00	NQ	Futures	18791.16	18842.46	18780.73	18837.83	5138.0
2021-11-29 02:00:00	NQ	Futures	18836.67	18841.01	18778.7	18788.27	7881.0
2021-11-29 03:00:00	NQ	Futures	18786.82	18813.48	18755.81	18778.7	13283.0
2021-11-29 04:00:00	NQ	Futures	18779.86	18811.45	18741.32	18744.79	11049.0
2021-11-29 05:00:00	NQ	Futures	18744.79	18802.76	18744.5	18795.22	8784.0
2021-11-29 06:00:00	NQ	Futures	18795.51	18812.61	18776.38	18778.41	6168.0
2021-11-29 07:00:00	NQ	Futures	18777.25	18792.32	18751.46	18784.5	9964.0
2021-11-29 08:00:00	NQ	Futures	18785.66	18830.58	18760.44	18825.07	14149.0
2021-11-29 09:00:00	NQ	Futures	18823.91	18903.32	18790.01	18893.47	95406.0
2021-11-29 10:00:00	NQ	Futures	18893.18	18912.6	18811.45	18868.26	97752.0
2021-11-29 11:00:00	NQ	Futures	18868.84	18963.32	18852.03	18957.81	61743.0
2021-11-29 12:00:00	NQ	Futures	18958.39	19020.41	18951.14	19009.4	48701.0
2021-11-29 13:00:00	NQ	Futures	19009.4	19034.03	18991.14	19027.37	36065.0
2021-11-29 14:00:00	NQ	Futures	19027.37	19032.0	18984.18	19014.61	30591.0
2021-11-29 15:00:00	NQ	Futures	19014.32	19055.77	18986.5	19001.28	64505.0
2021-11-29 16:00:00	NQ	Futures	19001.28	19029.39	18993.75	19027.95	15400.0
2021-11-29 18:00:00	NQ	Futures	19034.03	19059.54	19027.08	19047.94	5359.0
2021-11-29 19:00:00	NQ	Futures	19047.94	19056.06	19032.0	19050.55	3526.0
2021-11-29 20:00:00	NQ	Futures	19050.55	19056.93	19035.48	19040.7	2793.0
2021-11-29 21:00:00	NQ	Futures	19039.83	19043.31	19003.02	19018.96	4581.0
2021-11-29 22:00:00	NQ	Futures	19018.09	19020.41	18992.88	19017.22	3329.0
2021-11-29 23:00:00	NQ	Futures	19017.22	19030.55	19002.44	19015.48	4556.0
2021-11-29 00:00:00	YM	Futures	39264.3	39291.2	39178.0	39245.2	3613.0
2021-11-29 01:00:00	YM	Futures	39250.8	39356.2	39219.4	39349.5	2540.0
2021-11-29 02:00:00	YM	Futures	39349.5	39385.3	39287.8	39328.2	5847.0
2021-11-29 03:00:00	YM	Futures	39327.0	39377.5	39193.6	39235.1	9786.0

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

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