PREVIEW / stock_daily / 2014-02-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-24.parquet
  size:    219 KB
  rows:    6,504
  symbols: 3,554

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-02-24	AAPL	Stock	18.6839	18.9257	18.6579	18.8411	288909600.0
2014-02-24	MSFT	Stock	37.69	37.98	37.54	37.69	32085100.0
2014-02-24	NVDA	Stock	0.465	0.4763	0.4608	0.4728	403112000.0
2014-02-24	AMZN	Stock	17.2595	17.65	17.1645	17.589	72894000.0
2014-02-24	META	Stock	68.74	71.44	68.54	70.78	76620300.0
2014-02-24	TSLA	Stock	13.9173	14.5573	13.888	14.51	124176000.0
2014-02-24	TLT	Stock	106.7	106.74	106.165	106.4	3816733.0
2014-02-24	ES	Stock	44.79	44.94	44.4	44.41	2038500.0
2014-02-24	CL	Stock	61.81	62.47	61.58	61.95	3236300.0
2014-02-24	A	Stock	40.3791	40.7582	40.3433	40.5937	3345134.0
2014-02-24	AABA-DELISTED	Stock	37.23	37.71	36.82	37.42	14433577.0
2014-02-24	AACG	Stock	3.96	4.04	3.95	3.97	8100.0
2014-02-24	AAIC-DELISTED	Stock	25.95	26.28	25.944	26.09	97826.0
2014-02-24	AAL	Stock	36.2	36.66	36.02	36.65	7018500.0
2014-02-24	AAMC-DELISTED	Stock	260.25	266.1765	252.6441	265.0029	70271.0
2014-02-24	AAME	Stock	3.93	3.97	3.92	3.93	3800.0
2014-02-24	AAOI	Stock	20.5	21.12	19.1	20.1	297900.0
2014-02-24	AAON	Stock	13.0222	13.2489	12.7778	13.1467	224550.0
2014-02-24	AAP	Stock	128.31	129.1	126.33	126.5	1050700.0
2014-02-24	AAT	Stock	33.55	33.8	33.0	33.29	1385000.0
2014-02-24	AAU-DELISTED	Stock	1.7	1.71	1.6602	1.68	85443.0
2014-02-24	AAUAF-DELISTED	Stock	1.7	1.73	1.68	1.68	85998.0
2014-02-24	AAV-DELISTED	Stock	4.06	4.18	4.02	4.12	254234.0
2014-02-24	AAWW-DELISTED	Stock	32.23	32.73	31.98	31.99	329167.0
2014-02-24	AAXJ	Stock	57.51	58.0591	57.43	57.67	614094.0
2014-02-24	AAXN-DELISTED	Stock	18.9	19.47	18.9	19.06	1281558.0
2014-02-24	AB	Stock	24.24	24.58	23.91	24.46	403900.0
2014-02-24	ABAC-DELISTED	Stock	1.7045	1.78	1.7	1.77	11550.0
2014-02-24	ABAX-DELISTED	Stock	39.23	39.53	38.43	38.99	118862.0
2014-02-24	ABB-DELISTED	Stock	25.1	25.24	25.08	25.1	2074949.0
2014-02-24	ABBNY-DELISTED	Stock	25.1	25.24	25.08	25.1	2136274.0
2014-02-24	ABBV	Stock	51.01	51.56	50.83	50.85	5693000.0
2014-02-24	ABC-DELISTED	Stock	68.31	69.22	68.31	68.59	1230748.0
2014-02-24	ABCB	Stock	20.2	20.6	20.2	20.34	84900.0
2014-02-24	ABCD-DELISTED	Stock	2.0	2.0	1.91	1.92	5900.0
2014-02-24	ABCO-DELISTED	Stock	64.96	65.17	64.27	64.33	260176.0
2014-02-24	ABE-DELISTED	Stock	12.34	12.68	12.34	12.55	25099.0
2014-02-24	ABEO	Stock	450.0	487.5	425.0	487.5	116.0
2014-02-24	ABEV	Stock	7.08	7.15	6.98	7.03	5867400.0
2014-02-24	ABFS-DELISTED	Stock	32.64	34.58	32.64	33.39	511119.0
2014-02-24	ABG	Stock	48.55	48.64	48.04	48.05	278100.0
2014-02-24	ABGB-DELISTED	Stock	21.82	22.65	21.82	22.53	37844.0
2014-02-24	ABIL-DELISTED	Stock	9.61	9.64	9.58	9.6	14796.0
2014-02-24	ABM	Stock	27.71	28.15	27.63	27.86	262000.0
2014-02-24	ABMD-DELISTED	Stock	28.68	28.84	28.224	28.7	330431.0
2014-02-24	ABR	Stock	6.79	6.94	6.78	6.78	99000.0
2014-02-24	ABR.A-DELISTED	Stock	24.13	24.2	24.11	24.15	4013.0
2014-02-24	ABR.B-DELISTED	Stock	23.0	23.0	22.9	22.92	4429.0
2014-02-24	ABT	Stock	38.87	39.35	38.82	38.98	8104600.0
2014-02-24	ABTL-DELISTED	Stock	15.59	15.93	14.5	14.81	555759.0

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

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