PREVIEW / stock_daily / 2011-12-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-01.parquet
  size:    196 KB
  rows:    6,118
  symbols: 3,551

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
2011-12-01	AAPL	Stock	13.6621	13.8929	13.5982	13.8546	387181200.0
2011-12-01	MSFT	Stock	25.56	25.63	25.2	25.28	48545400.0
2011-12-01	NVDA	Stock	0.3875	0.3965	0.3858	0.3955	529760000.0
2011-12-01	AMZN	Stock	9.5925	9.9035	9.5795	9.8565	146554000.0
2011-12-01	TSLA	Stock	2.1713	2.266	2.132	2.1733	15453000.0
2011-12-01	TLT	Stock	116.29	117.239	115.8	117.0	9647137.0
2011-12-01	ES	Stock	34.63	35.0	34.48	34.85	1603900.0
2011-12-01	CL	Stock	45.605	45.99	44.995	45.055	5925600.0
2011-12-01	A	Stock	26.681	27.4535	26.5021	27.0529	4444522.0
2011-12-01	AABA-DELISTED	Stock	16.43	16.46	16.09	16.23	46070091.0
2011-12-01	AACC-DELISTED	Stock	3.56	3.99	3.54	3.54	49946.0
2011-12-01	AACG	Stock	9.41	9.62	9.41	9.49	2900.0
2011-12-01	AAIC-DELISTED	Stock	19.89	20.05	19.57	19.6	45241.0
2011-12-01	AAME	Stock	1.98	1.99	1.92	1.99	4000.0
2011-12-01	AAON	Stock	6.4563	6.563	6.2193	6.2252	222413.0
2011-12-01	AAP	Stock	68.94	70.17	68.65	68.75	695000.0
2011-12-01	AAT	Stock	20.65	20.66	20.12	20.44	454000.0
2011-12-01	AATI-DELISTED	Stock	5.75	5.76	5.75	5.75	1333186.0
2011-12-01	AAU-DELISTED	Stock	2.7	2.7914	2.6499	2.66	69143.0
2011-12-01	AAUAF-DELISTED	Stock	2.7	2.76	2.62	2.66	70527.0
2011-12-01	AAV-DELISTED	Stock	4.56	4.78	4.56	4.75	346299.0
2011-12-01	AAWW-DELISTED	Stock	41.95	42.11	40.06	40.07	253107.0
2011-12-01	AAXJ	Stock	52.34	52.87	52.34	52.49	522709.0
2011-12-01	AAXN-DELISTED	Stock	5.99	6.22	5.86	6.14	573899.0
2011-12-01	AB	Stock	13.34	13.39	13.12	13.26	330700.0
2011-12-01	ABAC-DELISTED	Stock	1.63	1.6799	1.55	1.55	11707.0
2011-12-01	ABAX-DELISTED	Stock	27.49	27.99	27.22	27.22	66073.0
2011-12-01	ABB-DELISTED	Stock	18.78	19.01	18.63	18.69	2261138.0
2011-12-01	ABBNY-DELISTED	Stock	18.78	19.01	18.63	18.68	2414029.0
2011-12-01	ABC-DELISTED	Stock	37.02	37.47	36.96	37.24	2151512.0
2011-12-01	ABCB	Stock	9.97	9.97	9.75	9.81	56000.0
2011-12-01	ABCD-DELISTED	Stock	3.17	3.18	3.04	3.04	40053.0
2011-12-01	ABCO-DELISTED	Stock	36.23	36.58	36.1	36.2	191520.0
2011-12-01	ABCW-DELISTED	Stock	0.3514	0.3916	0.3514	0.3815	77200.0
2011-12-01	ABD-DELISTED	Stock	9.35	9.6	9.19	9.27	385670.0
2011-12-01	ABE-DELISTED	Stock	17.84	18.19	17.74	18.01	9804.0
2011-12-01	ABEO	Stock	1600.0	1837.5	1600.0	1837.5	51.0
2011-12-01	ABFS-DELISTED	Stock	19.16	19.31	18.68	18.75	220966.0
2011-12-01	ABG	Stock	19.59	20.02	19.35	19.78	400100.0
2011-12-01	ABH-DELISTED	Stock	15.05	15.21	14.8	14.8	299768.0
2011-12-01	ABM	Stock	21.68	21.89	21.31	21.37	698300.0
2011-12-01	ABMD-DELISTED	Stock	19.95	20.14	19.7129	19.91	229591.0
2011-12-01	ABR	Stock	3.42	3.5	3.37	3.45	46400.0
2011-12-01	ABT	Stock	26.0004	26.2882	26.0004	26.1587	15006878.0
2011-12-01	ABTL-DELISTED	Stock	3.4876	3.8364	3.3471	3.5624	19665.0
2011-12-01	ABUS	Stock	1.61	1.61	1.61	1.61	1400.0
2011-12-01	ABV-DELISTED	Stock	34.34	34.98	34.2	34.69	2556037.0
2011-12-01	ABVA-DELISTED	Stock	3.77	3.8	3.77	3.77	5198.0
2011-12-01	ABVT-DELISTED	Stock	59.88	60.87	59.23	59.52	212569.0
2011-12-01	ABX-DELISTED	Stock	52.51	53.0	52.1	52.78	5442263.0

> showing 50 of 6,118 rows — these rows as CSV

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