PREVIEW / stock_daily / 2014-08-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-18.parquet
  size:    221 KB
  rows:    6,637
  symbols: 3,585

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-08-18	AAPL	Stock	24.6225	24.8425	24.495	24.79	190288000.0
2014-08-18	MSFT	Stock	44.94	45.11	44.68	45.11	26891100.0
2014-08-18	NVDA	Stock	0.478	0.483	0.4732	0.4825	284076000.0
2014-08-18	AMZN	Stock	16.774	16.89	16.6885	16.7265	49708000.0
2014-08-18	GOOGL	Stock	29.355	29.7525	29.3275	29.635	29415120.0
2014-08-18	META	Stock	74.0	74.72	73.96	74.59	23974000.0
2014-08-18	TSLA	Stock	17.55	17.8173	17.3167	17.3293	87738000.0
2014-08-18	TLT	Stock	117.21	117.3	116.39	116.54	7595663.0
2014-08-18	ES	Stock	44.23	44.46	44.01	44.18	948800.0
2014-08-18	CL	Stock	64.35	65.0	64.3	64.62	3797400.0
2014-08-18	A	Stock	41.309	41.9313	41.0229	41.8598	3860717.0
2014-08-18	AABA-DELISTED	Stock	36.77	37.77	36.75	37.38	19263264.0
2014-08-18	AACG	Stock	4.75	4.75	4.69	4.75	10100.0
2014-08-18	AAIC-DELISTED	Stock	27.48	27.57	27.44	27.54	121029.0
2014-08-18	AAL	Stock	39.6	40.9	39.6	40.66	10900700.0
2014-08-18	AAMC-DELISTED	Stock	162.4235	170.5529	162.4235	170.5529	21899.0
2014-08-18	AAME	Stock	4.15	4.19	4.06	4.13	6900.0
2014-08-18	AAOI	Stock	18.61	19.0	18.29	18.89	300800.0
2014-08-18	AAON	Stock	12.52	12.8333	12.4533	12.7467	235650.0
2014-08-18	AAP	Stock	132.08	133.35	131.88	133.33	678600.0
2014-08-18	AAT	Stock	35.05	35.34	34.8	35.33	159000.0
2014-08-18	AAU-DELISTED	Stock	1.5	1.52	1.476	1.5	26674.0
2014-08-18	AAUAF-DELISTED	Stock	1.49	1.51	1.471	1.5	27275.0
2014-08-18	AAV-DELISTED	Stock	5.72	5.74	5.47	5.61	635990.0
2014-08-18	AAVL-DELISTED	Stock	28.8	28.9	27.3101	28.02	41408.0
2014-08-18	AAWW-DELISTED	Stock	33.35	33.82	33.035	33.76	193411.0
2014-08-18	AAXJ	Stock	65.56	65.76	65.44	65.75	366829.0
2014-08-18	AAXN-DELISTED	Stock	14.71	15.58	14.57	14.67	5199703.0
2014-08-18	AB	Stock	25.6	26.03	25.55	25.82	157100.0
2014-08-18	ABAC-DELISTED	Stock	2.0	2.0	1.95	1.95	5300.0
2014-08-18	ABAX-DELISTED	Stock	45.89	46.33	45.82	45.91	100830.0
2014-08-18	ABB-DELISTED	Stock	22.56	22.62	22.51	22.61	912582.0
2014-08-18	ABBNY-DELISTED	Stock	22.56	22.62	22.51	22.61	979797.0
2014-08-18	ABBV	Stock	54.39	54.52	53.84	54.31	7370500.0
2014-08-18	ABC-DELISTED	Stock	76.53	76.99	76.36	76.6	593784.0
2014-08-18	ABCB	Stock	22.5	22.78	22.5	22.72	127100.0
2014-08-18	ABCD-DELISTED	Stock	1.79	1.86	1.78	1.79	3708.0
2014-08-18	ABCO-DELISTED	Stock	49.73	50.34	49.51	50.26	272322.0
2014-08-18	ABDC-DELISTED	Stock	13.2	13.42	13.05	13.33	81132.0
2014-08-18	ABE-DELISTED	Stock	14.58	14.6	14.52	14.59	48757.0
2014-08-18	ABEO	Stock	412.5	437.5	387.5	437.5	3.0
2014-08-18	ABEV	Stock	7.02	7.11	6.98	7.1	13917300.0
2014-08-18	ABG	Stock	69.79	70.2	68.99	69.49	173400.0
2014-08-18	ABGB-DELISTED	Stock	25.54	25.75	25.4401	25.72	7714.0
2014-08-18	ABM	Stock	26.23	26.25	25.87	25.9	403400.0
2014-08-18	ABMD-DELISTED	Stock	25.17	25.37	24.89	25.32	148098.0
2014-08-18	ABR	Stock	6.97	6.98	6.91	6.94	86600.0
2014-08-18	ABR.A-DELISTED	Stock	24.54	24.68	24.54	24.6	10045.0
2014-08-18	ABR.B-DELISTED	Stock	24.199	24.2	24.03	24.15	5414.0
2014-08-18	ABR.C-DELISTED	Stock	25.04	25.04	25.0	25.0399	1758.0

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

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