PREVIEW / futures_1hour / 2021-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-06.parquet
  size:    66 KB
  rows:    1,980

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-01-06 00:00:00	ES	Futures	4146.85	4159.76	4144.6	4150.21	12898.0
2021-01-06 01:00:00	ES	Futures	4150.21	4162.56	4149.65	4160.88	7941.0
2021-01-06 02:00:00	ES	Futures	4161.16	4175.47	4158.07	4166.77	14520.0
2021-01-06 03:00:00	ES	Futures	4166.77	4166.77	4139.55	4143.2	36179.0
2021-01-06 04:00:00	ES	Futures	4143.2	4167.33	4137.58	4163.69	26546.0
2021-01-06 05:00:00	ES	Futures	4163.41	4169.86	4156.67	4163.69	20162.0
2021-01-06 06:00:00	ES	Futures	4163.97	4165.65	4150.78	4164.25	19481.0
2021-01-06 07:00:00	ES	Futures	4163.97	4174.91	4156.67	4158.63	31880.0
2021-01-06 08:00:00	ES	Futures	4158.63	4167.33	4149.65	4153.02	35678.0
2021-01-06 09:00:00	ES	Futures	4153.02	4185.86	4149.09	4183.89	210610.0
2021-01-06 10:00:00	ES	Futures	4183.89	4224.03	4180.53	4216.45	258117.0
2021-01-06 11:00:00	ES	Futures	4216.45	4228.24	4215.61	4219.82	161881.0
2021-01-06 12:00:00	ES	Futures	4220.1	4233.01	4219.54	4231.61	96755.0
2021-01-06 13:00:00	ES	Futures	4231.61	4237.78	4227.4	4232.45	106390.0
2021-01-06 14:00:00	ES	Futures	4232.45	4236.94	4193.16	4209.72	322458.0
2021-01-06 15:00:00	ES	Futures	4209.43	4217.85	4191.47	4199.33	422264.0
2021-01-06 16:00:00	ES	Futures	4199.33	4215.61	4187.54	4209.15	90284.0
2021-01-06 18:00:00	ES	Futures	4212.8	4214.77	4205.79	4209.72	11052.0
2021-01-06 19:00:00	ES	Futures	4209.72	4215.61	4201.01	4215.33	18403.0
2021-01-06 20:00:00	ES	Futures	4215.61	4226.84	4212.24	4225.71	17724.0
2021-01-06 21:00:00	ES	Futures	4225.71	4226.84	4220.94	4224.87	9599.0
2021-01-06 22:00:00	ES	Futures	4225.15	4233.01	4221.78	4223.75	10380.0
2021-01-06 23:00:00	ES	Futures	4223.75	4225.43	4218.14	4218.98	4815.0
2021-01-06 00:00:00	NQ	Futures	14602.8	14633.19	14587.75	14600.2	6243.0
2021-01-06 01:00:00	NQ	Futures	14601.93	14664.16	14594.99	14625.67	5879.0
2021-01-06 02:00:00	NQ	Futures	14622.19	14660.4	14543.76	14555.91	17372.0
2021-01-06 03:00:00	NQ	Futures	14555.33	14584.57	14461.56	14493.68	24608.0
2021-01-06 04:00:00	NQ	Futures	14492.53	14579.65	14490.79	14566.04	12685.0
2021-01-06 05:00:00	NQ	Futures	14566.33	14568.65	14498.31	14518.0	11790.0
2021-01-06 06:00:00	NQ	Futures	14518.58	14563.15	14474.0	14557.07	11919.0
2021-01-06 07:00:00	NQ	Futures	14556.2	14624.22	14555.62	14575.01	18747.0
2021-01-06 08:00:00	NQ	Futures	14575.59	14638.98	14537.39	14555.62	22808.0
2021-01-06 09:00:00	NQ	Futures	14554.75	14666.19	14531.02	14627.4	91803.0
2021-01-06 10:00:00	NQ	Futures	14627.69	14782.25	14603.38	14742.31	88909.0
2021-01-06 11:00:00	NQ	Futures	14742.89	14802.8	14732.76	14763.44	58131.0
2021-01-06 12:00:00	NQ	Futures	14764.3	14814.38	14760.25	14779.93	40410.0
2021-01-06 13:00:00	NQ	Futures	14779.93	14812.06	14753.88	14783.7	34672.0
2021-01-06 14:00:00	NQ	Futures	14783.99	14799.9	14629.43	14683.55	84695.0
2021-01-06 15:00:00	NQ	Futures	14682.97	14703.81	14582.25	14608.88	101429.0
2021-01-06 16:00:00	NQ	Futures	14608.59	14667.34	14575.88	14654.61	17544.0
2021-01-06 18:00:00	NQ	Futures	14655.19	14678.05	14641.29	14672.26	4259.0
2021-01-06 19:00:00	NQ	Futures	14672.55	14702.37	14653.16	14702.08	5903.0
2021-01-06 20:00:00	NQ	Futures	14701.5	14747.52	14699.18	14746.36	7971.0
2021-01-06 21:00:00	NQ	Futures	14746.07	14751.86	14717.99	14730.73	5220.0
2021-01-06 22:00:00	NQ	Futures	14731.6	14744.91	14710.76	14721.76	3417.0
2021-01-06 23:00:00	NQ	Futures	14722.05	14731.02	14699.47	14702.94	3266.0
2021-01-06 00:00:00	YM	Futures	33521.0	33606.4	33509.9	33546.5	3174.0
2021-01-06 01:00:00	YM	Futures	33544.3	33641.9	33544.3	33631.9	2665.0
2021-01-06 02:00:00	YM	Futures	33629.7	33761.7	33609.7	33715.1	7821.0
2021-01-06 03:00:00	YM	Futures	33714.0	33714.0	33472.2	33518.8	10994.0

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

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