PREVIEW / stock_daily / 2015-05-19

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-19.parquet
  size:    224 KB
  rows:    6,667
  symbols: 3,521

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-05-19	AAPL	Stock	32.6725	32.72	32.41	32.5175	178532800.0
2015-05-19	MSFT	Stock	47.56	47.81	47.18	47.58	28574800.0
2015-05-19	NVDA	Stock	0.53	0.5318	0.525	0.526	253808000.0
2015-05-19	AMZN	Stock	21.2435	21.412	21.0315	21.0855	49284000.0
2015-05-19	GOOGL	Stock	27.4	27.67	27.356	27.464	47125480.0
2015-05-19	META	Stock	81.25	81.69	80.55	80.63	17955400.0
2015-05-19	TSLA	Stock	16.562	16.7333	16.41	16.476	55113000.0
2015-05-19	TLT	Stock	118.27	119.84	118.13	118.49	8435326.0
2015-05-19	ES	Stock	49.21	49.63	49.02	49.32	1116100.0
2015-05-19	CL	Stock	68.67	69.19	68.49	69.14	2505800.0
2015-05-19	A	Stock	41.57	42.83	41.5	42.37	5277300.0
2015-05-19	AA.B-DELISTED	Stock	45.65	45.65	44.84	44.88	54262.0
2015-05-19	AABA-DELISTED	Stock	44.45	44.66	39.12	41.0062	41779179.0
2015-05-19	AAC-DELISTED	Stock	37.79	37.86	35.85	35.99	203471.0
2015-05-19	AACG	Stock	4.73	4.74	4.59	4.59	2600.0
2015-05-19	AAIC-DELISTED	Stock	21.35	21.67	21.35	21.4	215082.0
2015-05-19	AAL	Stock	49.45	49.68	47.7	47.85	14984900.0
2015-05-19	AAMC-DELISTED	Stock	49.7206	54.0735	49.7206	54.0735	16266.0
2015-05-19	AAME	Stock	3.62	3.65	3.6	3.6	2600.0
2015-05-19	AAMI	Stock	19.74	19.876	19.52	19.74	74400.0
2015-05-19	AAOI	Stock	14.67	14.89	14.466	14.53	89500.0
2015-05-19	AAON	Stock	15.7133	15.8667	15.5933	15.7467	147150.0
2015-05-19	AAP	Stock	152.65	154.84	151.98	152.94	1096300.0
2015-05-19	AAT	Stock	40.59	40.91	40.3	40.75	118800.0
2015-05-19	AAU-DELISTED	Stock	0.8258	0.92	0.8258	0.9024	168923.0
2015-05-19	AAUAF-DELISTED	Stock	0.8258	0.92	0.8258	0.9024	172417.0
2015-05-19	AAV-DELISTED	Stock	5.93	6.07	5.91	6.04	211884.0
2015-05-19	AAVL-DELISTED	Stock	36.36	38.71	36.36	38.24	306858.0
2015-05-19	AAWW-DELISTED	Stock	59.0	59.47	58.57	59.43	450958.0
2015-05-19	AAXJ	Stock	67.85	67.93	67.73	67.875	859559.0
2015-05-19	AAXN-DELISTED	Stock	32.56	33.0	32.25	32.33	1398868.0
2015-05-19	AB	Stock	31.3	31.88	31.12	31.67	259600.0
2015-05-19	ABAC-DELISTED	Stock	1.67	1.68	1.66	1.6784	8200.0
2015-05-19	ABAX-DELISTED	Stock	53.18	53.4	52.82	52.87	64612.0
2015-05-19	ABB-DELISTED	Stock	21.91	21.92	21.7	21.75	2737567.0
2015-05-19	ABBNY-DELISTED	Stock	21.91	21.92	21.7	21.76	2926316.0
2015-05-19	ABBV	Stock	65.71	66.12	65.4	65.73	7674600.0
2015-05-19	ABC-DELISTED	Stock	113.54	115.58	113.42	115.13	1695545.0
2015-05-19	ABCB	Stock	25.36	25.67	25.3	25.61	83900.0
2015-05-19	ABCD-DELISTED	Stock	3.73	3.78	3.6	3.68	56465.0
2015-05-19	ABCO-DELISTED	Stock	48.75	48.9	47.85	47.88	219987.0
2015-05-19	ABCW-DELISTED	Stock	37.36	37.36	37.33	37.33	876.0
2015-05-19	ABDC-DELISTED	Stock	14.0	14.07	13.91	14.0	40478.0
2015-05-19	ABE-DELISTED	Stock	13.37	13.43	13.3117	13.41	8083.0
2015-05-19	ABEO	Stock	229.0	270.75	226.75	237.5	606120.0
2015-05-19	ABEOW-DELISTED	Stock	4.14	5.8	4.031	4.64	583557.0
2015-05-19	ABEV	Stock	6.35	6.38	6.3	6.3	10760100.0
2015-05-19	ABG	Stock	86.96	87.5	86.09	86.42	198900.0
2015-05-19	ABGB-DELISTED	Stock	16.72	16.95	16.66	16.77	80050.0
2015-05-19	ABIL-DELISTED	Stock	9.9	9.9	9.9	9.9	400.0

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

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