PREVIEW / stock_1hour / 2006-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-28.parquet
  size:    626 KB
  rows:    29,308
  symbols: 2,205

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
2006-02-28 07:00:00	AAPL	Stock	2.5429	2.5464	2.5429	2.5464	11200.0
2006-02-28 08:00:00	AAPL	Stock	2.55	2.5625	2.5446	2.5493	5535152.0
2006-02-28 09:00:00	AAPL	Stock	2.5496	2.5857	2.5443	2.5743	163700992.0
2006-02-28 10:00:00	AAPL	Stock	2.5743	2.58	2.5089	2.5093	216171620.0
2006-02-28 11:00:00	AAPL	Stock	2.5086	2.5554	2.5086	2.535	118549872.0
2006-02-28 12:00:00	AAPL	Stock	2.535	2.5482	2.5286	2.5286	59607744.0
2006-02-28 13:00:00	AAPL	Stock	2.5289	2.5529	2.4589	2.4768	268772672.0
2006-02-28 14:00:00	AAPL	Stock	2.4771	2.4868	2.4421	2.4511	193402104.0
2006-02-28 15:00:00	AAPL	Stock	2.4511	2.4621	2.4321	2.4457	212791572.0
2006-02-28 16:00:00	AAPL	Stock	2.4457	2.5093	2.4375	2.4464	5722948.0
2006-02-28 17:00:00	AAPL	Stock	2.4457	2.4493	2.4446	2.4489	666568.0
2006-02-28 18:00:00	AAPL	Stock	2.4493	2.45	2.4429	2.4493	512344.0
2006-02-28 08:00:00	MSFT	Stock	27.03	27.08	27.03	27.05	18659.0
2006-02-28 09:00:00	MSFT	Stock	27.05	27.19	26.94	27.18	5805542.0
2006-02-28 10:00:00	MSFT	Stock	27.19	27.3	27.01	27.01	11964584.0
2006-02-28 11:00:00	MSFT	Stock	27.01	27.06	26.97	27.05	7481357.0
2006-02-28 12:00:00	MSFT	Stock	27.05	27.06	26.95	27.0	5330503.0
2006-02-28 13:00:00	MSFT	Stock	27.01	27.12	27.0	27.05	5629064.0
2006-02-28 14:00:00	MSFT	Stock	27.05	27.07	26.96	27.01	6730490.0
2006-02-28 15:00:00	MSFT	Stock	27.01	27.04	26.87	26.88	14412926.0
2006-02-28 16:00:00	MSFT	Stock	26.88	27.01	26.86	26.9	2233850.0
2006-02-28 17:00:00	MSFT	Stock	26.9	26.9	26.872	26.9	68900.0
2006-02-28 18:00:00	MSFT	Stock	26.92	26.92	26.89	26.91	2170.0
2006-02-28 08:00:00	NVDA	Stock	0.3979	0.3979	0.3938	0.394	236760.0
2006-02-28 09:00:00	NVDA	Stock	0.3942	0.3975	0.3917	0.393	73818840.0
2006-02-28 10:00:00	NVDA	Stock	0.3927	0.3949	0.3889	0.3897	115847760.0
2006-02-28 11:00:00	NVDA	Stock	0.3897	0.394	0.389	0.3925	64411920.0
2006-02-28 12:00:00	NVDA	Stock	0.3925	0.3944	0.3915	0.3942	47718600.0
2006-02-28 13:00:00	NVDA	Stock	0.3943	0.3958	0.3927	0.3932	40746360.0
2006-02-28 14:00:00	NVDA	Stock	0.3932	0.3937	0.3908	0.3925	49715640.0
2006-02-28 15:00:00	NVDA	Stock	0.3926	0.3943	0.3912	0.3925	89041800.0
2006-02-28 16:00:00	NVDA	Stock	0.3927	0.3928	0.3917	0.3927	5244120.0
2006-02-28 17:00:00	NVDA	Stock	0.3927	0.3927	0.3917	0.3923	315840.0
2006-02-28 09:00:00	AMZN	Stock	1.9	1.9045	1.8875	1.8975	11072240.0
2006-02-28 10:00:00	AMZN	Stock	1.898	1.9	1.8645	1.867	56517680.0
2006-02-28 11:00:00	AMZN	Stock	1.867	1.871	1.8525	1.866	36411860.0
2006-02-28 12:00:00	AMZN	Stock	1.866	1.889	1.863	1.8765	17938080.0
2006-02-28 13:00:00	AMZN	Stock	1.8765	1.8925	1.8755	1.8795	12059300.0
2006-02-28 14:00:00	AMZN	Stock	1.88	1.8825	1.866	1.8755	13751940.0
2006-02-28 15:00:00	AMZN	Stock	1.876	1.8825	1.86	1.8725	28896460.0
2006-02-28 16:00:00	AMZN	Stock	1.871	1.8748	1.8705	1.8748	502520.0
2006-02-28 17:00:00	AMZN	Stock	1.8745	1.8745	1.8726	1.8735	52360.0
2006-02-28 18:00:00	AMZN	Stock	1.866	1.866	1.866	1.866	12000.0
2006-02-28 09:00:00	CL	Stock	27.65	27.87	27.65	27.71	480800.0
2006-02-28 10:00:00	CL	Stock	27.72	27.72	27.45	27.52	476000.0
2006-02-28 11:00:00	CL	Stock	27.5	27.51	27.3	27.32	375600.0
2006-02-28 12:00:00	CL	Stock	27.325	27.4	27.27	27.355	317600.0
2006-02-28 13:00:00	CL	Stock	27.36	27.43	27.28	27.295	298800.0
2006-02-28 14:00:00	CL	Stock	27.3	27.31	27.245	27.275	314400.0
2006-02-28 15:00:00	CL	Stock	27.267	27.315	27.225	27.225	806400.0

> showing 50 of 29,308 rows — these rows as CSV

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