PREVIEW / stock_daily / 2013-04-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-18.parquet
  size:    206 KB
  rows:    6,247
  symbols: 3,468

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-04-18	AAPL	Stock	14.4639	14.4925	13.9193	14.0018	666299200.0
2013-04-18	MSFT	Stock	28.95	28.98	28.5	28.79	56906600.0
2013-04-18	NVDA	Stock	0.3205	0.3225	0.3135	0.3135	402548000.0
2013-04-18	AMZN	Stock	13.3405	13.3495	12.83	12.971	62752000.0
2013-04-18	META	Stock	26.82	26.82	25.15	25.69	39059000.0
2013-04-18	TSLA	Stock	3.0653	3.1733	3.026	3.1313	50518500.0
2013-04-18	TLT	Stock	122.81	123.22	122.6	123.09	7010053.0
2013-04-18	ES	Stock	44.08	44.35	43.85	44.2	2049600.0
2013-04-18	CL	Stock	59.025	59.59	59.0	59.285	2743400.0
2013-04-18	A	Stock	29.8784	30.2217	29.671	29.9213	5559706.0
2013-04-18	AABA-DELISTED	Stock	23.66	23.6999	22.7	23.26	25361587.0
2013-04-18	AACC-DELISTED	Stock	6.49	6.51	6.48	6.495	194086.0
2013-04-18	AAIC-DELISTED	Stock	25.28	25.41	25.01	25.19	263617.0
2013-04-18	AAMC-DELISTED	Stock	38.9706	39.1912	38.8235	38.8235	8010.0
2013-04-18	AAME	Stock	3.37	3.4	3.34	3.38	5100.0
2013-04-18	AAMRQ-DELISTED	Stock	4.03	4.04	3.83	3.86	3978360.0
2013-04-18	AAON	Stock	8.1185	8.1985	7.9911	8.0178	163350.0
2013-04-18	AAP	Stock	79.8	79.86	78.81	78.92	653600.0
2013-04-18	AAT	Stock	32.11	32.46	31.77	32.32	153300.0
2013-04-18	AAU-DELISTED	Stock	1.46	1.6	1.45	1.56	218484.0
2013-04-18	AAUAF-DELISTED	Stock	1.46	1.6	1.45	1.57	222379.0
2013-04-18	AAV-DELISTED	Stock	3.52	3.72	3.46	3.72	723166.0
2013-04-18	AAWW-DELISTED	Stock	38.04	38.4975	37.75	38.18	316966.0
2013-04-18	AAXJ	Stock	57.7	57.7	57.17	57.31	272750.0
2013-04-18	AAXN-DELISTED	Stock	7.93	8.025	7.78	7.94	499971.0
2013-04-18	AB	Stock	22.49	22.49	22.25	22.39	161800.0
2013-04-18	ABAC-DELISTED	Stock	0.83	0.84	0.8	0.8	48146.0
2013-04-18	ABAX-DELISTED	Stock	44.43	45.64	44.0	44.85	135836.0
2013-04-18	ABB-DELISTED	Stock	21.67	21.69	21.36	21.47	2005203.0
2013-04-18	ABBNY-DELISTED	Stock	21.67	21.69	21.36	21.47	2129724.0
2013-04-18	ABBV	Stock	42.37	42.64	41.89	42.32	5009000.0
2013-04-18	ABC-DELISTED	Stock	55.06	56.07	55.02	55.44	4214632.0
2013-04-18	ABCB	Stock	13.35	13.78	13.05	13.16	37500.0
2013-04-18	ABCD-DELISTED	Stock	0.96	1.01	0.95	0.985	67290.0
2013-04-18	ABCO-DELISTED	Stock	49.39	49.63	47.55	47.89	245940.0
2013-04-18	ABCW-DELISTED	Stock	0.62	0.67	0.62	0.67	6418.0
2013-04-18	ABE-DELISTED	Stock	20.77	20.9269	20.75	20.76	3745.0
2013-04-18	ABEO	Stock	537.5	537.5	525.0	537.5	53.0
2013-04-18	ABFS-DELISTED	Stock	10.24	10.44	9.88	10.44	256592.0
2013-04-18	ABG	Stock	35.09	35.27	33.44	33.56	266700.0
2013-04-18	ABM	Stock	20.57	20.64	20.3	20.46	267400.0
2013-04-18	ABMD-DELISTED	Stock	18.0	18.079	17.24	17.44	351231.0
2013-04-18	ABR	Stock	7.41	7.41	7.1	7.12	268600.0
2013-04-18	ABR.A-DELISTED	Stock	25.81	25.889	25.8	25.8	1895.0
2013-04-18	ABT	Stock	37.45	37.47	36.61	36.88	7750800.0
2013-04-18	ABTL-DELISTED	Stock	4.22	4.29	4.18	4.2	18940.0
2013-04-18	ABUS	Stock	4.52	4.59	4.46	4.47	59600.0
2013-04-18	ABV-DELISTED	Stock	39.65	39.84	39.25	39.28	2358087.0
2013-04-18	ABX-DELISTED	Stock	17.99	18.2449	17.59	17.99	39749022.0
2013-04-18	ACAD	Stock	12.32	12.39	11.97	12.18	2698100.0

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

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