PREVIEW / stock_daily / 2015-06-08

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-08.parquet
  size:    224 KB
  rows:    6,652
  symbols: 3,503

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-08	AAPL	Stock	32.225	32.3025	31.7075	31.95	210699200.0
2015-06-08	MSFT	Stock	46.3	46.43	45.67	45.73	22121600.0
2015-06-08	NVDA	Stock	0.5548	0.5585	0.5375	0.5438	342812000.0
2015-06-08	AMZN	Stock	21.281	21.34	21.0715	21.175	43450000.0
2015-06-08	GOOGL	Stock	27.4805	27.4935	27.1475	27.174	27336320.0
2015-06-08	META	Stock	81.82	82.0	80.13	80.67	16915500.0
2015-06-08	TSLA	Stock	16.7233	17.25	16.6873	17.086	75255000.0
2015-06-08	TLT	Stock	117.96	118.16	117.37	117.47	5333972.0
2015-06-08	ES	Stock	46.62	46.69	46.31	46.33	1054500.0
2015-06-08	CL	Stock	65.39	65.54	64.83	65.34	3079300.0
2015-06-08	A	Stock	40.26	40.35	39.91	39.95	1353000.0
2015-06-08	AA.B-DELISTED	Stock	44.9	44.9	44.0	44.1599	35649.0
2015-06-08	AABA-DELISTED	Stock	42.74	42.89	42.0	42.01	7182301.0
2015-06-08	AAC-DELISTED	Stock	41.9	43.2499	41.35	41.71	212220.0
2015-06-08	AACG	Stock	5.0	5.09	4.95	4.96	16100.0
2015-06-08	AAIC-DELISTED	Stock	20.71	20.76	20.55	20.69	272315.0
2015-06-08	AAL	Stock	41.07	41.24	39.27	39.86	25757800.0
2015-06-08	AAMC-DELISTED	Stock	49.1176	49.1176	46.9118	47.6471	267628.0
2015-06-08	AAME	Stock	3.62	3.85	3.61	3.72	4100.0
2015-06-08	AAMI	Stock	19.32	19.48	18.77	18.99	104700.0
2015-06-08	AAOI	Stock	18.12	18.439	17.52	17.69	193000.0
2015-06-08	AAON	Stock	15.8467	16.0533	15.7267	15.94	219600.0
2015-06-08	AAP	Stock	157.25	157.85	156.59	157.31	924500.0
2015-06-08	AAT	Stock	39.16	39.47	39.05	39.4	169000.0
2015-06-08	AAU-DELISTED	Stock	0.8674	0.9016	0.84	0.86	119826.0
2015-06-08	AAUAF-DELISTED	Stock	0.8755	0.91	0.85	0.855	119156.0
2015-06-08	AAV-DELISTED	Stock	6.1	6.15	6.09	6.13	35134.0
2015-06-08	AAVL-DELISTED	Stock	40.15	40.15	37.39	37.75	308505.0
2015-06-08	AAWW-DELISTED	Stock	54.7	55.21	53.07	53.45	332495.0
2015-06-08	AAXJ	Stock	64.84	64.88	64.65	64.72	532845.0
2015-06-08	AAXN-DELISTED	Stock	32.35	33.17	32.0	32.88	2821505.0
2015-06-08	AB	Stock	31.38	31.52	30.3	30.6	221300.0
2015-06-08	ABAC-DELISTED	Stock	1.6503	1.6503	1.41	1.498	21250.0
2015-06-08	ABAX-DELISTED	Stock	52.88	53.26	52.26	52.2903	122548.0
2015-06-08	ABB-DELISTED	Stock	22.66	22.7464	22.59	22.66	1439847.0
2015-06-08	ABBNY-DELISTED	Stock	22.66	22.7464	22.59	22.67	1578281.0
2015-06-08	ABBV	Stock	67.86	68.2	67.53	67.79	10276700.0
2015-06-08	ABC-DELISTED	Stock	111.31	111.81	110.21	110.23	1204021.0
2015-06-08	ABCB	Stock	25.84	26.17	25.81	25.82	94700.0
2015-06-08	ABCD-DELISTED	Stock	4.15	4.29	4.15	4.26	58395.0
2015-06-08	ABCO-DELISTED	Stock	51.91	52.77	51.45	52.53	281922.0
2015-06-08	ABCW-DELISTED	Stock	37.0	37.1	36.95	37.0	39753.0
2015-06-08	ABDC-DELISTED	Stock	13.81	13.87	13.65	13.66	29703.0
2015-06-08	ABE-DELISTED	Stock	12.8	12.85	12.8	12.81	27341.0
2015-06-08	ABEO	Stock	199.5	205.0	186.0	186.25	210864.0
2015-06-08	ABEOW-DELISTED	Stock	3.5	3.52	3.01	3.27	13992.0
2015-06-08	ABEV	Stock	6.03	6.03	5.95	5.96	9801800.0
2015-06-08	ABG	Stock	89.65	91.0	89.26	89.38	188400.0
2015-06-08	ABGB-DELISTED	Stock	16.57	16.6	16.41	16.41	12640.0
2015-06-08	ABM	Stock	32.69	32.94	32.53	32.55	209900.0

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

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