PREVIEW / stock_daily / 2014-06-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-04.parquet
  size:    218 KB
  rows:    6,520
  symbols: 3,533

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-06-04	AAPL	Stock	22.7657	23.1389	22.7182	23.0293	335482000.0
2014-06-04	MSFT	Stock	40.21	40.37	39.86	40.32	23209000.0
2014-06-04	NVDA	Stock	0.4702	0.4755	0.47	0.472	161236000.0
2014-06-04	AMZN	Stock	15.3425	15.475	15.192	15.339	42142000.0
2014-06-04	GOOGL	Stock	27.576	27.929	27.428	27.688	34583840.0
2014-06-04	META	Stock	62.45	63.59	62.07	63.34	36514000.0
2014-06-04	TSLA	Stock	13.6233	13.7507	13.36	13.5993	51411000.0
2014-06-04	TLT	Stock	111.76	111.82	111.27	111.54	7884222.0
2014-06-04	ES	Stock	45.25	45.31	45.01	45.27	650700.0
2014-06-04	CL	Stock	67.34	67.73	66.98	67.71	2659500.0
2014-06-04	A	Stock	40.7868	41.1159	40.7439	41.0944	1597774.0
2014-06-04	AABA-DELISTED	Stock	34.43	34.83	34.26	34.72	8400821.0
2014-06-04	AACG	Stock	5.4	5.48	5.24	5.36	21900.0
2014-06-04	AAIC-DELISTED	Stock	27.51	27.69	27.3	27.67	93658.0
2014-06-04	AAL	Stock	41.36	42.9	41.2	42.82	11931500.0
2014-06-04	AAMC-DELISTED	Stock	291.1765	317.7647	291.1765	315.5912	85014.0
2014-06-04	AAME	Stock	3.65	3.66	3.51	3.63	24800.0
2014-06-04	AAOI	Stock	20.08	20.69	19.7	20.34	107300.0
2014-06-04	AAON	Stock	13.6133	13.7733	13.44	13.6444	272475.0
2014-06-04	AAP	Stock	124.82	126.51	124.73	126.46	418300.0
2014-06-04	AAT	Stock	34.21	34.47	34.03	34.35	110600.0
2014-06-04	AAU-DELISTED	Stock	1.34	1.35	1.29	1.34	76439.0
2014-06-04	AAUAF-DELISTED	Stock	1.34	1.35	1.29	1.34	77265.0
2014-06-04	AAV-DELISTED	Stock	6.29	6.44	6.2	6.38	1269214.0
2014-06-04	AAWW-DELISTED	Stock	35.65	36.52	35.65	36.49	113167.0
2014-06-04	AAXJ	Stock	62.08	62.21	61.92	62.18	388561.0
2014-06-04	AAXN-DELISTED	Stock	12.96	13.19	12.87	13.05	429490.0
2014-06-04	AB	Stock	24.85	25.37	24.76	25.25	279200.0
2014-06-04	ABAC-DELISTED	Stock	2.2	2.2	2.101	2.13	48525.0
2014-06-04	ABAX-DELISTED	Stock	41.89	42.2	41.41	41.63	98571.0
2014-06-04	ABB-DELISTED	Stock	23.38	23.45	23.38	23.41	1108032.0
2014-06-04	ABBNY-DELISTED	Stock	23.38	23.45	23.38	23.41	1153533.0
2014-06-04	ABBV	Stock	53.92	54.64	53.67	54.58	3388200.0
2014-06-04	ABC-DELISTED	Stock	73.11	73.67	72.85	73.66	1567188.0
2014-06-04	ABCB	Stock	21.0	21.34	20.88	21.02	30200.0
2014-06-04	ABCD-DELISTED	Stock	2.0982	2.2	2.05	2.199	63781.0
2014-06-04	ABCO-DELISTED	Stock	49.95	51.15	49.87	50.71	256558.0
2014-06-04	ABDC-DELISTED	Stock	14.75	14.78	14.6	14.69	48633.0
2014-06-04	ABE-DELISTED	Stock	14.14	14.14	14.05	14.0555	8426.0
2014-06-04	ABEO	Stock	462.5	462.5	412.5	425.0	258.0
2014-06-04	ABEV	Stock	7.14	7.15	7.0	7.02	5064600.0
2014-06-04	ABG	Stock	65.85	66.42	65.14	65.85	270600.0
2014-06-04	ABGB-DELISTED	Stock	24.15	24.64	24.15	24.51	7463.0
2014-06-04	ABIL-DELISTED	Stock	9.69	10.0	9.67	9.75	20555.0
2014-06-04	ABM	Stock	25.83	26.92	25.42	26.51	448800.0
2014-06-04	ABMD-DELISTED	Stock	22.86	23.18	22.67	22.91	196235.0
2014-06-04	ABR	Stock	7.3	7.3	7.18	7.23	56400.0
2014-06-04	ABR.A-DELISTED	Stock	24.3499	24.3499	24.06	24.2799	5860.0
2014-06-04	ABR.B-DELISTED	Stock	23.75	23.7501	23.7199	23.7199	1453.0
2014-06-04	ABR.C-DELISTED	Stock	25.0	25.0	24.982	25.0	4700.0

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

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