PREVIEW / stock_1hour / 2006-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-12.parquet
  size:    626 KB
  rows:    29,768
  symbols: 2,263

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-05-12 05:00:00	AAPL	Stock	2.4304	2.4304	2.4268	2.4268	186200.0
2006-05-12 07:00:00	AAPL	Stock	2.4289	2.4289	2.4236	2.425	19600.0
2006-05-12 08:00:00	AAPL	Stock	2.4182	2.4304	2.4182	2.4257	1355928.0
2006-05-12 09:00:00	AAPL	Stock	2.4257	2.4321	2.3879	2.4293	114566676.0
2006-05-12 10:00:00	AAPL	Stock	2.4296	2.4411	2.4	2.4111	115223612.0
2006-05-12 11:00:00	AAPL	Stock	2.4104	2.4304	2.4086	2.4246	72588236.0
2006-05-12 12:00:00	AAPL	Stock	2.4239	2.4375	2.4068	2.411	70574448.0
2006-05-12 13:00:00	AAPL	Stock	2.4107	2.4225	2.4032	2.4154	40296256.0
2006-05-12 14:00:00	AAPL	Stock	2.4154	2.4532	2.4146	2.4321	111617380.0
2006-05-12 15:00:00	AAPL	Stock	2.4321	2.4446	2.4125	2.4179	102572848.0
2006-05-12 16:00:00	AAPL	Stock	2.4179	2.4239	2.4143	2.4207	1551200.0
2006-05-12 17:00:00	AAPL	Stock	2.4207	2.4232	2.4204	2.4232	125300.0
2006-05-12 18:00:00	AAPL	Stock	2.4225	2.4225	2.4178	2.4214	177576.0
2006-05-12 07:00:00	MSFT	Stock	23.2	23.2	23.15	23.15	1100.0
2006-05-12 08:00:00	MSFT	Stock	23.17	23.22	23.15	23.19	114081.0
2006-05-12 09:00:00	MSFT	Stock	23.2	23.22	23.05	23.2	11476295.0
2006-05-12 10:00:00	MSFT	Stock	23.2	23.37	23.1	23.28	19664782.0
2006-05-12 11:00:00	MSFT	Stock	23.28	23.35	23.19	23.23	11895594.0
2006-05-12 12:00:00	MSFT	Stock	23.23	23.31	23.15	23.192	8476757.0
2006-05-12 13:00:00	MSFT	Stock	23.19	23.22	23.16	23.19	6867735.0
2006-05-12 14:00:00	MSFT	Stock	23.19	23.26	23.15	23.18	8054076.0
2006-05-12 15:00:00	MSFT	Stock	23.18	23.25	23.14	23.17	13633190.0
2006-05-12 16:00:00	MSFT	Stock	23.19	23.21	23.15	23.21	655237.0
2006-05-12 17:00:00	MSFT	Stock	23.2	23.25	23.2	23.23	38430.0
2006-05-12 18:00:00	MSFT	Stock	23.24	23.25	23.156	23.23	20220.0
2006-05-12 07:00:00	NVDA	Stock	0.475	0.4782	0.475	0.4782	658740.0
2006-05-12 08:00:00	NVDA	Stock	0.4765	0.4765	0.4558	0.46	18321780.0
2006-05-12 09:00:00	NVDA	Stock	0.4603	0.4683	0.452	0.4607	309844680.0
2006-05-12 10:00:00	NVDA	Stock	0.4607	0.4617	0.4453	0.4462	286598100.0
2006-05-12 11:00:00	NVDA	Stock	0.4462	0.463	0.4368	0.444	219695760.0
2006-05-12 12:00:00	NVDA	Stock	0.444	0.4485	0.4398	0.4437	115970760.0
2006-05-12 13:00:00	NVDA	Stock	0.4433	0.445	0.4395	0.4407	76903080.0
2006-05-12 14:00:00	NVDA	Stock	0.4407	0.4413	0.4335	0.4347	167035920.0
2006-05-12 15:00:00	NVDA	Stock	0.4347	0.4435	0.429	0.4383	333557400.0
2006-05-12 16:00:00	NVDA	Stock	0.4397	0.4418	0.4388	0.4413	2454840.0
2006-05-12 17:00:00	NVDA	Stock	0.4392	0.4415	0.4392	0.4398	100500.0
2006-05-12 18:00:00	NVDA	Stock	0.4391	0.4412	0.4391	0.4412	54000.0
2006-05-12 08:00:00	AMZN	Stock	1.687	1.687	1.6625	1.676	48060.0
2006-05-12 09:00:00	AMZN	Stock	1.6785	1.689	1.6705	1.6825	15512140.0
2006-05-12 10:00:00	AMZN	Stock	1.6825	1.689	1.658	1.6655	19670620.0
2006-05-12 11:00:00	AMZN	Stock	1.665	1.6695	1.654	1.657	9842400.0
2006-05-12 12:00:00	AMZN	Stock	1.6565	1.661	1.6495	1.6535	7715560.0
2006-05-12 13:00:00	AMZN	Stock	1.6535	1.654	1.639	1.639	11653060.0
2006-05-12 14:00:00	AMZN	Stock	1.639	1.65	1.63	1.632	11578340.0
2006-05-12 15:00:00	AMZN	Stock	1.632	1.6415	1.6275	1.6375	18531500.0
2006-05-12 16:00:00	AMZN	Stock	1.6365	1.6375	1.635	1.635	80820.0
2006-05-12 18:00:00	AMZN	Stock	1.635	1.6375	1.635	1.6375	37340.0
2006-05-12 09:00:00	CL	Stock	29.565	29.72	29.51	29.715	331000.0
2006-05-12 10:00:00	CL	Stock	29.715	29.75	29.575	29.745	1070800.0
2006-05-12 11:00:00	CL	Stock	29.735	29.79	29.67	29.73	838800.0

> showing 50 of 29,768 rows — these rows as CSV

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