PREVIEW / stock_1hour / 2008-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-27.parquet
  size:    838 KB
  rows:    40,245
  symbols: 3,307

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-27 07:00:00	AAPL	Stock	6.4846	6.4893	6.4818	6.4893	90104.0
2008-05-27 08:00:00	AAPL	Stock	6.4793	6.5068	6.4732	6.4946	2345812.0
2008-05-27 09:00:00	AAPL	Stock	6.495	6.5804	6.4871	6.5614	114173528.0
2008-05-27 10:00:00	AAPL	Stock	6.5629	6.5886	6.5493	6.5725	134143212.0
2008-05-27 11:00:00	AAPL	Stock	6.5729	6.5821	6.5107	6.5129	97779164.0
2008-05-27 12:00:00	AAPL	Stock	6.5129	6.5532	6.4943	6.5457	74650240.0
2008-05-27 13:00:00	AAPL	Stock	6.5461	6.5857	6.5357	6.5779	73124856.0
2008-05-27 14:00:00	AAPL	Stock	6.5779	6.6257	6.5589	6.61	120121904.0
2008-05-27 15:00:00	AAPL	Stock	6.6107	6.6571	6.5982	6.6554	153248340.0
2008-05-27 16:00:00	AAPL	Stock	6.6564	6.6607	6.5407	6.6582	14196000.0
2008-05-27 17:00:00	AAPL	Stock	6.6604	6.6621	6.6139	6.6586	565600.0
2008-05-27 18:00:00	AAPL	Stock	6.6586	6.6589	6.6536	6.6561	213332.0
2008-05-27 19:00:00	AAPL	Stock	6.6539	6.6604	6.6536	6.6589	317716.0
2008-05-27 08:00:00	MSFT	Stock	28.15	28.25	28.05	28.05	11236.0
2008-05-27 09:00:00	MSFT	Stock	28.06	28.36	28.05	28.2	4035159.0
2008-05-27 10:00:00	MSFT	Stock	28.195	28.4	28.18	28.34	6862328.0
2008-05-27 11:00:00	MSFT	Stock	28.33	28.37	28.2	28.208	7553495.0
2008-05-27 12:00:00	MSFT	Stock	28.21	28.23	28.14	28.218	3355971.0
2008-05-27 13:00:00	MSFT	Stock	28.22	28.26	28.15	28.24	3497108.0
2008-05-27 14:00:00	MSFT	Stock	28.25	28.451	28.15	28.398	6446337.0
2008-05-27 15:00:00	MSFT	Stock	28.39	28.5	28.31	28.45	11613458.0
2008-05-27 16:00:00	MSFT	Stock	28.47	28.47	28.284	28.44	3251742.0
2008-05-27 17:00:00	MSFT	Stock	28.39	28.45	28.314	28.45	2943.0
2008-05-27 18:00:00	MSFT	Stock	28.4	28.42	28.38	28.4	2387.0
2008-05-27 19:00:00	MSFT	Stock	28.4	28.46	28.36	28.39	84313.0
2008-05-27 08:00:00	NVDA	Stock	0.5788	0.58	0.5788	0.58	96000.0
2008-05-27 09:00:00	NVDA	Stock	0.5808	0.5825	0.57	0.5758	59398000.0
2008-05-27 10:00:00	NVDA	Stock	0.5755	0.5788	0.571	0.5725	129701960.0
2008-05-27 11:00:00	NVDA	Stock	0.5725	0.575	0.57	0.5725	110823880.0
2008-05-27 12:00:00	NVDA	Stock	0.5725	0.5735	0.5678	0.5702	108940880.0
2008-05-27 13:00:00	NVDA	Stock	0.5702	0.5735	0.5696	0.5722	87673360.0
2008-05-27 14:00:00	NVDA	Stock	0.5725	0.5835	0.5712	0.5818	157565600.0
2008-05-27 15:00:00	NVDA	Stock	0.582	0.5848	0.5795	0.5845	137139400.0
2008-05-27 16:00:00	NVDA	Stock	0.5845	0.586	0.5731	0.584	24072080.0
2008-05-27 17:00:00	NVDA	Stock	0.585	0.5875	0.585	0.5875	147600.0
2008-05-27 18:00:00	NVDA	Stock	0.5855	0.5875	0.5855	0.5855	85520.0
2008-05-27 19:00:00	NVDA	Stock	0.5855	0.5855	0.5855	0.5855	36000.0
2008-05-27 07:00:00	AMZN	Stock	3.944	3.944	3.944	3.944	8000.0
2008-05-27 08:00:00	AMZN	Stock	3.9	3.9	3.9	3.9	2000.0
2008-05-27 09:00:00	AMZN	Stock	3.913	3.997	3.8985	3.994	16531520.0
2008-05-27 10:00:00	AMZN	Stock	3.9925	4.045	3.976	3.9935	29537580.0
2008-05-27 11:00:00	AMZN	Stock	3.9935	4.04	3.94	3.9685	20748160.0
2008-05-27 12:00:00	AMZN	Stock	3.9675	3.97	3.935	3.9455	12527320.0
2008-05-27 13:00:00	AMZN	Stock	3.946	3.95	3.923	3.929	14333600.0
2008-05-27 14:00:00	AMZN	Stock	3.929	3.9675	3.9075	3.9655	25024040.0
2008-05-27 15:00:00	AMZN	Stock	3.9665	4.0435	3.9605	4.0305	56770720.0
2008-05-27 16:00:00	AMZN	Stock	4.031	4.0405	3.9175	4.029	19934500.0
2008-05-27 17:00:00	AMZN	Stock	4.0265	4.0265	4.025	4.025	14000.0
2008-05-27 18:00:00	AMZN	Stock	4.0275	4.0275	4.025	4.025	4000.0
2008-05-27 19:00:00	AMZN	Stock	4.0255	4.029	4.0255	4.029	22000.0

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

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