PREVIEW / stock_daily / 2009-01-14

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-14.parquet
  size:    176 KB
  rows:    5,727
  symbols: 3,432

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
2009-01-14	AAPL	Stock	3.08	3.1161	3.0257	3.0475	1021664000.0
2009-01-14	MSFT	Stock	19.53	19.68	19.01	19.09	80257500.0
2009-01-14	NVDA	Stock	0.1845	0.1868	0.18	0.1828	974908000.0
2009-01-14	AMZN	Stock	2.505	2.505	2.407	2.4245	208852000.0
2009-01-14	TLT	Stock	114.65	116.04	114.65	115.9	2494759.0
2009-01-14	CL	Stock	32.06	32.125	31.1	31.41	7007600.0
2009-01-14	A	Stock	13.1617	13.3763	12.9041	13.1974	9148792.0
2009-01-14	AABA-DELISTED	Stock	12.26	12.53	11.81	12.41	24751721.0
2009-01-14	AACC-DELISTED	Stock	4.91	5.03	4.67	4.67	57818.0
2009-01-14	AACG	Stock	4.1	4.33	4.0	4.0	66800.0
2009-01-14	AAI-DELISTED	Stock	4.31	4.35	4.0	4.03	2245977.0
2009-01-14	AAIC-DELISTED	Stock	4.2	4.6	3.6	3.6	1152998.0
2009-01-14	AAME	Stock	0.86	0.86	0.81	0.81	1100.0
2009-01-14	AAON	Stock	3.7472	3.761	3.5753	3.6109	731025.0
2009-01-14	AAP	Stock	30.46	30.76	30.0	30.13	1065600.0
2009-01-14	AATI-DELISTED	Stock	3.01	3.03	2.94	2.95	110627.0
2009-01-14	AAU-DELISTED	Stock	0.64	0.65	0.61	0.61	79000.0
2009-01-14	AAUAF-DELISTED	Stock	0.64	0.65	0.61	0.61	80800.0
2009-01-14	AAV-DELISTED	Stock	4.52	4.57	4.35	4.39	321077.0
2009-01-14	AAWW-DELISTED	Stock	20.19	20.39	18.28	18.35	235651.0
2009-01-14	AAXJ	Stock	32.46	32.46	30.52	30.97	106691.0
2009-01-14	AAXN-DELISTED	Stock	5.03	5.32	4.87	4.92	477252.0
2009-01-14	AB	Stock	19.83	19.83	18.6	18.96	428100.0
2009-01-14	ABAX-DELISTED	Stock	14.5	14.7	13.93	14.17	197877.0
2009-01-14	ABB-DELISTED	Stock	12.4	12.43	11.93	12.22	5383793.0
2009-01-14	ABBC-DELISTED	Stock	8.58	8.62	8.16	8.17	77527.0
2009-01-14	ABBNY-DELISTED	Stock	12.4	12.43	11.93	12.22	5385029.0
2009-01-14	ABC-DELISTED	Stock	17.96	18.19	17.75	18.12	3390348.0
2009-01-14	ABCB	Stock	9.9307	10.0085	9.0164	9.2401	47911.0
2009-01-14	ABCO-DELISTED	Stock	10.287	10.332	9.873	9.973	180390.0
2009-01-14	ABCW-DELISTED	Stock	2.73	2.85	2.47	2.47	107060.0
2009-01-14	ABD-DELISTED	Stock	3.5	3.53	3.13	3.41	276840.0
2009-01-14	ABE-DELISTED	Stock	12.98	12.98	12.2	12.34	9423.0
2009-01-14	ABEO	Stock	1125.0	1250.0	1125.0	1250.0	9.0
2009-01-14	ABFS-DELISTED	Stock	25.08	25.08	23.63	23.93	629550.0
2009-01-14	ABG	Stock	4.42	4.42	3.62	3.63	395200.0
2009-01-14	ABII-DELISTED	Stock	67.02	68.45	67.02	67.97	4539.0
2009-01-14	ABK-DELISTED	Stock	1.24	1.25	1.15	1.16	12280410.0
2009-01-14	ABM	Stock	18.0	18.01	17.06	17.08	355100.0
2009-01-14	ABMD-DELISTED	Stock	13.76	13.76	12.75	12.79	185846.0
2009-01-14	ABR	Stock	2.9	2.92	2.74	2.77	140700.0
2009-01-14	ABT	Stock	23.9324	23.966	23.515	23.7357	16723426.0
2009-01-14	ABTL-DELISTED	Stock	2.5	2.7	2.4985	2.55	2445.0
2009-01-14	ABV-DELISTED	Stock	42.45	42.67	40.95	42.13	877717.0
2009-01-14	ABVA-DELISTED	Stock	1.69	1.69	1.46	1.46	300.0
2009-01-14	ABVT-DELISTED	Stock	30.3	32.0	30.25	32.0	8138.0
2009-01-14	ABX-DELISTED	Stock	31.98	33.03	31.07	31.52	14578848.0
2009-01-14	ACAD	Stock	1.13	1.26	1.12	1.12	136400.0
2009-01-14	ACAP-DELISTED	Stock	43.74	44.86	41.36	41.43	76968.0
2009-01-14	ACAS-DELISTED	Stock	4.84	5.02	4.46	4.75	3430908.0

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

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