PREVIEW / stock_daily / 2016-02-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-04.parquet
  size:    219 KB
  rows:    6,578
  symbols: 3,348

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
2016-02-04	AAPL	Stock	23.965	24.3325	23.7975	24.15	185886800.0
2016-02-04	MSFT	Stock	52.1	52.81	51.37	52.0	46987100.0
2016-02-04	NVDA	Stock	0.706	0.7213	0.6982	0.7052	348140000.0
2016-02-04	AMZN	Stock	26.25	26.9495	25.961	26.813	123982000.0
2016-02-04	GOOGL	Stock	37.2295	37.262	36.13	36.5015	104922460.0
2016-02-04	META	Stock	111.8	111.94	109.25	110.49	38890200.0
2016-02-04	TSLA	Stock	11.38	11.732	11.1327	11.6887	65781000.0
2016-02-04	TLT	Stock	128.22	128.59	127.51	128.57	9953521.0
2016-02-04	ES	Stock	55.63	55.91	54.84	54.93	3347600.0
2016-02-04	CL	Stock	65.9	66.23	65.5	65.99	3078800.0
2016-02-04	A	Stock	37.15	37.79	36.97	37.42	2833500.0
2016-02-04	AA.B-DELISTED	Stock	27.0	29.45	27.0	29.1461	47575.0
2016-02-04	AAAP-DELISTED	Stock	25.05	27.31	24.52	26.43	11283.0
2016-02-04	AABA-DELISTED	Stock	27.91	29.23	27.71	29.16	27035334.0
2016-02-04	AAC-DELISTED	Stock	18.23	19.9	17.89	19.52	241475.0
2016-02-04	AACG	Stock	5.32	5.47	5.28	5.44	14000.0
2016-02-04	AAIC-DELISTED	Stock	12.08	12.3099	11.88	12.15	459853.0
2016-02-04	AAL	Stock	37.34	38.6	36.7	38.21	8599600.0
2016-02-04	AAMC-DELISTED	Stock	4.5853	5.0853	4.5853	4.9971	27224.0
2016-02-04	AAME	Stock	4.5	4.5	4.49	4.5	1300.0
2016-02-04	AAMI	Stock	11.31	12.15	10.91	11.14	403700.0
2016-02-04	AAOI	Stock	15.3	16.38	15.3	16.15	226800.0
2016-02-04	AAON	Stock	13.9667	14.28	13.9133	13.96	143250.0
2016-02-04	AAP	Stock	147.46	148.44	145.48	147.85	1573500.0
2016-02-04	AAT	Stock	36.92	37.59	36.92	37.28	179500.0
2016-02-04	AAU-DELISTED	Stock	0.6386	0.66	0.5881	0.648	116880.0
2016-02-04	AAUAF-DELISTED	Stock	0.6386	0.66	0.5881	0.648	120154.0
2016-02-04	AAV-DELISTED	Stock	5.56	5.66	5.43	5.61	208821.0
2016-02-04	AAVL-DELISTED	Stock	4.67	5.01	4.6	4.705	287362.0
2016-02-04	AAWW-DELISTED	Stock	34.97	35.9	34.96	35.39	359792.0
2016-02-04	AAXJ	Stock	49.11	49.59	48.785	49.04	1453017.0
2016-02-04	AAXN-DELISTED	Stock	15.06	15.94	15.01	15.79	1250302.0
2016-02-04	AB	Stock	18.03	18.32	17.92	18.07	273300.0
2016-02-04	ABAC-DELISTED	Stock	0.56	0.59	0.501	0.59	21582.0
2016-02-04	ABAX-DELISTED	Stock	41.31	42.42	40.8	41.25	416637.0
2016-02-04	ABB-DELISTED	Stock	17.22	17.6579	17.195	17.64	3456657.0
2016-02-04	ABBNY-DELISTED	Stock	17.22	17.6579	17.195	17.63	5710737.0
2016-02-04	ABBV	Stock	56.74	57.31	55.36	56.76	10351200.0
2016-02-04	ABC-DELISTED	Stock	81.13	87.97	80.5	84.4	7484852.0
2016-02-04	ABCB	Stock	27.81	28.17	27.22	27.4	174600.0
2016-02-04	ABCD-DELISTED	Stock	4.47	4.5	4.355	4.38	10078.0
2016-02-04	ABCO-DELISTED	Stock	43.3	43.99	43.25	43.52	121309.0
2016-02-04	ABCW-DELISTED	Stock	41.14	42.0	41.13	41.43	92437.0
2016-02-04	ABDC-DELISTED	Stock	10.48	10.5799	10.06	10.2	42490.0
2016-02-04	ABE-DELISTED	Stock	10.36	10.5097	10.36	10.5097	7875.0
2016-02-04	ABEO	Stock	59.0	63.75	59.0	61.75	804.0
2016-02-04	ABEV	Stock	4.75	4.82	4.68	4.74	18585600.0
2016-02-04	ABG	Stock	47.83	50.48	46.19	48.63	1151500.0
2016-02-04	ABGB-DELISTED	Stock	1.03	1.03	0.9805	1.0068	151164.0
2016-02-04	ABIL-DELISTED	Stock	7.09	7.245	6.9975	7.12	20284.0

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

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