PREVIEW / stock_daily / 2008-03-18

all stock daily files

  file:    by_date/stock_daily/2008/2008-03-18.parquet
  size:    181 KB
  rows:    5,700
  symbols: 3,457

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-18	AAPL	Stock	4.6136	4.75	4.5954	4.7436	1205120000.0
2008-03-18	MSFT	Stock	28.67	29.48	28.67	29.42	83695300.0
2008-03-18	NVDA	Stock	0.457	0.475	0.444	0.4742	1075256000.0
2008-03-18	AMZN	Stock	3.4125	3.5965	3.3795	3.585	191014000.0
2008-03-18	TLT	Stock	95.3	96.16	94.95	95.36	4022366.0
2008-03-18	CL	Stock	38.53	38.815	38.205	38.805	5408000.0
2008-03-18	A	Stock	21.4592	21.8097	21.0944	21.7954	3676600.0
2008-03-18	AABA-DELISTED	Stock	26.95	27.71	26.25	27.71	36084014.0
2008-03-18	AACC-DELISTED	Stock	8.85	9.14	8.39	9.0	166589.0
2008-03-18	AACG	Stock	10.93	10.93	10.2	10.2	24300.0
2008-03-18	AAI-DELISTED	Stock	5.82	6.27	5.7	6.25	2533566.0
2008-03-18	AAIC-DELISTED	Stock	35.0	37.8	34.4	37.6	2084397.0
2008-03-18	AAME	Stock	1.48	1.48	1.47	1.47	1300.0
2008-03-18	AAON	Stock	3.5101	3.6286	3.4607	3.6286	634331.0
2008-03-18	AAP	Stock	32.75	33.19	32.05	32.71	1407000.0
2008-03-18	AATI-DELISTED	Stock	6.5	6.54	6.11	6.43	1117736.0
2008-03-18	AAU-DELISTED	Stock	2.64	2.64	2.43	2.5	49032.0
2008-03-18	AAUAF-DELISTED	Stock	2.64	2.64	2.43	2.5	51232.0
2008-03-18	AAV-DELISTED	Stock	11.09	11.2	10.91	11.07	671677.0
2008-03-18	AAWW-DELISTED	Stock	51.84	51.84	50.46	51.02	241190.0
2008-03-18	AAXN-DELISTED	Stock	9.61	10.08	9.51	10.02	1806900.0
2008-03-18	AB	Stock	58.19	60.44	58.01	60.38	512400.0
2008-03-18	ABAX-DELISTED	Stock	23.14	24.06	22.82	23.94	364380.0
2008-03-18	ABB-DELISTED	Stock	25.04	25.41	24.75	25.35	4802857.0
2008-03-18	ABBC-DELISTED	Stock	10.06	10.23	10.02	10.23	48090.0
2008-03-18	ABBNY-DELISTED	Stock	25.04	25.41	24.75	25.34	5172857.0
2008-03-18	ABC-DELISTED	Stock	19.88	20.08	19.67	20.0	3183770.0
2008-03-18	ABCB	Stock	15.4164	15.5623	14.9689	15.5234	40200.0
2008-03-18	ABCO-DELISTED	Stock	26.45	27.57	26.44	27.55	542783.0
2008-03-18	ABCW-DELISTED	Stock	18.345	19.046	18.104	18.945	224750.0
2008-03-18	ABD-DELISTED	Stock	13.77	14.16	13.43	13.92	429500.0
2008-03-18	ABE-DELISTED	Stock	21.68	22.37	21.37	22.37	57750.0
2008-03-18	ABEO	Stock	1875.0	1875.0	1875.0	1875.0	41.0
2008-03-18	ABFS-DELISTED	Stock	30.65	31.94	30.29	31.86	609602.0
2008-03-18	ABG	Stock	13.6	14.0	13.3	13.93	420400.0
2008-03-18	ABII-DELISTED	Stock	61.49	61.49	59.65	60.82	31507.0
2008-03-18	ABK-DELISTED	Stock	5.95	6.51	5.62	6.3	16212070.0
2008-03-18	ABM	Stock	20.17	20.84	19.88	20.77	254600.0
2008-03-18	ABMD-DELISTED	Stock	13.73	14.1899	13.64	14.03	239675.0
2008-03-18	ABP-DELISTED	Stock	3.55	3.55	3.35	3.4	189200.0
2008-03-18	ABR	Stock	14.61	15.26	14.61	15.26	330000.0
2008-03-18	ABT	Stock	25.6453	25.8564	25.2951	25.8228	12747603.0
2008-03-18	ABTL-DELISTED	Stock	12.477	12.477	9.771	10.473	47116.0
2008-03-18	ABV-DELISTED	Stock	79.48	82.74	78.97	82.37	718977.0
2008-03-18	ABVA-DELISTED	Stock	5.84	5.84	5.18	5.18	2881.0
2008-03-18	ABVT-DELISTED	Stock	64.5	65.0	64.0	64.5	8000.0
2008-03-18	ABX-DELISTED	Stock	53.02	53.02	49.43	49.62	8715831.0
2008-03-18	ACAD	Stock	8.09	8.5	7.63	8.05	296600.0
2008-03-18	ACAP-DELISTED	Stock	43.51	45.77	43.28	45.19	61036.0
2008-03-18	ACAS-DELISTED	Stock	35.24	35.54	34.1	35.25	1622669.0

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

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