PREVIEW / stock_1hour / 2005-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-23.parquet
  size:    545 KB
  rows:    25,898
  symbols: 1,939

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-02-23 08:00:00	AAPL	Stock	1.5241	1.5443	1.5241	1.5409	10146360.0
2005-02-23 09:00:00	AAPL	Stock	1.5393	1.5536	1.523	1.5336	186354112.0
2005-02-23 10:00:00	AAPL	Stock	1.5336	1.5575	1.5327	1.5514	275318176.0
2005-02-23 11:00:00	AAPL	Stock	1.5514	1.5745	1.5509	1.5734	276936072.0
2005-02-23 12:00:00	AAPL	Stock	1.5734	1.5775	1.5682	1.575	127361360.0
2005-02-23 13:00:00	AAPL	Stock	1.575	1.5795	1.5664	1.5714	145024936.0
2005-02-23 14:00:00	AAPL	Stock	1.5709	1.5748	1.5645	1.5702	139858880.0
2005-02-23 15:00:00	AAPL	Stock	1.57	1.5768	1.5686	1.5754	172436824.0
2005-02-23 16:00:00	AAPL	Stock	1.5754	1.5802	1.5745	1.5796	4818016.0
2005-02-23 17:00:00	AAPL	Stock	1.5795	1.5825	1.5748	1.5821	1269520.0
2005-02-23 18:00:00	AAPL	Stock	1.5821	1.5821	1.5796	1.5818	666232.0
2005-02-23 08:00:00	MSFT	Stock	25.2	25.27	25.18	25.26	48648.0
2005-02-23 09:00:00	MSFT	Stock	25.26	25.34	25.21	25.32	8837225.0
2005-02-23 10:00:00	MSFT	Stock	25.32	25.35	25.21	25.23	15610097.0
2005-02-23 11:00:00	MSFT	Stock	25.23	25.29	25.22	25.26	10849421.0
2005-02-23 12:00:00	MSFT	Stock	25.26	25.3	25.23	25.26	6760833.0
2005-02-23 13:00:00	MSFT	Stock	25.27	25.28	25.21	25.25	10410889.0
2005-02-23 14:00:00	MSFT	Stock	25.25	25.29	25.21	25.28	10625223.0
2005-02-23 15:00:00	MSFT	Stock	25.29	25.34	25.17	25.19	12742148.0
2005-02-23 16:00:00	MSFT	Stock	25.18	25.2	25.14	25.18	1516118.0
2005-02-23 17:00:00	MSFT	Stock	25.18	25.2	25.16	25.18	387140.0
2005-02-23 18:00:00	MSFT	Stock	25.17	25.18	25.17	25.18	1100.0
2005-02-23 08:00:00	NVDA	Stock	0.2387	0.2412	0.2384	0.2402	723600.0
2005-02-23 09:00:00	NVDA	Stock	0.2402	0.2412	0.2297	0.2312	290349720.0
2005-02-23 10:00:00	NVDA	Stock	0.2312	0.2323	0.2271	0.229	180837600.0
2005-02-23 11:00:00	NVDA	Stock	0.2289	0.2303	0.227	0.2286	163476600.0
2005-02-23 12:00:00	NVDA	Stock	0.2285	0.2297	0.2279	0.2293	58747920.0
2005-02-23 13:00:00	NVDA	Stock	0.2294	0.2297	0.2271	0.2274	78743400.0
2005-02-23 14:00:00	NVDA	Stock	0.2274	0.2313	0.2272	0.2299	163077000.0
2005-02-23 15:00:00	NVDA	Stock	0.23	0.2325	0.2292	0.2307	161755320.0
2005-02-23 16:00:00	NVDA	Stock	0.2309	0.2321	0.2304	0.2321	1832280.0
2005-02-23 17:00:00	NVDA	Stock	0.2318	0.2322	0.2312	0.2312	450480.0
2005-02-23 18:00:00	NVDA	Stock	0.2309	0.2309	0.2309	0.2309	36000.0
2005-02-23 08:00:00	AMZN	Stock	1.7395	1.7395	1.732	1.732	8000.0
2005-02-23 09:00:00	AMZN	Stock	1.7475	1.751	1.7025	1.713	26033000.0
2005-02-23 10:00:00	AMZN	Stock	1.7135	1.7205	1.6965	1.701	31336520.0
2005-02-23 11:00:00	AMZN	Stock	1.7015	1.7155	1.698	1.7065	20852060.0
2005-02-23 12:00:00	AMZN	Stock	1.7061	1.7065	1.6895	1.6925	16574580.0
2005-02-23 13:00:00	AMZN	Stock	1.6925	1.6995	1.6785	1.679	26385000.0
2005-02-23 14:00:00	AMZN	Stock	1.679	1.69	1.66	1.6855	35350540.0
2005-02-23 15:00:00	AMZN	Stock	1.6855	1.719	1.685	1.7075	46167160.0
2005-02-23 16:00:00	AMZN	Stock	1.7085	1.7145	1.707	1.7085	599940.0
2005-02-23 17:00:00	AMZN	Stock	1.707	1.707	1.707	1.707	4383760.0
2005-02-23 09:00:00	CL	Stock	26.25	26.365	26.2	26.335	479400.0
2005-02-23 10:00:00	CL	Stock	26.345	26.345	26.235	26.27	409200.0
2005-02-23 11:00:00	CL	Stock	26.275	26.295	26.1465	26.24	458400.0
2005-02-23 12:00:00	CL	Stock	26.24	26.26	26.205	26.25	326400.0
2005-02-23 13:00:00	CL	Stock	26.25	26.29	26.205	26.28	420600.0
2005-02-23 14:00:00	CL	Stock	26.28	26.355	26.25	26.32	742800.0
2005-02-23 15:00:00	CL	Stock	26.32	26.38	26.305	26.33	721600.0

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

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