PREVIEW / stock_daily / 2012-11-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-27.parquet
  size:    201 KB
  rows:    6,200
  symbols: 3,509

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
2012-11-27	AAPL	Stock	21.0554	21.0864	20.7179	20.885	533330000.0
2012-11-27	MSFT	Stock	27.36	27.38	27.04	27.08	45018600.0
2012-11-27	NVDA	Stock	0.3015	0.3085	0.299	0.304	451404000.0
2012-11-27	AMZN	Stock	12.161	12.2835	12.077	12.17	60970000.0
2012-11-27	META	Stock	26.04	26.5	25.46	26.15	85760600.0
2012-11-27	TSLA	Stock	2.142	2.1773	2.1013	2.1433	13662000.0
2012-11-27	TLT	Stock	124.94	125.39	124.7	125.29	2544314.0
2012-11-27	ES	Stock	38.18	38.65	38.12	38.39	1356800.0
2012-11-27	CL	Stock	53.925	54.24	53.715	53.82	2469400.0
2012-11-27	A	Stock	26.7239	26.9313	26.4521	26.7096	4802689.0
2012-11-27	AABA-DELISTED	Stock	18.87	19.16	18.8	18.92	28666189.0
2012-11-27	AACC-DELISTED	Stock	4.35	4.5	4.15	4.43	25538.0
2012-11-27	AACG	Stock	4.42	4.55	4.26	4.32	12400.0
2012-11-27	AAIC-DELISTED	Stock	20.9	21.24	20.8201	21.15	123793.0
2012-11-27	AAME	Stock	2.93	2.94	2.93	2.94	300.0
2012-11-27	AAMRQ-DELISTED	Stock	0.51	0.511	0.461	0.495	13431398.0
2012-11-27	AAON	Stock	6.083	6.2341	6.083	6.2222	318600.0
2012-11-27	AAP	Stock	78.06	78.07	76.03	76.61	1326100.0
2012-11-27	AAT	Stock	27.74	28.2	27.5	28.0	144500.0
2012-11-27	AAU-DELISTED	Stock	2.72	2.79	2.72	2.74	162396.0
2012-11-27	AAUAF-DELISTED	Stock	2.71	2.78	2.71	2.75	164078.0
2012-11-27	AAV-DELISTED	Stock	3.35	3.37	3.33	3.35	658492.0
2012-11-27	AAWW-DELISTED	Stock	42.6	43.11	41.17	41.91	264046.0
2012-11-27	AAXJ	Stock	57.32	57.48	57.13	57.18	214688.0
2012-11-27	AAXN-DELISTED	Stock	8.49	8.99	8.4401	8.72	1351753.0
2012-11-27	AB	Stock	18.03	18.19	17.93	18.08	480600.0
2012-11-27	ABAC-DELISTED	Stock	0.8	0.9101	0.8	0.85	26679.0
2012-11-27	ABAX-DELISTED	Stock	37.13	37.31	36.65	36.87	56091.0
2012-11-27	ABB-DELISTED	Stock	18.85	18.98	18.78	18.85	2099739.0
2012-11-27	ABBNY-DELISTED	Stock	18.85	18.98	18.78	18.86	2167715.0
2012-11-27	ABC-DELISTED	Stock	41.18	41.51	41.08	41.23	2324400.0
2012-11-27	ABCB	Stock	10.78	11.32	10.75	11.02	55700.0
2012-11-27	ABCD-DELISTED	Stock	1.0	1.03	0.93	1.0	7435.0
2012-11-27	ABCO-DELISTED	Stock	43.37	44.09	43.09	43.98	193326.0
2012-11-27	ABCW-DELISTED	Stock	0.38	0.42	0.38	0.41	30745.0
2012-11-27	ABE-DELISTED	Stock	20.12	20.3599	20.12	20.25	41082.0
2012-11-27	ABEO	Stock	312.5	462.5	312.5	462.5	25.0
2012-11-27	ABFS-DELISTED	Stock	8.02	8.56	8.02	8.48	504470.0
2012-11-27	ABG	Stock	29.87	30.3	29.68	29.86	446300.0
2012-11-27	ABM	Stock	18.97	19.02	18.85	18.95	134800.0
2012-11-27	ABMD-DELISTED	Stock	14.25	14.94	14.19	14.65	802762.0
2012-11-27	ABR	Stock	5.2	5.26	5.14	5.19	65400.0
2012-11-27	ABT	Stock	30.7696	30.9567	30.6736	30.736	10685911.0
2012-11-27	ABTL-DELISTED	Stock	3.92	4.0	3.8	3.87	9221.0
2012-11-27	ABUS	Stock	5.78	5.78	5.27	5.28	94800.0
2012-11-27	ABV-DELISTED	Stock	41.17	41.26	40.79	40.89	1874138.0
2012-11-27	ABVA-DELISTED	Stock	4.5699	4.72	4.5	4.62	6500.0
2012-11-27	ABX-DELISTED	Stock	35.2	35.3	34.51	34.54	5817730.0
2012-11-27	ACAD	Stock	6.5	6.54	5.06	5.43	60106100.0
2012-11-27	ACAS-DELISTED	Stock	11.89	11.92	11.81	11.86	1908167.0

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

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