PREVIEW / stock_daily / 2014-07-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-17.parquet
  size:    220 KB
  rows:    6,590
  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-17	AAPL	Stock	23.7575	23.82	23.1425	23.2725	229192000.0
2014-07-17	MSFT	Stock	45.45	45.71	44.25	44.53	82180300.0
2014-07-17	NVDA	Stock	0.4782	0.4875	0.4782	0.4825	324832000.0
2014-07-17	AMZN	Stock	17.672	17.848	17.569	17.6225	72720000.0
2014-07-17	GOOGL	Stock	29.4485	29.475	28.8425	29.041	58832960.0
2014-07-17	META	Stock	67.03	67.85	66.04	66.41	38188000.0
2014-07-17	TSLA	Stock	14.4107	14.7033	14.24	14.36	69741000.0
2014-07-17	TLT	Stock	114.23	115.05	113.94	114.89	10906396.0
2014-07-17	ES	Stock	45.38	45.56	45.05	45.05	730200.0
2014-07-17	CL	Stock	69.36	69.5	68.6	68.6	2366300.0
2014-07-17	A	Stock	40.3934	40.4149	39.4421	39.4492	6156932.0
2014-07-17	AABA-DELISTED	Stock	33.82	33.9	32.98	33.21	36018491.0
2014-07-17	AACG	Stock	4.39	4.4	4.2	4.2	14200.0
2014-07-17	AAIC-DELISTED	Stock	26.72	26.8575	26.4199	26.47	154559.0
2014-07-17	AAL	Stock	43.04	43.44	41.65	41.7	13919700.0
2014-07-17	AAMC-DELISTED	Stock	213.8176	214.1176	205.8824	205.8824	23715.0
2014-07-17	AAME	Stock	3.83	4.0	3.83	3.85	15800.0
2014-07-17	AAOI	Stock	22.43	22.99	21.07	21.46	258400.0
2014-07-17	AAON	Stock	14.1133	14.4533	13.6667	13.7533	265800.0
2014-07-17	AAP	Stock	130.97	131.37	129.73	129.86	480500.0
2014-07-17	AAT	Stock	35.44	35.58	35.23	35.38	200000.0
2014-07-17	AAU-DELISTED	Stock	1.45	1.4801	1.41	1.4499	98375.0
2014-07-17	AAUAF-DELISTED	Stock	1.45	1.48	1.41	1.4499	106117.0
2014-07-17	AAV-DELISTED	Stock	5.63	5.717	5.41	5.45	375115.0
2014-07-17	AAWW-DELISTED	Stock	36.39	36.86	35.94	35.97	186412.0
2014-07-17	AAXJ	Stock	63.55	63.87	63.07	63.11	375107.0
2014-07-17	AAXN-DELISTED	Stock	10.68	10.7883	10.46	10.5	1380465.0
2014-07-17	AB	Stock	27.56	27.73	27.33	27.4	223200.0
2014-07-17	ABAC-DELISTED	Stock	2.23	2.27	2.05	2.06	93033.0
2014-07-17	ABAX-DELISTED	Stock	41.89	42.43	41.57	41.81	131058.0
2014-07-17	ABB-DELISTED	Stock	22.96	23.06	22.77	22.8	2138759.0
2014-07-17	ABBNY-DELISTED	Stock	22.96	23.06	22.77	22.79	2287758.0
2014-07-17	ABBV	Stock	53.21	55.0	52.88	53.52	18699000.0
2014-07-17	ABC-DELISTED	Stock	72.78	73.55	72.49	72.71	1160228.0
2014-07-17	ABCB	Stock	21.0	21.14	21.0	21.03	72300.0
2014-07-17	ABCD-DELISTED	Stock	1.96	1.96	1.92	1.96	3459.0
2014-07-17	ABCO-DELISTED	Stock	50.05	50.81	49.39	49.96	168958.0
2014-07-17	ABDC-DELISTED	Stock	13.95	14.1	13.79	13.91	102276.0
2014-07-17	ABE-DELISTED	Stock	14.66	14.66	14.44	14.45	8748.0
2014-07-17	ABEO	Stock	312.5	325.0	300.0	325.0	42.0
2014-07-17	ABEV	Stock	7.16	7.25	7.08	7.13	11194600.0
2014-07-17	ABG	Stock	70.8	71.11	69.06	69.26	239800.0
2014-07-17	ABGB-DELISTED	Stock	26.81	27.22	26.79	26.873	22685.0
2014-07-17	ABM	Stock	25.8	26.0	25.48	25.51	118500.0
2014-07-17	ABMD-DELISTED	Stock	24.43	24.68	24.19	24.5	218412.0
2014-07-17	ABR	Stock	6.9	6.9	6.83	6.87	124500.0
2014-07-17	ABR.A-DELISTED	Stock	24.83	24.8399	24.79	24.8	2240.0
2014-07-17	ABR.B-DELISTED	Stock	24.7	24.7	24.6	24.6	1400.0
2014-07-17	ABR.C-DELISTED	Stock	25.27	25.34	25.27	25.34	7700.0
2014-07-17	ABRN-DELISTED	Stock	25.08	25.08	25.01	25.02	32859.0

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

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