PREVIEW / stock_daily / 2016-02-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-23.parquet
  size:    217 KB
  rows:    6,552
  symbols: 3,326

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
2016-02-23	AAPL	Stock	24.1	24.125	23.6375	23.6725	127770400.0
2016-02-23	MSFT	Stock	52.34	52.37	50.98	51.18	28895300.0
2016-02-23	NVDA	Stock	0.7818	0.7975	0.778	0.79	369380000.0
2016-02-23	AMZN	Stock	27.7775	27.8455	27.2665	27.647	81016000.0
2016-02-23	GOOGL	Stock	36.305	36.545	35.7835	35.8645	41331320.0
2016-02-23	META	Stock	106.85	107.47	105.12	105.46	25319300.0
2016-02-23	TSLA	Stock	11.744	12.1153	11.5787	11.814	89766000.0
2016-02-23	TLT	Stock	129.88	131.74	129.78	131.47	8320727.0
2016-02-23	ES	Stock	55.02	56.0	55.02	55.84	1595600.0
2016-02-23	CL	Stock	67.39	67.71	67.02	67.2	2083200.0
2016-02-23	A	Stock	37.64	37.96	36.95	37.17	1282300.0
2016-02-23	AA.B-DELISTED	Stock	30.65	30.65	29.51	29.51	29252.0
2016-02-23	AAAP-DELISTED	Stock	32.24	32.82	30.195	31.33	74088.0
2016-02-23	AABA-DELISTED	Stock	31.2	31.3801	30.505	30.68	16395641.0
2016-02-23	AAC-DELISTED	Stock	22.13	24.11	21.69	23.2	517999.0
2016-02-23	AACG	Stock	4.96	4.96	4.38	4.39	11000.0
2016-02-23	AAIC-DELISTED	Stock	11.84	11.94	11.75	11.82	193128.0
2016-02-23	AAL	Stock	40.56	40.81	40.17	40.38	6432200.0
2016-02-23	AAMC-DELISTED	Stock	5.6206	5.8235	5.2956	5.4	311913.0
2016-02-23	AAME	Stock	4.33	4.33	4.33	4.33	1200.0
2016-02-23	AAMI	Stock	11.44	12.47	10.83	11.17	334200.0
2016-02-23	AAOI	Stock	16.3	16.78	16.071	16.45	233400.0
2016-02-23	AAON	Stock	14.28	14.52	14.2333	14.2333	147150.0
2016-02-23	AAP	Stock	148.44	151.34	147.37	147.55	698300.0
2016-02-23	AAT	Stock	36.37	36.76	36.23	36.4	113400.0
2016-02-23	AAU-DELISTED	Stock	0.771	0.8	0.73	0.79	129453.0
2016-02-23	AAUAF-DELISTED	Stock	0.771	0.8	0.73	0.79	130135.0
2016-02-23	AAV-DELISTED	Stock	5.28	5.28	5.03	5.07	52223.0
2016-02-23	AAVL-DELISTED	Stock	5.49	5.569	5.26	5.35	375555.0
2016-02-23	AAWW-DELISTED	Stock	36.36	36.89	35.565	35.62	216005.0
2016-02-23	AAXJ	Stock	49.65	49.69	49.21	49.24	396849.0
2016-02-23	AAXN-DELISTED	Stock	17.13	17.27	16.96	17.0	619629.0
2016-02-23	AB	Stock	18.77	18.98	18.33	18.63	220300.0
2016-02-23	ABAC-DELISTED	Stock	0.651	0.651	0.601	0.601	1450.0
2016-02-23	ABAX-DELISTED	Stock	39.29	39.66	38.93	39.23	269203.0
2016-02-23	ABB-DELISTED	Stock	17.79	17.87	17.62	17.65	1435465.0
2016-02-23	ABBNY-DELISTED	Stock	17.79	17.87	17.62	17.65	1461635.0
2016-02-23	ABBV	Stock	55.7	56.31	55.0	55.07	8629700.0
2016-02-23	ABC-DELISTED	Stock	87.69	88.1899	86.86	87.35	1470717.0
2016-02-23	ABCB	Stock	26.38	26.72	26.02	26.29	164500.0
2016-02-23	ABCD-DELISTED	Stock	4.23	4.39	4.07	4.09	43391.0
2016-02-23	ABCO-DELISTED	Stock	36.81	37.06	35.84	36.24	549577.0
2016-02-23	ABCW-DELISTED	Stock	41.76	41.76	40.96	41.235	142983.0
2016-02-23	ABDC-DELISTED	Stock	9.28	9.6	9.265	9.38	35003.0
2016-02-23	ABE-DELISTED	Stock	10.51	10.556	10.496	10.52	3730.0
2016-02-23	ABEO	Stock	62.25	64.25	59.25	59.5	2600.0
2016-02-23	ABEV	Stock	4.62	4.64	4.53	4.57	13570900.0
2016-02-23	ABG	Stock	55.73	59.46	55.11	56.02	926500.0
2016-02-23	ABGB-DELISTED	Stock	0.76	0.79	0.76	0.79	3218.0
2016-02-23	ABIL-DELISTED	Stock	7.19	7.2	6.9	6.92	4692.0

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

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