PREVIEW / stock_daily / 2014-07-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-28.parquet
  size:    220 KB
  rows:    6,596
  symbols: 3,563

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-07-28	AAPL	Stock	24.455	24.81	24.3875	24.755	221272000.0
2014-07-28	MSFT	Stock	44.36	44.51	43.93	43.97	29684200.0
2014-07-28	NVDA	Stock	0.4468	0.4468	0.4355	0.443	330352000.0
2014-07-28	AMZN	Stock	16.2125	16.241	15.825	16.0205	118640000.0
2014-07-28	GOOGL	Stock	29.8875	30.0549	29.6295	29.951	27161420.0
2014-07-28	META	Stock	75.17	75.5	73.85	74.92	41725000.0
2014-07-28	TSLA	Stock	14.95	15.4667	14.76	14.988	97714500.0
2014-07-28	TLT	Stock	115.59	115.9	115.12	115.51	5138315.0
2014-07-28	ES	Stock	45.27	46.18	45.21	46.1	1146600.0
2014-07-28	CL	Stock	67.64	67.89	67.09	67.33	1711600.0
2014-07-28	A	Stock	40.4077	40.4363	39.9785	40.2647	2111260.0
2014-07-28	AABA-DELISTED	Stock	36.23	36.23	35.51	35.9	14128282.0
2014-07-28	AACG	Stock	4.5	4.91	4.42	4.75	60300.0
2014-07-28	AAIC-DELISTED	Stock	26.57	26.738	26.51	26.55	225457.0
2014-07-28	AAL	Stock	41.87	41.95	39.81	40.29	15941300.0
2014-07-28	AAMC-DELISTED	Stock	208.1941	208.1941	198.5294	198.5324	11954.0
2014-07-28	AAME	Stock	3.96	4.07	3.96	4.07	10100.0
2014-07-28	AAOI	Stock	20.51	20.68	19.82	20.31	83800.0
2014-07-28	AAON	Stock	13.52	13.52	13.0533	13.3067	204750.0
2014-07-28	AAP	Stock	125.24	125.27	123.8	124.49	495500.0
2014-07-28	AAT	Stock	35.41	35.84	35.38	35.77	103000.0
2014-07-28	AAU-DELISTED	Stock	1.37	1.41	1.3372	1.404	100483.0
2014-07-28	AAUAF-DELISTED	Stock	1.37	1.41	1.34	1.4	102171.0
2014-07-28	AAV-DELISTED	Stock	5.39	5.5	5.36	5.41	259849.0
2014-07-28	AAWW-DELISTED	Stock	35.08	35.1	34.68	34.9	183408.0
2014-07-28	AAXJ	Stock	65.2	65.57	65.04	65.56	369179.0
2014-07-28	AAXN-DELISTED	Stock	11.48	11.62	11.19	11.31	540066.0
2014-07-28	AB	Stock	27.06	27.25	26.08	26.72	206400.0
2014-07-28	ABAC-DELISTED	Stock	1.9961	2.0	1.88	2.0	25879.0
2014-07-28	ABAX-DELISTED	Stock	46.26	47.98	46.165	47.46	509410.0
2014-07-28	ABB-DELISTED	Stock	23.95	24.056	23.88	24.01	1453314.0
2014-07-28	ABBNY-DELISTED	Stock	23.95	24.056	23.88	24.0	1593525.0
2014-07-28	ABBV	Stock	53.42	54.0	53.17	53.74	10466000.0
2014-07-28	ABC-DELISTED	Stock	76.75	77.72	76.565	77.41	2969027.0
2014-07-28	ABCB	Stock	21.15	21.24	21.0	21.0	51100.0
2014-07-28	ABCD-DELISTED	Stock	1.85	1.88	1.8	1.87	11250.0
2014-07-28	ABCO-DELISTED	Stock	51.75	52.4	51.2	51.63	149155.0
2014-07-28	ABDC-DELISTED	Stock	13.74	13.935	13.5789	13.76	89003.0
2014-07-28	ABE-DELISTED	Stock	14.65	14.67	14.59	14.63	18917.0
2014-07-28	ABEO	Stock	350.0	362.5	350.0	362.5	8.0
2014-07-28	ABEV	Stock	7.42	7.46	7.37	7.41	8722800.0
2014-07-28	ABG	Stock	70.98	71.0	69.58	69.97	170800.0
2014-07-28	ABGB-DELISTED	Stock	26.6501	26.82	26.65	26.75	900.0
2014-07-28	ABM	Stock	25.18	25.19	24.87	24.98	184500.0
2014-07-28	ABMD-DELISTED	Stock	26.21	26.33	25.72	26.31	427090.0
2014-07-28	ABR	Stock	7.18	7.22	7.05	7.09	98100.0
2014-07-28	ABR.A-DELISTED	Stock	25.03	25.12	25.03	25.12	2788.0
2014-07-28	ABR.B-DELISTED	Stock	24.49	24.5599	24.45	24.46	2605.0
2014-07-28	ABR.C-DELISTED	Stock	25.4	25.4	25.391	25.4	2600.0
2014-07-28	ABRN-DELISTED	Stock	25.3	25.3	25.09	25.11	21446.0

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

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