PREVIEW / stock_1hour / 2008-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-31.parquet
  size:    823 KB
  rows:    40,990
  symbols: 3,283

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-31 05:00:00	AAPL	Stock	5.0993	5.0993	5.0864	5.0864	5600.0
2008-03-31 06:00:00	AAPL	Stock	5.0929	5.1046	5.0929	5.1046	5600.0
2008-03-31 07:00:00	AAPL	Stock	5.1125	5.1375	5.1125	5.1375	241780.0
2008-03-31 08:00:00	AAPL	Stock	5.1361	5.1429	5.105	5.1214	2563148.0
2008-03-31 09:00:00	AAPL	Stock	5.1143	5.2039	5.1125	5.1761	115621800.0
2008-03-31 10:00:00	AAPL	Stock	5.1761	5.1786	5.1346	5.1629	136592904.0
2008-03-31 11:00:00	AAPL	Stock	5.1632	5.1664	5.1336	5.1336	80085768.0
2008-03-31 12:00:00	AAPL	Stock	5.1336	5.139	5.09	5.1329	95537316.0
2008-03-31 13:00:00	AAPL	Stock	5.1329	5.1725	5.1311	5.1364	95540872.0
2008-03-31 14:00:00	AAPL	Stock	5.1371	5.1496	5.1107	5.1271	89016004.0
2008-03-31 15:00:00	AAPL	Stock	5.1268	5.1461	5.1125	5.125	117450424.0
2008-03-31 16:00:00	AAPL	Stock	5.125	5.1442	5.12	5.1321	20236608.0
2008-03-31 17:00:00	AAPL	Stock	5.1318	5.1537	5.125	5.1361	832048.0
2008-03-31 18:00:00	AAPL	Stock	5.1361	5.1375	5.1339	5.1357	151928.0
2008-03-31 19:00:00	AAPL	Stock	5.1332	5.1389	5.1325	5.1389	192108.0
2008-03-31 08:00:00	MSFT	Stock	28.0	28.08	27.94	27.94	8275.0
2008-03-31 09:00:00	MSFT	Stock	28.28	28.36	27.79	28.29	5745393.0
2008-03-31 10:00:00	MSFT	Stock	28.285	28.285	28.07	28.24	4704276.0
2008-03-31 11:00:00	MSFT	Stock	28.24	28.38	28.14	28.365	4586867.0
2008-03-31 12:00:00	MSFT	Stock	28.37	28.47	28.35	28.42	2960670.0
2008-03-31 13:00:00	MSFT	Stock	28.41	28.56	28.4	28.5	4659728.0
2008-03-31 14:00:00	MSFT	Stock	28.5	28.59	28.36	28.44	4477286.0
2008-03-31 15:00:00	MSFT	Stock	28.43	28.45	28.25	28.38	11526037.0
2008-03-31 16:00:00	MSFT	Stock	28.33	28.428	28.16	28.22	4716266.0
2008-03-31 17:00:00	MSFT	Stock	28.23	28.443	28.22	28.24	210638.0
2008-03-31 18:00:00	MSFT	Stock	28.24	28.25	28.23	28.24	12580.0
2008-03-31 19:00:00	MSFT	Stock	28.24	28.26	28.23	28.25	5687.0
2008-03-31 08:00:00	NVDA	Stock	0.4972	0.4972	0.4902	0.4902	63200.0
2008-03-31 09:00:00	NVDA	Stock	0.495	0.5065	0.4925	0.505	50337480.0
2008-03-31 10:00:00	NVDA	Stock	0.5053	0.5058	0.4885	0.4928	95650680.0
2008-03-31 11:00:00	NVDA	Stock	0.4928	0.4978	0.4898	0.4955	64533840.0
2008-03-31 12:00:00	NVDA	Stock	0.4958	0.4975	0.4923	0.4975	40021720.0
2008-03-31 13:00:00	NVDA	Stock	0.4972	0.4995	0.496	0.4965	44184480.0
2008-03-31 14:00:00	NVDA	Stock	0.4965	0.4965	0.493	0.496	57511320.0
2008-03-31 15:00:00	NVDA	Stock	0.4958	0.4978	0.4932	0.495	161311760.0
2008-03-31 16:00:00	NVDA	Stock	0.4948	0.4975	0.4938	0.4975	15839440.0
2008-03-31 17:00:00	NVDA	Stock	0.4947	0.498	0.4906	0.4906	3160800.0
2008-03-31 18:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	4800.0
2008-03-31 19:00:00	NVDA	Stock	0.4965	0.4965	0.4965	0.4965	20000.0
2008-03-31 08:00:00	AMZN	Stock	3.5	3.5	3.5	3.5	2000.0
2008-03-31 09:00:00	AMZN	Stock	3.4925	3.5705	3.4885	3.545	14400660.0
2008-03-31 10:00:00	AMZN	Stock	3.5465	3.5495	3.4815	3.498	18674620.0
2008-03-31 11:00:00	AMZN	Stock	3.4975	3.5425	3.4835	3.5235	13900380.0
2008-03-31 12:00:00	AMZN	Stock	3.523	3.5435	3.5	3.539	7511560.0
2008-03-31 13:00:00	AMZN	Stock	3.539	3.582	3.5325	3.5665	12135140.0
2008-03-31 14:00:00	AMZN	Stock	3.5665	3.5665	3.533	3.546	11238900.0
2008-03-31 15:00:00	AMZN	Stock	3.545	3.58	3.5415	3.565	25304480.0
2008-03-31 16:00:00	AMZN	Stock	3.565	3.5652	3.5372	3.56	4458480.0
2008-03-31 17:00:00	AMZN	Stock	3.565	3.565	3.55	3.55	17980.0
2008-03-31 18:00:00	AMZN	Stock	3.55	3.55	3.55	3.55	20000.0

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

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