PREVIEW / stock_daily / 2014-03-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-04.parquet
  size:    219 KB
  rows:    6,511
  symbols: 3,552

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-03-04	AAPL	Stock	18.9643	19.0229	18.8489	18.9729	259140000.0
2014-03-04	MSFT	Stock	38.2	38.48	38.07	38.41	26802400.0
2014-03-04	NVDA	Stock	0.4595	0.465	0.4588	0.462	260344000.0
2014-03-04	AMZN	Stock	18.195	18.284	18.123	18.195	54088000.0
2014-03-04	META	Stock	68.66	68.9	67.62	68.8	42013500.0
2014-03-04	TSLA	Stock	17.232	17.3333	16.8553	16.9893	131184000.0
2014-03-04	TLT	Stock	108.35	108.35	107.36	107.39	8068066.0
2014-03-04	ES	Stock	44.25	44.29	44.05	44.18	1337600.0
2014-03-04	CL	Stock	62.67	63.26	62.67	63.01	2937600.0
2014-03-04	A	Stock	40.9299	41.4878	40.7582	41.3305	3972976.0
2014-03-04	AABA-DELISTED	Stock	38.76	39.79	38.68	39.62	15453063.0
2014-03-04	AACG	Stock	4.27	4.36	4.27	4.33	28600.0
2014-03-04	AAIC-DELISTED	Stock	26.5	27.05	26.5	26.8	241016.0
2014-03-04	AAL	Stock	36.57	37.46	36.57	37.34	11739700.0
2014-03-04	AAMC-DELISTED	Stock	218.6059	227.0294	217.9529	226.9118	29260.0
2014-03-04	AAME	Stock	3.91	3.92	3.77	3.77	21800.0
2014-03-04	AAOI	Stock	25.02	25.39	24.05	24.64	217000.0
2014-03-04	AAON	Stock	13.1289	13.8978	13.1289	13.6711	1374075.0
2014-03-04	AAP	Stock	128.33	129.99	126.16	126.42	1126500.0
2014-03-04	AAT	Stock	33.45	33.92	33.45	33.62	260500.0
2014-03-04	AAU-DELISTED	Stock	1.65	1.65	1.62	1.62	65095.0
2014-03-04	AAUAF-DELISTED	Stock	1.63	1.65	1.62	1.62	66032.0
2014-03-04	AAV-DELISTED	Stock	4.09	4.09	3.99	4.01	120435.0
2014-03-04	AAWW-DELISTED	Stock	30.41	31.25	30.41	30.95	336657.0
2014-03-04	AAXJ	Stock	58.24	58.46	58.11	58.24	514558.0
2014-03-04	AAXN-DELISTED	Stock	19.83	20.39	19.83	20.28	1333076.0
2014-03-04	AB	Stock	24.0	24.25	23.72	24.22	329900.0
2014-03-04	ABAC-DELISTED	Stock	1.88	1.95	1.8413	1.95	34700.0
2014-03-04	ABAX-DELISTED	Stock	38.15	39.23	38.15	38.69	228070.0
2014-03-04	ABB-DELISTED	Stock	25.61	25.64	25.45	25.48	1552906.0
2014-03-04	ABBNY-DELISTED	Stock	25.61	25.64	25.45	25.48	1606166.0
2014-03-04	ABBV	Stock	50.73	51.73	50.53	51.59	6198000.0
2014-03-04	ABC-DELISTED	Stock	68.03	68.94	67.97	68.75	2061611.0
2014-03-04	ABCB	Stock	20.91	21.62	20.88	21.29	121000.0
2014-03-04	ABCD-DELISTED	Stock	1.99	2.03	1.96	1.96	22269.0
2014-03-04	ABCO-DELISTED	Stock	65.14	66.96	64.79	66.79	276513.0
2014-03-04	ABE-DELISTED	Stock	12.46	12.55	12.42	12.4999	22232.0
2014-03-04	ABEV	Stock	7.12	7.37	7.1	7.18	5728700.0
2014-03-04	ABFS-DELISTED	Stock	33.29	35.3793	32.95	34.88	385921.0
2014-03-04	ABG	Stock	51.26	53.39	50.73	53.13	548100.0
2014-03-04	ABGB-DELISTED	Stock	23.3	23.3499	23.0	23.09	4116.0
2014-03-04	ABIL-DELISTED	Stock	9.62	9.62	9.62	9.62	288.0
2014-03-04	ABM	Stock	28.53	29.5	28.47	29.43	455900.0
2014-03-04	ABMD-DELISTED	Stock	27.96	28.48	27.65	28.45	380181.0
2014-03-04	ABR	Stock	6.87	6.9	6.81	6.86	63300.0
2014-03-04	ABR.A-DELISTED	Stock	24.27	24.31	24.26	24.31	7471.0
2014-03-04	ABR.B-DELISTED	Stock	23.0	23.0	22.9604	23.0	8036.0
2014-03-04	ABR.C-DELISTED	Stock	24.25	24.39	24.066	24.25	91842.0
2014-03-04	ABT	Stock	39.74	40.32	39.67	40.12	9460200.0
2014-03-04	ABTL-DELISTED	Stock	15.25	15.25	14.3	14.92	252059.0

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

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