PREVIEW / stock_daily / 2014-01-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-15.parquet
  size:    217 KB
  rows:    6,443
  symbols: 3,524

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
2014-01-15	AAPL	Stock	19.7686	20.0071	19.7021	19.9057	391638800.0
2014-01-15	MSFT	Stock	35.9	36.79	35.85	36.76	44812600.0
2014-01-15	NVDA	Stock	0.3978	0.4018	0.396	0.4003	175044000.0
2014-01-15	AMZN	Stock	19.947	19.9655	19.6265	19.7935	53566000.0
2014-01-15	META	Stock	57.98	58.57	57.27	57.6	33663400.0
2014-01-15	TSLA	Stock	11.23	11.482	10.8067	10.942	306984000.0
2014-01-15	TLT	Stock	104.04	104.51	103.93	104.34	7507464.0
2014-01-15	ES	Stock	42.31	42.37	41.85	42.04	1599000.0
2014-01-15	CL	Stock	64.86	64.97	64.35	64.78	2287400.0
2014-01-15	A	Stock	42.7897	43.1831	42.6252	43.1617	3264610.0
2014-01-15	AABA-DELISTED	Stock	41.06	41.305	40.76	41.07	9059242.0
2014-01-15	AACG	Stock	3.93	3.98	3.93	3.93	3200.0
2014-01-15	AAIC-DELISTED	Stock	26.68	26.98	26.49	26.49	162358.0
2014-01-15	AAL	Stock	28.9	29.44	28.7	28.84	11192500.0
2014-01-15	AAMC-DELISTED	Stock	341.1765	355.5882	339.7059	351.8706	315840.0
2014-01-15	AAME	Stock	3.99	4.05	3.88	4.02	23200.0
2014-01-15	AAOI	Stock	14.0	14.11	13.59	13.97	63600.0
2014-01-15	AAON	Stock	14.0578	14.4711	13.9778	14.4	154575.0
2014-01-15	AAP	Stock	117.65	119.54	116.71	117.47	958200.0
2014-01-15	AAT	Stock	32.04	32.27	31.88	32.0	57800.0
2014-01-15	AAU-DELISTED	Stock	1.26	1.34	1.26	1.34	113716.0
2014-01-15	AAUAF-DELISTED	Stock	1.26	1.34	1.26	1.34	114304.0
2014-01-15	AAV-DELISTED	Stock	4.09	4.1196	4.03	4.08	87124.0
2014-01-15	AAWW-DELISTED	Stock	43.33	43.99	43.26	43.85	138316.0
2014-01-15	AAXJ	Stock	58.46	58.49	58.26	58.44	555453.0
2014-01-15	AAXN-DELISTED	Stock	18.12	18.19	17.65	17.93	794039.0
2014-01-15	AB	Stock	22.73	23.1	22.6	22.86	358200.0
2014-01-15	ABAC-DELISTED	Stock	2.031	2.13	2.03	2.06	41060.0
2014-01-15	ABAX-DELISTED	Stock	43.22	44.52	43.2099	44.28	164842.0
2014-01-15	ABB-DELISTED	Stock	26.15	26.39	26.12	26.32	1670726.0
2014-01-15	ABBNY-DELISTED	Stock	26.15	26.39	26.12	26.31	1784359.0
2014-01-15	ABBV	Stock	50.65	50.67	50.07	50.11	4728400.0
2014-01-15	ABC-DELISTED	Stock	70.74	70.74	70.03	70.55	1079122.0
2014-01-15	ABCB	Stock	20.58	21.09	20.58	20.63	60700.0
2014-01-15	ABCD-DELISTED	Stock	2.0412	2.26	2.0412	2.08	21080.0
2014-01-15	ABCO-DELISTED	Stock	61.27	61.82	60.42	60.58	102121.0
2014-01-15	ABE-DELISTED	Stock	13.42	13.42	13.22	13.4	15721.0
2014-01-15	ABEO	Stock	375.0	375.0	337.5	362.5	8.0
2014-01-15	ABEV	Stock	7.2	7.3	7.15	7.15	7649900.0
2014-01-15	ABFS-DELISTED	Stock	34.81	34.99	34.17	34.89	194819.0
2014-01-15	ABG	Stock	51.3	51.3	48.37	48.5	1065000.0
2014-01-15	ABGB-DELISTED	Stock	17.18	17.18	17.18	17.18	1189.0
2014-01-15	ABM	Stock	27.81	27.98	27.67	27.79	177600.0
2014-01-15	ABMD-DELISTED	Stock	29.42	29.545	27.91	28.42	478175.0
2014-01-15	ABR	Stock	6.88	6.99	6.83	6.99	286500.0
2014-01-15	ABR.A-DELISTED	Stock	24.94	24.95	24.69	24.85	2255.0
2014-01-15	ABR.B-DELISTED	Stock	22.75	22.75	22.75	22.75	1000.0
2014-01-15	ABT	Stock	39.6	39.62	39.25	39.53	5279000.0
2014-01-15	ABTL-DELISTED	Stock	16.52	17.63	16.5	17.05	491636.0
2014-01-15	ABUS	Stock	11.25	11.5	10.94	11.45	209700.0

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

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