PREVIEW / stock_daily / 2015-12-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-12-17.parquet
  size:    223 KB
  rows:    6,671
  symbols: 3,423

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-12-17	AAPL	Stock	28.005	28.0625	27.245	27.245	179091200.0
2015-12-17	MSFT	Stock	56.36	56.79	55.53	55.7	41280900.0
2015-12-17	NVDA	Stock	0.8305	0.839	0.8162	0.8168	254160000.0
2015-12-17	AMZN	Stock	34.0	34.125	33.5325	33.5325	73632000.0
2015-12-17	GOOGL	Stock	39.058	39.0795	38.465	38.4915	36510760.0
2015-12-17	META	Stock	107.49	107.75	106.13	106.22	21675700.0
2015-12-17	TSLA	Stock	15.596	15.8507	15.3207	15.5593	49479000.0
2015-12-17	TLT	Stock	121.78	122.78	121.64	122.55	9922991.0
2015-12-17	ES	Stock	51.11	51.92	51.11	51.72	1806100.0
2015-12-17	CL	Stock	68.19	68.3	67.3	67.33	4224800.0
2015-12-17	A	Stock	41.55	41.63	40.77	40.78	2218800.0
2015-12-17	AA.B-DELISTED	Stock	31.43	31.43	30.68	31.04	201324.0
2015-12-17	AAAP-DELISTED	Stock	29.3499	29.9	28.92	29.48	26503.0
2015-12-17	AABA-DELISTED	Stock	33.81	34.075	33.11	33.23	12139161.0
2015-12-17	AAC-DELISTED	Stock	22.23	23.69	22.23	22.73	321543.0
2015-12-17	AACG	Stock	6.09	6.15	5.96	6.08	60900.0
2015-12-17	AAIC-DELISTED	Stock	13.51	13.97	13.51	13.97	510406.0
2015-12-17	AAL	Stock	43.33	43.95	42.45	42.46	7225000.0
2015-12-17	AAMC-DELISTED	Stock	4.2324	4.3676	4.0588	4.1059	190437.0
2015-12-17	AAME	Stock	4.67	4.74	4.67	4.69	2400.0
2015-12-17	AAMI	Stock	14.4	14.63	14.35	14.41	130800.0
2015-12-17	AAOI	Stock	16.93	17.16	16.84	16.87	244900.0
2015-12-17	AAON	Stock	15.7267	15.74	15.3133	15.3867	219150.0
2015-12-17	AAP	Stock	161.13	161.9	153.0	153.07	1732900.0
2015-12-17	AAT	Stock	39.7	39.82	39.13	39.24	193500.0
2015-12-17	AAU-DELISTED	Stock	0.56	0.5755	0.5501	0.5706	68584.0
2015-12-17	AAUAF-DELISTED	Stock	0.56	0.58	0.5501	0.58	69167.0
2015-12-17	AAV-DELISTED	Stock	4.76	4.76	4.51	4.52	79785.0
2015-12-17	AAVL-DELISTED	Stock	9.12	9.235	8.755	8.89	146676.0
2015-12-17	AAWW-DELISTED	Stock	40.43	41.3899	40.43	41.0	179874.0
2015-12-17	AAXJ	Stock	54.78	54.78	54.08	54.09	785603.0
2015-12-17	AAXN-DELISTED	Stock	16.81	17.31	16.76	16.99	1002120.0
2015-12-17	AB	Stock	23.13	23.72	23.06	23.29	333800.0
2015-12-17	ABAC-DELISTED	Stock	0.97	1.03	0.97	1.0	1598.0
2015-12-17	ABAX-DELISTED	Stock	53.75	54.27	52.77	52.95	99087.0
2015-12-17	ABB-DELISTED	Stock	17.99	18.0	17.71	17.72	1869799.0
2015-12-17	ABBNY-DELISTED	Stock	17.99	18.0	17.71	17.71	2658257.0
2015-12-17	ABBV	Stock	57.66	57.93	56.35	56.38	7848900.0
2015-12-17	ABC-DELISTED	Stock	101.69	102.89	101.44	102.3	2381376.0
2015-12-17	ABCB	Stock	34.48	35.1	34.11	34.25	407400.0
2015-12-17	ABCD-DELISTED	Stock	5.09	5.09	4.96	4.98	11747.0
2015-12-17	ABCO-DELISTED	Stock	50.0	50.27	48.78	49.02	212429.0
2015-12-17	ABCW-DELISTED	Stock	44.82	45.57	44.38	45.28	17968.0
2015-12-17	ABDC-DELISTED	Stock	11.35	11.5899	11.35	11.41	31730.0
2015-12-17	ABE-DELISTED	Stock	10.9	10.906	10.81	10.85	6879.0
2015-12-17	ABEO	Stock	90.25	92.5	89.5	89.75	1828.0
2015-12-17	ABEOW-DELISTED	Stock	1.25	1.2501	1.25	1.2501	1100.0
2015-12-17	ABEV	Stock	4.77	4.8	4.57	4.62	16236300.0
2015-12-17	ABG	Stock	70.24	70.32	68.12	68.15	175900.0
2015-12-17	ABGB-DELISTED	Stock	1.79	1.79	1.7	1.71	10798.0

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

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