PREVIEW / stock_daily / 2015-10-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-10-20.parquet
  size:    221 KB
  rows:    6,602
  symbols: 3,417

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-10-20	AAPL	Stock	27.835	28.5425	27.705	28.4425	195871200.0
2015-10-20	MSFT	Stock	47.44	47.81	47.02	47.77	30802200.0
2015-10-20	NVDA	Stock	0.6922	0.6975	0.687	0.6942	264824000.0
2015-10-20	AMZN	Stock	28.6	28.65	27.764	28.044	86924000.0
2015-10-20	GOOGL	Stock	34.8945	34.9	33.684	34.0	52434380.0
2015-10-20	META	Stock	98.73	99.59	96.56	97.0	30881800.0
2015-10-20	TSLA	Stock	15.1813	15.24	13.4667	14.202	223500000.0
2015-10-20	TLT	Stock	122.8	122.97	122.55	122.83	6431302.0
2015-10-20	ES	Stock	51.82	52.27	51.56	52.2	1343400.0
2015-10-20	CL	Stock	66.95	67.24	66.86	67.06	3281900.0
2015-10-20	A	Stock	36.11	36.52	36.03	36.32	2635800.0
2015-10-20	AA.B-DELISTED	Stock	33.61	33.84	33.6	33.7	49995.0
2015-10-20	AABA-DELISTED	Stock	33.49	33.59	32.77	32.82	18466553.0
2015-10-20	AAC-DELISTED	Stock	28.42	28.59	27.31	27.98	159639.0
2015-10-20	AACG	Stock	3.6	3.89	3.31	3.8	80600.0
2015-10-20	AAIC-DELISTED	Stock	15.29	15.47	15.21	15.39	114735.0
2015-10-20	AAL	Stock	44.54	45.18	44.45	44.79	7610800.0
2015-10-20	AAMC-DELISTED	Stock	8.5294	8.7041	8.3235	8.3529	30583.0
2015-10-20	AAME	Stock	4.28	4.3	4.28	4.29	1400.0
2015-10-20	AAMI	Stock	14.87	14.95	14.73	14.81	102300.0
2015-10-20	AAOI	Stock	17.94	18.28	17.7	18.24	274200.0
2015-10-20	AAON	Stock	14.1267	14.4	14.0133	14.08	121650.0
2015-10-20	AAP	Stock	191.78	194.31	191.5	193.59	774300.0
2015-10-20	AAT	Stock	43.45	43.79	43.35	43.38	109500.0
2015-10-20	AAU-DELISTED	Stock	0.6	0.6195	0.6	0.6171	137015.0
2015-10-20	AAUAF-DELISTED	Stock	0.6	0.6195	0.6	0.6171	141841.0
2015-10-20	AAV-DELISTED	Stock	5.89	6.07	5.89	6.02	56518.0
2015-10-20	AAVL-DELISTED	Stock	8.51	8.71	8.17	8.265	203679.0
2015-10-20	AAWW-DELISTED	Stock	40.38	40.73	39.99	40.62	141694.0
2015-10-20	AAXJ	Stock	57.66	57.77	57.53	57.71	451359.0
2015-10-20	AAXN-DELISTED	Stock	24.67	25.83	20.99	22.1	5796925.0
2015-10-20	AB	Stock	26.5	26.66	26.31	26.5	279500.0
2015-10-20	ABAC-DELISTED	Stock	0.6039	0.66	0.6039	0.66	40940.0
2015-10-20	ABAX-DELISTED	Stock	46.0	46.637	45.0	45.61	130288.0
2015-10-20	ABB-DELISTED	Stock	17.94	18.22	17.93	18.14	3224477.0
2015-10-20	ABBNY-DELISTED	Stock	17.94	18.22	17.93	18.14	3448768.0
2015-10-20	ABBV	Stock	56.15	56.38	54.63	54.83	6494600.0
2015-10-20	ABC-DELISTED	Stock	94.62	95.05	92.87	93.19	2144630.0
2015-10-20	ABCB	Stock	28.57	28.92	28.49	28.84	86100.0
2015-10-20	ABCD-DELISTED	Stock	5.02	5.04	4.99	5.01	28740.0
2015-10-20	ABCO-DELISTED	Stock	46.57	48.14	46.21	47.94	186085.0
2015-10-20	ABCW-DELISTED	Stock	42.02	42.45	41.79	42.33	24138.0
2015-10-20	ABDC-DELISTED	Stock	12.21	12.59	11.93	12.56	15090.0
2015-10-20	ABE-DELISTED	Stock	11.2	11.3	11.16	11.28	3981.0
2015-10-20	ABEO	Stock	101.0	103.25	98.0	99.0	3472.0
2015-10-20	ABEOW-DELISTED	Stock	1.46	1.46	1.46	1.46	130.0
2015-10-20	ABEV	Stock	4.96	5.0	4.9	4.98	8739200.0
2015-10-20	ABG	Stock	86.39	87.61	86.24	87.27	369600.0
2015-10-20	ABGB-DELISTED	Stock	5.1433	5.23	5.1	5.12	54069.0
2015-10-20	ABIL-DELISTED	Stock	10.05	10.06	10.05	10.06	10606.0

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

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