PREVIEW / stock_daily / 2006-04-12

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-12.parquet
  size:    147 KB
  rows:    4,379
  symbols: 2,763

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
2006-04-12	AAPL	Stock	2.4289	2.4346	2.3679	2.3825	739894400.0
2006-04-12	MSFT	Stock	27.1	27.2	26.97	27.2	32183000.0
2006-04-12	NVDA	Stock	0.491	0.5102	0.4883	0.5075	598308000.0
2006-04-12	AMZN	Stock	1.7955	1.822	1.7955	1.8065	57116000.0
2006-04-12	CL	Stock	28.6	28.7	28.41	28.44	2542800.0
2006-04-12	A	Stock	26.3948	26.5379	25.9371	25.9871	1992010.0
2006-04-12	AABA-DELISTED	Stock	31.4400005340576	31.5	30.8899993896484	31.1000003814697	14926900.0
2006-04-12	AACC-DELISTED	Stock	20.0	20.5	20.0	20.25	67256.0
2006-04-12	AACQW-DELISTED	Stock	0.71	0.73	0.7	0.73	283000.0
2006-04-12	AAI-DELISTED	Stock	16.25	16.48	16.05	16.19	1534200.0
2006-04-12	AAIC-DELISTED	Stock	177.8	180.6	174.0	180.2	594400.0
2006-04-12	AAME	Stock	2.91	3.07	2.91	3.05	7100.0
2006-04-12	AAON	Stock	3.1579	3.1658	3.1355	3.1644	83531.0
2006-04-12	AAP	Stock	39.41	39.9	39.36	39.82	1073600.0
2006-04-12	AATI-DELISTED	Stock	10.76	10.93	10.58	10.78	634986.0
2006-04-12	AAU-DELISTED	Stock	3.01	3.04	2.94	3.04	56300.0
2006-04-12	AAUAF-DELISTED	Stock	3.01	3.04	2.94	3.04	56300.0
2006-04-12	AAV-DELISTED	Stock	19.32	19.36	19.15	19.31	159800.0
2006-04-12	AAWW-DELISTED	Stock	44.0	46.0	44.0	46.0	13300.0
2006-04-12	AAXN-DELISTED	Stock	10.0200004577637	10.1800003051758	9.90999984741211	10.1000003814697	1475200.0
2006-04-12	AB	Stock	67.77	69.95	67.77	69.85	446300.0
2006-04-12	ABAX-DELISTED	Stock	24.26	25.12	24.15	24.66	211013.0
2006-04-12	ABB-DELISTED	Stock	12.62	12.82	12.6	12.8099	932700.0
2006-04-12	ABBC-DELISTED	Stock	13.51	13.51	13.4	13.47	15879.0
2006-04-12	ABC-DELISTED	Stock	22.96	23.38	22.92	23.32	3381800.0
2006-04-12	ABCB	Stock	20.9604	20.9604	20.5033	20.8534	9048.0
2006-04-12	ABCO-DELISTED	Stock	26.88	27.04	26.56	26.85	115994.0
2006-04-12	ABCW-DELISTED	Stock	28.7	28.98	28.7	28.98	31090.0
2006-04-12	ABD-DELISTED	Stock	22.12	22.3	22.05	22.21	73800.0
2006-04-12	ABE-DELISTED	Stock	12.98	12.98	12.75	12.83	9200.0
2006-04-12	ABFS-DELISTED	Stock	39.17	39.279	38.45	39.21	279016.0
2006-04-12	ABG	Stock	18.57	18.64	18.4	18.53	24200.0
2006-04-12	ABK-DELISTED	Stock	77.75	78.2	77.41	78.0	378800.0
2006-04-12	ABM	Stock	17.56	17.62	17.31	17.52	305100.0
2006-04-12	ABMD-DELISTED	Stock	13.11	13.25	12.91	13.11	47999.0
2006-04-12	ABP-DELISTED	Stock	5.29	5.39	5.25	5.33	391700.0
2006-04-12	ABR	Stock	25.98	26.1	25.88	25.98	111800.0
2006-04-12	ABT	Stock	19.8877	19.9789	19.7726	19.9789	8264902.0
2006-04-12	ABTL-DELISTED	Stock	22.05	22.3	21.85	21.85	11889.0
2006-04-12	ABV-DELISTED	Stock	44.7	45.1	44.27	44.39	1033700.0
2006-04-12	ABX-DELISTED	Stock	28.77	29.17	28.58	28.94	3627300.0
2006-04-12	ACAD	Stock	14.6	15.04	14.6	14.91	179600.0
2006-04-12	ACAP-DELISTED	Stock	46.97	47.15	46.5	46.85	75329.0
2006-04-12	ACAS-DELISTED	Stock	34.66	34.72	34.2	34.3	975143.0
2006-04-12	ACAT-DELISTED	Stock	21.36	21.67	21.21	21.45	58849.0
2006-04-12	ACC-DELISTED	Stock	24.4	25.1	24.4	24.66	83000.0
2006-04-12	ACCL-DELISTED	Stock	7.24	7.42	7.2	7.3	65253.0
2006-04-12	ACCO	Stock	22.12	22.3	22.05	22.21	73900.0
2006-04-12	ACCP-DELISTED	Stock	1.3	1.35	1.2	1.25	42300.0
2006-04-12	ACE-DELISTED	Stock	51.0	51.18	50.5	50.85	897800.0

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

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