PREVIEW / stock_daily / 2014-03-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-06.parquet
  size:    218 KB
  rows:    6,483
  symbols: 3,528

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-06	AAPL	Stock	19.0282	19.0871	18.8607	18.9554	185488800.0
2014-03-06	MSFT	Stock	38.14	38.24	37.89	38.15	23582200.0
2014-03-06	NVDA	Stock	0.4668	0.4692	0.4588	0.4595	290144000.0
2014-03-06	AMZN	Stock	18.7025	18.7665	18.445	18.608	58532000.0
2014-03-06	META	Stock	71.88	71.89	70.25	70.84	46026500.0
2014-03-06	TSLA	Stock	16.9427	17.1667	16.63	16.8627	110416500.0
2014-03-06	TLT	Stock	106.76	106.969	106.52	106.56	7418274.0
2014-03-06	ES	Stock	43.83	43.89	43.4	43.5	1600400.0
2014-03-06	CL	Stock	62.78	63.19	62.64	63.02	2665900.0
2014-03-06	A	Stock	41.7668	42.432	41.588	42.0386	7239962.0
2014-03-06	AABA-DELISTED	Stock	39.6	39.98	39.5	39.67	9678833.0
2014-03-06	AACG	Stock	4.16	4.5	4.1	4.25	34500.0
2014-03-06	AAIC-DELISTED	Stock	27.24	27.5799	27.04	27.31	116332.0
2014-03-06	AAL	Stock	38.28	39.33	38.28	38.81	14006200.0
2014-03-06	AAMC-DELISTED	Stock	221.2941	236.8338	221.2941	230.8265	61180.0
2014-03-06	AAME	Stock	3.86	3.89	3.82	3.85	6200.0
2014-03-06	AAOI	Stock	25.0	26.45	24.93	26.36	223800.0
2014-03-06	AAON	Stock	13.7467	13.8578	13.3422	13.64	188550.0
2014-03-06	AAP	Stock	126.23	127.32	125.86	126.74	715100.0
2014-03-06	AAT	Stock	33.47	33.49	32.99	33.18	105800.0
2014-03-06	AAU-DELISTED	Stock	1.65	1.65	1.6	1.6	106533.0
2014-03-06	AAUAF-DELISTED	Stock	1.65	1.65	1.6	1.6	108527.0
2014-03-06	AAV-DELISTED	Stock	4.05	4.19	4.05	4.16	251111.0
2014-03-06	AAWW-DELISTED	Stock	31.47	32.45	31.31	32.42	239315.0
2014-03-06	AAXJ	Stock	58.63	59.1	58.63	58.93	1409339.0
2014-03-06	AAXN-DELISTED	Stock	19.83	19.95	19.51	19.64	663139.0
2014-03-06	AB	Stock	24.17	24.27	23.7	23.93	280100.0
2014-03-06	ABAC-DELISTED	Stock	2.25	2.35	1.83	2.07	295668.0
2014-03-06	ABAX-DELISTED	Stock	38.86	39.18	38.615	39.0	115769.0
2014-03-06	ABB-DELISTED	Stock	25.95	26.0	25.87	25.92	810939.0
2014-03-06	ABBNY-DELISTED	Stock	25.95	26.0	25.87	25.93	847175.0
2014-03-06	ABBV	Stock	52.04	52.77	51.97	52.04	6529000.0
2014-03-06	ABC-DELISTED	Stock	69.0	69.45	68.75	68.78	1380524.0
2014-03-06	ABCB	Stock	21.23	21.57	21.15	21.39	55400.0
2014-03-06	ABCD-DELISTED	Stock	2.01	2.0701	2.0	2.04	44660.0
2014-03-06	ABCO-DELISTED	Stock	66.93	67.1	66.04	66.85	196227.0
2014-03-06	ABE-DELISTED	Stock	12.42	12.76	12.42	12.71	120957.0
2014-03-06	ABEO	Stock	487.5	487.5	462.5	487.5	31.0
2014-03-06	ABEV	Stock	7.27	7.36	7.2	7.25	16727600.0
2014-03-06	ABFS-DELISTED	Stock	35.88	36.68	35.55	36.66	357661.0
2014-03-06	ABG	Stock	52.96	54.13	52.96	53.98	343600.0
2014-03-06	ABGB-DELISTED	Stock	23.7	23.83	23.48	23.48	4852.0
2014-03-06	ABM	Stock	28.22	28.36	27.97	28.28	383100.0
2014-03-06	ABMD-DELISTED	Stock	29.25	29.75	29.02	29.61	276619.0
2014-03-06	ABR	Stock	6.82	6.84	6.69	6.77	130600.0
2014-03-06	ABR.A-DELISTED	Stock	24.17	24.44	24.17	24.39	3750.0
2014-03-06	ABR.B-DELISTED	Stock	22.996	23.0	22.8909	22.93	6731.0
2014-03-06	ABR.C-DELISTED	Stock	24.21	24.44	24.15	24.29	51667.0
2014-03-06	ABT	Stock	39.92	40.23	39.73	39.73	6442000.0
2014-03-06	ABTL-DELISTED	Stock	14.95	15.1185	13.31	14.13	914784.0

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

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