PREVIEW / stock_1hour / 2005-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-02.parquet
  size:    546 KB
  rows:    25,631
  symbols: 1,947

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-03-02 08:00:00	AAPL	Stock	1.5786	1.5846	1.5743	1.5818	743820.0
2005-03-02 09:00:00	AAPL	Stock	1.5818	1.5918	1.5743	1.5825	57301468.0
2005-03-02 10:00:00	AAPL	Stock	1.5825	1.5893	1.5764	1.5886	73444952.0
2005-03-02 11:00:00	AAPL	Stock	1.5889	1.6032	1.5864	1.591	78698116.0
2005-03-02 12:00:00	AAPL	Stock	1.5909	1.5982	1.59	1.5907	40194756.0
2005-03-02 13:00:00	AAPL	Stock	1.591	1.5968	1.5814	1.5871	43901144.0
2005-03-02 14:00:00	AAPL	Stock	1.5868	1.5882	1.5775	1.5793	50838984.0
2005-03-02 15:00:00	AAPL	Stock	1.5793	1.5864	1.575	1.5761	65636928.0
2005-03-02 16:00:00	AAPL	Stock	1.5775	1.5836	1.5746	1.5786	2164540.0
2005-03-02 17:00:00	AAPL	Stock	1.5782	1.5782	1.5764	1.5764	232400.0
2005-03-02 18:00:00	AAPL	Stock	1.5764	1.5764	1.5757	1.5757	222824.0
2005-03-02 08:00:00	MSFT	Stock	25.28	25.3	25.21	25.21	21820.0
2005-03-02 09:00:00	MSFT	Stock	25.23	25.3	25.16	25.19	6001459.0
2005-03-02 10:00:00	MSFT	Stock	25.18	25.3	25.16	25.27	9045704.0
2005-03-02 11:00:00	MSFT	Stock	25.26	25.48	25.26	25.44	16954479.0
2005-03-02 12:00:00	MSFT	Stock	25.44	25.47	25.35	25.38	8205845.0
2005-03-02 13:00:00	MSFT	Stock	25.38	25.45	25.36	25.37	8042807.0
2005-03-02 14:00:00	MSFT	Stock	25.37	25.38	25.24	25.25	8528302.0
2005-03-02 15:00:00	MSFT	Stock	25.25	25.37	25.18	25.26	9675774.0
2005-03-02 16:00:00	MSFT	Stock	25.25	25.32	25.25	25.28	207379.0
2005-03-02 17:00:00	MSFT	Stock	25.26	25.28	25.26	25.28	157000.0
2005-03-02 18:00:00	MSFT	Stock	25.28	25.28	25.28	25.28	800.0
2005-03-02 09:00:00	NVDA	Stock	0.2397	0.2407	0.2351	0.2357	116578320.0
2005-03-02 10:00:00	NVDA	Stock	0.2357	0.2366	0.2348	0.2365	111839520.0
2005-03-02 11:00:00	NVDA	Stock	0.2365	0.2397	0.2362	0.2376	199688160.0
2005-03-02 12:00:00	NVDA	Stock	0.2375	0.2381	0.2366	0.2375	55283040.0
2005-03-02 13:00:00	NVDA	Stock	0.2375	0.2377	0.2329	0.2342	129564120.0
2005-03-02 14:00:00	NVDA	Stock	0.234	0.2357	0.2331	0.2333	143729880.0
2005-03-02 15:00:00	NVDA	Stock	0.2333	0.236	0.2325	0.2337	176735880.0
2005-03-02 16:00:00	NVDA	Stock	0.2337	0.2342	0.233	0.233	3112560.0
2005-03-02 17:00:00	NVDA	Stock	0.233	0.233	0.2325	0.2327	2564520.0
2005-03-02 18:00:00	NVDA	Stock	0.233	0.2331	0.2329	0.2329	180000.0
2005-03-02 08:00:00	AMZN	Stock	1.7695	1.7695	1.76	1.7675	12000.0
2005-03-02 09:00:00	AMZN	Stock	1.76	1.7745	1.7535	1.7615	10614140.0
2005-03-02 10:00:00	AMZN	Stock	1.7615	1.7845	1.76	1.7845	18388180.0
2005-03-02 11:00:00	AMZN	Stock	1.7845	1.7945	1.781	1.787	21642700.0
2005-03-02 12:00:00	AMZN	Stock	1.787	1.7965	1.7865	1.793	8764600.0
2005-03-02 13:00:00	AMZN	Stock	1.793	1.7955	1.783	1.7856	9906180.0
2005-03-02 14:00:00	AMZN	Stock	1.786	1.792	1.7735	1.7795	10197100.0
2005-03-02 15:00:00	AMZN	Stock	1.7795	1.785	1.775	1.775	16931240.0
2005-03-02 16:00:00	AMZN	Stock	1.777	1.7795	1.7733	1.778	247620.0
2005-03-02 17:00:00	AMZN	Stock	1.775	1.775	1.775	1.775	2734000.0
2005-03-02 18:00:00	AMZN	Stock	1.78	1.7845	1.778	1.778	38000.0
2005-03-02 09:00:00	CL	Stock	26.435	26.445	26.205	26.34	464400.0
2005-03-02 10:00:00	CL	Stock	26.34	26.515	26.315	26.495	410200.0
2005-03-02 11:00:00	CL	Stock	26.495	26.65	26.44	26.64	411000.0
2005-03-02 12:00:00	CL	Stock	26.64	26.645	26.475	26.475	505200.0
2005-03-02 13:00:00	CL	Stock	26.47	26.475	26.22	26.225	470000.0
2005-03-02 14:00:00	CL	Stock	26.23	26.33	26.12	26.19	616400.0
2005-03-02 15:00:00	CL	Stock	26.185	26.4	26.185	26.345	713000.0

> showing 50 of 25,631 rows — these rows as CSV

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