PREVIEW / stock_daily / 2015-06-30

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-30.parquet
  size:    226 KB
  rows:    6,700
  symbols: 3,517

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-06-30	AAPL	Stock	31.3925	31.53	31.215	31.3575	177482800.0
2015-06-30	MSFT	Stock	44.71	44.72	43.94	44.15	35945400.0
2015-06-30	NVDA	Stock	0.506	0.5082	0.4992	0.5028	315916000.0
2015-06-30	AMZN	Stock	21.71	21.7785	21.523	21.7045	51938000.0
2015-06-30	GOOGL	Stock	27.2545	27.295	26.977	27.002	34509280.0
2015-06-30	META	Stock	86.6	86.7	85.57	85.77	23016500.0
2015-06-30	TSLA	Stock	17.6533	18.0613	17.6	17.884	46303500.0
2015-06-30	TLT	Stock	117.4	118.7	117.33	117.46	13469011.0
2015-06-30	ES	Stock	45.68	45.78	45.31	45.41	1995300.0
2015-06-30	CL	Stock	65.85	65.88	65.31	65.41	2786600.0
2015-06-30	A	Stock	39.08	39.19	38.48	38.58	3037400.0
2015-06-30	AA.B-DELISTED	Stock	40.95	40.95	40.1	40.1	55468.0
2015-06-30	AABA-DELISTED	Stock	39.36	39.65	39.19	39.295	10652743.0
2015-06-30	AAC-DELISTED	Stock	43.35	43.865	42.68	43.65	105623.0
2015-06-30	AACG	Stock	5.9	5.98	5.79	5.79	27600.0
2015-06-30	AAIC-DELISTED	Stock	19.56	19.59	19.395	19.56	504613.0
2015-06-30	AAL	Stock	40.2	40.6	39.93	39.94	11184500.0
2015-06-30	AAMC-DELISTED	Stock	42.7382	43.1618	42.4382	42.4382	30314.0
2015-06-30	AAME	Stock	3.7	3.71	3.62	3.62	3400.0
2015-06-30	AAMI	Stock	17.57	17.91	17.49	17.79	501900.0
2015-06-30	AAOI	Stock	17.5	18.025	17.22	17.36	148300.0
2015-06-30	AAON	Stock	15.1133	15.3133	14.9667	15.0133	428850.0
2015-06-30	AAP	Stock	160.41	160.73	158.03	159.29	789600.0
2015-06-30	AAT	Stock	39.15	39.46	38.77	39.21	260400.0
2015-06-30	AAU-DELISTED	Stock	0.815	0.8605	0.8094	0.84	63432.0
2015-06-30	AAUAF-DELISTED	Stock	0.796	0.84	0.79	0.84	65452.0
2015-06-30	AAV-DELISTED	Stock	6.36	6.401	6.31	6.32	42649.0
2015-06-30	AAVL-DELISTED	Stock	15.28	16.47	15.28	16.26	705990.0
2015-06-30	AAWW-DELISTED	Stock	55.1	55.9	54.37	54.96	446135.0
2015-06-30	AAXJ	Stock	63.5	63.6	62.93	63.0	2059290.0
2015-06-30	AAXN-DELISTED	Stock	32.04	33.47	31.61	33.31	2282554.0
2015-06-30	AB	Stock	29.36	29.93	29.26	29.53	137800.0
2015-06-30	ABAC-DELISTED	Stock	1.37	1.37	1.34	1.3511	12168.0
2015-06-30	ABAX-DELISTED	Stock	51.35	51.91	50.95	51.48	79893.0
2015-06-30	ABB-DELISTED	Stock	21.29	21.3252	20.7599	20.89	3903148.0
2015-06-30	ABBNY-DELISTED	Stock	21.29	21.3252	20.7599	20.88	4374481.0
2015-06-30	ABBV	Stock	68.0	68.22	66.66	67.19	11459600.0
2015-06-30	ABC-DELISTED	Stock	106.3	107.31	106.15	106.35	1653632.0
2015-06-30	ABCB	Stock	25.61	25.66	24.01	25.29	208800.0
2015-06-30	ABCD-DELISTED	Stock	4.25	4.34	4.21	4.27	94313.0
2015-06-30	ABCO-DELISTED	Stock	53.57	54.94	53.41	54.69	379926.0
2015-06-30	ABCW-DELISTED	Stock	38.29	38.3	38.01	38.01	10850.0
2015-06-30	ABDC-DELISTED	Stock	13.47	13.47	12.42	12.65	129091.0
2015-06-30	ABE-DELISTED	Stock	12.62	12.79	12.6	12.79	28474.0
2015-06-30	ABEO	Stock	142.0	142.5	122.0	126.5	45528.0
2015-06-30	ABEOW-DELISTED	Stock	1.85	1.95	1.72	1.9	13193.0
2015-06-30	ABEV	Stock	6.14	6.18	6.07	6.1	20153300.0
2015-06-30	ABG	Stock	90.82	91.49	90.01	90.62	216600.0
2015-06-30	ABGB-DELISTED	Stock	16.07	16.09	15.751	15.89	10049.0
2015-06-30	ABIL-DELISTED	Stock	10.0	10.0	9.95	9.95	290.0

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

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