PREVIEW / stock_daily / 2015-02-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-27.parquet
  size:    223 KB
  rows:    6,641
  symbols: 3,519

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
2015-02-27	AAPL	Stock	32.5	32.6425	32.06	32.115	248059200.0
2015-02-27	MSFT	Stock	44.13	44.2	43.66	43.85	33807700.0
2015-02-27	NVDA	Stock	0.5535	0.5548	0.5495	0.5515	157492000.0
2015-02-27	AMZN	Stock	19.2	19.2995	18.9895	19.008	50646000.0
2015-02-27	GOOGL	Stock	27.9075	28.471	27.8515	28.1315	68328900.0
2015-02-27	META	Stock	80.68	81.23	78.62	78.97	30739200.0
2015-02-27	TSLA	Stock	13.7933	13.9033	13.52	13.556	58231500.0
2015-02-27	TLT	Stock	129.02	129.62	128.27	129.53	9225087.0
2015-02-27	ES	Stock	51.87	52.0	51.44	51.75	1176600.0
2015-02-27	CL	Stock	71.04	71.13	70.73	70.82	1997300.0
2015-02-27	A	Stock	42.3	42.36	42.05	42.21	1676400.0
2015-02-27	AA.B-DELISTED	Stock	49.26	49.3163	48.35	48.4	90030.0
2015-02-27	AABA-DELISTED	Stock	44.38	44.57	44.045	44.28	9445217.0
2015-02-27	AAC-DELISTED	Stock	36.5	37.25	34.59	35.99	122007.0
2015-02-27	AACG	Stock	4.16	4.23	4.05	4.05	9700.0
2015-02-27	AAIC-DELISTED	Stock	25.3	25.42	24.97	24.99	788605.0
2015-02-27	AAL	Stock	49.0	49.4	47.85	47.9	9396400.0
2015-02-27	AAMC-DELISTED	Stock	56.4676	56.4676	52.0735	52.0735	62846.0
2015-02-27	AAME	Stock	4.02	4.03	3.93	4.0	2600.0
2015-02-27	AAMI	Stock	17.63	18.49	17.63	17.96	514300.0
2015-02-27	AAOI	Stock	11.7	12.66	11.55	12.48	457600.0
2015-02-27	AAON	Stock	15.8333	15.9	14.9733	15.0067	486750.0
2015-02-27	AAP	Stock	155.74	156.24	154.63	154.93	718500.0
2015-02-27	AAT	Stock	40.61	41.37	40.61	41.02	320600.0
2015-02-27	AAU-DELISTED	Stock	1.13	1.1619	1.1	1.11	154236.0
2015-02-27	AAUAF-DELISTED	Stock	1.09	1.12	1.07	1.11	160691.0
2015-02-27	AAV-DELISTED	Stock	5.32	5.33	5.18	5.19	105084.0
2015-02-27	AAVL-DELISTED	Stock	36.77	37.45	35.92	36.19	154207.0
2015-02-27	AAWW-DELISTED	Stock	45.64	46.04	45.32	45.33	286448.0
2015-02-27	AAXJ	Stock	63.96	64.1	63.82	63.83	820487.0
2015-02-27	AAXN-DELISTED	Stock	23.41	23.93	23.1	23.475	5631369.0
2015-02-27	AB	Stock	28.36	28.66	28.3	28.64	418200.0
2015-02-27	ABAC-DELISTED	Stock	1.5001	1.51	1.45	1.49	2950.0
2015-02-27	ABAX-DELISTED	Stock	61.14	61.93	60.92	60.92	106822.0
2015-02-27	ABB-DELISTED	Stock	21.54	21.57	21.37	21.39	1728806.0
2015-02-27	ABBNY-DELISTED	Stock	21.54	21.57	21.37	21.39	1881311.0
2015-02-27	ABBV	Stock	60.53	60.99	60.37	60.5	8649100.0
2015-02-27	ABC-DELISTED	Stock	103.08	103.31	102.49	102.77	1200285.0
2015-02-27	ABCB	Stock	26.23	26.35	26.05	26.17	156000.0
2015-02-27	ABCD-DELISTED	Stock	2.67	2.67	2.67	2.67	300.0
2015-02-27	ABCO-DELISTED	Stock	54.46	54.93	53.9	54.12	207447.0
2015-02-27	ABCW-DELISTED	Stock	34.64	35.0	34.375	34.9	8667.0
2015-02-27	ABDC-DELISTED	Stock	13.8628	14.0	13.8628	14.0	47447.0
2015-02-27	ABE-DELISTED	Stock	13.29	13.32	13.18	13.32	13472.0
2015-02-27	ABEO	Stock	80.0	85.75	79.25	82.5	660.0
2015-02-27	ABEOW-DELISTED	Stock	0.9998	1.0	0.78	0.94	50301.0
2015-02-27	ABEV	Stock	6.42	6.61	6.42	6.45	16463300.0
2015-02-27	ABG	Stock	79.02	79.1	78.02	78.67	213200.0
2015-02-27	ABGB-DELISTED	Stock	16.9	17.09	16.76	16.76	44434.0
2015-02-27	ABIL-DELISTED	Stock	9.87	9.95	9.85	9.91	7500.0

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

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