PREVIEW / stock_daily / 2014-09-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-11.parquet
  size:    221 KB
  rows:    6,636
  symbols: 3,587

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-09-11	AAPL	Stock	25.1025	25.36	24.905	25.3575	249412400.0
2014-09-11	MSFT	Stock	46.74	47.0	46.47	47.0	29216400.0
2014-09-11	NVDA	Stock	0.4868	0.4885	0.48	0.4852	250720000.0
2014-09-11	AMZN	Stock	16.497	16.6505	16.3195	16.526	54404000.0
2014-09-11	GOOGL	Stock	29.5	29.5972	29.302	29.5555	30029020.0
2014-09-11	META	Stock	77.13	78.36	77.05	77.92	32219000.0
2014-09-11	TSLA	Stock	18.6973	18.986	18.5753	18.6873	56491500.0
2014-09-11	TLT	Stock	115.26	115.54	114.57	114.58	9274904.0
2014-09-11	ES	Stock	45.15	45.47	44.95	45.38	1755000.0
2014-09-11	CL	Stock	63.97	64.5	63.78	64.42	3271900.0
2014-09-11	A	Stock	41.1445	41.2876	41.0658	41.1946	1392268.0
2014-09-11	AABA-DELISTED	Stock	41.02	41.56	40.93	41.245	23598495.0
2014-09-11	AACG	Stock	4.52	4.55	4.52	4.52	3700.0
2014-09-11	AAIC-DELISTED	Stock	27.54	27.66	27.5	27.57	237949.0
2014-09-11	AAL	Stock	38.73	39.04	37.93	38.09	10066700.0
2014-09-11	AAMC-DELISTED	Stock	205.8824	206.7647	205.8824	206.5147	37509.0
2014-09-11	AAME	Stock	4.06	4.07	3.93	3.99	2100.0
2014-09-11	AAOI	Stock	19.16	19.235	18.62	18.99	223900.0
2014-09-11	AAON	Stock	12.3733	12.64	12.1867	12.5933	347250.0
2014-09-11	AAP	Stock	135.01	135.56	133.58	134.42	554800.0
2014-09-11	AAT	Stock	34.6	34.92	34.42	34.77	92600.0
2014-09-11	AAU-DELISTED	Stock	1.5	1.53	1.485	1.4949	190850.0
2014-09-11	AAUAF-DELISTED	Stock	1.5	1.52	1.48	1.5	192074.0
2014-09-11	AAV-DELISTED	Stock	5.74	5.74	5.57	5.66	255054.0
2014-09-11	AAVL-DELISTED	Stock	30.95	32.6	30.22	32.5	150769.0
2014-09-11	AAWW-DELISTED	Stock	34.61	36.9	34.4001	36.37	755710.0
2014-09-11	AAXJ	Stock	64.83	64.98	64.613	64.95	404109.0
2014-09-11	AAXN-DELISTED	Stock	17.91	18.16	17.54	17.79	4010343.0
2014-09-11	AB	Stock	26.85	27.22	26.79	27.12	127500.0
2014-09-11	ABAC-DELISTED	Stock	1.37	1.49	1.31	1.48	158364.0
2014-09-11	ABAX-DELISTED	Stock	48.76	50.78	48.76	50.63	308195.0
2014-09-11	ABB-DELISTED	Stock	22.79	22.97	22.76	22.92	1896554.0
2014-09-11	ABBNY-DELISTED	Stock	22.79	22.97	22.76	22.92	2828169.0
2014-09-11	ABBV	Stock	57.0	57.88	56.85	57.85	9943900.0
2014-09-11	ABC-DELISTED	Stock	77.52	77.725	76.73	77.35	1609755.0
2014-09-11	ABCB	Stock	23.02	23.33	23.02	23.26	60200.0
2014-09-11	ABCD-DELISTED	Stock	1.5	1.61	1.5	1.56	31034.0
2014-09-11	ABCO-DELISTED	Stock	48.62	48.69	47.74	48.56	175024.0
2014-09-11	ABDC-DELISTED	Stock	13.718	13.9	13.718	13.85	30040.0
2014-09-11	ABE-DELISTED	Stock	14.58	14.64	14.56	14.61	16322.0
2014-09-11	ABEO	Stock	400.0	400.0	375.0	387.5	3.0
2014-09-11	ABEV	Stock	6.9	7.02	6.88	6.9	14056800.0
2014-09-11	ABG	Stock	68.44	69.29	68.38	69.03	173500.0
2014-09-11	ABGB-DELISTED	Stock	28.38	28.55	28.38	28.52	6380.0
2014-09-11	ABM	Stock	27.6	28.12	27.6	27.93	201300.0
2014-09-11	ABMD-DELISTED	Stock	24.76	25.33	24.73	25.28	347835.0
2014-09-11	ABR	Stock	6.79	6.88	6.78	6.87	108900.0
2014-09-11	ABR.A-DELISTED	Stock	24.8	24.82	24.74	24.76	19713.0
2014-09-11	ABR.B-DELISTED	Stock	24.07	24.07	23.55	23.75	5580.0
2014-09-11	ABR.C-DELISTED	Stock	25.24	25.25	25.24	25.25	2800.0

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

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