PREVIEW / stock_1hour / 2005-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-18.parquet
  size:    556 KB
  rows:    26,389
  symbols: 2,060

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-08-18 08:00:00	AAPL	Stock	1.6821	1.6857	1.6768	1.6768	45052.0
2005-08-18 09:00:00	AAPL	Stock	1.6768	1.6804	1.6525	1.6586	64698956.0
2005-08-18 10:00:00	AAPL	Stock	1.6589	1.6618	1.6371	1.6386	96100060.0
2005-08-18 11:00:00	AAPL	Stock	1.6386	1.65	1.6339	1.6411	71776908.0
2005-08-18 12:00:00	AAPL	Stock	1.6407	1.6464	1.6404	1.6436	26135452.0
2005-08-18 13:00:00	AAPL	Stock	1.6436	1.6604	1.6414	1.6561	62213620.0
2005-08-18 14:00:00	AAPL	Stock	1.6557	1.6571	1.6439	1.6479	46861948.0
2005-08-18 15:00:00	AAPL	Stock	1.6475	1.6561	1.6421	1.6529	62538672.0
2005-08-18 16:00:00	AAPL	Stock	1.6536	1.6546	1.6518	1.6546	2155720.0
2005-08-18 17:00:00	AAPL	Stock	1.6529	1.6529	1.6529	1.6529	21000.0
2005-08-18 18:00:00	AAPL	Stock	1.6546	1.6564	1.6546	1.6546	27496.0
2005-08-18 08:00:00	MSFT	Stock	26.93	26.93	26.8	26.87	9857.0
2005-08-18 09:00:00	MSFT	Stock	26.87	26.96	26.82	26.89	3940989.0
2005-08-18 10:00:00	MSFT	Stock	26.9	26.96	26.86	26.89	5768380.0
2005-08-18 11:00:00	MSFT	Stock	26.88	26.952	26.84	26.88	3591256.0
2005-08-18 12:00:00	MSFT	Stock	26.89	26.96	26.87	26.92	3744486.0
2005-08-18 13:00:00	MSFT	Stock	26.92	27.08	26.9	27.01	3806091.0
2005-08-18 14:00:00	MSFT	Stock	27.0	27.01	26.85	26.92	6420187.0
2005-08-18 15:00:00	MSFT	Stock	26.91	26.92	26.8	26.81	10332365.0
2005-08-18 16:00:00	MSFT	Stock	26.82	26.821	26.76	26.81	1502590.0
2005-08-18 17:00:00	MSFT	Stock	26.81	26.81	26.78	26.81	9960.0
2005-08-18 18:00:00	MSFT	Stock	26.81	26.81	26.75	26.77	7990.0
2005-08-18 08:00:00	NVDA	Stock	0.2522	0.2522	0.2522	0.2522	24000.0
2005-08-18 09:00:00	NVDA	Stock	0.2512	0.2512	0.247	0.2483	88485720.0
2005-08-18 10:00:00	NVDA	Stock	0.2482	0.2499	0.2462	0.2487	162224760.0
2005-08-18 11:00:00	NVDA	Stock	0.2487	0.2487	0.2468	0.2473	74191320.0
2005-08-18 12:00:00	NVDA	Stock	0.2473	0.2485	0.2472	0.2477	52904040.0
2005-08-18 13:00:00	NVDA	Stock	0.2477	0.2492	0.2475	0.2482	99313440.0
2005-08-18 14:00:00	NVDA	Stock	0.2481	0.2481	0.244	0.2442	175890120.0
2005-08-18 15:00:00	NVDA	Stock	0.2442	0.2473	0.2442	0.2451	158853840.0
2005-08-18 16:00:00	NVDA	Stock	0.2452	0.2457	0.2449	0.2452	1700160.0
2005-08-18 17:00:00	NVDA	Stock	0.2447	0.2447	0.2447	0.2447	36000.0
2005-08-18 18:00:00	NVDA	Stock	0.245	0.245	0.2447	0.2447	324000.0
2005-08-18 08:00:00	AMZN	Stock	2.1995	2.1995	2.1995	2.1995	2000.0
2005-08-18 09:00:00	AMZN	Stock	2.1995	2.2025	2.1755	2.1825	18594140.0
2005-08-18 10:00:00	AMZN	Stock	2.1825	2.19	2.1795	2.1885	11148700.0
2005-08-18 11:00:00	AMZN	Stock	2.189	2.1895	2.179	2.179	8747700.0
2005-08-18 12:00:00	AMZN	Stock	2.1795	2.188	2.1785	2.187	5354340.0
2005-08-18 13:00:00	AMZN	Stock	2.1875	2.195	2.184	2.1885	5534280.0
2005-08-18 14:00:00	AMZN	Stock	2.1885	2.1925	2.1845	2.1876	5044660.0
2005-08-18 15:00:00	AMZN	Stock	2.188	2.1925	2.1855	2.1865	15884640.0
2005-08-18 16:00:00	AMZN	Stock	2.187	2.19	2.1865	2.1875	177280.0
2005-08-18 09:00:00	CL	Stock	25.935	26.13	25.925	26.085	309800.0
2005-08-18 10:00:00	CL	Stock	26.08	26.375	26.065	26.275	560000.0
2005-08-18 11:00:00	CL	Stock	26.29	26.4	26.25	26.33	481600.0
2005-08-18 12:00:00	CL	Stock	26.335	26.415	26.31	26.4	373800.0
2005-08-18 13:00:00	CL	Stock	26.405	26.5	26.38	26.5	374400.0
2005-08-18 14:00:00	CL	Stock	26.5	26.5	26.375	26.46	471600.0
2005-08-18 15:00:00	CL	Stock	26.46	26.465	26.36	26.37	896400.0
2005-08-18 16:00:00	CL	Stock	26.345	26.345	26.345	26.345	800.0

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

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