PREVIEW / stock_daily / 2014-10-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-10.parquet
  size:    221 KB
  rows:    6,616
  symbols: 3,553

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-10-10	AAPL	Stock	25.1725	25.5075	25.075	25.1825	265326400.0
2014-10-10	MSFT	Stock	45.6	46.12	43.95	44.03	51978100.0
2014-10-10	NVDA	Stock	0.4442	0.4458	0.421	0.4213	691376000.0
2014-10-10	AMZN	Stock	15.701	15.8885	15.569	15.5695	73638000.0
2014-10-10	GOOGL	Stock	28.3735	28.7615	27.7505	27.7595	59593460.0
2014-10-10	META	Stock	75.59	76.5	72.76	72.91	52146000.0
2014-10-10	TSLA	Stock	16.3093	16.3927	15.68	15.794	193324500.0
2014-10-10	TLT	Stock	119.52	120.08	119.31	120.05	8778325.0
2014-10-10	ES	Stock	46.3	46.92	46.29	46.46	1955700.0
2014-10-10	CL	Stock	65.39	65.76	65.24	65.29	3860900.0
2014-10-10	A	Stock	39.2775	39.3562	38.2117	38.3691	7176773.0
2014-10-10	AA.B-DELISTED	Stock	48.1	48.46	46.99	46.999	253509.0
2014-10-10	AABA-DELISTED	Stock	40.76	41.07	39.59	39.62	35518234.0
2014-10-10	AAC-DELISTED	Stock	19.25	19.36	18.77	19.0	33765.0
2014-10-10	AACG	Stock	4.33	4.35	4.3	4.3	5300.0
2014-10-10	AAIC-DELISTED	Stock	25.7	25.89	25.36	25.55	561651.0
2014-10-10	AAL	Stock	31.55	32.25	29.78	30.78	31018700.0
2014-10-10	AAMC-DELISTED	Stock	184.7059	195.1265	184.7059	190.0176	34235.0
2014-10-10	AAME	Stock	4.0	4.0	3.99	4.0	1000.0
2014-10-10	AAMI	Stock	13.88	14.1	13.56	13.87	1786000.0
2014-10-10	AAOI	Stock	14.0	14.03	13.0	13.07	415300.0
2014-10-10	AAON	Stock	11.2333	11.7267	11.22	11.3533	247650.0
2014-10-10	AAP	Stock	133.35	134.88	132.7	132.81	869400.0
2014-10-10	AAT	Stock	34.3	34.96	34.3	34.41	112000.0
2014-10-10	AAU-DELISTED	Stock	1.35	1.41	1.3093	1.32	87913.0
2014-10-10	AAUAF-DELISTED	Stock	1.31	1.32	1.22	1.32	94816.0
2014-10-10	AAV-DELISTED	Stock	4.51	4.56	4.23	4.38	329616.0
2014-10-10	AAVL-DELISTED	Stock	30.35	31.175	29.76	29.9	125593.0
2014-10-10	AAWW-DELISTED	Stock	32.0	32.78	31.642	31.79	301053.0
2014-10-10	AAXJ	Stock	60.31	60.54	59.79	59.98	1259937.0
2014-10-10	AAXN-DELISTED	Stock	14.7	14.7599	13.91	14.055	1755321.0
2014-10-10	AB	Stock	25.09	25.45	24.15	24.22	454700.0
2014-10-10	ABAC-DELISTED	Stock	2.09	2.1	1.97	2.1	43035.0
2014-10-10	ABAX-DELISTED	Stock	47.39	48.42	47.2532	47.29	111807.0
2014-10-10	ABB-DELISTED	Stock	20.6	20.69	20.39	20.41	2066054.0
2014-10-10	ABBNY-DELISTED	Stock	20.6	20.69	20.39	20.4	2235940.0
2014-10-10	ABBV	Stock	55.99	56.67	54.95	54.97	12108700.0
2014-10-10	ABC-DELISTED	Stock	77.35	78.11	76.86	76.9	1217898.0
2014-10-10	ABCB	Stock	22.05	22.9	22.04	22.34	73600.0
2014-10-10	ABCD-DELISTED	Stock	1.5799	1.5799	1.49	1.56	1177.0
2014-10-10	ABCO-DELISTED	Stock	46.64	47.7	46.44	46.7	227506.0
2014-10-10	ABDC-DELISTED	Stock	12.66	12.74	12.56	12.67	18031.0
2014-10-10	ABE-DELISTED	Stock	13.8	13.85	13.71	13.71	7858.0
2014-10-10	ABEO	Stock	275.0	300.0	275.0	300.0	39.0
2014-10-10	ABEV	Stock	6.7	6.71	6.49	6.49	10413000.0
2014-10-10	ABG	Stock	66.19	67.97	66.0	67.12	414100.0
2014-10-10	ABGB-DELISTED	Stock	19.85	20.01	19.311	19.34	37422.0
2014-10-10	ABIL-DELISTED	Stock	9.75	9.82	9.75	9.82	800.0
2014-10-10	ABM	Stock	25.47	25.76	25.29	25.32	236800.0
2014-10-10	ABMD-DELISTED	Stock	22.91	23.25	22.19	22.225	303671.0

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

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