PREVIEW / stock_1hour / 2006-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-02.parquet
  size:    605 KB
  rows:    29,231
  symbols: 2,325

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-08-02 07:00:00	AAPL	Stock	2.425	2.4446	2.4139	2.4139	23800.0
2006-08-02 08:00:00	AAPL	Stock	2.4139	2.4268	2.4089	2.4161	2634044.0
2006-08-02 09:00:00	AAPL	Stock	2.4143	2.4354	2.4111	2.4264	73446268.0
2006-08-02 10:00:00	AAPL	Stock	2.4264	2.4332	2.4211	2.4282	85713432.0
2006-08-02 11:00:00	AAPL	Stock	2.4279	2.4429	2.4268	2.4421	84670712.0
2006-08-02 12:00:00	AAPL	Stock	2.4418	2.4529	2.44	2.4443	79119040.0
2006-08-02 13:00:00	AAPL	Stock	2.4443	2.4457	2.4332	2.4411	50781416.0
2006-08-02 14:00:00	AAPL	Stock	2.4411	2.45	2.4225	2.4329	77921956.0
2006-08-02 15:00:00	AAPL	Stock	2.4325	2.4371	2.4239	2.4304	78466416.0
2006-08-02 16:00:00	AAPL	Stock	2.4304	2.4375	2.4289	2.4339	2627184.0
2006-08-02 17:00:00	AAPL	Stock	2.4343	2.4357	2.4343	2.4343	3637844.0
2006-08-02 18:00:00	AAPL	Stock	2.4343	2.4368	2.4343	2.4368	164080.0
2006-08-02 08:00:00	MSFT	Stock	23.99	24.17	23.99	24.07	77900.0
2006-08-02 09:00:00	MSFT	Stock	24.11	24.17	24.07	24.15	3394433.0
2006-08-02 10:00:00	MSFT	Stock	24.15	24.19	24.03	24.04	5339797.0
2006-08-02 11:00:00	MSFT	Stock	24.04	24.24	24.04	24.21	7156270.0
2006-08-02 12:00:00	MSFT	Stock	24.21	24.4	24.19	24.38	7913501.0
2006-08-02 13:00:00	MSFT	Stock	24.38	24.4	24.34	24.382	3152170.0
2006-08-02 14:00:00	MSFT	Stock	24.38	24.4	24.3	24.33	7102276.0
2006-08-02 15:00:00	MSFT	Stock	24.33	24.38	24.28	24.3	10773726.0
2006-08-02 16:00:00	MSFT	Stock	24.29	24.36	24.27	24.3	366691.0
2006-08-02 17:00:00	MSFT	Stock	24.31	24.33	24.3	24.33	800.0
2006-08-02 08:00:00	NVDA	Stock	0.3583	0.3592	0.358	0.3592	466500.0
2006-08-02 09:00:00	NVDA	Stock	0.36	0.3775	0.3593	0.3737	110040360.0
2006-08-02 10:00:00	NVDA	Stock	0.3737	0.3757	0.3667	0.3708	106480560.0
2006-08-02 11:00:00	NVDA	Stock	0.371	0.3805	0.3703	0.3802	113001840.0
2006-08-02 12:00:00	NVDA	Stock	0.3803	0.3832	0.379	0.381	76935300.0
2006-08-02 13:00:00	NVDA	Stock	0.381	0.3822	0.3787	0.3788	58409040.0
2006-08-02 14:00:00	NVDA	Stock	0.379	0.3817	0.3778	0.3783	106020480.0
2006-08-02 15:00:00	NVDA	Stock	0.3785	0.3818	0.3757	0.3808	151160760.0
2006-08-02 16:00:00	NVDA	Stock	0.381	0.3825	0.3766	0.3823	18058680.0
2006-08-02 17:00:00	NVDA	Stock	0.3828	0.3828	0.3813	0.3817	88320.0
2006-08-02 18:00:00	NVDA	Stock	0.3823	0.3823	0.3823	0.3823	49800.0
2006-08-02 08:00:00	AMZN	Stock	1.31	1.31	1.31	1.31	4880.0
2006-08-02 09:00:00	AMZN	Stock	1.309	1.317	1.297	1.3065	18245100.0
2006-08-02 10:00:00	AMZN	Stock	1.3075	1.3095	1.299	1.3004	18703820.0
2006-08-02 11:00:00	AMZN	Stock	1.3005	1.3135	1.3	1.309	16489720.0
2006-08-02 12:00:00	AMZN	Stock	1.309	1.315	1.305	1.308	12502780.0
2006-08-02 13:00:00	AMZN	Stock	1.3075	1.3095	1.304	1.307	9059100.0
2006-08-02 14:00:00	AMZN	Stock	1.3065	1.312	1.3005	1.302	26031480.0
2006-08-02 15:00:00	AMZN	Stock	1.302	1.306	1.2945	1.304	45887120.0
2006-08-02 16:00:00	AMZN	Stock	1.304	1.3045	1.304	1.304	401980.0
2006-08-02 17:00:00	AMZN	Stock	1.303	1.304	1.303	1.304	12000.0
2006-08-02 18:00:00	AMZN	Stock	1.304	1.304	1.3025	1.3025	52500.0
2006-08-02 08:00:00	CL	Stock	29.265	29.265	29.265	29.265	200600.0
2006-08-02 09:00:00	CL	Stock	29.155	29.355	29.025	29.28	740000.0
2006-08-02 10:00:00	CL	Stock	29.27	29.29	29.075	29.26	513000.0
2006-08-02 11:00:00	CL	Stock	29.255	29.41	29.255	29.41	565000.0
2006-08-02 12:00:00	CL	Stock	29.435	29.595	29.4	29.595	550400.0
2006-08-02 13:00:00	CL	Stock	29.6	29.619	29.515	29.58	317000.0

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

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