PREVIEW / stock_1hour / 2004-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-24.parquet
  size:    479 KB
  rows:    23,343
  symbols: 1,824

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
2004-08-24 08:00:00	AAPL	Stock	0.555	0.555	0.555	0.555	22400.0
2004-08-24 09:00:00	AAPL	Stock	0.5563	0.5613	0.5552	0.5586	23688616.0
2004-08-24 10:00:00	AAPL	Stock	0.5582	0.5621	0.5579	0.5586	59237416.0
2004-08-24 11:00:00	AAPL	Stock	0.5586	0.5618	0.5575	0.5613	39006800.0
2004-08-24 12:00:00	AAPL	Stock	0.5613	0.5621	0.5598	0.562	47188176.0
2004-08-24 13:00:00	AAPL	Stock	0.562	0.5679	0.5614	0.5679	60851952.0
2004-08-24 14:00:00	AAPL	Stock	0.5679	0.568	0.5652	0.5663	38028704.0
2004-08-24 15:00:00	AAPL	Stock	0.5661	0.57	0.5643	0.57	76822312.0
2004-08-24 16:00:00	AAPL	Stock	0.57	0.5713	0.5689	0.5705	15083656.0
2004-08-24 17:00:00	AAPL	Stock	0.5711	0.5711	0.5711	0.5711	25200.0
2004-08-24 08:00:00	MSFT	Stock	27.34	27.36	27.21	27.35	93500.0
2004-08-24 09:00:00	MSFT	Stock	27.35	27.42	27.28	27.34	5610494.0
2004-08-24 10:00:00	MSFT	Stock	27.33	27.43	27.23	27.24	7222111.0
2004-08-24 11:00:00	MSFT	Stock	27.24	27.25	27.13	27.17	5768760.0
2004-08-24 12:00:00	MSFT	Stock	27.17	27.24	27.09	27.22	3743188.0
2004-08-24 13:00:00	MSFT	Stock	27.22	27.29	27.19	27.24	3755310.0
2004-08-24 14:00:00	MSFT	Stock	27.24	27.25	27.14	27.169	3205557.0
2004-08-24 15:00:00	MSFT	Stock	27.16	27.24	27.11	27.22	6046109.0
2004-08-24 16:00:00	MSFT	Stock	27.23	27.26	27.21	27.24	4438034.0
2004-08-24 17:00:00	MSFT	Stock	27.25	27.25	27.2	27.21	13800.0
2004-08-24 18:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	400.0
2004-08-24 08:00:00	NVDA	Stock	0.1042	0.1058	0.1042	0.1057	687600.0
2004-08-24 09:00:00	NVDA	Stock	0.1057	0.1072	0.1035	0.1039	133867440.0
2004-08-24 10:00:00	NVDA	Stock	0.1038	0.1039	0.1002	0.1004	233195760.0
2004-08-24 11:00:00	NVDA	Stock	0.1004	0.1009	0.0992	0.1007	172413720.0
2004-08-24 12:00:00	NVDA	Stock	0.1008	0.1016	0.1005	0.1016	97584840.0
2004-08-24 13:00:00	NVDA	Stock	0.1015	0.1017	0.1011	0.1017	62536800.0
2004-08-24 14:00:00	NVDA	Stock	0.1016	0.1016	0.1005	0.1007	59684280.0
2004-08-24 15:00:00	NVDA	Stock	0.1007	0.1015	0.1002	0.1012	125653560.0
2004-08-24 16:00:00	NVDA	Stock	0.1012	0.1017	0.101	0.101	2315880.0
2004-08-24 17:00:00	NVDA	Stock	0.1011	0.1011	0.1009	0.1009	123480.0
2004-08-24 18:00:00	NVDA	Stock	0.1009	0.101	0.1009	0.101	196800.0
2004-08-24 08:00:00	AMZN	Stock	1.985	1.985	1.979	1.979	35340.0
2004-08-24 09:00:00	AMZN	Stock	1.987	1.9965	1.9715	1.9835	16906080.0
2004-08-24 10:00:00	AMZN	Stock	1.9835	1.989	1.939	1.9455	29986940.0
2004-08-24 11:00:00	AMZN	Stock	1.9455	1.946	1.9205	1.926	29979640.0
2004-08-24 12:00:00	AMZN	Stock	1.9255	1.935	1.916	1.934	15291080.0
2004-08-24 13:00:00	AMZN	Stock	1.934	1.9575	1.9315	1.9565	14699060.0
2004-08-24 14:00:00	AMZN	Stock	1.957	1.9575	1.9345	1.937	13866100.0
2004-08-24 15:00:00	AMZN	Stock	1.9365	1.9585	1.931	1.9525	27549120.0
2004-08-24 16:00:00	AMZN	Stock	1.949	1.9525	1.9465	1.9525	1216940.0
2004-08-24 17:00:00	AMZN	Stock	1.9495	1.952	1.946	1.952	126860.0
2004-08-24 18:00:00	AMZN	Stock	1.946	1.9499	1.946	1.946	1018000.0
2004-08-24 09:00:00	CL	Stock	26.775	26.8	26.66	26.77	188200.0
2004-08-24 10:00:00	CL	Stock	26.775	26.825	26.6	26.63	232200.0
2004-08-24 11:00:00	CL	Stock	26.625	26.675	26.58	26.66	143400.0
2004-08-24 12:00:00	CL	Stock	26.665	26.725	26.63	26.705	137600.0
2004-08-24 13:00:00	CL	Stock	26.7	26.72	26.68	26.705	201600.0
2004-08-24 14:00:00	CL	Stock	26.7	26.715	26.655	26.655	158200.0
2004-08-24 15:00:00	CL	Stock	26.65	26.72	26.63	26.685	525200.0

> showing 50 of 23,343 rows — these rows as CSV

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