PREVIEW / stock_1hour / 2005-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-08.parquet
  size:    563 KB
  rows:    26,604
  symbols: 2,110

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
2005-11-08 07:00:00	AAPL	Stock	2.1571	2.1571	2.1511	2.1511	22400.0
2005-11-08 08:00:00	AAPL	Stock	2.1536	2.1536	2.1386	2.1393	1453480.0
2005-11-08 09:00:00	AAPL	Stock	2.1393	2.1425	2.1107	2.1189	98102536.0
2005-11-08 10:00:00	AAPL	Stock	2.1193	2.1314	2.1125	2.1246	82009928.0
2005-11-08 11:00:00	AAPL	Stock	2.1246	2.1496	2.1196	2.1464	72525236.0
2005-11-08 12:00:00	AAPL	Stock	2.1457	2.1564	2.14	2.1464	75189744.0
2005-11-08 13:00:00	AAPL	Stock	2.1464	2.1486	2.1304	2.1325	48406848.0
2005-11-08 14:00:00	AAPL	Stock	2.1329	2.1421	2.1329	2.1379	29445864.0
2005-11-08 15:00:00	AAPL	Stock	2.1375	2.1457	2.1264	2.1382	59099292.0
2005-11-08 16:00:00	AAPL	Stock	2.1368	2.1425	2.1361	2.1404	1229620.0
2005-11-08 17:00:00	AAPL	Stock	2.1393	2.1407	2.1364	2.1393	272524.0
2005-11-08 18:00:00	AAPL	Stock	2.1364	2.1393	2.1361	2.1368	78064.0
2005-11-08 07:00:00	MSFT	Stock	27.03	27.03	27.03	27.03	100.0
2005-11-08 08:00:00	MSFT	Stock	27.03	27.03	26.95	27.01	68458.0
2005-11-08 09:00:00	MSFT	Stock	26.98	26.99	26.77	26.82	8589527.0
2005-11-08 10:00:00	MSFT	Stock	26.82	27.18	26.81	27.01	13074385.0
2005-11-08 11:00:00	MSFT	Stock	27.01	27.18	27.01	27.15	9082963.0
2005-11-08 12:00:00	MSFT	Stock	27.15	27.15	27.069	27.14	4991433.0
2005-11-08 13:00:00	MSFT	Stock	27.14	27.15	26.97	27.041	4253690.0
2005-11-08 14:00:00	MSFT	Stock	27.05	27.12	27.03	27.05	6012747.0
2005-11-08 15:00:00	MSFT	Stock	27.05	27.13	27.02	27.05	12479169.0
2005-11-08 16:00:00	MSFT	Stock	27.04	27.147	27.028	27.07	234942.0
2005-11-08 17:00:00	MSFT	Stock	27.075	27.08	27.04	27.08	22954.0
2005-11-08 08:00:00	NVDA	Stock	0.2841	0.2841	0.2841	0.2841	36000.0
2005-11-08 09:00:00	NVDA	Stock	0.2839	0.2839	0.2815	0.2817	43750560.0
2005-11-08 10:00:00	NVDA	Stock	0.2817	0.2825	0.2785	0.2802	77081760.0
2005-11-08 11:00:00	NVDA	Stock	0.2802	0.2809	0.2793	0.2804	87158160.0
2005-11-08 12:00:00	NVDA	Stock	0.2804	0.2806	0.2788	0.2792	85460880.0
2005-11-08 13:00:00	NVDA	Stock	0.2792	0.28	0.2771	0.2779	54580080.0
2005-11-08 14:00:00	NVDA	Stock	0.2779	0.2788	0.2768	0.2777	60584040.0
2005-11-08 15:00:00	NVDA	Stock	0.2777	0.2782	0.2761	0.2773	111700200.0
2005-11-08 16:00:00	NVDA	Stock	0.2773	0.2773	0.2762	0.2771	1814880.0
2005-11-08 17:00:00	NVDA	Stock	0.2773	0.2778	0.2766	0.2778	659160.0
2005-11-08 09:00:00	AMZN	Stock	2.06	2.078	2.0515	2.0585	8207360.0
2005-11-08 10:00:00	AMZN	Stock	2.058	2.09	2.0575	2.077	14226040.0
2005-11-08 11:00:00	AMZN	Stock	2.0775	2.087	2.0725	2.0859	6575300.0
2005-11-08 12:00:00	AMZN	Stock	2.086	2.0935	2.0795	2.09	9863380.0
2005-11-08 13:00:00	AMZN	Stock	2.09	2.1	2.0885	2.0955	18162180.0
2005-11-08 14:00:00	AMZN	Stock	2.096	2.1055	2.0865	2.0895	18933880.0
2005-11-08 15:00:00	AMZN	Stock	2.09	2.105	2.085	2.0985	20671140.0
2005-11-08 16:00:00	AMZN	Stock	2.0975	2.1075	2.095	2.1075	260800.0
2005-11-08 17:00:00	AMZN	Stock	2.1075	2.114	2.0974	2.0974	770700.0
2005-11-08 18:00:00	AMZN	Stock	2.114	2.114	2.114	2.114	4000.0
2005-11-08 09:00:00	CL	Stock	25.83	26.045	25.83	26.02	369600.0
2005-11-08 10:00:00	CL	Stock	26.03	26.1	25.97	26.085	826400.0
2005-11-08 11:00:00	CL	Stock	26.09	26.245	26.07	26.22	702800.0
2005-11-08 12:00:00	CL	Stock	26.22	26.3	26.2	26.24	728200.0
2005-11-08 13:00:00	CL	Stock	26.24	26.31	26.2	26.27	397400.0
2005-11-08 14:00:00	CL	Stock	26.275	26.435	26.265	26.39	655800.0
2005-11-08 15:00:00	CL	Stock	26.395	26.42	26.29	26.335	980600.0

> showing 50 of 26,604 rows — these rows as CSV

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