PREVIEW / stock_daily / 2008-03-27

all stock daily files

  file:    by_date/stock_daily/2008/2008-03-27.parquet
  size:    181 KB
  rows:    5,681
  symbols: 3,435

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
2008-03-27	AAPL	Stock	5.1768	5.1896	4.9996	5.0089	999829600.0
2008-03-27	MSFT	Stock	28.48	28.49	28.0	28.05	47894400.0
2008-03-27	NVDA	Stock	0.4843	0.498	0.4768	0.4848	601308000.0
2008-03-27	AMZN	Stock	3.7185	3.7345	3.54	3.54	158848000.0
2008-03-27	TLT	Stock	94.64	95.36	94.54	94.63	2405670.0
2008-03-27	CL	Stock	38.94	39.035	38.615	38.85	4563600.0
2008-03-27	A	Stock	21.4592	21.4878	20.8941	20.9013	3697151.0
2008-03-27	AABA-DELISTED	Stock	28.49	28.5	27.9	28.12	15200881.0
2008-03-27	AACC-DELISTED	Stock	9.96	9.99	9.65	9.81	141327.0
2008-03-27	AACG	Stock	9.16	9.43	8.02	9.05	107400.0
2008-03-27	AAI-DELISTED	Stock	6.46	7.07	6.27	6.82	4019298.0
2008-03-27	AAIC-DELISTED	Stock	39.0	39.6	34.6	34.8	1732755.0
2008-03-27	AAME	Stock	1.44	1.45	1.43	1.44	7900.0
2008-03-27	AAON	Stock	4.0731	4.0731	3.8973	3.9052	342225.0
2008-03-27	AAP	Stock	35.17	35.2	33.85	33.91	1141700.0
2008-03-27	AATI-DELISTED	Stock	6.02	6.13	5.62	5.8	2500403.0
2008-03-27	AAU-DELISTED	Stock	2.4	2.4	2.25	2.34	25200.0
2008-03-27	AAUAF-DELISTED	Stock	2.4	2.4	2.25	2.34	27600.0
2008-03-27	AAV-DELISTED	Stock	11.6	11.6	11.39	11.44	476490.0
2008-03-27	AAWW-DELISTED	Stock	53.4	53.5	52.83	52.98	57727.0
2008-03-27	AAXN-DELISTED	Stock	10.17	10.39	9.83	9.89	1547525.0
2008-03-27	AB	Stock	66.01	66.91	64.84	65.15	286200.0
2008-03-27	ABAX-DELISTED	Stock	22.89	23.6	22.74	23.12	342586.0
2008-03-27	ABB-DELISTED	Stock	26.83	26.87	26.34	26.4	4942386.0
2008-03-27	ABBC-DELISTED	Stock	10.55	10.55	10.38	10.44	70526.0
2008-03-27	ABBNY-DELISTED	Stock	26.83	26.87	26.34	26.38	5299386.0
2008-03-27	ABC-DELISTED	Stock	20.83	20.83	20.38	20.46	3455862.0
2008-03-27	ABCB	Stock	16.0778	16.1459	15.3191	15.5428	46574.0
2008-03-27	ABCO-DELISTED	Stock	27.27	27.62	26.94	27.0	346969.0
2008-03-27	ABCW-DELISTED	Stock	19.835	19.835	19.018	19.105	269510.0
2008-03-27	ABD-DELISTED	Stock	13.21	13.36	12.96	13.11	219890.0
2008-03-27	ABE-DELISTED	Stock	21.32	22.18	20.7	21.78	22139.0
2008-03-27	ABEO	Stock	1712.5	1750.0	1637.5	1687.5	13.0
2008-03-27	ABFS-DELISTED	Stock	32.29	32.42	31.34	31.46	981470.0
2008-03-27	ABG	Stock	14.94	15.08	14.22	14.23	400100.0
2008-03-27	ABII-DELISTED	Stock	60.25	60.4999	60.01	60.34	11509.0
2008-03-27	ABK-DELISTED	Stock	6.5	6.54	6.0	6.03	14805313.0
2008-03-27	ABM	Stock	22.07	22.8	21.95	22.36	381000.0
2008-03-27	ABMD-DELISTED	Stock	14.0	14.44	13.516	14.33	192595.0
2008-03-27	ABP-DELISTED	Stock	3.29	3.35	3.26	3.28	103804.0
2008-03-27	ABR	Stock	15.56	15.99	15.5	15.56	68000.0
2008-03-27	ABT	Stock	26.0339	26.0819	25.6261	25.6933	10788662.0
2008-03-27	ABTL-DELISTED	Stock	10.149	10.2	9.946	10.2	33526.0
2008-03-27	ABV-DELISTED	Stock	79.73	80.1	77.77	78.07	527500.0
2008-03-27	ABVA-DELISTED	Stock	5.34	5.45	5.31	5.31	13100.0
2008-03-27	ABVT-DELISTED	Stock	64.5	66.0	62.0	66.0	14550.0
2008-03-27	ABX-DELISTED	Stock	45.55	45.88	44.8	45.08	7622917.0
2008-03-27	ACAD	Stock	9.53	10.03	9.51	9.81	411700.0
2008-03-27	ACAP-DELISTED	Stock	46.54	47.05	46.04	46.64	38676.0
2008-03-27	ACAS-DELISTED	Stock	36.1	36.1	35.43	35.47	4398648.0

> showing 50 of 5,681 rows — these rows as CSV

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