PREVIEW / stock_daily / 2014-03-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-21.parquet
  size:    221 KB
  rows:    6,524
  symbols: 3,555

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
2014-03-21	AAPL	Stock	18.9975	19.0625	18.7975	19.0311	374046400.0
2014-03-21	MSFT	Stock	40.72	40.94	40.01	40.16	80721800.0
2014-03-21	NVDA	Stock	0.4683	0.472	0.461	0.4635	566116000.0
2014-03-21	AMZN	Stock	18.55	18.642	17.92	18.031	108282000.0
2014-03-21	META	Stock	67.53	67.92	66.18	67.24	59999900.0
2014-03-21	TSLA	Stock	15.7347	15.7467	15.1667	15.2593	123253500.0
2014-03-21	TLT	Stock	107.41	108.32	107.37	108.23	8986860.0
2014-03-21	ES	Stock	44.25	44.88	44.09	44.42	2046700.0
2014-03-21	CL	Stock	64.06	64.13	63.32	63.46	5963400.0
2014-03-21	A	Stock	40.9013	41.3305	40.0286	40.1216	3862534.0
2014-03-21	AABA-DELISTED	Stock	37.95	38.27	37.73	37.925	15210573.0
2014-03-21	AACG	Stock	4.22	4.24	4.18	4.18	2700.0
2014-03-21	AAIC-DELISTED	Stock	28.0	28.28	27.9601	28.19	212819.0
2014-03-21	AAL	Stock	36.76	36.82	35.91	36.11	14110700.0
2014-03-21	AAMC-DELISTED	Stock	307.3529	319.1941	292.6941	319.1941	66048.0
2014-03-21	AAME	Stock	3.66	3.75	3.54	3.74	4700.0
2014-03-21	AAOI	Stock	25.68	26.03	25.05	25.47	234500.0
2014-03-21	AAON	Stock	12.9644	13.1333	12.6311	12.7778	512775.0
2014-03-21	AAP	Stock	125.58	127.92	124.31	126.33	1985700.0
2014-03-21	AAT	Stock	33.57	34.18	33.53	34.04	257300.0
2014-03-21	AAU-DELISTED	Stock	1.52	1.53	1.4	1.4	250816.0
2014-03-21	AAUAF-DELISTED	Stock	1.52	1.53	1.4	1.4	251826.0
2014-03-21	AAV-DELISTED	Stock	4.3	4.4	4.26	4.36	219988.0
2014-03-21	AAWW-DELISTED	Stock	32.75	34.01	32.5375	34.0	412499.0
2014-03-21	AAXJ	Stock	56.95	57.41	56.7425	56.85	452137.0
2014-03-21	AAXN-DELISTED	Stock	18.2	18.48	18.09	18.1	1099472.0
2014-03-21	AB	Stock	25.71	25.9	25.32	25.77	391700.0
2014-03-21	ABAC-DELISTED	Stock	1.7373	1.81	1.73	1.77	27953.0
2014-03-21	ABAX-DELISTED	Stock	39.71	39.73	38.36	38.52	131912.0
2014-03-21	ABB-DELISTED	Stock	25.2	25.25	24.96	24.99	1171771.0
2014-03-21	ABBNY-DELISTED	Stock	25.2	25.25	24.96	24.99	1240758.0
2014-03-21	ABBV	Stock	54.22	54.73	53.09	53.46	12930500.0
2014-03-21	ABC-DELISTED	Stock	66.55	66.63	64.56	64.82	3292568.0
2014-03-21	ABCB	Stock	24.0	24.0	23.48	23.75	235400.0
2014-03-21	ABCD-DELISTED	Stock	2.16	2.18	2.03	2.112	48348.0
2014-03-21	ABCO-DELISTED	Stock	69.54	70.14	67.38	67.53	203916.0
2014-03-21	ABE-DELISTED	Stock	12.58	12.738	12.58	12.65	17723.0
2014-03-21	ABEO	Stock	650.0	737.5	625.0	737.5	134.0
2014-03-21	ABEV	Stock	7.14	7.36	7.12	7.15	11651200.0
2014-03-21	ABFS-DELISTED	Stock	36.27	37.45	36.05	37.16	494574.0
2014-03-21	ABG	Stock	54.27	55.1	53.96	55.05	318400.0
2014-03-21	ABGB-DELISTED	Stock	23.5	23.6	23.15	23.15	17471.0
2014-03-21	ABIL-DELISTED	Stock	9.62	9.73	9.62	9.67	5568.0
2014-03-21	ABM	Stock	28.79	29.11	28.75	28.91	499100.0
2014-03-21	ABMD-DELISTED	Stock	27.47	27.48	26.68	26.8401	740385.0
2014-03-21	ABR	Stock	6.71	6.95	6.71	6.95	191700.0
2014-03-21	ABR.A-DELISTED	Stock	24.52	24.65	24.4	24.4	21737.0
2014-03-21	ABR.B-DELISTED	Stock	22.92	22.98	22.87	22.98	48332.0
2014-03-21	ABR.C-DELISTED	Stock	24.88	24.88	24.75	24.85	18096.0
2014-03-21	ABT	Stock	39.21	39.6	38.36	38.39	21663000.0

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

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