PREVIEW / stock_daily / 2014-03-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-03.parquet
  size:    218 KB
  rows:    6,486
  symbols: 3,540

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-03	AAPL	Stock	18.6936	18.9518	18.6718	18.8486	238781200.0
2014-03-03	MSFT	Stock	37.92	38.13	37.49	37.78	29717500.0
2014-03-03	NVDA	Stock	0.4492	0.4572	0.4452	0.4572	375948000.0
2014-03-03	AMZN	Stock	17.937	18.048	17.724	17.989	55966000.0
2014-03-03	META	Stock	66.96	68.05	66.51	67.41	56824100.0
2014-03-03	TSLA	Stock	15.8173	16.7767	15.666	16.704	196339500.0
2014-03-03	TLT	Stock	108.88	109.18	108.64	109.03	11099175.0
2014-03-03	ES	Stock	44.29	44.51	43.84	43.95	1441400.0
2014-03-03	CL	Stock	62.23	62.63	62.0	62.22	2714800.0
2014-03-03	A	Stock	40.1431	40.8584	39.907	40.5651	3478783.0
2014-03-03	AABA-DELISTED	Stock	37.63	38.66	37.43	38.25	13979367.0
2014-03-03	AACG	Stock	4.2	4.3	4.19	4.22	6300.0
2014-03-03	AAIC-DELISTED	Stock	26.4	26.64	26.31	26.42	161257.0
2014-03-03	AAL	Stock	36.17	36.4	35.32	36.1	9495500.0
2014-03-03	AAMC-DELISTED	Stock	223.8235	230.0	214.4235	226.35	32582.0
2014-03-03	AAME	Stock	3.95	3.95	3.91	3.91	3600.0
2014-03-03	AAOI	Stock	22.88	25.49	22.01	25.11	270100.0
2014-03-03	AAON	Stock	12.9956	13.0267	12.5556	12.9111	436050.0
2014-03-03	AAP	Stock	125.92	127.18	125.13	126.28	777200.0
2014-03-03	AAT	Stock	32.89	33.32	32.69	33.18	122900.0
2014-03-03	AAU-DELISTED	Stock	1.65	1.72	1.65	1.66	106633.0
2014-03-03	AAUAF-DELISTED	Stock	1.65	1.72	1.65	1.66	108432.0
2014-03-03	AAV-DELISTED	Stock	4.08	4.09	4.05	4.06	135054.0
2014-03-03	AAWW-DELISTED	Stock	29.84	30.3325	29.81	30.14	279853.0
2014-03-03	AAXJ	Stock	57.62	57.69	57.24	57.63	871036.0
2014-03-03	AAXN-DELISTED	Stock	19.11	19.79	18.801	19.57	1127825.0
2014-03-03	AB	Stock	24.15	24.22	23.35	23.79	358300.0
2014-03-03	ABAC-DELISTED	Stock	1.81	1.87	1.81	1.86	16737.0
2014-03-03	ABAX-DELISTED	Stock	37.65	38.11	37.47	37.73	94402.0
2014-03-03	ABB-DELISTED	Stock	25.06	25.14	24.83	24.96	1360287.0
2014-03-03	ABBNY-DELISTED	Stock	25.06	25.14	24.83	24.95	1458367.0
2014-03-03	ABBV	Stock	50.34	50.86	49.79	50.09	6817700.0
2014-03-03	ABC-DELISTED	Stock	67.11	67.69	66.965	67.49	1247135.0
2014-03-03	ABCB	Stock	20.78	21.07	20.45	20.66	81800.0
2014-03-03	ABCD-DELISTED	Stock	1.99	2.07	1.95	1.96	21755.0
2014-03-03	ABCO-DELISTED	Stock	63.62	64.22	62.73	64.22	164650.0
2014-03-03	ABE-DELISTED	Stock	12.4	12.48	12.4	12.43	12198.0
2014-03-03	ABEO	Stock	462.5	487.5	450.0	462.5	19.0
2014-03-03	ABEV	Stock	7.14	7.17	6.93	7.08	5935900.0
2014-03-03	ABFS-DELISTED	Stock	32.84	33.38	32.0501	32.8	223190.0
2014-03-03	ABG	Stock	50.5	51.17	50.06	50.78	353100.0
2014-03-03	ABGB-DELISTED	Stock	22.94	22.94	22.39	22.5529	18820.0
2014-03-03	ABIL-DELISTED	Stock	9.61	9.62	9.61	9.62	1047.0
2014-03-03	ABM	Stock	27.93	28.25	27.8	28.23	185200.0
2014-03-03	ABMD-DELISTED	Stock	28.0	28.234	27.41	27.74	331729.0
2014-03-03	ABR	Stock	6.86	6.88	6.74	6.88	69200.0
2014-03-03	ABR.A-DELISTED	Stock	24.1	24.27	24.01	24.2	4340.0
2014-03-03	ABR.B-DELISTED	Stock	23.0	23.0	22.95	22.9833	9492.0
2014-03-03	ABR.C-DELISTED	Stock	24.37	24.37	24.11	24.13	25890.0
2014-03-03	ABT	Stock	39.5	39.64	38.83	39.33	11006300.0

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

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