PREVIEW / stock_1hour / 2005-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-14.parquet
  size:    566 KB
  rows:    26,949
  symbols: 2,109

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-11-14 08:00:00	AAPL	Stock	2.1943	2.1943	2.1857	2.1914	1333556.0
2005-11-14 09:00:00	AAPL	Stock	2.1921	2.2136	2.1911	2.1979	56645092.0
2005-11-14 10:00:00	AAPL	Stock	2.1982	2.2071	2.1886	2.1993	76618640.0
2005-11-14 11:00:00	AAPL	Stock	2.1989	2.2025	2.1754	2.1836	64913716.0
2005-11-14 12:00:00	AAPL	Stock	2.1836	2.1925	2.1821	2.1854	35622384.0
2005-11-14 13:00:00	AAPL	Stock	2.1854	2.2046	2.1832	2.2043	37124416.0
2005-11-14 14:00:00	AAPL	Stock	2.2039	2.205	2.1946	2.1954	39562796.0
2005-11-14 15:00:00	AAPL	Stock	2.1957	2.2004	2.1896	2.1946	54519948.0
2005-11-14 16:00:00	AAPL	Stock	2.1957	2.1971	2.1925	2.1946	880992.0
2005-11-14 17:00:00	AAPL	Stock	2.1964	2.1964	2.1943	2.1957	192500.0
2005-11-14 18:00:00	AAPL	Stock	2.1943	2.1943	2.1943	2.1943	134400.0
2005-11-14 06:00:00	MSFT	Stock	27.34	27.34	27.25	27.25	4000.0
2005-11-14 07:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	6943.0
2005-11-14 08:00:00	MSFT	Stock	27.3	27.39	27.27	27.37	83679.0
2005-11-14 09:00:00	MSFT	Stock	27.37	27.44	27.29	27.32	8900563.0
2005-11-14 10:00:00	MSFT	Stock	27.32	27.42	27.3	27.368	8926620.0
2005-11-14 11:00:00	MSFT	Stock	27.36	27.41	27.35	27.4	6109783.0
2005-11-14 12:00:00	MSFT	Stock	27.4	27.44	27.2	27.31	5319005.0
2005-11-14 13:00:00	MSFT	Stock	27.32	27.38	27.31	27.36	6256543.0
2005-11-14 14:00:00	MSFT	Stock	27.37	27.37	27.3	27.35	8821537.0
2005-11-14 15:00:00	MSFT	Stock	27.35	27.39	27.3	27.37	16181545.0
2005-11-14 16:00:00	MSFT	Stock	27.35	27.39	27.3	27.37	1721163.0
2005-11-14 17:00:00	MSFT	Stock	27.37	27.4	27.35	27.35	994845.0
2005-11-14 18:00:00	MSFT	Stock	27.35	27.37	27.35	27.35	2773.0
2005-11-14 09:00:00	NVDA	Stock	0.2833	0.2852	0.2794	0.2839	62011440.0
2005-11-14 10:00:00	NVDA	Stock	0.2839	0.288	0.2834	0.2862	95974680.0
2005-11-14 11:00:00	NVDA	Stock	0.2862	0.2896	0.2859	0.2886	72114120.0
2005-11-14 12:00:00	NVDA	Stock	0.2885	0.2909	0.2885	0.2887	82940400.0
2005-11-14 13:00:00	NVDA	Stock	0.2887	0.2908	0.2883	0.2907	47116200.0
2005-11-14 14:00:00	NVDA	Stock	0.2907	0.2917	0.29	0.2902	46623240.0
2005-11-14 15:00:00	NVDA	Stock	0.2902	0.2907	0.2891	0.29	78219720.0
2005-11-14 16:00:00	NVDA	Stock	0.2899	0.2902	0.2897	0.2902	2713440.0
2005-11-14 17:00:00	NVDA	Stock	0.2897	0.2897	0.2897	0.2897	572280.0
2005-11-14 18:00:00	NVDA	Stock	0.2896	0.2896	0.2892	0.2892	96000.0
2005-11-14 08:00:00	AMZN	Stock	2.1365	2.1365	2.1365	2.1365	20000.0
2005-11-14 09:00:00	AMZN	Stock	2.1325	2.1495	2.12	2.145	7207220.0
2005-11-14 10:00:00	AMZN	Stock	2.145	2.15	2.124	2.127	8466080.0
2005-11-14 11:00:00	AMZN	Stock	2.1274	2.1335	2.1215	2.1275	5630320.0
2005-11-14 12:00:00	AMZN	Stock	2.128	2.1345	2.126	2.1275	3793040.0
2005-11-14 13:00:00	AMZN	Stock	2.1275	2.1275	2.12	2.123	3666020.0
2005-11-14 14:00:00	AMZN	Stock	2.123	2.1235	2.117	2.121	3418920.0
2005-11-14 15:00:00	AMZN	Stock	2.1215	2.127	2.117	2.1265	11272120.0
2005-11-14 16:00:00	AMZN	Stock	2.1265	2.127	2.1255	2.127	31980.0
2005-11-14 17:00:00	AMZN	Stock	2.135	2.2595	2.134	2.24	14595880.0
2005-11-14 18:00:00	AMZN	Stock	2.2415	2.2625	2.24	2.261	3221560.0
2005-11-14 09:00:00	CL	Stock	26.765	26.82	26.705	26.755	465600.0
2005-11-14 10:00:00	CL	Stock	26.755	26.94	26.755	26.833	339800.0
2005-11-14 11:00:00	CL	Stock	26.835	26.875	26.77	26.795	303800.0
2005-11-14 12:00:00	CL	Stock	26.8	26.83	26.755	26.765	203200.0
2005-11-14 13:00:00	CL	Stock	26.755	26.765	26.66	26.745	409800.0

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

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