PREVIEW / stock_1hour / 2007-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-09.parquet
  size:    692 KB
  rows:    32,814
  symbols: 2,516

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
2007-03-09 04:00:00	AAPL	Stock	3.1561	3.1561	3.1561	3.1561	2800.0
2007-03-09 07:00:00	AAPL	Stock	3.1518	3.1518	3.1464	3.1518	176400.0
2007-03-09 08:00:00	AAPL	Stock	3.1514	3.1679	3.1446	3.1639	4572988.0
2007-03-09 09:00:00	AAPL	Stock	3.1639	3.1761	3.1346	3.14	87195304.0
2007-03-09 10:00:00	AAPL	Stock	3.1396	3.1704	3.1339	3.1496	94039652.0
2007-03-09 11:00:00	AAPL	Stock	3.1496	3.155	3.1457	3.1499	39445700.0
2007-03-09 12:00:00	AAPL	Stock	3.1504	3.1561	3.1464	3.15	29031072.0
2007-03-09 13:00:00	AAPL	Stock	3.15	3.1511	3.1321	3.1329	50606360.0
2007-03-09 14:00:00	AAPL	Stock	3.1325	3.1371	3.1214	3.1354	68640572.0
2007-03-09 15:00:00	AAPL	Stock	3.1357	3.1464	3.1307	3.1418	65944816.0
2007-03-09 16:00:00	AAPL	Stock	3.1414	3.1482	3.1414	3.1471	6228600.0
2007-03-09 17:00:00	AAPL	Stock	3.1443	3.15	3.1418	3.1418	1428756.0
2007-03-09 18:00:00	AAPL	Stock	3.1457	3.1479	3.1457	3.1464	49280.0
2007-03-09 19:00:00	AAPL	Stock	3.1464	3.1521	3.1454	3.1454	221536.0
2007-03-09 07:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	3596.0
2007-03-09 08:00:00	MSFT	Stock	27.3	27.46	27.29	27.4	47290.0
2007-03-09 09:00:00	MSFT	Stock	27.42	27.48	27.21	27.23	8713309.0
2007-03-09 10:00:00	MSFT	Stock	27.23	27.35	27.03	27.29	10940870.0
2007-03-09 11:00:00	MSFT	Stock	27.28	27.32	27.24	27.28	5362330.0
2007-03-09 12:00:00	MSFT	Stock	27.29	27.32	27.17	27.22	5322686.0
2007-03-09 13:00:00	MSFT	Stock	27.21	27.29	27.19	27.19	5411170.0
2007-03-09 14:00:00	MSFT	Stock	27.19	27.26	27.11	27.23	7641957.0
2007-03-09 15:00:00	MSFT	Stock	27.23	27.4	27.18	27.29	11814969.0
2007-03-09 16:00:00	MSFT	Stock	27.29	27.38	27.23	27.28	630058.0
2007-03-09 17:00:00	MSFT	Stock	27.28	27.28	27.28	27.28	119808.0
2007-03-09 18:00:00	MSFT	Stock	27.28	27.3	27.28	27.3	11300.0
2007-03-09 19:00:00	MSFT	Stock	27.29	27.29	27.29	27.29	3855.0
2007-03-09 08:00:00	NVDA	Stock	0.55	0.55	0.5163	0.5192	439980.0
2007-03-09 09:00:00	NVDA	Stock	0.52	0.5267	0.513	0.5138	98675400.0
2007-03-09 10:00:00	NVDA	Stock	0.514	0.5163	0.5108	0.5145	122077260.0
2007-03-09 11:00:00	NVDA	Stock	0.5145	0.5155	0.512	0.512	62962080.0
2007-03-09 12:00:00	NVDA	Stock	0.5122	0.513	0.5077	0.5092	40073460.0
2007-03-09 13:00:00	NVDA	Stock	0.509	0.5093	0.505	0.505	64848240.0
2007-03-09 14:00:00	NVDA	Stock	0.505	0.508	0.5027	0.5063	61669020.0
2007-03-09 15:00:00	NVDA	Stock	0.5063	0.5102	0.5058	0.5083	70474980.0
2007-03-09 16:00:00	NVDA	Stock	0.5083	0.509	0.508	0.5085	2600940.0
2007-03-09 17:00:00	NVDA	Stock	0.508	0.5085	0.508	0.5085	750900.0
2007-03-09 19:00:00	NVDA	Stock	0.5093	0.5097	0.5093	0.5097	150000.0
2007-03-09 08:00:00	AMZN	Stock	1.9145	1.9225	1.91	1.9225	58000.0
2007-03-09 09:00:00	AMZN	Stock	1.92	1.925	1.9025	1.913	17033600.0
2007-03-09 10:00:00	AMZN	Stock	1.913	1.916	1.9	1.9146	21133860.0
2007-03-09 11:00:00	AMZN	Stock	1.9145	1.9225	1.906	1.9095	11826420.0
2007-03-09 12:00:00	AMZN	Stock	1.909	1.9225	1.909	1.919	9777360.0
2007-03-09 13:00:00	AMZN	Stock	1.9185	1.9215	1.9125	1.917	10551920.0
2007-03-09 14:00:00	AMZN	Stock	1.917	1.9235	1.9085	1.9225	16538860.0
2007-03-09 15:00:00	AMZN	Stock	1.922	1.9445	1.9195	1.9425	34521760.0
2007-03-09 16:00:00	AMZN	Stock	1.942	1.943	1.9385	1.941	221160.0
2007-03-09 17:00:00	AMZN	Stock	1.941	1.942	1.941	1.942	191740.0
2007-03-09 18:00:00	AMZN	Stock	1.94	1.9425	1.94	1.9425	59000.0
2007-03-09 19:00:00	AMZN	Stock	1.9425	1.9425	1.9425	1.9425	10000.0

> showing 50 of 32,814 rows — these rows as CSV

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