PREVIEW / stock_1hour / 2007-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-16.parquet
  size:    806 KB
  rows:    40,002
  symbols: 3,148

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-10-16 05:00:00	AAPL	Stock	5.9007	5.9007	5.9007	5.9007	5600.0
2007-10-16 06:00:00	AAPL	Stock	5.9357	5.9357	5.8882	5.8886	14000.0
2007-10-16 07:00:00	AAPL	Stock	5.8925	5.9096	5.8732	5.9061	541100.0
2007-10-16 08:00:00	AAPL	Stock	5.9096	5.9246	5.8857	5.9171	6041616.0
2007-10-16 09:00:00	AAPL	Stock	5.9164	5.9764	5.8989	5.9746	130411456.0
2007-10-16 10:00:00	AAPL	Stock	5.9743	6.01	5.9543	5.9979	198912728.0
2007-10-16 11:00:00	AAPL	Stock	5.9986	6.0696	5.9936	6.0389	168520968.0
2007-10-16 12:00:00	AAPL	Stock	6.0389	6.0607	6.0214	6.0456	113362788.0
2007-10-16 13:00:00	AAPL	Stock	6.0456	6.0625	6.0121	6.0566	108123512.0
2007-10-16 14:00:00	AAPL	Stock	6.0568	6.0779	6.0446	6.0586	151940040.0
2007-10-16 15:00:00	AAPL	Stock	6.0586	6.0688	6.0296	6.0564	156719052.0
2007-10-16 16:00:00	AAPL	Stock	6.0607	6.1314	6.0152	6.1221	26947172.0
2007-10-16 17:00:00	AAPL	Stock	6.115	6.1304	6.0196	6.1279	3712632.0
2007-10-16 18:00:00	AAPL	Stock	6.125	6.1389	6.0564	6.1389	4006716.0
2007-10-16 19:00:00	AAPL	Stock	6.1393	6.1393	6.1275	6.1346	618156.0
2007-10-16 05:00:00	MSFT	Stock	30.05	30.15	30.05	30.15	2000.0
2007-10-16 07:00:00	MSFT	Stock	30.17	30.17	30.11	30.15	9400.0
2007-10-16 08:00:00	MSFT	Stock	30.11	30.22	30.1	30.2	88013.0
2007-10-16 09:00:00	MSFT	Stock	30.2	30.54	30.16	30.51	9260922.0
2007-10-16 10:00:00	MSFT	Stock	30.52	30.58	30.3	30.38	9722561.0
2007-10-16 11:00:00	MSFT	Stock	30.39	30.5	30.3	30.472	5170779.0
2007-10-16 12:00:00	MSFT	Stock	30.47	30.5	30.36	30.38	4480688.0
2007-10-16 13:00:00	MSFT	Stock	30.38	30.47	30.3	30.438	4813275.0
2007-10-16 14:00:00	MSFT	Stock	30.45	30.47	30.35	30.38	4826147.0
2007-10-16 15:00:00	MSFT	Stock	30.39	30.47	30.3	30.31	11580045.0
2007-10-16 16:00:00	MSFT	Stock	30.31	30.59	30.29	30.59	5889337.0
2007-10-16 17:00:00	MSFT	Stock	30.59	30.75	30.59	30.69	139024.0
2007-10-16 18:00:00	MSFT	Stock	30.69	30.75	30.31	30.45	287824.0
2007-10-16 19:00:00	MSFT	Stock	30.69	30.69	30.6	30.6	16157.0
2007-10-16 08:00:00	NVDA	Stock	0.9075	0.9155	0.9025	0.9025	128000.0
2007-10-16 09:00:00	NVDA	Stock	0.9	0.9342	0.8975	0.9245	37145360.0
2007-10-16 10:00:00	NVDA	Stock	0.9248	0.925	0.9152	0.9185	45288600.0
2007-10-16 11:00:00	NVDA	Stock	0.9185	0.924	0.9155	0.9238	28843440.0
2007-10-16 12:00:00	NVDA	Stock	0.9235	0.9238	0.9158	0.9213	23448160.0
2007-10-16 13:00:00	NVDA	Stock	0.921	0.9238	0.916	0.9231	28210600.0
2007-10-16 14:00:00	NVDA	Stock	0.9231	0.9238	0.9178	0.9203	30856520.0
2007-10-16 15:00:00	NVDA	Stock	0.9203	0.922	0.918	0.918	61765800.0
2007-10-16 16:00:00	NVDA	Stock	0.918	0.9352	0.918	0.918	16488520.0
2007-10-16 17:00:00	NVDA	Stock	0.934	0.9365	0.93	0.93	348040.0
2007-10-16 18:00:00	NVDA	Stock	0.9208	0.9363	0.9075	0.9242	3938280.0
2007-10-16 19:00:00	NVDA	Stock	0.9338	0.9363	0.9338	0.9363	167960.0
2007-10-16 08:00:00	AMZN	Stock	4.5	4.5	4.419	4.4395	1003080.0
2007-10-16 09:00:00	AMZN	Stock	4.4435	4.5	4.4215	4.4905	28801440.0
2007-10-16 10:00:00	AMZN	Stock	4.4915	4.4915	4.441	4.477	21279320.0
2007-10-16 11:00:00	AMZN	Stock	4.4765	4.5025	4.4515	4.477	18228820.0
2007-10-16 12:00:00	AMZN	Stock	4.4775	4.499	4.4645	4.479	17334260.0
2007-10-16 13:00:00	AMZN	Stock	4.4785	4.485	4.458	4.4665	13979100.0
2007-10-16 14:00:00	AMZN	Stock	4.4675	4.487	4.461	4.466	17667620.0
2007-10-16 15:00:00	AMZN	Stock	4.4655	4.4835	4.455	4.476	34795060.0
2007-10-16 16:00:00	AMZN	Stock	4.476	4.5375	4.4702	4.4765	9099160.0

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

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