PREVIEW / stock_1hour / 2008-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-05.parquet
  size:    835 KB
  rows:    42,342
  symbols: 3,249

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-05 05:00:00	AAPL	Stock	4.4639	4.4639	4.4639	4.4639	5600.0
2008-03-05 06:00:00	AAPL	Stock	4.4643	4.4821	4.4643	4.4821	142800.0
2008-03-05 07:00:00	AAPL	Stock	4.4925	4.5129	4.4714	4.4957	3151344.0
2008-03-05 08:00:00	AAPL	Stock	4.4893	4.4964	4.4329	4.4511	11506712.0
2008-03-05 09:00:00	AAPL	Stock	4.4511	4.4518	4.3661	4.3839	182057848.0
2008-03-05 10:00:00	AAPL	Stock	4.3836	4.4404	4.3789	4.4068	257122992.0
2008-03-05 11:00:00	AAPL	Stock	4.4064	4.4621	4.4039	4.4368	148229564.0
2008-03-05 12:00:00	AAPL	Stock	4.4364	4.7857	4.4143	4.4493	152022248.0
2008-03-05 13:00:00	AAPL	Stock	4.4489	4.4582	4.3929	4.405	153528900.0
2008-03-05 14:00:00	AAPL	Stock	4.4054	4.435	4.3771	4.4261	137823336.0
2008-03-05 15:00:00	AAPL	Stock	4.4254	4.4486	4.4086	4.4479	149755508.0
2008-03-05 16:00:00	AAPL	Stock	4.4464	4.4486	4.4121	4.4371	15310232.0
2008-03-05 17:00:00	AAPL	Stock	4.4379	4.4964	4.4218	4.4921	8729112.0
2008-03-05 18:00:00	AAPL	Stock	4.4907	4.4925	4.4209	4.4821	2092692.0
2008-03-05 19:00:00	AAPL	Stock	4.4775	4.4811	4.4682	4.4704	372232.0
2008-03-05 04:00:00	MSFT	Stock	27.55	27.55	27.55	27.55	100.0
2008-03-05 06:00:00	MSFT	Stock	27.48	27.48	27.48	27.48	600.0
2008-03-05 07:00:00	MSFT	Stock	27.65	27.8	27.65	27.75	18454.0
2008-03-05 08:00:00	MSFT	Stock	27.75	27.79	27.6	27.63	41606.0
2008-03-05 09:00:00	MSFT	Stock	27.62	27.9	27.6	27.859	8300356.0
2008-03-05 10:00:00	MSFT	Stock	27.85	28.41	27.85	28.3	23143234.0
2008-03-05 11:00:00	MSFT	Stock	28.3	28.34	28.18	28.2	10469266.0
2008-03-05 12:00:00	MSFT	Stock	28.2	28.38	28.2	28.32	15354299.0
2008-03-05 13:00:00	MSFT	Stock	28.33	28.34	27.89	28.02	14080598.0
2008-03-05 14:00:00	MSFT	Stock	28.02	28.24	27.96	28.12	12883676.0
2008-03-05 15:00:00	MSFT	Stock	28.12	28.13	27.98	28.13	16376424.0
2008-03-05 16:00:00	MSFT	Stock	28.14	28.18	28.04	28.12	5072547.0
2008-03-05 17:00:00	MSFT	Stock	28.12	28.17	28.032	28.1	731578.0
2008-03-05 18:00:00	MSFT	Stock	28.16	28.16	28.03	28.16	6663.0
2008-03-05 19:00:00	MSFT	Stock	28.15	28.22	28.15	28.18	12250.0
2008-03-05 08:00:00	NVDA	Stock	0.5245	0.5472	0.5245	0.5472	148000.0
2008-03-05 09:00:00	NVDA	Stock	0.5345	0.5388	0.5255	0.5374	46066440.0
2008-03-05 10:00:00	NVDA	Stock	0.5372	0.5418	0.5367	0.5372	123070360.0
2008-03-05 11:00:00	NVDA	Stock	0.5374	0.5385	0.535	0.5355	60566480.0
2008-03-05 12:00:00	NVDA	Stock	0.5358	0.54	0.5352	0.5378	74933280.0
2008-03-05 13:00:00	NVDA	Stock	0.5378	0.539	0.5242	0.526	95751040.0
2008-03-05 14:00:00	NVDA	Stock	0.526	0.5325	0.5228	0.5293	93197000.0
2008-03-05 15:00:00	NVDA	Stock	0.529	0.53	0.524	0.5293	119884960.0
2008-03-05 16:00:00	NVDA	Stock	0.5287	0.5328	0.5275	0.53	12184800.0
2008-03-05 17:00:00	NVDA	Stock	0.529	0.5293	0.528	0.5282	473440.0
2008-03-05 18:00:00	NVDA	Stock	0.5282	0.5293	0.528	0.5293	240000.0
2008-03-05 19:00:00	NVDA	Stock	0.5293	0.5293	0.5293	0.5293	84000.0
2008-03-05 08:00:00	AMZN	Stock	3.27	3.279	3.2245	3.265	279580.0
2008-03-05 09:00:00	AMZN	Stock	3.265	3.29	3.21	3.256	35296680.0
2008-03-05 10:00:00	AMZN	Stock	3.2565	3.317	3.2445	3.277	45575680.0
2008-03-05 11:00:00	AMZN	Stock	3.277	3.28	3.236	3.2535	21389380.0
2008-03-05 12:00:00	AMZN	Stock	3.2525	3.288	3.2325	3.2455	29699080.0
2008-03-05 13:00:00	AMZN	Stock	3.2445	3.2585	3.191	3.2195	33313320.0
2008-03-05 14:00:00	AMZN	Stock	3.219	3.2665	3.2085	3.262	24770820.0
2008-03-05 15:00:00	AMZN	Stock	3.261	3.2615	3.2375	3.2505	26270760.0

> showing 50 of 42,342 rows — these rows as CSV

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