PREVIEW / stock_daily / 2014-02-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-12.parquet
  size:    217 KB
  rows:    6,456
  symbols: 3,539

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-02-12	AAPL	Stock	19.1768	19.27	19.0443	19.14	308100800.0
2014-02-12	MSFT	Stock	37.35	37.6	37.3	37.47	27051800.0
2014-02-12	NVDA	Stock	0.4075	0.4238	0.4075	0.4208	744528000.0
2014-02-12	AMZN	Stock	17.8215	17.8875	17.316	17.4625	131754000.0
2014-02-12	META	Stock	64.92	65.06	64.05	64.45	47282100.0
2014-02-12	TSLA	Stock	13.052	13.218	12.9547	13.0213	77605500.0
2014-02-12	TLT	Stock	106.17	106.2099	105.62	105.92	6723271.0
2014-02-12	ES	Stock	44.2	44.45	44.02	44.39	1308600.0
2014-02-12	CL	Stock	62.41	62.74	61.68	61.92	3972100.0
2014-02-12	A	Stock	42.9185	43.2475	42.6824	42.8398	3280826.0
2014-02-12	AABA-DELISTED	Stock	38.6	38.91	38.03	38.1	13306457.0
2014-02-12	AACG	Stock	3.85	3.99	3.85	3.85	2900.0
2014-02-12	AAIC-DELISTED	Stock	25.49	25.57	25.25	25.35	125068.0
2014-02-12	AAL	Stock	34.89	35.0	34.36	34.69	9383300.0
2014-02-12	AAMC-DELISTED	Stock	294.1176	295.5882	289.1179	292.6471	45601.0
2014-02-12	AAME	Stock	3.96	3.96	3.93	3.93	4200.0
2014-02-12	AAOI	Stock	12.87	12.99	12.49	12.52	39100.0
2014-02-12	AAON	Stock	12.3511	12.6044	12.1733	12.5244	216675.0
2014-02-12	AAP	Stock	125.55	126.68	124.29	124.96	663300.0
2014-02-12	AAT	Stock	32.5	32.76	32.29	32.56	194600.0
2014-02-12	AAU-DELISTED	Stock	1.67	1.77	1.61	1.65	271346.0
2014-02-12	AAUAF-DELISTED	Stock	1.66	1.76	1.61	1.66	274515.0
2014-02-12	AAV-DELISTED	Stock	3.93	4.0	3.85	3.87	124070.0
2014-02-12	AAWW-DELISTED	Stock	34.1	34.1	31.29	31.45	1198160.0
2014-02-12	AAXJ	Stock	57.48	57.72	57.2	57.25	853900.0
2014-02-12	AAXN-DELISTED	Stock	16.87	17.08	16.6	16.8	588194.0
2014-02-12	AB	Stock	23.0	23.89	22.65	23.59	812300.0
2014-02-12	ABAC-DELISTED	Stock	1.779	1.81	1.77	1.8	10620.0
2014-02-12	ABAX-DELISTED	Stock	37.86	38.58	37.7	38.56	150263.0
2014-02-12	ABB-DELISTED	Stock	25.55	25.935	25.49	25.68	3040099.0
2014-02-12	ABBNY-DELISTED	Stock	25.57	25.935	25.49	25.67	5580685.0
2014-02-12	ABBV	Stock	49.63	50.93	49.59	50.56	6534500.0
2014-02-12	ABC-DELISTED	Stock	67.81	68.82	67.54	67.75	1782421.0
2014-02-12	ABCB	Stock	20.19	20.44	19.85	19.99	81300.0
2014-02-12	ABCD-DELISTED	Stock	1.92	1.94	1.89	1.94	785.0
2014-02-12	ABCO-DELISTED	Stock	59.24	60.17	59.0	59.97	393046.0
2014-02-12	ABE-DELISTED	Stock	12.61	12.6999	12.58	12.65	14966.0
2014-02-12	ABEO	Stock	375.0	400.0	375.0	387.5	17.0
2014-02-12	ABEV	Stock	6.79	6.81	6.59	6.72	8361500.0
2014-02-12	ABFS-DELISTED	Stock	30.44	32.19	30.2825	32.15	645907.0
2014-02-12	ABG	Stock	49.27	49.52	48.04	48.19	385200.0
2014-02-12	ABGB-DELISTED	Stock	19.45	19.87	19.37	19.7988	3444.0
2014-02-12	ABIL-DELISTED	Stock	9.55	9.88	9.54	9.55	3859.0
2014-02-12	ABM	Stock	27.13	27.43	27.11	27.24	149800.0
2014-02-12	ABMD-DELISTED	Stock	27.12	27.36	26.85	27.36	183749.0
2014-02-12	ABR	Stock	7.0	7.04	6.95	7.04	174900.0
2014-02-12	ABR.A-DELISTED	Stock	24.7	24.7	24.38	24.38	4000.0
2014-02-12	ABR.B-DELISTED	Stock	23.1	23.27	23.1	23.15	700.0
2014-02-12	ABT	Stock	37.93	38.38	37.89	38.26	8793500.0
2014-02-12	ABTL-DELISTED	Stock	18.07	18.11	17.47	17.8	298388.0

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

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