PREVIEW / stock_1hour / 2006-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-28.parquet
  size:    606 KB
  rows:    28,556
  symbols: 2,243

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
2006-04-28 07:00:00	AAPL	Stock	2.4654	2.4654	2.4654	2.4654	14000.0
2006-04-28 08:00:00	AAPL	Stock	2.4643	2.4714	2.4193	2.4689	2557156.0
2006-04-28 09:00:00	AAPL	Stock	2.4696	2.5171	2.4571	2.5082	134210804.0
2006-04-28 10:00:00	AAPL	Stock	2.5086	2.5464	2.5079	2.5346	193264372.0
2006-04-28 11:00:00	AAPL	Stock	2.5346	2.535	2.5218	2.528	90416760.0
2006-04-28 12:00:00	AAPL	Stock	2.5279	2.53	2.5093	2.5154	73033352.0
2006-04-28 13:00:00	AAPL	Stock	2.5151	2.5271	2.515	2.5271	58355220.0
2006-04-28 14:00:00	AAPL	Stock	2.5271	2.5371	2.5204	2.5236	69385232.0
2006-04-28 15:00:00	AAPL	Stock	2.5236	2.5275	2.5139	2.5161	114876160.0
2006-04-28 16:00:00	AAPL	Stock	2.5186	2.5221	2.5139	2.5139	3291316.0
2006-04-28 17:00:00	AAPL	Stock	2.5171	2.5179	2.515	2.5157	155120.0
2006-04-28 18:00:00	AAPL	Stock	2.5157	2.5161	2.5143	2.5146	218120.0
2006-04-28 04:00:00	MSFT	Stock	25.52	25.52	25.5	25.5	1200.0
2006-04-28 06:00:00	MSFT	Stock	25.43	25.43	25.33	25.37	2600.0
2006-04-28 07:00:00	MSFT	Stock	25.37	25.37	24.84	24.9	693113.0
2006-04-28 08:00:00	MSFT	Stock	24.87	25.08	24.59	24.65	25984755.0
2006-04-28 09:00:00	MSFT	Stock	24.64	25.003	24.0	24.2	151810081.0
2006-04-28 10:00:00	MSFT	Stock	24.2	24.38	24.07	24.21	100335911.0
2006-04-28 11:00:00	MSFT	Stock	24.21	24.29	24.07	24.29	55085289.0
2006-04-28 12:00:00	MSFT	Stock	24.29	24.3	24.15	24.27	48860078.0
2006-04-28 13:00:00	MSFT	Stock	24.27	24.28	24.16	24.176	33200027.0
2006-04-28 14:00:00	MSFT	Stock	24.18	24.23	24.0	24.05	53899181.0
2006-04-28 15:00:00	MSFT	Stock	24.05	24.25	24.02	24.16	79881913.0
2006-04-28 16:00:00	MSFT	Stock	24.16	24.33	24.11	24.15	6099181.0
2006-04-28 17:00:00	MSFT	Stock	24.15	24.16	24.13	24.16	690991.0
2006-04-28 18:00:00	MSFT	Stock	24.15	24.17	24.14	24.16	29907.0
2006-04-28 08:00:00	NVDA	Stock	0.4847	0.4847	0.4812	0.4832	408000.0
2006-04-28 09:00:00	NVDA	Stock	0.4843	0.4903	0.4823	0.4875	28777800.0
2006-04-28 10:00:00	NVDA	Stock	0.4875	0.4932	0.4852	0.4858	47965320.0
2006-04-28 11:00:00	NVDA	Stock	0.4862	0.4888	0.4835	0.4852	27061320.0
2006-04-28 12:00:00	NVDA	Stock	0.4853	0.4858	0.4825	0.4843	29357700.0
2006-04-28 13:00:00	NVDA	Stock	0.4842	0.4867	0.4837	0.4857	27342540.0
2006-04-28 14:00:00	NVDA	Stock	0.4857	0.4868	0.4843	0.4852	20477040.0
2006-04-28 15:00:00	NVDA	Stock	0.4853	0.487	0.4842	0.4865	84930540.0
2006-04-28 16:00:00	NVDA	Stock	0.4867	0.4875	0.4857	0.487	2903760.0
2006-04-28 08:00:00	AMZN	Stock	1.7825	1.7825	1.778	1.778	28000.0
2006-04-28 09:00:00	AMZN	Stock	1.7875	1.7945	1.7725	1.775	6716560.0
2006-04-28 10:00:00	AMZN	Stock	1.775	1.781	1.7695	1.776	13125420.0
2006-04-28 11:00:00	AMZN	Stock	1.776	1.78	1.7685	1.7685	7121900.0
2006-04-28 12:00:00	AMZN	Stock	1.769	1.7735	1.76	1.765	9121520.0
2006-04-28 13:00:00	AMZN	Stock	1.765	1.7735	1.763	1.766	4506080.0
2006-04-28 14:00:00	AMZN	Stock	1.766	1.766	1.761	1.762	5171260.0
2006-04-28 15:00:00	AMZN	Stock	1.7615	1.7675	1.757	1.762	17987240.0
2006-04-28 16:00:00	AMZN	Stock	1.7615	1.769	1.7575	1.7605	1357620.0
2006-04-28 17:00:00	AMZN	Stock	1.761	1.761	1.761	1.761	100000.0
2006-04-28 18:00:00	AMZN	Stock	1.758	1.758	1.7575	1.7575	16000.0
2006-04-28 09:00:00	CL	Stock	29.525	29.565	29.3	29.3225	685400.0
2006-04-28 10:00:00	CL	Stock	29.32	29.59	29.3	29.505	799400.0
2006-04-28 11:00:00	CL	Stock	29.51	29.625	29.41	29.625	1288800.0
2006-04-28 12:00:00	CL	Stock	29.625	29.64	29.5	29.505	449200.0

> showing 50 of 28,556 rows — these rows as CSV

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