PREVIEW / stock_daily / 2009-01-28

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-28.parquet
  size:    175 KB
  rows:    5,720
  symbols: 3,415

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-28	AAPL	Stock	3.29	3.3929	3.2679	3.3643	861406000.0
2009-01-28	MSFT	Stock	17.8	18.31	17.76	18.04	64145500.0
2009-01-28	NVDA	Stock	0.2185	0.2232	0.2115	0.2198	723752000.0
2009-01-28	AMZN	Stock	2.486	2.5745	2.4485	2.518	161132000.0
2009-01-28	TLT	Stock	109.31	109.81	105.72	106.53	4348083.0
2009-01-28	CL	Stock	31.315	32.17	31.095	31.925	8023400.0
2009-01-28	A	Stock	13.5336	13.8555	13.3977	13.5622	7473149.0
2009-01-28	AABA-DELISTED	Stock	12.24	12.38	11.92	12.17	36298029.0
2009-01-28	AACC-DELISTED	Stock	4.2	4.45	4.13	4.45	37412.0
2009-01-28	AACG	Stock	3.7	4.12	3.41	4.12	14900.0
2009-01-28	AAI-DELISTED	Stock	4.31	4.49	4.16	4.35	3001000.0
2009-01-28	AAIC-DELISTED	Stock	3.98	4.378	3.204	4.0	553018.0
2009-01-28	AAME	Stock	0.92	0.92	0.92	0.92	200.0
2009-01-28	AAON	Stock	3.7057	3.8538	3.6741	3.7847	506250.0
2009-01-28	AAP	Stock	33.73	34.55	33.48	34.4	1432100.0
2009-01-28	AATI-DELISTED	Stock	3.53	3.57	3.41	3.44	103346.0
2009-01-28	AAU-DELISTED	Stock	0.73	0.75	0.71	0.72	44500.0
2009-01-28	AAUAF-DELISTED	Stock	0.73	0.75	0.71	0.72	44600.0
2009-01-28	AAV-DELISTED	Stock	4.37	4.41	4.29	4.34	669631.0
2009-01-28	AAWW-DELISTED	Stock	17.19	17.54	16.79	17.38	143909.0
2009-01-28	AAXJ	Stock	32.07	32.47	30.67	32.47	40810.0
2009-01-28	AAXN-DELISTED	Stock	5.18	5.35	5.17	5.35	465632.0
2009-01-28	AB	Stock	18.42	19.99	18.35	19.77	597100.0
2009-01-28	ABAX-DELISTED	Stock	14.37	14.83	14.25	14.66	147888.0
2009-01-28	ABB-DELISTED	Stock	13.43	13.62	13.18	13.44	4914659.0
2009-01-28	ABBC-DELISTED	Stock	7.65	7.89	7.464	7.56	93513.0
2009-01-28	ABBNY-DELISTED	Stock	13.43	13.62	13.18	13.43	4929416.0
2009-01-28	ABC-DELISTED	Stock	18.86	18.9	18.61	18.88	4879298.0
2009-01-28	ABCB	Stock	8.676	9.5416	8.676	9.4833	21179.0
2009-01-28	ABCO-DELISTED	Stock	9.15	9.385	8.995	9.005	475905.0
2009-01-28	ABCW-DELISTED	Stock	2.49	2.49	2.1	2.38	111010.0
2009-01-28	ABD-DELISTED	Stock	1.79	1.8	1.56	1.65	280860.0
2009-01-28	ABE-DELISTED	Stock	12.59	12.75	12.59	12.75	10649.0
2009-01-28	ABEO	Stock	1125.0	1125.0	1037.5	1125.0	6.0
2009-01-28	ABFS-DELISTED	Stock	23.65	24.93	23.65	23.81	798335.0
2009-01-28	ABG	Stock	3.99	4.2	3.82	4.13	260400.0
2009-01-28	ABII-DELISTED	Stock	66.92	67.58	66.0	67.0	14960.0
2009-01-28	ABK-DELISTED	Stock	1.21	1.29	1.16	1.28	18909459.0
2009-01-28	ABM	Stock	16.31	16.72	16.0	16.5	230400.0
2009-01-28	ABMD-DELISTED	Stock	13.53	14.21	13.53	14.16	313545.0
2009-01-28	ABR	Stock	1.84	2.03	1.84	2.02	254100.0
2009-01-28	ABT	Stock	26.2499	26.4514	25.866	26.3698	29094831.0
2009-01-28	ABTL-DELISTED	Stock	2.1	2.1	1.6	2.05	11880.0
2009-01-28	ABV-DELISTED	Stock	42.1	42.14	40.585	41.01	1283921.0
2009-01-28	ABVA-DELISTED	Stock	1.6	1.6	1.35	1.6	5435.0
2009-01-28	ABVT-DELISTED	Stock	35.0	35.0	33.0	33.0	250.0
2009-01-28	ABX-DELISTED	Stock	37.45	37.67	35.53	36.31	16041908.0
2009-01-28	ACAD	Stock	1.23	1.23	1.12	1.14	98400.0
2009-01-28	ACAP-DELISTED	Stock	42.82	44.02	41.28	43.76	52401.0
2009-01-28	ACAS-DELISTED	Stock	4.44	4.4431	4.029	4.12	4653547.0

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

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