PREVIEW / stock_1hour / 2006-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-22.parquet
  size:    601 KB
  rows:    28,548
  symbols: 2,198

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-22 05:00:00	AAPL	Stock	2.4643	2.4643	2.4629	2.4629	30800.0
2006-02-22 07:00:00	AAPL	Stock	2.4679	2.4679	2.4643	2.4643	14000.0
2006-02-22 08:00:00	AAPL	Stock	2.4643	2.4768	2.4607	2.4696	1440796.0
2006-02-22 09:00:00	AAPL	Stock	2.4696	2.4714	2.4286	2.4557	129290784.0
2006-02-22 10:00:00	AAPL	Stock	2.4554	2.5029	2.4504	2.5018	184754332.0
2006-02-22 11:00:00	AAPL	Stock	2.5018	2.5421	2.495	2.5229	175114660.0
2006-02-22 12:00:00	AAPL	Stock	2.5229	2.5357	2.5168	2.5339	76563116.0
2006-02-22 13:00:00	AAPL	Stock	2.5339	2.5554	2.5304	2.5389	152604592.0
2006-02-22 14:00:00	AAPL	Stock	2.5396	2.5489	2.5304	2.54	95331208.0
2006-02-22 15:00:00	AAPL	Stock	2.5393	2.5596	2.5386	2.5468	143441760.0
2006-02-22 16:00:00	AAPL	Stock	2.5471	2.5471	2.5411	2.5411	1626772.0
2006-02-22 17:00:00	AAPL	Stock	2.5411	2.5429	2.4403	2.54	659400.0
2006-02-22 18:00:00	AAPL	Stock	2.54	2.5471	2.5393	2.5396	264292.0
2006-02-22 08:00:00	MSFT	Stock	26.4	26.47	26.4	26.47	5770.0
2006-02-22 09:00:00	MSFT	Stock	26.46	26.76	26.4	26.52	7064907.0
2006-02-22 10:00:00	MSFT	Stock	26.51	26.602	26.5	26.58	4144266.0
2006-02-22 11:00:00	MSFT	Stock	26.59	26.76	26.57	26.73	6637623.0
2006-02-22 12:00:00	MSFT	Stock	26.74	26.84	26.73	26.78	5854101.0
2006-02-22 13:00:00	MSFT	Stock	26.78	26.85	26.75	26.79	4706002.0
2006-02-22 14:00:00	MSFT	Stock	26.79	26.86	26.76	26.81	3535432.0
2006-02-22 15:00:00	MSFT	Stock	26.81	26.82	26.48	26.72	7316978.0
2006-02-22 16:00:00	MSFT	Stock	26.72	26.75	26.69	26.72	382859.0
2006-02-22 17:00:00	MSFT	Stock	26.74	26.74	26.73	26.74	3100.0
2006-02-22 18:00:00	MSFT	Stock	26.72	26.74	26.72	26.74	2804.0
2006-02-22 08:00:00	NVDA	Stock	0.3872	0.3872	0.3872	0.3872	12000.0
2006-02-22 09:00:00	NVDA	Stock	0.3875	0.3875	0.3725	0.3804	254478840.0
2006-02-22 10:00:00	NVDA	Stock	0.3802	0.385	0.3795	0.3849	227665440.0
2006-02-22 11:00:00	NVDA	Stock	0.3849	0.3889	0.3832	0.3887	145837920.0
2006-02-22 12:00:00	NVDA	Stock	0.3888	0.3896	0.3863	0.3875	75992760.0
2006-02-22 13:00:00	NVDA	Stock	0.3875	0.3893	0.3837	0.3866	63213360.0
2006-02-22 14:00:00	NVDA	Stock	0.3867	0.3877	0.3846	0.3874	64617720.0
2006-02-22 15:00:00	NVDA	Stock	0.3874	0.3881	0.3857	0.3862	98313960.0
2006-02-22 16:00:00	NVDA	Stock	0.3863	0.3869	0.3863	0.3869	343200.0
2006-02-22 17:00:00	NVDA	Stock	0.386	0.3866	0.386	0.3866	72000.0
2006-02-22 09:00:00	AMZN	Stock	1.915	1.918	1.8925	1.899	13720840.0
2006-02-22 10:00:00	AMZN	Stock	1.899	1.904	1.8855	1.898	21544640.0
2006-02-22 11:00:00	AMZN	Stock	1.8981	1.9205	1.898	1.919	23665960.0
2006-02-22 12:00:00	AMZN	Stock	1.919	1.9305	1.9125	1.927	15716640.0
2006-02-22 13:00:00	AMZN	Stock	1.927	1.937	1.924	1.935	12132880.0
2006-02-22 14:00:00	AMZN	Stock	1.9345	1.9545	1.933	1.949	18658260.0
2006-02-22 15:00:00	AMZN	Stock	1.949	1.955	1.9265	1.927	39558000.0
2006-02-22 16:00:00	AMZN	Stock	1.925	1.9355	1.9225	1.926	288740.0
2006-02-22 17:00:00	AMZN	Stock	1.93	1.9345	1.93	1.9345	34000.0
2006-02-22 18:00:00	AMZN	Stock	1.93	1.931	1.928	1.928	12000.0
2006-02-22 09:00:00	CL	Stock	27.085	27.385	27.01	27.35	389800.0
2006-02-22 10:00:00	CL	Stock	27.365	27.39	27.26	27.32	395800.0
2006-02-22 11:00:00	CL	Stock	27.32	27.49	27.31	27.435	350800.0
2006-02-22 12:00:00	CL	Stock	27.435	27.44	27.315	27.32	294800.0
2006-02-22 13:00:00	CL	Stock	27.32	27.335	27.26	27.275	294200.0
2006-02-22 14:00:00	CL	Stock	27.27	27.295	27.255	27.29	324600.0

> showing 50 of 28,548 rows — these rows as CSV

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