PREVIEW / stock_1hour / 2008-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-27.parquet
  size:    794 KB
  rows:    39,452
  symbols: 3,275

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-03-27 06:00:00	AAPL	Stock	5.1775	5.1786	5.1375	5.1489	163576.0
2008-03-27 07:00:00	AAPL	Stock	5.1489	5.1714	5.1482	5.1507	615076.0
2008-03-27 08:00:00	AAPL	Stock	5.15	5.1786	5.125	5.1732	3595060.0
2008-03-27 09:00:00	AAPL	Stock	5.1736	5.1896	5.125	5.1736	129472084.0
2008-03-27 10:00:00	AAPL	Stock	5.1736	5.1875	5.0943	5.1189	190895236.0
2008-03-27 11:00:00	AAPL	Stock	5.1186	5.1496	5.0921	5.1368	116467960.0
2008-03-27 12:00:00	AAPL	Stock	5.1368	5.1493	5.0896	5.0929	104389768.0
2008-03-27 13:00:00	AAPL	Stock	5.0936	5.11	5.0407	5.0639	129845800.0
2008-03-27 14:00:00	AAPL	Stock	5.0639	5.0818	5.0482	5.0618	125023220.0
2008-03-27 15:00:00	AAPL	Stock	5.0629	5.0682	4.9996	5.0104	174752284.0
2008-03-27 16:00:00	AAPL	Stock	5.0086	5.0987	5.0086	5.0114	10263820.0
2008-03-27 17:00:00	AAPL	Stock	5.0168	5.0321	5.0107	5.0304	1443820.0
2008-03-27 18:00:00	AAPL	Stock	5.0304	5.0304	5.0089	5.0264	2267972.0
2008-03-27 19:00:00	AAPL	Stock	5.0268	5.0268	5.0214	5.0243	112476.0
2008-03-27 07:00:00	MSFT	Stock	28.46	28.46	28.32	28.32	1900.0
2008-03-27 08:00:00	MSFT	Stock	28.41	28.5	28.33	28.45	31420.0
2008-03-27 09:00:00	MSFT	Stock	28.5	28.5	28.2	28.26	3924511.0
2008-03-27 10:00:00	MSFT	Stock	28.26	28.273	28.0	28.148	9261676.0
2008-03-27 11:00:00	MSFT	Stock	28.14	28.26	28.04	28.22	4590784.0
2008-03-27 12:00:00	MSFT	Stock	28.22	28.35	28.18	28.29	3638300.0
2008-03-27 13:00:00	MSFT	Stock	28.29	28.3	28.12	28.2	3862263.0
2008-03-27 14:00:00	MSFT	Stock	28.19	28.28	28.1	28.19	4295824.0
2008-03-27 15:00:00	MSFT	Stock	28.2	28.27	28.02	28.05	8702594.0
2008-03-27 16:00:00	MSFT	Stock	28.05	28.57	28.04	28.12	7562727.0
2008-03-27 17:00:00	MSFT	Stock	28.12	28.12	28.1	28.1	6150.0
2008-03-27 18:00:00	MSFT	Stock	28.1	28.13	28.05	28.1	194698.0
2008-03-27 19:00:00	MSFT	Stock	28.1	28.23	28.06	28.14	10750.0
2008-03-27 08:00:00	NVDA	Stock	0.4878	0.4925	0.4878	0.4925	152000.0
2008-03-27 09:00:00	NVDA	Stock	0.492	0.4932	0.4768	0.4878	108824000.0
2008-03-27 10:00:00	NVDA	Stock	0.488	0.493	0.4848	0.4892	134959000.0
2008-03-27 11:00:00	NVDA	Stock	0.4895	0.4952	0.4875	0.4935	50733560.0
2008-03-27 12:00:00	NVDA	Stock	0.4935	0.498	0.4912	0.4935	47842560.0
2008-03-27 13:00:00	NVDA	Stock	0.4932	0.4935	0.4875	0.4885	43803560.0
2008-03-27 14:00:00	NVDA	Stock	0.4883	0.4908	0.4852	0.4878	62097360.0
2008-03-27 15:00:00	NVDA	Stock	0.4878	0.4898	0.4848	0.4848	131341680.0
2008-03-27 16:00:00	NVDA	Stock	0.4848	0.488	0.4848	0.4852	5068200.0
2008-03-27 17:00:00	NVDA	Stock	0.4878	0.4925	0.4875	0.4888	6246800.0
2008-03-27 18:00:00	NVDA	Stock	0.4875	0.4878	0.4875	0.4875	66000.0
2008-03-27 08:00:00	AMZN	Stock	3.706	3.706	3.7025	3.7025	12000.0
2008-03-27 09:00:00	AMZN	Stock	3.712	3.7345	3.6625	3.6935	15471040.0
2008-03-27 10:00:00	AMZN	Stock	3.6935	3.697	3.5915	3.6185	32101980.0
2008-03-27 11:00:00	AMZN	Stock	3.619	3.637	3.6	3.611	19359660.0
2008-03-27 12:00:00	AMZN	Stock	3.611	3.657	3.601	3.61	17431040.0
2008-03-27 13:00:00	AMZN	Stock	3.6095	3.632	3.585	3.592	12788340.0
2008-03-27 14:00:00	AMZN	Stock	3.5915	3.594	3.554	3.5785	25485240.0
2008-03-27 15:00:00	AMZN	Stock	3.579	3.59	3.54	3.54	32025180.0
2008-03-27 16:00:00	AMZN	Stock	3.54	3.6122	3.54	3.5705	841000.0
2008-03-27 17:00:00	AMZN	Stock	3.552	3.5545	3.552	3.5545	28000.0
2008-03-27 19:00:00	AMZN	Stock	3.552	3.5595	3.546	3.5595	14420.0
2008-03-27 08:00:00	TLT	Stock	94.8	94.8	94.47	94.5	7500.0

> showing 50 of 39,452 rows — these rows as CSV

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