PREVIEW / stock_daily / 2014-06-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-03.parquet
  size:    218 KB
  rows:    6,525
  symbols: 3,531

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-03	AAPL	Stock	22.445	22.8121	22.4375	22.7693	292709200.0
2014-06-03	MSFT	Stock	40.6	40.68	40.25	40.29	18068900.0
2014-06-03	NVDA	Stock	0.4745	0.475	0.4652	0.4715	243212000.0
2014-06-03	AMZN	Stock	15.2875	15.396	15.2535	15.3595	47584000.0
2014-06-03	GOOGL	Stock	28.045	28.12	27.6264	27.7255	40632940.0
2014-06-03	META	Stock	62.62	63.42	62.32	62.87	32217000.0
2014-06-03	TSLA	Stock	13.566	13.8667	13.506	13.6627	57912000.0
2014-06-03	TLT	Stock	112.41	112.54	111.51	111.57	12694684.0
2014-06-03	ES	Stock	45.22	45.5	45.13	45.33	902600.0
2014-06-03	CL	Stock	68.03	68.15	67.12	67.24	3143700.0
2014-06-03	A	Stock	40.5794	41.123	40.5436	40.9299	2575535.0
2014-06-03	AABA-DELISTED	Stock	34.8	34.97	34.58	34.64	6142240.0
2014-06-03	AACG	Stock	5.36	5.53	5.3	5.39	25400.0
2014-06-03	AAIC-DELISTED	Stock	27.56	27.68	27.41	27.55	145259.0
2014-06-03	AAL	Stock	41.13	42.09	41.11	41.44	9456200.0
2014-06-03	AAMC-DELISTED	Stock	289.7059	293.2118	285.5882	293.2118	24143.0
2014-06-03	AAME	Stock	3.63	3.65	3.51	3.63	11400.0
2014-06-03	AAOI	Stock	20.34	20.8	19.99	20.13	147300.0
2014-06-03	AAON	Stock	13.9467	13.9644	13.5289	13.6489	910800.0
2014-06-03	AAP	Stock	123.88	125.82	123.77	125.23	733600.0
2014-06-03	AAT	Stock	34.09	34.31	33.99	34.2	146100.0
2014-06-03	AAU-DELISTED	Stock	1.36	1.4	1.34	1.35	41143.0
2014-06-03	AAUAF-DELISTED	Stock	1.31	1.35	1.29	1.35	43165.0
2014-06-03	AAV-DELISTED	Stock	6.19	6.32	6.15	6.285	341186.0
2014-06-03	AAWW-DELISTED	Stock	35.53	36.04	35.21	35.74	164883.0
2014-06-03	AAXJ	Stock	62.06	62.58	62.06	62.48	440459.0
2014-06-03	AAXN-DELISTED	Stock	13.19	13.32	12.98	13.01	577628.0
2014-06-03	AB	Stock	24.42	25.02	24.38	24.96	301700.0
2014-06-03	ABAC-DELISTED	Stock	2.16	2.2	2.1	2.15	27802.0
2014-06-03	ABAX-DELISTED	Stock	41.71	42.145	41.68	42.08	109376.0
2014-06-03	ABB-DELISTED	Stock	23.615	23.62	23.345	23.48	3416475.0
2014-06-03	ABBNY-DELISTED	Stock	23.615	23.62	23.345	23.48	3693263.0
2014-06-03	ABBV	Stock	54.06	54.47	53.87	54.37	3078000.0
2014-06-03	ABC-DELISTED	Stock	72.95	73.2	72.67	73.1	1569208.0
2014-06-03	ABCB	Stock	20.95	21.31	20.87	21.09	80100.0
2014-06-03	ABCD-DELISTED	Stock	2.2	2.2	2.081	2.15	21323.0
2014-06-03	ABCO-DELISTED	Stock	48.42	50.7	48.05	50.42	307132.0
2014-06-03	ABDC-DELISTED	Stock	14.9	14.9	14.7	14.79	23416.0
2014-06-03	ABE-DELISTED	Stock	14.02	14.17	14.02	14.16	12976.0
2014-06-03	ABEO	Stock	487.5	575.0	450.0	512.5	23.0
2014-06-03	ABEV	Stock	7.14	7.2	7.1	7.13	9453700.0
2014-06-03	ABG	Stock	64.43	66.65	64.42	66.2	320200.0
2014-06-03	ABGB-DELISTED	Stock	23.7988	23.94	23.6668	23.8714	5756.0
2014-06-03	ABM	Stock	27.27	27.53	26.48	26.89	227700.0
2014-06-03	ABMD-DELISTED	Stock	22.73	23.086	22.25	23.01	417821.0
2014-06-03	ABR	Stock	7.27	7.3	7.23	7.29	85400.0
2014-06-03	ABR.A-DELISTED	Stock	24.44	24.48	24.21	24.28	22462.0
2014-06-03	ABR.B-DELISTED	Stock	23.83	23.83	23.7	23.79	4400.0
2014-06-03	ABR.C-DELISTED	Stock	24.95	25.02	24.95	24.9601	5100.0
2014-06-03	ABRN-DELISTED	Stock	24.97	25.06	24.92	24.94	19519.0

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

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