PREVIEW / stock_1hour / 2008-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-28.parquet
  size:    840 KB
  rows:    40,330
  symbols: 3,302

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
2008-05-28 07:00:00	AAPL	Stock	6.675	6.6961	6.675	6.6929	326592.0
2008-05-28 08:00:00	AAPL	Stock	6.6964	6.7136	6.6761	6.7086	6544048.0
2008-05-28 09:00:00	AAPL	Stock	6.7064	6.7125	6.6386	6.6489	144004672.0
2008-05-28 10:00:00	AAPL	Stock	6.6493	6.6725	6.6161	6.6429	133582400.0
2008-05-28 11:00:00	AAPL	Stock	6.6421	6.6464	6.5796	6.5961	96112128.0
2008-05-28 12:00:00	AAPL	Stock	6.5954	6.62	6.5614	6.6146	83359220.0
2008-05-28 13:00:00	AAPL	Stock	6.6154	6.6518	6.6082	6.6193	79469684.0
2008-05-28 14:00:00	AAPL	Stock	6.6193	6.6582	6.6025	6.6339	74336724.0
2008-05-28 15:00:00	AAPL	Stock	6.6339	6.6807	6.6236	6.6786	109603900.0
2008-05-28 16:00:00	AAPL	Stock	6.6786	6.685	6.6394	6.6732	7260792.0
2008-05-28 17:00:00	AAPL	Stock	6.6732	6.6804	6.6386	6.6796	371140.0
2008-05-28 18:00:00	AAPL	Stock	6.6786	6.6804	6.675	6.6789	176400.0
2008-05-28 19:00:00	AAPL	Stock	6.6804	6.6804	6.6786	6.6789	299628.0
2008-05-28 08:00:00	MSFT	Stock	28.45	28.61	28.45	28.58	40275.0
2008-05-28 09:00:00	MSFT	Stock	28.58	28.6	28.27	28.39	4973576.0
2008-05-28 10:00:00	MSFT	Stock	28.388	28.4	28.09	28.28	7167258.0
2008-05-28 11:00:00	MSFT	Stock	28.29	28.33	28.14	28.14	5182770.0
2008-05-28 12:00:00	MSFT	Stock	28.144	28.144	28.04	28.08	7499189.0
2008-05-28 13:00:00	MSFT	Stock	28.08	28.16	28.04	28.09	5177583.0
2008-05-28 14:00:00	MSFT	Stock	28.08	28.16	28.05	28.07	5772862.0
2008-05-28 15:00:00	MSFT	Stock	28.08	28.22	28.07	28.21	11895294.0
2008-05-28 16:00:00	MSFT	Stock	28.18	28.23	28.086	28.2	1764250.0
2008-05-28 17:00:00	MSFT	Stock	28.2	28.3	28.084	28.25	80700.0
2008-05-28 18:00:00	MSFT	Stock	28.25	28.25	28.2	28.25	268602.0
2008-05-28 19:00:00	MSFT	Stock	28.2	28.24	28.2	28.24	900.0
2008-05-28 20:00:00	MSFT	Stock	28.21	28.21	28.21	28.21	3911.0
2008-05-28 07:00:00	NVDA	Stock	0.594	0.5988	0.594	0.5988	104000.0
2008-05-28 08:00:00	NVDA	Stock	0.5978	0.6	0.5952	0.5965	3304120.0
2008-05-28 09:00:00	NVDA	Stock	0.597	0.6015	0.594	0.5973	102286520.0
2008-05-28 10:00:00	NVDA	Stock	0.597	0.5973	0.5883	0.5938	106114080.0
2008-05-28 11:00:00	NVDA	Stock	0.5938	0.594	0.5855	0.5898	95991400.0
2008-05-28 12:00:00	NVDA	Stock	0.5898	0.5951	0.5875	0.5885	70431360.0
2008-05-28 13:00:00	NVDA	Stock	0.5883	0.5918	0.5828	0.5858	91442240.0
2008-05-28 14:00:00	NVDA	Stock	0.5858	0.5878	0.5832	0.5865	97850240.0
2008-05-28 15:00:00	NVDA	Stock	0.5868	0.5912	0.5858	0.5898	165469960.0
2008-05-28 16:00:00	NVDA	Stock	0.5895	0.5923	0.589	0.5908	6696240.0
2008-05-28 17:00:00	NVDA	Stock	0.5908	0.592	0.5908	0.5912	66080.0
2008-05-28 18:00:00	NVDA	Stock	0.5912	0.5923	0.5912	0.5923	146960.0
2008-05-28 19:00:00	NVDA	Stock	0.5895	0.5895	0.5895	0.5895	8000.0
2008-05-28 08:00:00	AMZN	Stock	4.0495	4.0575	4.035	4.0505	482180.0
2008-05-28 09:00:00	AMZN	Stock	4.05	4.055	3.9675	3.9855	25050680.0
2008-05-28 10:00:00	AMZN	Stock	3.987	4.0045	3.9585	4.0	22691180.0
2008-05-28 11:00:00	AMZN	Stock	4.0	4.0015	3.9625	3.98	13969540.0
2008-05-28 12:00:00	AMZN	Stock	3.9805	4.0255	3.9495	3.97	14705780.0
2008-05-28 13:00:00	AMZN	Stock	3.97	3.992	3.9645	3.979	11017280.0
2008-05-28 14:00:00	AMZN	Stock	3.9775	4.011	3.9705	3.997	14873200.0
2008-05-28 15:00:00	AMZN	Stock	3.997	4.0195	3.984	4.0059	26573360.0
2008-05-28 16:00:00	AMZN	Stock	4.004	4.0075	3.9887	4.004	3019920.0
2008-05-28 19:00:00	AMZN	Stock	3.9985	3.9985	3.9985	3.9985	3800.0
2008-05-28 09:00:00	TLT	Stock	90.6	90.73	90.41	90.49	493502.0

> showing 50 of 40,330 rows — these rows as CSV

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