PREVIEW / stock_1hour / 2010-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-10.parquet
  size:    937 KB
  rows:    45,399
  symbols: 3,534

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
2010-12-10 05:00:00	AAPL	Stock	11.4786	11.4786	11.4786	11.4786	2800.0
2010-12-10 06:00:00	AAPL	Stock	11.4779	11.4779	11.42	11.42	19600.0
2010-12-10 07:00:00	AAPL	Stock	11.4411	11.4536	11.4286	11.4464	145600.0
2010-12-10 08:00:00	AAPL	Stock	11.4464	11.4518	11.4061	11.4071	1383872.0
2010-12-10 09:00:00	AAPL	Stock	11.4071	11.45	11.3846	11.3957	39128292.0
2010-12-10 10:00:00	AAPL	Stock	11.3957	11.4357	11.3786	11.425	43496964.0
2010-12-10 11:00:00	AAPL	Stock	11.4243	11.4411	11.4157	11.4332	22003856.0
2010-12-10 12:00:00	AAPL	Stock	11.4329	11.4482	11.4246	11.4346	21779464.0
2010-12-10 13:00:00	AAPL	Stock	11.4343	11.4661	11.4307	11.4632	30544024.0
2010-12-10 14:00:00	AAPL	Stock	11.4621	11.4632	11.4382	11.4448	29080688.0
2010-12-10 15:00:00	AAPL	Stock	11.4457	11.4518	11.43	11.45	58748312.0
2010-12-10 16:00:00	AAPL	Stock	11.4482	11.4514	11.4069	11.4339	9280600.0
2010-12-10 17:00:00	AAPL	Stock	11.4339	11.4414	11.4339	11.4411	157584.0
2010-12-10 18:00:00	AAPL	Stock	11.4393	11.4486	11.4375	11.4386	121240.0
2010-12-10 19:00:00	AAPL	Stock	11.4457	11.4457	11.4382	11.4421	56252.0
2010-12-10 04:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	100.0
2010-12-10 07:00:00	MSFT	Stock	27.08	27.1	27.0	27.0	13700.0
2010-12-10 08:00:00	MSFT	Stock	27.05	27.14	27.01	27.08	19683.0
2010-12-10 09:00:00	MSFT	Stock	27.06	27.25	27.06	27.2	4362445.0
2010-12-10 10:00:00	MSFT	Stock	27.205	27.29	27.198	27.225	5573658.0
2010-12-10 11:00:00	MSFT	Stock	27.225	27.38	27.21	27.38	4246868.0
2010-12-10 12:00:00	MSFT	Stock	27.38	27.4	27.33	27.36	3405665.0
2010-12-10 13:00:00	MSFT	Stock	27.355	27.37	27.31	27.36	2957490.0
2010-12-10 14:00:00	MSFT	Stock	27.36	27.38	27.33	27.38	2556902.0
2010-12-10 15:00:00	MSFT	Stock	27.372	27.4	27.32	27.34	10688031.0
2010-12-10 16:00:00	MSFT	Stock	27.34	27.44	27.1	27.34	2445779.0
2010-12-10 17:00:00	MSFT	Stock	27.42	27.42	27.39	27.42	4100.0
2010-12-10 18:00:00	MSFT	Stock	27.4	27.4	27.24	27.24	22405.0
2010-12-10 19:00:00	MSFT	Stock	27.39	27.39	27.38	27.38	1300.0
2010-12-10 08:00:00	NVDA	Stock	0.3715	0.3715	0.3715	0.3715	4000.0
2010-12-10 09:00:00	NVDA	Stock	0.3703	0.3773	0.3703	0.376	85039600.0
2010-12-10 10:00:00	NVDA	Stock	0.3763	0.3768	0.3738	0.3758	80568000.0
2010-12-10 11:00:00	NVDA	Stock	0.376	0.3767	0.3705	0.3722	60161760.0
2010-12-10 12:00:00	NVDA	Stock	0.3723	0.3758	0.3721	0.375	43870040.0
2010-12-10 13:00:00	NVDA	Stock	0.375	0.3753	0.374	0.3745	34288240.0
2010-12-10 14:00:00	NVDA	Stock	0.3744	0.375	0.374	0.375	26774080.0
2010-12-10 15:00:00	NVDA	Stock	0.375	0.3753	0.3728	0.3738	103995120.0
2010-12-10 16:00:00	NVDA	Stock	0.3738	0.3748	0.3735	0.3738	16449760.0
2010-12-10 18:00:00	NVDA	Stock	0.3748	0.3748	0.3748	0.3748	4440.0
2010-12-10 06:00:00	AMZN	Stock	8.775	8.775	8.775	8.775	2000.0
2010-12-10 07:00:00	AMZN	Stock	8.7995	8.7995	8.7995	8.7995	2000.0
2010-12-10 08:00:00	AMZN	Stock	8.75	8.7625	8.744	8.755	133160.0
2010-12-10 09:00:00	AMZN	Stock	8.745	8.784	8.6825	8.694	11321360.0
2010-12-10 10:00:00	AMZN	Stock	8.692	8.7595	8.668	8.748	13111120.0
2010-12-10 11:00:00	AMZN	Stock	8.7475	8.7725	8.737	8.7714	7204120.0
2010-12-10 12:00:00	AMZN	Stock	8.7665	8.7765	8.7465	8.763	5386260.0
2010-12-10 13:00:00	AMZN	Stock	8.7615	8.785	8.751	8.785	6169100.0
2010-12-10 14:00:00	AMZN	Stock	8.7846	8.789	8.757	8.782	8105900.0
2010-12-10 15:00:00	AMZN	Stock	8.7825	8.7975	8.764	8.7805	15656960.0
2010-12-10 16:00:00	AMZN	Stock	8.781	8.8025	8.7495	8.781	1091300.0

> showing 50 of 45,399 rows — these rows as CSV

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