PREVIEW / stock_daily / 2015-12-14

all stock daily files

  file:    by_date/stock_daily/2015/2015-12-14.parquet
  size:    221 KB
  rows:    6,638
  symbols: 3,400

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-14	AAPL	Stock	28.045	28.17	27.4475	28.12	257274800.0
2015-12-14	MSFT	Stock	54.33	55.21	53.68	55.14	46768900.0
2015-12-14	NVDA	Stock	0.813	0.8188	0.8045	0.8142	275892000.0
2015-12-14	AMZN	Stock	32.0875	32.9295	31.7635	32.8955	86594000.0
2015-12-14	GOOGL	Stock	37.563	38.2075	36.813	38.127	54170400.0
2015-12-14	META	Stock	102.29	104.74	101.46	104.66	24648100.0
2015-12-14	TSLA	Stock	14.5007	14.728	14.3247	14.572	42406500.0
2015-12-14	TLT	Stock	123.08	123.15	121.75	122.16	10661052.0
2015-12-14	ES	Stock	48.95	49.21	48.6	49.19	1118100.0
2015-12-14	CL	Stock	65.29	65.9	65.0	65.85	3353800.0
2015-12-14	A	Stock	40.22	40.54	39.9	40.25	2310500.0
2015-12-14	AA.B-DELISTED	Stock	30.36	30.89	29.7301	30.73	78898.0
2015-12-14	AAAP-DELISTED	Stock	29.12	29.975	28.3101	29.55	25044.0
2015-12-14	AABA-DELISTED	Stock	32.94	33.27	32.21	32.6	14675895.0
2015-12-14	AAC-DELISTED	Stock	23.17	24.0	21.8	22.52	133536.0
2015-12-14	AACG	Stock	5.74	6.05	5.74	5.9	31900.0
2015-12-14	AAIC-DELISTED	Stock	12.63	12.75	12.07	12.1	432207.0
2015-12-14	AAL	Stock	42.26	42.87	41.08	41.77	10750500.0
2015-12-14	AAMC-DELISTED	Stock	3.5941	3.65	3.05	3.3353	703674.0
2015-12-14	AAME	Stock	4.89	4.89	4.75	4.75	3000.0
2015-12-14	AAMI	Stock	14.24	14.48	14.23	14.41	299700.0
2015-12-14	AAOI	Stock	16.8	17.29	16.56	17.01	253800.0
2015-12-14	AAON	Stock	15.0933	15.6933	15.0933	15.6733	474300.0
2015-12-14	AAP	Stock	148.73	150.35	145.89	147.61	986500.0
2015-12-14	AAT	Stock	38.22	38.47	37.85	38.14	230100.0
2015-12-14	AAU-DELISTED	Stock	0.56	0.5699	0.5452	0.556	102795.0
2015-12-14	AAUAF-DELISTED	Stock	0.56	0.5699	0.5452	0.556	103126.0
2015-12-14	AAV-DELISTED	Stock	4.5	4.5	4.35	4.38	86026.0
2015-12-14	AAVL-DELISTED	Stock	8.5	8.7	8.29	8.37	164651.0
2015-12-14	AAWW-DELISTED	Stock	38.54	39.3	37.85	38.95	249023.0
2015-12-14	AAXJ	Stock	52.88	53.14	52.4675	53.1	1601267.0
2015-12-14	AAXN-DELISTED	Stock	17.06	17.11	16.14	16.29	1649309.0
2015-12-14	AB	Stock	22.89	23.25	21.24	21.41	758900.0
2015-12-14	ABAC-DELISTED	Stock	1.06	1.1424	0.954	1.05	11378.0
2015-12-14	ABAX-DELISTED	Stock	51.99	55.125	51.035	53.07	190529.0
2015-12-14	ABB-DELISTED	Stock	17.99	18.035	17.78	17.88	3978998.0
2015-12-14	ABBNY-DELISTED	Stock	17.99	18.035	17.78	17.87	5580786.0
2015-12-14	ABBV	Stock	53.71	55.48	53.24	55.44	9419500.0
2015-12-14	ABC-DELISTED	Stock	102.2	102.75	101.33	102.55	2065583.0
2015-12-14	ABCB	Stock	32.82	33.8	32.63	33.56	302500.0
2015-12-14	ABCD-DELISTED	Stock	4.95	5.11	4.9	4.93	27158.0
2015-12-14	ABCO-DELISTED	Stock	50.75	50.925	48.72	49.52	208904.0
2015-12-14	ABCW-DELISTED	Stock	41.99	43.26	41.99	42.64	25082.0
2015-12-14	ABDC-DELISTED	Stock	11.61	11.71	11.5	11.5	39243.0
2015-12-14	ABE-DELISTED	Stock	10.81	10.82	10.79	10.8	4614.0
2015-12-14	ABEO	Stock	88.75	89.25	82.5	85.5	3584.0
2015-12-14	ABEOW-DELISTED	Stock	1.31	1.31	1.25	1.3	990.0
2015-12-14	ABEV	Stock	4.62	4.67	4.58	4.59	17358600.0
2015-12-14	ABG	Stock	70.05	70.69	67.94	69.0	339600.0
2015-12-14	ABGB-DELISTED	Stock	1.59	1.59	1.45	1.499	39451.0

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

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