PREVIEW / stock_daily / 2015-05-14

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-14.parquet
  size:    224 KB
  rows:    6,653
  symbols: 3,514

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-14	AAPL	Stock	31.8525	32.2375	31.79	32.2375	180814000.0
2015-05-14	MSFT	Stock	48.03	48.82	48.03	48.72	32980900.0
2015-05-14	NVDA	Stock	0.5253	0.535	0.524	0.5322	293052000.0
2015-05-14	AMZN	Stock	21.4725	21.65	21.3505	21.614	37770000.0
2015-05-14	GOOGL	Stock	27.1985	27.4845	27.125	27.46	31736660.0
2015-05-14	META	Stock	78.94	81.85	78.67	81.37	49438000.0
2015-05-14	TSLA	Stock	16.3213	16.326	16.0833	16.2733	43438500.0
2015-05-14	TLT	Stock	118.92	119.83	118.69	119.2	9128441.0
2015-05-14	ES	Stock	48.25	48.74	47.98	48.54	1831300.0
2015-05-14	CL	Stock	68.02	68.72	68.01	68.63	2269900.0
2015-05-14	A	Stock	42.18	42.23	41.87	42.05	2883700.0
2015-05-14	AA.B-DELISTED	Stock	46.45	46.7	46.16	46.3399	72186.0
2015-05-14	AABA-DELISTED	Stock	44.54	44.99	44.45	44.95	8613783.0
2015-05-14	AAC-DELISTED	Stock	34.61	36.83	34.25	36.38	278943.0
2015-05-14	AACG	Stock	4.51	4.8	4.51	4.8	700.0
2015-05-14	AAIC-DELISTED	Stock	21.2	21.34	21.15	21.19	219629.0
2015-05-14	AAL	Stock	48.94	49.09	48.5	48.82	7980100.0
2015-05-14	AAMC-DELISTED	Stock	52.5735	54.7059	52.0588	53.7059	21311.0
2015-05-14	AAME	Stock	3.83	3.83	3.7	3.72	3100.0
2015-05-14	AAMI	Stock	19.75	19.75	18.73	18.95	198400.0
2015-05-14	AAOI	Stock	14.85	14.92	14.63	14.72	131600.0
2015-05-14	AAON	Stock	15.5533	15.66	15.34	15.6067	208500.0
2015-05-14	AAP	Stock	150.0	151.22	148.75	149.86	979900.0
2015-05-14	AAT	Stock	39.9	40.5	39.72	40.13	170800.0
2015-05-14	AAU-DELISTED	Stock	0.7977	0.8446	0.7956	0.83	106872.0
2015-05-14	AAUAF-DELISTED	Stock	0.7934	0.84	0.7913	0.8255	108535.0
2015-05-14	AAV-DELISTED	Stock	6.36	6.36	6.18	6.2	68601.0
2015-05-14	AAVL-DELISTED	Stock	35.81	36.24	34.51	35.95	270659.0
2015-05-14	AAWW-DELISTED	Stock	56.88	56.88	56.03	56.17	484563.0
2015-05-14	AAXJ	Stock	67.26	67.5	67.11	67.44	485731.0
2015-05-14	AAXN-DELISTED	Stock	33.55	33.95	33.0	33.69	1268706.0
2015-05-14	AB	Stock	30.4	30.89	30.03	30.74	185200.0
2015-05-14	ABAC-DELISTED	Stock	1.65	1.65	1.57	1.64	1425.0
2015-05-14	ABAX-DELISTED	Stock	52.45	53.3	51.772	52.73	74230.0
2015-05-14	ABB-DELISTED	Stock	22.21	22.27	22.1	22.19	1785068.0
2015-05-14	ABBNY-DELISTED	Stock	22.21	22.27	22.1	22.19	1845066.0
2015-05-14	ABBV	Stock	65.86	66.27	64.94	65.97	5868900.0
2015-05-14	ABC-DELISTED	Stock	114.4	114.84	114.0	114.67	2197771.0
2015-05-14	ABCB	Stock	25.26	25.53	25.1	25.32	46200.0
2015-05-14	ABCD-DELISTED	Stock	2.9499	3.08	2.93	3.0	40683.0
2015-05-14	ABCO-DELISTED	Stock	48.28	49.0	47.97	48.64	169699.0
2015-05-14	ABCW-DELISTED	Stock	37.5	37.5	36.73	36.7475	1822.0
2015-05-14	ABDC-DELISTED	Stock	13.71	13.89	13.68	13.68	32282.0
2015-05-14	ABE-DELISTED	Stock	13.23	13.3	13.22	13.3	7700.0
2015-05-14	ABEO	Stock	234.75	237.25	201.25	208.5	224692.0
2015-05-14	ABEOW-DELISTED	Stock	4.25	4.4	3.17	3.4	174533.0
2015-05-14	ABEV	Stock	6.45	6.54	6.44	6.47	12704000.0
2015-05-14	ABG	Stock	85.18	85.19	83.76	84.54	167000.0
2015-05-14	ABGB-DELISTED	Stock	16.84	17.29	16.7772	17.28	25199.0
2015-05-14	ABIL-DELISTED	Stock	9.9	9.94	9.8901	9.9	51600.0

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

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