PREVIEW / stock_daily / 2009-09-22

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-22.parquet
  size:    187 KB
  rows:    5,829
  symbols: 3,488

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-09-22	AAPL	Stock	6.6139	6.6207	6.5304	6.5886	356753600.0
2009-09-22	MSFT	Stock	25.4	25.82	25.29	25.77	61376700.0
2009-09-22	NVDA	Stock	0.3815	0.3838	0.3765	0.3795	361388000.0
2009-09-22	AMZN	Stock	4.573	4.7095	4.555	4.6875	165298000.0
2009-09-22	TLT	Stock	95.65	96.37	95.5099	96.18	2067965.0
2009-09-22	ES	Stock	24.51	24.51	23.77	23.93	1490300.0
2009-09-22	CL	Stock	37.84	37.955	37.625	37.83	5748400.0
2009-09-22	A	Stock	20.7153	20.7153	20.3076	20.4077	6613658.0
2009-09-22	AABA-DELISTED	Stock	17.18	17.22	16.75	16.86	30037306.0
2009-09-22	AACC-DELISTED	Stock	7.69	7.83	7.63	7.66	27354.0
2009-09-22	AACG	Stock	6.57	6.69	6.49	6.49	12900.0
2009-09-22	AAI-DELISTED	Stock	7.01	7.07	6.8	6.8	1244813.0
2009-09-22	AAIC-DELISTED	Stock	9.6	11.6	9.6	11.6	2196340.0
2009-09-22	AAME	Stock	0.78	1.03	0.78	0.93	32300.0
2009-09-22	AAON	Stock	4.1383	4.164	4.0672	4.083	397912.0
2009-09-22	AAP	Stock	40.19	40.79	40.12	40.32	2441800.0
2009-09-22	AATI-DELISTED	Stock	4.32	4.39	4.28	4.31	208508.0
2009-09-22	AAU-DELISTED	Stock	0.69	0.75	0.6711	0.73	483273.0
2009-09-22	AAUAF-DELISTED	Stock	0.69	0.75	0.6711	0.73	496773.0
2009-09-22	AAV-DELISTED	Stock	6.97	7.24	6.93	7.16	1262891.0
2009-09-22	AAWW-DELISTED	Stock	32.06	33.48	31.36	33.29	305430.0
2009-09-22	AAXJ	Stock	53.26	53.26	52.68	53.21	472239.0
2009-09-22	AAXN-DELISTED	Stock	4.69	4.72	4.59	4.65	336440.0
2009-09-22	AB	Stock	25.79	27.4	25.66	27.22	1080400.0
2009-09-22	ABAX-DELISTED	Stock	28.85	28.86	28.36	28.42	82429.0
2009-09-22	ABB-DELISTED	Stock	20.95	20.95	20.75	20.87	3039468.0
2009-09-22	ABBC-DELISTED	Stock	8.0	8.03	7.79	7.82	28906.0
2009-09-22	ABBNY-DELISTED	Stock	20.95	20.95	20.75	20.91	3042776.0
2009-09-22	ABC-DELISTED	Stock	21.99	22.0	21.65	21.69	2111967.0
2009-09-22	ABCB	Stock	7.042	7.3338	6.8085	7.2656	26423.0
2009-09-22	ABCO-DELISTED	Stock	13.432	13.522	13.238	13.253	94706.0
2009-09-22	ABCW-DELISTED	Stock	1.3399	1.3793	1.3098	1.33	67350.0
2009-09-22	ABD-DELISTED	Stock	7.11	7.48	7.04	7.39	514990.0
2009-09-22	ABE-DELISTED	Stock	17.64	17.67	17.41	17.45	28305.0
2009-09-22	ABEO	Stock	3937.5	4375.0	3937.5	4362.5	20.0
2009-09-22	ABFS-DELISTED	Stock	32.58	33.0891	31.9	31.94	456567.0
2009-09-22	ABG	Stock	13.63	13.82	13.42	13.66	322600.0
2009-09-22	ABII-DELISTED	Stock	29.97	30.75	29.7	30.05	58628.0
2009-09-22	ABK-DELISTED	Stock	1.7	2.02	1.67	1.87	107115533.0
2009-09-22	ABM	Stock	21.05	21.05	20.63	20.71	155800.0
2009-09-22	ABMD-DELISTED	Stock	9.35	9.6	9.1	9.38	330491.0
2009-09-22	ABR	Stock	2.61	3.25	2.61	3.24	1689400.0
2009-09-22	ABT	Stock	22.3923	22.517	22.2627	22.4211	17101292.0
2009-09-22	ABTL-DELISTED	Stock	3.35	3.35	3.015	3.1	6671.0
2009-09-22	ABV-DELISTED	Stock	80.45	80.83	79.85	80.45	449383.0
2009-09-22	ABVA-DELISTED	Stock	2.6	2.7	2.5995	2.6	47007.0
2009-09-22	ABVT-DELISTED	Stock	46.15	46.54	45.24	45.93	134242.0
2009-09-22	ABX-DELISTED	Stock	37.46	37.8	36.98	37.52	14763015.0
2009-09-22	ACAD	Stock	1.89	1.91	1.85	1.91	1129600.0
2009-09-22	ACAP-DELISTED	Stock	29.84	29.84	29.24	29.5	50746.0

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

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