PREVIEW / stock_daily / 2009-01-26

all stock daily files

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

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-26	AAPL	Stock	3.1736	3.2489	3.1536	3.2014	692238400.0
2009-01-26	MSFT	Stock	17.29	17.81	17.23	17.63	92476500.0
2009-01-26	NVDA	Stock	0.1938	0.205	0.1905	0.1992	581748000.0
2009-01-26	AMZN	Stock	2.509	2.5445	2.426	2.4815	143114000.0
2009-01-26	TLT	Stock	107.43	107.82	106.3	106.75	2240814.0
2009-01-26	CL	Stock	30.84	31.16	30.585	30.89	4914200.0
2009-01-26	A	Stock	13.3691	13.8484	13.3047	13.5265	5797925.0
2009-01-26	AABA-DELISTED	Stock	11.26	11.33	10.81	11.16	16570694.0
2009-01-26	AACC-DELISTED	Stock	3.8	4.29	3.76	4.04	72736.0
2009-01-26	AACG	Stock	3.45	3.66	2.75	3.66	34500.0
2009-01-26	AAI-DELISTED	Stock	4.4	4.73	4.4	4.49	1384587.0
2009-01-26	AAIC-DELISTED	Stock	3.4	3.8	3.2	3.6	256506.0
2009-01-26	AAON	Stock	3.3798	3.601	3.36	3.5575	576112.0
2009-01-26	AAP	Stock	32.32	33.51	32.32	32.77	1567700.0
2009-01-26	AATI-DELISTED	Stock	3.02	3.26	3.02	3.18	105608.0
2009-01-26	AAU-DELISTED	Stock	0.76	0.76	0.7	0.749	73962.0
2009-01-26	AAUAF-DELISTED	Stock	0.76	0.76	0.7	0.749	72962.0
2009-01-26	AAV-DELISTED	Stock	4.38	4.46	4.26	4.29	988313.0
2009-01-26	AAWW-DELISTED	Stock	16.17	16.94	15.77	16.61	228061.0
2009-01-26	AAXJ	Stock	30.37	30.83	29.92	30.03	48181.0
2009-01-26	AAXN-DELISTED	Stock	5.25	5.25	4.93	5.06	433297.0
2009-01-26	AB	Stock	17.1	17.77	17.1	17.68	927700.0
2009-01-26	ABAX-DELISTED	Stock	13.5	14.2	13.5	14.0	176966.0
2009-01-26	ABB-DELISTED	Stock	11.97	12.45	11.93	12.2	5197825.0
2009-01-26	ABBC-DELISTED	Stock	6.99	7.34	6.99	7.26	73767.0
2009-01-26	ABBNY-DELISTED	Stock	11.97	12.45	11.93	12.2	5279325.0
2009-01-26	ABC-DELISTED	Stock	18.08	18.6	18.08	18.41	5762648.0
2009-01-26	ABCB	Stock	7.5963	8.4717	7.5963	7.9757	13674.0
2009-01-26	ABCO-DELISTED	Stock	9.085	9.085	8.67	8.96	236722.0
2009-01-26	ABCW-DELISTED	Stock	2.41	2.49	2.22	2.24	52080.0
2009-01-26	ABD-DELISTED	Stock	1.8	1.83	1.75	1.77	181040.0
2009-01-26	ABE-DELISTED	Stock	11.77	12.34	11.77	12.1	17322.0
2009-01-26	ABEO	Stock	1025.0	1125.0	1025.0	1062.5	8.0
2009-01-26	ABFS-DELISTED	Stock	22.81	23.532	22.15	22.52	577151.0
2009-01-26	ABG	Stock	3.46	4.34	3.46	3.86	325600.0
2009-01-26	ABII-DELISTED	Stock	70.45	70.45	67.47	69.0	19615.0
2009-01-26	ABK-DELISTED	Stock	1.1	1.15	1.03	1.04	9717623.0
2009-01-26	ABM	Stock	16.3	16.86	15.54	15.98	440600.0
2009-01-26	ABMD-DELISTED	Stock	12.88	13.25	12.58	12.67	272898.0
2009-01-26	ABR	Stock	2.15	2.6	2.15	2.24	117100.0
2009-01-26	ABT	Stock	25.5014	26.1443	25.1175	25.9332	23680700.0
2009-01-26	ABTL-DELISTED	Stock	2.1	2.3	2.06	2.25	1408.0
2009-01-26	ABV-DELISTED	Stock	40.94	41.39	40.11	40.28	682699.0
2009-01-26	ABVA-DELISTED	Stock	1.495	1.55	1.495	1.55	294.0
2009-01-26	ABX-DELISTED	Stock	40.64	40.9	37.52	38.1	19235996.0
2009-01-26	ACAD	Stock	1.12	1.25	1.11	1.23	88000.0
2009-01-26	ACAP-DELISTED	Stock	39.68	41.48	39.48	40.66	65108.0
2009-01-26	ACAS-DELISTED	Stock	4.12	4.4	3.92	4.0	3524925.0
2009-01-26	ACAT-DELISTED	Stock	4.66	4.99	4.6	4.74	42971.0
2009-01-26	ACC-DELISTED	Stock	20.93	21.63	20.72	21.08	602702.0

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

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