PREVIEW / stock_daily / 2009-09-11

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-11.parquet
  size:    185 KB
  rows:    5,809
  symbols: 3,452

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-11	AAPL	Stock	6.1754	6.185	6.1025	6.1486	348961200.0
2009-09-11	MSFT	Stock	24.93	25.17	24.81	24.86	54303500.0
2009-09-11	NVDA	Stock	0.4108	0.4122	0.405	0.408	712732000.0
2009-09-11	AMZN	Stock	4.222	4.245	4.188	4.227	120138000.0
2009-09-11	TLT	Stock	96.82	97.68	96.6	96.7	4826128.0
2009-09-11	ES	Stock	23.68	23.75	23.41	23.68	1463100.0
2009-09-11	CL	Stock	37.125	37.845	37.125	37.615	9739400.0
2009-09-11	A	Stock	19.9428	20.1431	19.8498	20.0644	6138338.0
2009-09-11	AABA-DELISTED	Stock	15.55	15.68	15.41	15.59	25921451.0
2009-09-11	AACC-DELISTED	Stock	7.63	7.72	7.38	7.43	11160.0
2009-09-11	AACG	Stock	6.75	6.75	6.61	6.62	3600.0
2009-09-11	AAI-DELISTED	Stock	6.7	6.7	6.45	6.54	1497180.0
2009-09-11	AAIC-DELISTED	Stock	9.4	9.8	9.4	9.6	291791.0
2009-09-11	AAME	Stock	0.83	0.87	0.72	0.72	2500.0
2009-09-11	AAON	Stock	3.9802	4.0198	3.9388	4.0138	312862.0
2009-09-11	AAP	Stock	40.65	40.65	38.08	39.15	7883700.0
2009-09-11	AATI-DELISTED	Stock	4.65	4.65	4.54	4.55	73885.0
2009-09-11	AAU-DELISTED	Stock	0.71	0.72	0.67	0.69	351696.0
2009-09-11	AAUAF-DELISTED	Stock	0.71	0.72	0.67	0.69	352496.0
2009-09-11	AAV-DELISTED	Stock	6.2	6.32	6.15	6.27	922475.0
2009-09-11	AAWW-DELISTED	Stock	27.0	29.97	26.93	29.0	616778.0
2009-09-11	AAXJ	Stock	52.19	52.19	51.58	51.75	1141525.0
2009-09-11	AAXN-DELISTED	Stock	4.53	4.68	4.5	4.65	608655.0
2009-09-11	AB	Stock	25.26	25.69	23.93	24.09	840000.0
2009-09-11	ABAX-DELISTED	Stock	28.07	28.45	27.51	27.56	110761.0
2009-09-11	ABB-DELISTED	Stock	20.62	20.68	20.3	20.5	4010319.0
2009-09-11	ABBC-DELISTED	Stock	7.77	7.79	7.52	7.66	110003.0
2009-09-11	ABBNY-DELISTED	Stock	20.62	20.68	20.3	20.54	4015419.0
2009-09-11	ABC-DELISTED	Stock	21.59	21.7	21.505	21.64	1947919.0
2009-09-11	ABCB	Stock	6.0693	6.0693	5.8942	5.9039	8533.0
2009-09-11	ABCO-DELISTED	Stock	13.713	13.843	13.437	13.512	89035.0
2009-09-11	ABCW-DELISTED	Stock	1.2	1.2294	1.2	1.2	23140.0
2009-09-11	ABD-DELISTED	Stock	5.87	5.99	5.75	5.88	251210.0
2009-09-11	ABE-DELISTED	Stock	16.69	16.92	16.69	16.91	11576.0
2009-09-11	ABEO	Stock	4425.0	4625.0	4375.0	4375.0	66.0
2009-09-11	ABFS-DELISTED	Stock	33.82	33.97	33.28	33.97	607487.0
2009-09-11	ABG	Stock	14.04	14.72	13.93	14.12	320100.0
2009-09-11	ABII-DELISTED	Stock	26.17	26.47	25.81	26.46	37838.0
2009-09-11	ABK-DELISTED	Stock	1.66	1.66	1.59	1.62	9351740.0
2009-09-11	ABM	Stock	20.56	20.8	20.35	20.51	131300.0
2009-09-11	ABMD-DELISTED	Stock	8.08	8.15	7.9	7.98	66612.0
2009-09-11	ABR	Stock	1.9	1.92	1.82	1.88	123500.0
2009-09-11	ABT	Stock	22.4978	22.541	22.3395	22.469	16682368.0
2009-09-11	ABTL-DELISTED	Stock	3.0	3.0	2.9495	2.95	3460.0
2009-09-11	ABV-DELISTED	Stock	76.74	76.74	75.73	75.9	776283.0
2009-09-11	ABVA-DELISTED	Stock	2.7685	2.7685	2.7685	2.7685	100.0
2009-09-11	ABVT-DELISTED	Stock	45.17	45.86	44.77	44.77	38169.0
2009-09-11	ABX-DELISTED	Stock	38.72	38.93	37.81	38.18	18791162.0
2009-09-11	ACAD	Stock	1.97	1.99	1.93	1.93	1283300.0
2009-09-11	ACAP-DELISTED	Stock	31.52	31.88	31.29	31.33	34611.0

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

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