PREVIEW / stock_daily / 2013-09-24

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-24.parquet
  size:    213 KB
  rows:    6,365
  symbols: 3,513

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
2013-09-24	AAPL	Stock	17.6743	17.6954	17.4221	17.4679	364344400.0
2013-09-24	MSFT	Stock	32.87	32.87	32.15	32.45	40685000.0
2013-09-24	NVDA	Stock	0.3913	0.394	0.389	0.3925	229732000.0
2013-09-24	AMZN	Stock	15.6215	15.904	15.564	15.7065	40672000.0
2013-09-24	META	Stock	48.51	49.66	48.16	48.45	136716100.0
2013-09-24	TSLA	Stock	11.9427	12.3307	11.8433	12.1553	94101000.0
2013-09-24	TLT	Stock	105.99	106.84	105.845	106.83	11447619.0
2013-09-24	ES	Stock	41.58	41.7	41.37	41.54	1230000.0
2013-09-24	CL	Stock	60.02	60.42	59.83	59.87	2600300.0
2013-09-24	A	Stock	36.917	37.1388	36.6237	36.9099	3080912.0
2013-09-24	AABA-DELISTED	Stock	30.55	31.66	30.54	31.27	27110733.0
2013-09-24	AACG	Stock	4.68	4.68	4.55	4.55	200.0
2013-09-24	AAIC-DELISTED	Stock	26.14	26.62	26.07	26.45	215383.0
2013-09-24	AAMC-DELISTED	Stock	112.0529	136.7676	112.0529	132.3529	233012.0
2013-09-24	AAME	Stock	3.99	4.05	3.92	4.04	10400.0
2013-09-24	AAMRQ-DELISTED	Stock	3.95	4.19	3.91	4.13	9246126.0
2013-09-24	AAON	Stock	11.6089	11.9067	11.5244	11.6667	169200.0
2013-09-24	AAP	Stock	79.6	80.59	79.24	80.1	665400.0
2013-09-24	AAT	Stock	30.82	30.97	30.53	30.75	82600.0
2013-09-24	AAU-DELISTED	Stock	1.33	1.39	1.32	1.36	100925.0
2013-09-24	AAUAF-DELISTED	Stock	1.32	1.37	1.31	1.36	102226.0
2013-09-24	AAV-DELISTED	Stock	3.61	3.7	3.58	3.67	259851.0
2013-09-24	AAWW-DELISTED	Stock	46.1	46.11	45.42	45.51	148195.0
2013-09-24	AAXJ	Stock	59.59	59.74	59.29	59.45	304166.0
2013-09-24	AAXN-DELISTED	Stock	14.44	15.09	14.42	14.65	1292424.0
2013-09-24	AB	Stock	20.38	20.4	19.73	19.88	393100.0
2013-09-24	ABAC-DELISTED	Stock	0.79	0.8298	0.78	0.8	24500.0
2013-09-24	ABAX-DELISTED	Stock	42.02	42.24	41.428	41.9	116622.0
2013-09-24	ABB-DELISTED	Stock	23.82	23.97	23.67	23.77	1387540.0
2013-09-24	ABBNY-DELISTED	Stock	23.82	23.97	23.67	23.76	1505714.0
2013-09-24	ABBV	Stock	46.95	46.95	45.94	45.98	7162700.0
2013-09-24	ABC-DELISTED	Stock	61.73	61.9	60.84	60.92	1303676.0
2013-09-24	ABCB	Stock	18.95	19.09	18.65	18.91	427400.0
2013-09-24	ABCD-DELISTED	Stock	1.568	1.6299	1.51	1.6	9730.0
2013-09-24	ABCO-DELISTED	Stock	59.88	60.02	58.84	59.66	75377.0
2013-09-24	ABE-DELISTED	Stock	19.9	19.98	19.801	19.88	5200.0
2013-09-24	ABEO	Stock	587.5	587.5	437.5	500.0	73.0
2013-09-24	ABFS-DELISTED	Stock	25.1	26.09	25.1	25.64	286112.0
2013-09-24	ABG	Stock	53.0	53.71	52.41	53.24	123400.0
2013-09-24	ABM	Stock	26.48	26.67	26.38	26.46	219300.0
2013-09-24	ABMD-DELISTED	Stock	19.2	20.78	18.79	20.43	1473023.0
2013-09-24	ABR	Stock	6.87	6.92	6.8	6.9	5229500.0
2013-09-24	ABR.A-DELISTED	Stock	24.71	24.71	24.7	24.7	300.0
2013-09-24	ABR.B-DELISTED	Stock	23.5	23.5001	23.03	23.362	3800.0
2013-09-24	ABT	Stock	35.07	35.1	34.32	34.36	9829500.0
2013-09-24	ABTL-DELISTED	Stock	7.46	7.46	7.35	7.44	48483.0
2013-09-24	ABUS	Stock	6.25	7.14	6.15	6.88	377300.0
2013-09-24	ABV-DELISTED	Stock	39.3	39.3	38.96	39.03	1523763.0
2013-09-24	ABX-DELISTED	Stock	18.22	18.7	18.05	18.59	15830035.0
2013-09-24	ACAD	Stock	24.51	25.11	24.4	24.94	1121000.0

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

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