PREVIEW / stock_daily / 2013-04-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-19.parquet
  size:    206 KB
  rows:    6,265
  symbols: 3,481

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-19	AAPL	Stock	13.8561	14.2714	13.7536	13.9475	609274400.0
2013-04-19	MSFT	Stock	29.62	30.24	29.61	29.77	99790700.0
2013-04-19	NVDA	Stock	0.3133	0.3153	0.3093	0.3143	303028000.0
2013-04-19	AMZN	Stock	12.908	13.144	12.875	13.016	52050000.0
2013-04-19	META	Stock	25.62	25.96	25.33	25.73	20380900.0
2013-04-19	TSLA	Stock	3.164	3.3253	3.138	3.1887	45175500.0
2013-04-19	TLT	Stock	122.94	122.98	122.63	122.83	5474711.0
2013-04-19	ES	Stock	44.21	44.94	44.13	44.94	1203000.0
2013-04-19	CL	Stock	59.33	59.945	59.29	59.86	2951600.0
2013-04-19	A	Stock	29.9642	30.2003	29.7926	30.0429	4297592.0
2013-04-19	AABA-DELISTED	Stock	23.12	23.63	22.83	23.475	17744644.0
2013-04-19	AACC-DELISTED	Stock	6.49	6.51	6.47	6.49	59516.0
2013-04-19	AAIC-DELISTED	Stock	25.27	25.45	25.11	25.3	155826.0
2013-04-19	AAMC-DELISTED	Stock	39.1176	39.1176	38.8529	38.8529	4760.0
2013-04-19	AAME	Stock	3.4	3.41	3.4	3.4	3400.0
2013-04-19	AAMRQ-DELISTED	Stock	3.85	3.9	3.79	3.86	2152786.0
2013-04-19	AAON	Stock	8.0119	8.1719	7.9941	8.1067	239963.0
2013-04-19	AAP	Stock	79.14	80.69	77.98	79.93	1045000.0
2013-04-19	AAT	Stock	32.31	33.07	32.29	33.04	108200.0
2013-04-19	AAU-DELISTED	Stock	1.59	1.67	1.57	1.6	113983.0
2013-04-19	AAUAF-DELISTED	Stock	1.59	1.67	1.57	1.6	114383.0
2013-04-19	AAV-DELISTED	Stock	3.77	3.77	3.68	3.73	315763.0
2013-04-19	AAWW-DELISTED	Stock	38.12	38.735	37.74	38.08	159276.0
2013-04-19	AAXJ	Stock	58.12	58.38	58.04	58.33	398621.0
2013-04-19	AAXN-DELISTED	Stock	7.95	8.11	7.895	8.02	379227.0
2013-04-19	AB	Stock	22.6	22.63	22.4	22.59	142300.0
2013-04-19	ABAC-DELISTED	Stock	0.78	0.83	0.78	0.8	42400.0
2013-04-19	ABAX-DELISTED	Stock	44.84	45.9	43.76	44.98	143907.0
2013-04-19	ABB-DELISTED	Stock	21.48	21.54	21.34	21.43	1279186.0
2013-04-19	ABBNY-DELISTED	Stock	21.48	21.54	21.34	21.42	1288922.0
2013-04-19	ABBV	Stock	42.51	42.58	42.2	42.39	6493200.0
2013-04-19	ABC-DELISTED	Stock	55.61	55.99	55.24	55.92	1972249.0
2013-04-19	ABCB	Stock	13.14	13.47	13.14	13.45	21200.0
2013-04-19	ABCD-DELISTED	Stock	0.97	0.99	0.9676	0.9825	12600.0
2013-04-19	ABCO-DELISTED	Stock	47.74	48.0	46.89	47.07	313803.0
2013-04-19	ABCW-DELISTED	Stock	0.65	0.65	0.64	0.64	12474.0
2013-04-19	ABE-DELISTED	Stock	20.92	20.92	20.73	20.77	1541.0
2013-04-19	ABEO	Stock	512.5	512.5	500.0	500.0	28.0
2013-04-19	ABFS-DELISTED	Stock	10.45	10.945	10.24	10.9	382883.0
2013-04-19	ABG	Stock	33.69	34.46	33.23	34.18	480300.0
2013-04-19	ABM	Stock	20.46	20.77	20.38	20.46	221200.0
2013-04-19	ABMD-DELISTED	Stock	17.42	17.92	17.32	17.83	202324.0
2013-04-19	ABR	Stock	7.26	7.29	7.18	7.23	241900.0
2013-04-19	ABR.A-DELISTED	Stock	25.8	25.93	25.8	25.9	3068.0
2013-04-19	ABT	Stock	37.05	37.3	36.91	37.2	6665900.0
2013-04-19	ABTL-DELISTED	Stock	4.2	4.2	4.06	4.12	7244.0
2013-04-19	ABUS	Stock	4.47	4.68	4.47	4.65	42400.0
2013-04-19	ABV-DELISTED	Stock	39.55	39.85	39.27	39.74	1625441.0
2013-04-19	ABX-DELISTED	Stock	18.58	18.92	17.76	18.175	30438766.0
2013-04-19	ACAD	Stock	12.2	12.3	11.81	12.09	4033000.0

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

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