PREVIEW / stock_daily / 2016-03-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-09.parquet
  size:    218 KB
  rows:    6,548
  symbols: 3,319

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-03-09	AAPL	Stock	25.3275	25.395	25.0675	25.28	108806800.0
2016-03-09	MSFT	Stock	51.89	52.85	51.86	52.84	28251600.0
2016-03-09	NVDA	Stock	0.8008	0.802	0.783	0.7932	222788000.0
2016-03-09	AMZN	Stock	27.978	28.0175	27.5065	27.9735	87546000.0
2016-03-09	GOOGL	Stock	35.7582	36.312	35.633	36.2705	39543380.0
2016-03-09	META	Stock	106.7	107.51	105.49	107.51	20493300.0
2016-03-09	TSLA	Stock	13.6347	13.958	13.5193	13.9147	48129000.0
2016-03-09	TLT	Stock	129.08	129.69	128.81	129.19	7194693.0
2016-03-09	ES	Stock	56.59	57.16	56.4	56.87	1648700.0
2016-03-09	CL	Stock	67.88	68.58	67.3	67.98	2711800.0
2016-03-09	A	Stock	38.31	38.4	37.96	38.13	1614600.0
2016-03-09	AA.B-DELISTED	Stock	31.97	31.97	31.0	31.9	17611.0
2016-03-09	AAAP-DELISTED	Stock	34.32	35.725	34.01	34.28	17493.0
2016-03-09	AABA-DELISTED	Stock	33.09	33.52	32.775	33.51	10865253.0
2016-03-09	AAC-DELISTED	Stock	16.59	17.19	16.27	16.97	321100.0
2016-03-09	AACG	Stock	4.75	4.85	4.61	4.77	1400.0
2016-03-09	AAIC-DELISTED	Stock	12.78	12.97	12.65	12.85	214954.0
2016-03-09	AAL	Stock	40.74	41.72	40.52	41.65	8546300.0
2016-03-09	AAMC-DELISTED	Stock	3.8324	3.9779	3.8236	3.8824	38134.0
2016-03-09	AAME	Stock	4.2	4.2	4.16	4.16	1600.0
2016-03-09	AAMI	Stock	11.65	11.85	11.39	11.77	150000.0
2016-03-09	AAOI	Stock	17.14	17.22	16.77	17.02	161600.0
2016-03-09	AAON	Stock	16.9867	17.0867	16.8333	16.9	247350.0
2016-03-09	AAP	Stock	150.98	154.09	149.75	153.77	627800.0
2016-03-09	AAT	Stock	37.75	38.1	37.56	37.76	84800.0
2016-03-09	AAU-DELISTED	Stock	0.67	0.7053	0.6601	0.6961	85518.0
2016-03-09	AAUAF-DELISTED	Stock	0.67	0.7053	0.6601	0.69	86224.0
2016-03-09	AAV-DELISTED	Stock	5.25	5.46	5.19	5.42	153225.0
2016-03-09	AAVL-DELISTED	Stock	5.2	5.2476	5.0	5.12	423172.0
2016-03-09	AAWW-DELISTED	Stock	38.82	39.74	38.08	38.65	151940.0
2016-03-09	AAXJ	Stock	51.87	52.14	51.77	51.84	838750.0
2016-03-09	AAXN-DELISTED	Stock	19.64	19.82	19.4	19.54	533848.0
2016-03-09	AB	Stock	21.74	22.05	21.62	22.04	192800.0
2016-03-09	ABAC-DELISTED	Stock	0.6625	0.6625	0.635	0.635	600.0
2016-03-09	ABAX-DELISTED	Stock	41.14	41.75	40.8	41.72	107781.0
2016-03-09	ABB-DELISTED	Stock	18.19	18.2899	18.1251	18.2	1166645.0
2016-03-09	ABBNY-DELISTED	Stock	18.19	18.2899	18.1251	18.21	1220267.0
2016-03-09	ABBV	Stock	55.51	56.65	55.04	56.39	8402500.0
2016-03-09	ABC-DELISTED	Stock	87.79	88.01	87.37	87.56	1580434.0
2016-03-09	ABCB	Stock	28.06	28.13	27.56	27.67	70900.0
2016-03-09	ABCD-DELISTED	Stock	4.49	4.53	4.4	4.5	10120.0
2016-03-09	ABCO-DELISTED	Stock	29.44	29.55	27.97	28.5	589950.0
2016-03-09	ABCW-DELISTED	Stock	43.34	43.5	42.96	43.12	51503.0
2016-03-09	ABDC-DELISTED	Stock	10.2699	10.4	10.12	10.21	33679.0
2016-03-09	ABE-DELISTED	Stock	11.03	11.03	11.0	11.0	6015.0
2016-03-09	ABEO	Stock	67.0	67.75	65.25	67.0	748.0
2016-03-09	ABEV	Stock	5.13	5.14	4.99	5.0	26302700.0
2016-03-09	ABG	Stock	58.58	59.4	57.95	59.0	394900.0
2016-03-09	ABGB-DELISTED	Stock	2.37	2.37	1.56	1.72	196103.0
2016-03-09	ABIL-DELISTED	Stock	6.45	6.7	6.13	6.5	25819.0

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

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