PREVIEW / stock_1hour / 2005-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-11.parquet
  size:    558 KB
  rows:    26,416
  symbols: 2,028

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-07-11 08:00:00	AAPL	Stock	1.375	1.3857	1.3721	1.3757	1324204.0
2005-07-11 09:00:00	AAPL	Stock	1.3754	1.3814	1.3643	1.3654	76101228.0
2005-07-11 10:00:00	AAPL	Stock	1.365	1.3746	1.3493	1.3571	106743784.0
2005-07-11 11:00:00	AAPL	Stock	1.3571	1.3664	1.3557	1.3625	52094504.0
2005-07-11 12:00:00	AAPL	Stock	1.3629	1.3679	1.3539	1.3561	30102744.0
2005-07-11 13:00:00	AAPL	Stock	1.3561	1.3607	1.3546	1.3593	24306072.0
2005-07-11 14:00:00	AAPL	Stock	1.3596	1.3625	1.3568	1.3593	32782876.0
2005-07-11 15:00:00	AAPL	Stock	1.3596	1.3607	1.3532	1.3607	51073036.0
2005-07-11 16:00:00	AAPL	Stock	1.3607	1.3632	1.3568	1.3611	2803332.0
2005-07-11 17:00:00	AAPL	Stock	1.3611	1.3625	1.3591	1.3618	553840.0
2005-07-11 18:00:00	AAPL	Stock	1.3614	1.3618	1.3607	1.3607	79800.0
2005-07-11 08:00:00	MSFT	Stock	25.14	25.17	25.14	25.14	67024.0
2005-07-11 09:00:00	MSFT	Stock	25.14	25.18	25.11	25.14	9778346.0
2005-07-11 10:00:00	MSFT	Stock	25.14	25.32	25.13	25.27	9126017.0
2005-07-11 11:00:00	MSFT	Stock	25.27	25.37	25.25	25.34	8658646.0
2005-07-11 12:00:00	MSFT	Stock	25.341	25.35	25.25	25.29	5449227.0
2005-07-11 13:00:00	MSFT	Stock	25.29	25.38	25.27	25.28	6235909.0
2005-07-11 14:00:00	MSFT	Stock	25.28	25.34	25.25	25.32	4972268.0
2005-07-11 15:00:00	MSFT	Stock	25.32	25.32	25.18	25.3	14625022.0
2005-07-11 16:00:00	MSFT	Stock	25.29	25.35	25.28	25.286	461533.0
2005-07-11 17:00:00	MSFT	Stock	25.31	25.34	25.255	25.255	7112.0
2005-07-11 18:00:00	MSFT	Stock	25.34	25.35	25.33	25.34	8375.0
2005-07-11 08:00:00	NVDA	Stock	0.235	0.235	0.235	0.235	60000.0
2005-07-11 09:00:00	NVDA	Stock	0.235	0.2404	0.2347	0.2378	110221560.0
2005-07-11 10:00:00	NVDA	Stock	0.2377	0.2386	0.2356	0.2381	103317600.0
2005-07-11 11:00:00	NVDA	Stock	0.2381	0.2392	0.2368	0.2369	43042800.0
2005-07-11 12:00:00	NVDA	Stock	0.2369	0.2374	0.2362	0.2363	20867040.0
2005-07-11 13:00:00	NVDA	Stock	0.2363	0.2373	0.2362	0.2364	21125040.0
2005-07-11 14:00:00	NVDA	Stock	0.2363	0.2383	0.2363	0.2381	23599680.0
2005-07-11 15:00:00	NVDA	Stock	0.238	0.2387	0.2373	0.238	67551720.0
2005-07-11 16:00:00	NVDA	Stock	0.2379	0.238	0.2379	0.238	2184000.0
2005-07-11 17:00:00	NVDA	Stock	0.238	0.238	0.238	0.238	201000.0
2005-07-11 08:00:00	AMZN	Stock	1.738	1.738	1.737	1.737	30300.0
2005-07-11 09:00:00	AMZN	Stock	1.7375	1.7515	1.7285	1.7485	12511000.0
2005-07-11 10:00:00	AMZN	Stock	1.749	1.7725	1.7475	1.7725	19220660.0
2005-07-11 11:00:00	AMZN	Stock	1.772	1.783	1.7715	1.7805	21462120.0
2005-07-11 12:00:00	AMZN	Stock	1.781	1.784	1.77	1.77	13794740.0
2005-07-11 13:00:00	AMZN	Stock	1.77	1.7755	1.7685	1.7721	9800920.0
2005-07-11 14:00:00	AMZN	Stock	1.772	1.7765	1.772	1.774	8066000.0
2005-07-11 15:00:00	AMZN	Stock	1.7745	1.7795	1.7735	1.7795	15909220.0
2005-07-11 16:00:00	AMZN	Stock	1.779	1.7805	1.7775	1.7793	391200.0
2005-07-11 17:00:00	AMZN	Stock	1.7775	1.78	1.775	1.775	95240.0
2005-07-11 18:00:00	AMZN	Stock	1.78	1.78	1.7765	1.7765	6000.0
2005-07-11 09:00:00	CL	Stock	25.3	25.385	25.21	25.23	486600.0
2005-07-11 10:00:00	CL	Stock	25.2	25.265	25.105	25.265	494400.0
2005-07-11 11:00:00	CL	Stock	25.265	25.305	25.2	25.22	338400.0
2005-07-11 12:00:00	CL	Stock	25.215	25.215	25.145	25.19	293800.0
2005-07-11 13:00:00	CL	Stock	25.185	25.185	25.085	25.135	431000.0
2005-07-11 14:00:00	CL	Stock	25.125	25.185	25.125	25.14	345000.0
2005-07-11 15:00:00	CL	Stock	25.13	25.215	25.105	25.21	550600.0

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

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