PREVIEW / stock_daily / 2007-03-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-13.parquet
  size:    161 KB
  rows:    4,861
  symbols: 3,052

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2007-03-13	AAPL	Stock	3.1932	3.2357	3.1571	3.1571	867890800.0
2007-03-13	MSFT	Stock	27.25	27.4	26.71	26.72	75169500.0
2007-03-13	NVDA	Stock	0.5003	0.5033	0.4838	0.4842	617070000.0
2007-03-13	AMZN	Stock	1.915	1.944	1.8845	1.891	104082000.0
2007-03-13	TLT	Stock	90.23	90.34	89.98	90.29	553800.0
2007-03-13	CL	Stock	33.21	33.27	32.885	32.935	4286600.0
2007-03-13	A	Stock	22.7754	22.9041	22.5894	22.6538	4176944.0
2007-03-13	AABA-DELISTED	Stock	29.7700004577637	30.2399997711182	29.4200000762939	29.5599994659424	18263800.0
2007-03-13	AACC-DELISTED	Stock	15.38	15.4	14.9	14.94	142487.0
2007-03-13	AACQ-DELISTED	Stock	4.66	4.66	4.51	4.55	17200.0
2007-03-13	AACQW-DELISTED	Stock	0.62	0.65	0.61	0.65	132200.0
2007-03-13	AAI-DELISTED	Stock	10.24	10.41	10.1	10.16	2086900.0
2007-03-13	AAIC-DELISTED	Stock	109.8	110.4	90.0	92.8	10514700.0
2007-03-13	AAME	Stock	3.24	3.49	3.24	3.49	6400.0
2007-03-13	AAON	Stock	3.4252	3.4594	3.2329	3.2514	297675.0
2007-03-13	AAP	Stock	38.54	38.71	37.78	37.78	788500.0
2007-03-13	AATI-DELISTED	Stock	6.53	6.8	6.45	6.46	442509.0
2007-03-13	AAU-DELISTED	Stock	2.2	2.21	2.13	2.15	60400.0
2007-03-13	AAUAF-DELISTED	Stock	2.2	2.21	2.13	2.15	60400.0
2007-03-13	AAV-DELISTED	Stock	10.0	10.1	9.85	9.89	910500.0
2007-03-13	AAWW-DELISTED	Stock	50.23	51.49	49.52	49.77	196265.0
2007-03-13	AAXN-DELISTED	Stock	7.96000003814697	8.02999973297119	7.78000020980835	7.80000019073486	1462800.0
2007-03-13	AB	Stock	85.68	85.68	82.75	83.3	322600.0
2007-03-13	ABAX-DELISTED	Stock	22.81	22.81	22.27	22.55	203232.0
2007-03-13	ABB-DELISTED	Stock	16.85	17.0	16.65	16.66	3593100.0
2007-03-13	ABBC-DELISTED	Stock	19.05	19.05	18.86	18.9	30180.0
2007-03-13	ABC-DELISTED	Stock	26.05	26.28	25.5	25.57	4292400.0
2007-03-13	ABCB	Stock	23.6157	23.7033	22.7209	22.8279	65286.0
2007-03-13	ABCO-DELISTED	Stock	25.71	25.71	25.15	25.39	247847.0
2007-03-13	ABCW-DELISTED	Stock	27.83	27.88	26.81	26.91	162990.0
2007-03-13	ABD-DELISTED	Stock	21.24	21.43	20.84	20.89	381300.0
2007-03-13	ABE-DELISTED	Stock	17.52	17.52	16.25	16.8214	57000.0
2007-03-13	ABFS-DELISTED	Stock	37.37	37.38	36.2	36.42	789167.0
2007-03-13	ABG	Stock	27.76	27.95	27.49	27.59	3256800.0
2007-03-13	ABK-DELISTED	Stock	88.95	89.54	86.71	86.93	2160500.0
2007-03-13	ABM	Stock	26.3	26.31	25.66	25.74	468100.0
2007-03-13	ABMD-DELISTED	Stock	13.26	13.31	12.93	13.06	148355.0
2007-03-13	ABP-DELISTED	Stock	3.15	3.2	2.89	3.02	472800.0
2007-03-13	ABR	Stock	30.15	30.15	28.82	29.05	179700.0
2007-03-13	ABT	Stock	25.9092	26.2499	25.8948	25.962	17118591.0
2007-03-13	ABTL-DELISTED	Stock	18.574	18.674	17.776	17.776	10908.0
2007-03-13	ABV-DELISTED	Stock	51.96	52.57	51.5	51.59	540200.0
2007-03-13	ABVA-DELISTED	Stock	15.19	15.19	14.9	14.9	2480.0
2007-03-13	ABVT-DELISTED	Stock	50.0	58.5	50.0	51.0	19211.0
2007-03-13	ABX-DELISTED	Stock	28.37	28.69	27.35	27.42	7346650.0
2007-03-13	ACAD	Stock	6.94	7.16	6.82	6.99	221600.0
2007-03-13	ACAP-DELISTED	Stock	36.77	36.87	35.71	35.78	70501.0
2007-03-13	ACAS-DELISTED	Stock	43.7	43.76	42.256	42.46	1716546.0
2007-03-13	ACAT-DELISTED	Stock	18.84	18.98	18.57	18.89	65791.0
2007-03-13	ACC-DELISTED	Stock	30.65	30.65	29.5	30.31	240500.0

> showing 50 of 4,861 rows — these rows as CSV

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