PREVIEW / stock_daily / 2013-03-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-20.parquet
  size:    206 KB
  rows:    6,268
  symbols: 3,474

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-03-20	AAPL	Stock	16.3364	16.3439	16.0568	16.1457	308660800.0
2013-03-20	MSFT	Stock	28.34	28.49	28.18	28.32	35447800.0
2013-03-20	NVDA	Stock	0.3148	0.3165	0.312	0.3155	340588000.0
2013-03-20	AMZN	Stock	12.9025	12.988	12.7275	12.864	54778000.0
2013-03-20	META	Stock	26.68	26.69	25.78	25.86	44006500.0
2013-03-20	TSLA	Stock	2.3507	2.4047	2.344	2.3967	21345000.0
2013-03-20	TLT	Stock	116.71	116.9901	116.08	116.12	8544030.0
2013-03-20	ES	Stock	42.55	42.98	42.55	42.72	1471100.0
2013-03-20	CL	Stock	56.43	57.4	56.43	57.3	3447800.0
2013-03-20	A	Stock	30.2217	30.608	30.2003	30.5436	4530079.0
2013-03-20	AABA-DELISTED	Stock	22.04	22.33	21.95	22.11	18039991.0
2013-03-20	AACC-DELISTED	Stock	6.49	6.52	6.46	6.5	169736.0
2013-03-20	AACG	Stock	4.06	4.07	4.0	4.0	1400.0
2013-03-20	AAIC-DELISTED	Stock	25.83	25.9	25.75	25.75	252664.0
2013-03-20	AAMC-DELISTED	Stock	42.6471	43.5294	41.7647	43.5294	41269.0
2013-03-20	AAME	Stock	3.34	3.34	3.09	3.34	3000.0
2013-03-20	AAMRQ-DELISTED	Stock	4.1	4.27	4.06	4.26	11499695.0
2013-03-20	AAON	Stock	7.7837	8.077	7.7719	8.0444	555863.0
2013-03-20	AAP	Stock	80.07	80.7	79.8	80.22	730100.0
2013-03-20	AAT	Stock	32.13	32.35	31.88	32.04	80700.0
2013-03-20	AAU-DELISTED	Stock	2.22	2.25	2.13	2.17	75850.0
2013-03-20	AAUAF-DELISTED	Stock	2.22	2.25	2.13	2.17	76050.0
2013-03-20	AAV-DELISTED	Stock	3.34	3.37	3.3	3.33	172846.0
2013-03-20	AAWW-DELISTED	Stock	43.69	43.69	42.4401	42.69	306376.0
2013-03-20	AAXJ	Stock	58.39	58.47	58.18	58.35	1442590.0
2013-03-20	AAXN-DELISTED	Stock	7.94	8.1	7.93	8.06	460409.0
2013-03-20	AB	Stock	21.75	21.89	21.64	21.79	146100.0
2013-03-20	ABAC-DELISTED	Stock	0.71	0.7898	0.7	0.7794	5000.0
2013-03-20	ABAX-DELISTED	Stock	47.13	47.79	46.39	46.74	89100.0
2013-03-20	ABB-DELISTED	Stock	22.82	23.04	22.82	22.95	1056761.0
2013-03-20	ABBNY-DELISTED	Stock	22.82	23.04	22.82	22.97	1091849.0
2013-03-20	ABBV	Stock	38.5	39.19	38.41	39.06	7072900.0
2013-03-20	ABC-DELISTED	Stock	50.3	50.45	49.72	50.24	3139756.0
2013-03-20	ABCB	Stock	14.32	14.4	14.0	14.25	50800.0
2013-03-20	ABCD-DELISTED	Stock	1.13	1.13	0.989	1.0	116675.0
2013-03-20	ABCO-DELISTED	Stock	49.81	50.24	49.47	49.89	73067.0
2013-03-20	ABCW-DELISTED	Stock	0.6	0.65	0.6	0.62	19186.0
2013-03-20	ABE-DELISTED	Stock	21.045	21.43	20.7401	20.96	3190.0
2013-03-20	ABEO	Stock	812.5	812.5	700.0	750.0	90.0
2013-03-20	ABFS-DELISTED	Stock	12.4	12.72	12.2501	12.49	374021.0
2013-03-20	ABG	Stock	37.34	37.88	37.22	37.74	221700.0
2013-03-20	ABM	Stock	22.06	22.28	22.0	22.17	186500.0
2013-03-20	ABMD-DELISTED	Stock	17.75	17.87	17.3	17.43	289062.0
2013-03-20	ABR	Stock	8.1	8.18	8.08	8.14	126700.0
2013-03-20	ABR.A-DELISTED	Stock	25.59	25.7	25.48	25.7	12000.0
2013-03-20	ABT	Stock	33.66	33.82	33.5	33.81	6664900.0
2013-03-20	ABTL-DELISTED	Stock	4.24	4.24	3.92	4.1	134589.0
2013-03-20	ABUS	Stock	4.5	4.55	4.46	4.49	70600.0
2013-03-20	ABV-DELISTED	Stock	43.06	43.22	42.935	43.02	1277088.0
2013-03-20	ABX-DELISTED	Stock	28.91	29.05	28.67	28.85	5989398.0

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

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