PREVIEW / stock_daily / 2014-02-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-27.parquet
  size:    217 KB
  rows:    6,473
  symbols: 3,545

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-02-27	AAPL	Stock	18.4693	18.885	18.4304	18.8454	301882000.0
2014-02-27	MSFT	Stock	37.45	37.89	37.23	37.86	33903400.0
2014-02-27	NVDA	Stock	0.4678	0.4725	0.4612	0.4625	388848000.0
2014-02-27	AMZN	Stock	17.861	18.0295	17.775	18.0065	62098000.0
2014-02-27	META	Stock	69.34	70.01	68.87	68.94	41653700.0
2014-02-27	TSLA	Stock	17.4167	17.46	16.5553	16.836	269187000.0
2014-02-27	TLT	Stock	108.28	108.56	108.1	108.51	5394718.0
2014-02-27	ES	Stock	43.9	44.19	43.82	44.03	2020300.0
2014-02-27	CL	Stock	61.74	62.21	61.62	62.12	2469700.0
2014-02-27	A	Stock	40.7868	40.9728	40.1931	40.3147	4367072.0
2014-02-27	AABA-DELISTED	Stock	37.8	38.475	37.74	38.46	14377899.0
2014-02-27	AACG	Stock	4.0	4.05	4.0	4.05	3000.0
2014-02-27	AAIC-DELISTED	Stock	26.46	26.55	26.31	26.45	67489.0
2014-02-27	AAL	Stock	36.88	36.95	36.34	36.56	5657000.0
2014-02-27	AAMC-DELISTED	Stock	227.0588	239.6971	214.7059	235.2941	230860.0
2014-02-27	AAME	Stock	3.95	3.98	3.91	3.94	14400.0
2014-02-27	AAOI	Stock	19.7	20.0	18.94	19.2	196200.0
2014-02-27	AAON	Stock	12.8222	13.12	12.7511	13.1067	168975.0
2014-02-27	AAP	Stock	125.82	126.09	124.43	125.03	888100.0
2014-02-27	AAT	Stock	33.3	33.53	33.09	33.2	86800.0
2014-02-27	AAU-DELISTED	Stock	1.53	1.6	1.52	1.55	93584.0
2014-02-27	AAUAF-DELISTED	Stock	1.56	1.62	1.55	1.55	92387.0
2014-02-27	AAV-DELISTED	Stock	4.03	4.08	3.97	3.99	99762.0
2014-02-27	AAWW-DELISTED	Stock	31.36	32.04	31.11	31.28	517765.0
2014-02-27	AAXJ	Stock	58.05	58.47	57.99	58.38	150765.0
2014-02-27	AAXN-DELISTED	Stock	18.97	20.83	18.75	20.5	2910603.0
2014-02-27	AB	Stock	24.07	24.22	23.97	23.97	261000.0
2014-02-27	ABAC-DELISTED	Stock	1.88	1.88	1.8341	1.8341	13665.0
2014-02-27	ABAX-DELISTED	Stock	38.73	39.19	38.29	39.11	93499.0
2014-02-27	ABB-DELISTED	Stock	25.16	25.39	25.12	25.325	826542.0
2014-02-27	ABBNY-DELISTED	Stock	25.15	25.39	25.12	25.33	1658546.0
2014-02-27	ABBV	Stock	50.6	50.92	50.47	50.91	5052900.0
2014-02-27	ABC-DELISTED	Stock	68.01	68.31	67.65	68.02	1279031.0
2014-02-27	ABCB	Stock	20.71	20.93	20.5	20.88	42500.0
2014-02-27	ABCD-DELISTED	Stock	1.96	2.0	1.95	2.0	12495.0
2014-02-27	ABCO-DELISTED	Stock	64.29	64.46	63.81	63.92	329598.0
2014-02-27	ABE-DELISTED	Stock	12.4	12.49	12.4	12.45	100994.0
2014-02-27	ABEO	Stock	487.5	487.5	487.5	487.5	1.0
2014-02-27	ABEV	Stock	7.17	7.29	7.07	7.23	6903800.0
2014-02-27	ABFS-DELISTED	Stock	33.59	34.16	32.53	33.7	272197.0
2014-02-27	ABG	Stock	50.36	51.38	50.19	51.37	181200.0
2014-02-27	ABGB-DELISTED	Stock	22.35	22.799	22.13	22.79	7537.0
2014-02-27	ABIL-DELISTED	Stock	9.62	9.63	9.62	9.63	599.0
2014-02-27	ABM	Stock	27.97	28.18	27.84	28.12	159800.0
2014-02-27	ABMD-DELISTED	Stock	28.8	29.11	28.74	29.11	365388.0
2014-02-27	ABR	Stock	6.77	6.84	6.72	6.82	56800.0
2014-02-27	ABR.A-DELISTED	Stock	23.98	24.0	23.98	24.0	1700.0
2014-02-27	ABR.B-DELISTED	Stock	22.84	23.0	22.84	23.0	4766.0
2014-02-27	ABT	Stock	39.35	39.83	39.33	39.79	9189600.0
2014-02-27	ABTL-DELISTED	Stock	15.96	16.1999	15.511	16.0	152464.0

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

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