PREVIEW / stock_daily / 2009-09-17

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-17.parquet
  size:    187 KB
  rows:    5,834
  symbols: 3,474

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-17	AAPL	Stock	6.4993	6.6711	6.4989	6.5911	810572000.0
2009-09-17	MSFT	Stock	25.06	25.38	25.06	25.3	42428800.0
2009-09-17	NVDA	Stock	0.3975	0.3975	0.3743	0.381	923096000.0
2009-09-17	AMZN	Stock	4.5375	4.5595	4.45	4.522	157454000.0
2009-09-17	TLT	Stock	95.69	96.73	95.1703	96.62	2831914.0
2009-09-17	ES	Stock	24.72	24.78	24.48	24.51	874200.0
2009-09-17	CL	Stock	37.765	38.13	37.57	37.63	4281000.0
2009-09-17	A	Stock	20.4506	20.6152	20.1574	20.3791	5478762.0
2009-09-17	AABA-DELISTED	Stock	17.0	17.79	16.96	17.5	60406924.0
2009-09-17	AACC-DELISTED	Stock	7.77	7.94	7.42	7.81	29277.0
2009-09-17	AACG	Stock	7.04	7.04	6.75	6.76	16500.0
2009-09-17	AAI-DELISTED	Stock	6.75	6.99	6.47	6.67	2340895.0
2009-09-17	AAIC-DELISTED	Stock	10.2	10.2	9.6	9.8	272791.0
2009-09-17	AAME	Stock	0.73	0.74	0.72	0.72	3000.0
2009-09-17	AAON	Stock	4.1225	4.2311	4.1106	4.1462	410062.0
2009-09-17	AAP	Stock	38.64	39.4	38.57	38.71	1876300.0
2009-09-17	AATI-DELISTED	Stock	4.49	4.5	4.3	4.36	176063.0
2009-09-17	AAU-DELISTED	Stock	0.69	0.719	0.67	0.68	244511.0
2009-09-17	AAUAF-DELISTED	Stock	0.69	0.719	0.67	0.68	245611.0
2009-09-17	AAV-DELISTED	Stock	6.83	6.9395	6.63	6.79	1274714.0
2009-09-17	AAWW-DELISTED	Stock	31.05	31.95	31.01	31.76	703895.0
2009-09-17	AAXJ	Stock	53.12	53.36	52.63	53.0	299667.0
2009-09-17	AAXN-DELISTED	Stock	4.75	4.87	4.62	4.69	502754.0
2009-09-17	AB	Stock	25.66	26.36	25.13	25.13	433400.0
2009-09-17	ABAX-DELISTED	Stock	29.33	29.8	28.86	28.92	249557.0
2009-09-17	ABB-DELISTED	Stock	20.36	20.62	20.18	20.37	4514692.0
2009-09-17	ABBC-DELISTED	Stock	7.71	7.79	7.67	7.79	12598.0
2009-09-17	ABBNY-DELISTED	Stock	20.36	20.62	20.18	20.33	4518070.0
2009-09-17	ABC-DELISTED	Stock	21.77	21.8	21.54	21.57	6209364.0
2009-09-17	ABCB	Stock	6.3513	6.4973	6.3416	6.4389	10693.0
2009-09-17	ABCO-DELISTED	Stock	13.493	13.513	13.307	13.337	74480.0
2009-09-17	ABCW-DELISTED	Stock	1.32	1.45	1.25	1.4	103540.0
2009-09-17	ABD-DELISTED	Stock	6.58	7.671	6.58	7.17	809370.0
2009-09-17	ABE-DELISTED	Stock	17.05	17.32	16.9705	17.12	20578.0
2009-09-17	ABEO	Stock	4550.0	4550.0	4125.0	4125.0	99.0
2009-09-17	ABFS-DELISTED	Stock	33.49	34.35	32.39	32.84	707028.0
2009-09-17	ABG	Stock	14.78	14.78	13.9	14.0	374800.0
2009-09-17	ABII-DELISTED	Stock	28.5	29.99	28.47	29.4	71577.0
2009-09-17	ABK-DELISTED	Stock	1.65	1.73	1.61	1.62	10289071.0
2009-09-17	ABM	Stock	21.0	21.14	20.81	20.96	112300.0
2009-09-17	ABMD-DELISTED	Stock	8.94	9.25	8.94	9.2	343950.0
2009-09-17	ABR	Stock	2.12	2.65	2.12	2.65	1350600.0
2009-09-17	ABT	Stock	22.4259	22.5506	22.2435	22.2435	14515215.0
2009-09-17	ABTL-DELISTED	Stock	3.0015	3.5035	3.0015	3.4985	113386.0
2009-09-17	ABV-DELISTED	Stock	79.28	80.15	79.22	79.49	543011.0
2009-09-17	ABVA-DELISTED	Stock	2.671	2.671	2.671	2.671	100.0
2009-09-17	ABVT-DELISTED	Stock	45.35	45.35	44.06	44.2	31183.0
2009-09-17	ABX-DELISTED	Stock	38.13	39.07	37.56	38.06	16381703.0
2009-09-17	ACAD	Stock	1.95	1.98	1.91	1.92	1108000.0
2009-09-17	ACAP-DELISTED	Stock	30.7	31.2999	30.66	30.71	32423.0

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

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