PREVIEW / stock_daily / 2014-01-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-14.parquet
  size:    217 KB
  rows:    6,444
  symbols: 3,521

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-14	AAPL	Stock	19.2221	19.5261	19.2021	19.5139	332561600.0
2014-01-14	MSFT	Stock	34.73	35.88	34.63	35.78	41623300.0
2014-01-14	NVDA	Stock	0.386	0.3968	0.3842	0.396	241828000.0
2014-01-14	AMZN	Stock	19.6065	19.9315	19.5645	19.877	46802000.0
2014-01-14	META	Stock	56.46	57.78	56.1	57.74	37503600.0
2014-01-14	TSLA	Stock	9.3667	10.8	9.1113	10.7513	414105000.0
2014-01-14	TLT	Stock	104.65	104.83	104.39	104.45	10343500.0
2014-01-14	ES	Stock	42.33	42.52	42.2	42.29	1686700.0
2014-01-14	CL	Stock	64.7	64.99	64.56	64.85	2480000.0
2014-01-14	A	Stock	42.3176	42.8827	42.2175	42.8326	3581956.0
2014-01-14	AABA-DELISTED	Stock	40.21	41.14	40.0401	41.13	13745982.0
2014-01-14	AACG	Stock	4.01	4.02	3.93	3.93	5000.0
2014-01-14	AAIC-DELISTED	Stock	26.61	26.89	26.32	26.56	123537.0
2014-01-14	AAL	Stock	28.75	29.04	28.71	28.87	10600500.0
2014-01-14	AAMC-DELISTED	Stock	313.8	338.5294	310.0	338.5294	136357.0
2014-01-14	AAME	Stock	4.02	4.06	4.02	4.05	7900.0
2014-01-14	AAOI	Stock	13.72	14.13	13.59	13.88	116600.0
2014-01-14	AAON	Stock	13.8444	14.0533	13.6711	13.9822	305100.0
2014-01-14	AAP	Stock	115.4	117.99	113.82	117.6	819500.0
2014-01-14	AAT	Stock	31.69	32.25	31.56	31.99	91800.0
2014-01-14	AAU-DELISTED	Stock	1.27	1.3	1.25	1.27	87991.0
2014-01-14	AAUAF-DELISTED	Stock	1.27	1.3	1.25	1.27	89013.0
2014-01-14	AAV-DELISTED	Stock	4.18	4.22	4.07	4.08	124091.0
2014-01-14	AAWW-DELISTED	Stock	43.05	43.64	42.55	43.35	166764.0
2014-01-14	AAXJ	Stock	58.27	58.514	57.94	58.43	213011.0
2014-01-14	AAXN-DELISTED	Stock	17.64	18.14	17.45	18.06	1196039.0
2014-01-14	AB	Stock	22.52	22.73	22.41	22.66	244300.0
2014-01-14	ABAC-DELISTED	Stock	2.07	2.14	2.05	2.09	22224.0
2014-01-14	ABAX-DELISTED	Stock	43.09	43.648	42.61	43.14	81565.0
2014-01-14	ABB-DELISTED	Stock	26.26	26.428	26.16	26.41	825789.0
2014-01-14	ABBNY-DELISTED	Stock	26.26	26.428	26.16	26.42	1159537.0
2014-01-14	ABBV	Stock	49.94	50.88	49.63	50.6	6610800.0
2014-01-14	ABC-DELISTED	Stock	70.66	70.96	69.61	70.52	2189255.0
2014-01-14	ABCB	Stock	20.35	20.78	20.35	20.64	145000.0
2014-01-14	ABCD-DELISTED	Stock	2.27	2.28	1.98	2.1	106436.0
2014-01-14	ABCO-DELISTED	Stock	59.94	61.74	59.39	61.43	177674.0
2014-01-14	ABE-DELISTED	Stock	13.44	13.52	13.37	13.38	28825.0
2014-01-14	ABEO	Stock	337.5	375.0	337.5	375.0	17.0
2014-01-14	ABEV	Stock	7.23	7.33	7.2	7.27	9118300.0
2014-01-14	ABFS-DELISTED	Stock	33.62	34.92	33.62	34.71	242324.0
2014-01-14	ABG	Stock	50.16	51.42	49.72	51.42	194500.0
2014-01-14	ABGB-DELISTED	Stock	16.6899	16.94	16.65	16.82	16950.0
2014-01-14	ABM	Stock	27.89	27.99	27.68	27.9	138400.0
2014-01-14	ABMD-DELISTED	Stock	29.4	29.74	29.25	29.55	174083.0
2014-01-14	ABR	Stock	6.88	6.91	6.8	6.89	89800.0
2014-01-14	ABR.A-DELISTED	Stock	24.74	25.03	24.5303	24.9	1000.0
2014-01-14	ABR.B-DELISTED	Stock	22.5457	22.9279	22.5457	22.869	1462.0
2014-01-14	ABT	Stock	39.3	39.59	39.07	39.57	6570300.0
2014-01-14	ABTL-DELISTED	Stock	15.02	16.599	14.32	16.46	665220.0
2014-01-14	ABUS	Stock	12.06	12.37	11.03	11.35	518100.0

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

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