PREVIEW / stock_daily / 2016-03-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-04.parquet
  size:    220 KB
  rows:    6,588
  symbols: 3,335

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-04	AAPL	Stock	25.5925	25.9375	25.3425	25.7525	184220400.0
2016-03-04	MSFT	Stock	52.4	52.45	51.71	52.03	33034200.0
2016-03-04	NVDA	Stock	0.8225	0.8232	0.8075	0.8138	175304000.0
2016-03-04	AMZN	Stock	29.0535	29.07	28.5535	28.757	68330000.0
2016-03-04	GOOGL	Stock	36.74	36.75	36.281	36.511	48515000.0
2016-03-04	META	Stock	110.05	110.05	107.93	108.39	24938900.0
2016-03-04	TSLA	Stock	13.2	13.602	13.1667	13.4027	97336500.0
2016-03-04	TLT	Stock	128.75	129.13	127.76	128.6	8687010.0
2016-03-04	ES	Stock	54.33	55.69	54.13	55.54	1839900.0
2016-03-04	CL	Stock	67.42	68.32	67.28	68.16	2827300.0
2016-03-04	A	Stock	39.14	39.58	39.03	39.34	1125000.0
2016-03-04	AA.B-DELISTED	Stock	32.25	33.4	31.73	32.2	348187.0
2016-03-04	AAAP-DELISTED	Stock	33.38	35.41	32.7	33.03	20993.0
2016-03-04	AABA-DELISTED	Stock	32.91	33.9275	32.7572	33.86	21889774.0
2016-03-04	AAC-DELISTED	Stock	20.02	20.03	18.62	18.87	214352.0
2016-03-04	AACG	Stock	4.66	4.88	4.6	4.77	7900.0
2016-03-04	AAIC-DELISTED	Stock	12.84	13.19	12.76	13.02	345991.0
2016-03-04	AAL	Stock	42.17	42.17	41.42	41.63	9474100.0
2016-03-04	AAMC-DELISTED	Stock	4.8412	5.0	4.4853	4.6324	131536.0
2016-03-04	AAMI	Stock	11.89	12.11	11.845	11.98	125200.0
2016-03-04	AAOI	Stock	18.27	18.79	17.96	18.24	210100.0
2016-03-04	AAON	Stock	16.84	17.0667	16.48	16.8667	247650.0
2016-03-04	AAP	Stock	154.07	154.27	151.17	152.37	724900.0
2016-03-04	AAT	Stock	38.06	38.13	37.63	37.94	204900.0
2016-03-04	AAU-DELISTED	Stock	0.775	0.84	0.76	0.7898	228284.0
2016-03-04	AAUAF-DELISTED	Stock	0.775	0.84	0.76	0.7898	229668.0
2016-03-04	AAV-DELISTED	Stock	5.21	5.28	5.07	5.12	112226.0
2016-03-04	AAVL-DELISTED	Stock	5.18	5.49	5.12	5.36	318536.0
2016-03-04	AAWW-DELISTED	Stock	38.34	39.53	37.78	37.8	463766.0
2016-03-04	AAXJ	Stock	52.21	53.04	52.12	52.91	590173.0
2016-03-04	AAXN-DELISTED	Stock	19.44	19.85	19.17	19.45	1353529.0
2016-03-04	AB	Stock	21.28	22.07	21.28	21.56	281900.0
2016-03-04	ABAC-DELISTED	Stock	0.6242	0.65	0.6242	0.65	1250.0
2016-03-04	ABAX-DELISTED	Stock	40.31	42.16	38.759	41.52	187414.0
2016-03-04	ABB-DELISTED	Stock	18.29	18.49	18.2329	18.38	1563405.0
2016-03-04	ABBNY-DELISTED	Stock	18.29	18.49	18.2329	18.39	2423949.0
2016-03-04	ABBV	Stock	56.0	56.7	55.3	56.15	6439700.0
2016-03-04	ABC-DELISTED	Stock	88.17	88.47	87.781	88.0001	1478991.0
2016-03-04	ABCB	Stock	28.35	28.56	28.04	28.2	130100.0
2016-03-04	ABCD-DELISTED	Stock	4.1701	4.75	4.1701	4.73	60343.0
2016-03-04	ABCO-DELISTED	Stock	28.44	30.56	28.3	29.77	854249.0
2016-03-04	ABCW-DELISTED	Stock	43.28	43.65	43.23	43.41	128424.0
2016-03-04	ABDC-DELISTED	Stock	10.09	10.42	10.03	10.28	39984.0
2016-03-04	ABE-DELISTED	Stock	11.07	11.14	11.07	11.14	369.0
2016-03-04	ABEO	Stock	59.25	72.5	57.75	64.0	4648.0
2016-03-04	ABEOW-DELISTED	Stock	0.7	0.7412	0.6	0.6	1400.0
2016-03-04	ABEV	Stock	5.0	5.09	4.98	5.08	36782800.0
2016-03-04	ABG	Stock	60.52	62.55	59.99	60.37	707500.0
2016-03-04	ABGB-DELISTED	Stock	0.88	1.06	0.88	1.06	57764.0
2016-03-04	ABIL-DELISTED	Stock	6.141	6.84	6.14	6.6999	11800.0

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

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