PREVIEW / stock_1hour / 2008-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-28.parquet
  size:    831 KB
  rows:    40,139
  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-04-28 05:00:00	AAPL	Stock	6.1018	6.1018	6.1018	6.1018	5600.0
2008-04-28 06:00:00	AAPL	Stock	6.11	6.11	6.11	6.11	2800.0
2008-04-28 07:00:00	AAPL	Stock	6.1089	6.1161	6.0893	6.1071	207984.0
2008-04-28 08:00:00	AAPL	Stock	6.1086	6.1086	6.0625	6.0861	3463208.0
2008-04-28 09:00:00	AAPL	Stock	6.0879	6.1207	6.0404	6.1036	115522204.0
2008-04-28 10:00:00	AAPL	Stock	6.1029	6.1446	6.0721	6.1386	144108468.0
2008-04-28 11:00:00	AAPL	Stock	6.1389	6.1518	6.1021	6.1271	103389580.0
2008-04-28 12:00:00	AAPL	Stock	6.1268	6.1682	6.1214	6.1554	90694212.0
2008-04-28 13:00:00	AAPL	Stock	6.1568	6.2054	6.1564	6.1932	102403476.0
2008-04-28 14:00:00	AAPL	Stock	6.1939	6.1989	6.1661	6.1804	80153388.0
2008-04-28 15:00:00	AAPL	Stock	6.1806	6.1882	6.1421	6.1518	123394152.0
2008-04-28 16:00:00	AAPL	Stock	6.1518	6.1631	6.1355	6.15	9807644.0
2008-04-28 17:00:00	AAPL	Stock	6.15	6.1518	6.1404	6.1486	1012228.0
2008-04-28 18:00:00	AAPL	Stock	6.1486	6.1486	6.1389	6.1389	300636.0
2008-04-28 19:00:00	AAPL	Stock	6.1393	6.1479	6.1364	6.1414	137396.0
2008-04-28 20:00:00	AAPL	Stock	6.1139	6.1139	6.1139	6.1139	117600.0
2008-04-28 07:00:00	MSFT	Stock	29.95	30.09	29.9	29.9	3400.0
2008-04-28 08:00:00	MSFT	Stock	29.9	29.99	29.8	29.87	81942.0
2008-04-28 09:00:00	MSFT	Stock	29.86	29.9	29.4	29.505	9589618.0
2008-04-28 10:00:00	MSFT	Stock	29.51	29.51	29.28	29.401	12676268.0
2008-04-28 11:00:00	MSFT	Stock	29.41	29.55	29.21	29.21	9089754.0
2008-04-28 12:00:00	MSFT	Stock	29.21	29.22	29.05	29.108	12395649.0
2008-04-28 13:00:00	MSFT	Stock	29.1	29.2	29.07	29.15	11835248.0
2008-04-28 14:00:00	MSFT	Stock	29.15	29.16	29.01	29.07	12832287.0
2008-04-28 15:00:00	MSFT	Stock	29.07	29.08	28.82	28.95	24638128.0
2008-04-28 16:00:00	MSFT	Stock	28.95	29.216	28.92	28.95	2446890.0
2008-04-28 17:00:00	MSFT	Stock	28.94	29.186	28.93	28.95	238791.0
2008-04-28 18:00:00	MSFT	Stock	28.95	28.96	28.93	28.94	12702.0
2008-04-28 19:00:00	MSFT	Stock	28.94	28.98	28.93	28.95	20808.0
2008-04-28 20:00:00	MSFT	Stock	28.97	28.97	28.97	28.97	200.0
2008-04-28 08:00:00	NVDA	Stock	0.5025	0.5093	0.5025	0.5062	96000.0
2008-04-28 09:00:00	NVDA	Stock	0.5062	0.509	0.4966	0.4995	56150360.0
2008-04-28 10:00:00	NVDA	Stock	0.4995	0.5022	0.4958	0.4985	73752120.0
2008-04-28 11:00:00	NVDA	Stock	0.4988	0.5	0.4928	0.4932	51134360.0
2008-04-28 12:00:00	NVDA	Stock	0.493	0.4978	0.4928	0.4975	77197600.0
2008-04-28 13:00:00	NVDA	Stock	0.4975	0.4995	0.4963	0.4988	42840840.0
2008-04-28 14:00:00	NVDA	Stock	0.4988	0.5	0.495	0.4963	68525920.0
2008-04-28 15:00:00	NVDA	Stock	0.496	0.4972	0.4938	0.4948	139777800.0
2008-04-28 16:00:00	NVDA	Stock	0.4948	0.4997	0.4948	0.4948	23521000.0
2008-04-28 17:00:00	NVDA	Stock	0.4968	0.4968	0.4928	0.4952	224000.0
2008-04-28 18:00:00	NVDA	Stock	0.496	0.496	0.496	0.496	9800.0
2008-04-28 19:00:00	NVDA	Stock	0.4955	0.4955	0.4955	0.4955	4000.0
2008-04-28 20:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	104000.0
2008-04-28 08:00:00	AMZN	Stock	4.045	4.0495	4.044	4.0495	39380.0
2008-04-28 09:00:00	AMZN	Stock	4.049	4.125	4.006	4.105	29179860.0
2008-04-28 10:00:00	AMZN	Stock	4.105	4.107	4.07	4.085	29295620.0
2008-04-28 11:00:00	AMZN	Stock	4.086	4.094	4.0455	4.0785	27143220.0
2008-04-28 12:00:00	AMZN	Stock	4.077	4.096	4.0725	4.077	18386920.0
2008-04-28 13:00:00	AMZN	Stock	4.077	4.1245	4.0735	4.122	23347380.0
2008-04-28 14:00:00	AMZN	Stock	4.1225	4.124	4.0915	4.1	31180620.0

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

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