PREVIEW / stock_daily / 2012-04-30

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-30.parquet
  size:    198 KB
  rows:    6,191
  symbols: 3,563

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
2012-04-30	AAPL	Stock	21.35	21.3714	20.8214	20.8564	506144800.0
2012-04-30	MSFT	Stock	31.98	32.11	31.92	32.02	35697200.0
2012-04-30	NVDA	Stock	0.3228	0.3268	0.3205	0.325	262268000.0
2012-04-30	AMZN	Stock	11.1975	11.692	11.1525	11.595	195138000.0
2012-04-30	TSLA	Stock	2.218	2.224	2.172	2.2087	6208500.0
2012-04-30	TLT	Stock	117.57	117.75	117.19	117.32	4198334.0
2012-04-30	ES	Stock	36.79	36.84	36.57	36.77	1605500.0
2012-04-30	CL	Stock	49.075	49.47	49.025	49.47	4164400.0
2012-04-30	A	Stock	30.4077	30.5722	30.0286	30.1717	2605732.0
2012-04-30	AABA-DELISTED	Stock	15.55	15.57	15.45	15.54	10556814.0
2012-04-30	AACC-DELISTED	Stock	5.38	5.38	5.232	5.36	37467.0
2012-04-30	AACG	Stock	6.84	6.84	6.3	6.3	5200.0
2012-04-30	AAIC-DELISTED	Stock	23.68	23.83	23.5	23.51	42385.0
2012-04-30	AAME	Stock	2.88	2.96	2.87	2.94	6000.0
2012-04-30	AAMRQ-DELISTED	Stock	0.576	0.59	0.575	0.579	2607035.0
2012-04-30	AAON	Stock	5.9941	6.2193	5.9289	6.0444	425250.0
2012-04-30	AAP	Stock	92.56	92.72	91.54	91.8	664900.0
2012-04-30	AAT	Stock	23.55	23.88	23.47	23.51	150000.0
2012-04-30	AAU-DELISTED	Stock	2.25	2.36	2.22	2.36	128338.0
2012-04-30	AAUAF-DELISTED	Stock	2.25	2.36	2.22	2.36	128838.0
2012-04-30	AAV-DELISTED	Stock	3.13	3.16	3.07	3.14	167143.0
2012-04-30	AAWW-DELISTED	Stock	45.5	46.14	44.81	46.04	257019.0
2012-04-30	AAXJ	Stock	56.22	56.33	55.95	56.2	326914.0
2012-04-30	AAXN-DELISTED	Stock	4.6	4.65	4.52	4.6	1254639.0
2012-04-30	AB	Stock	14.05	14.19	13.75	14.09	334300.0
2012-04-30	ABAC-DELISTED	Stock	1.8	1.86	1.7	1.84	20419.0
2012-04-30	ABAX-DELISTED	Stock	35.82	36.25	35.58	35.61	183101.0
2012-04-30	ABB-DELISTED	Stock	18.93	18.95	18.78	18.86	3509195.0
2012-04-30	ABBNY-DELISTED	Stock	18.94	18.95	18.78	18.87	3512906.0
2012-04-30	ABC-DELISTED	Stock	36.85	37.33	36.81	37.22	2073138.0
2012-04-30	ABCB	Stock	12.7	12.7	12.28	12.4	92000.0
2012-04-30	ABCD-DELISTED	Stock	2.45	2.48	2.21	2.27	12024.0
2012-04-30	ABCO-DELISTED	Stock	45.49	45.99	45.1	45.59	214641.0
2012-04-30	ABCW-DELISTED	Stock	0.6828	0.6828	0.6526	0.6526	27160.0
2012-04-30	ABD-DELISTED	Stock	10.94	10.97	10.3	10.5	8514950.0
2012-04-30	ABE-DELISTED	Stock	19.45	19.5	19.41	19.47	2601.0
2012-04-30	ABEO	Stock	1275.0	1362.5	1275.0	1362.5	6.0
2012-04-30	ABFS-DELISTED	Stock	15.85	16.18	15.0	15.33	915216.0
2012-04-30	ABG	Stock	28.72	28.75	27.65	27.92	349400.0
2012-04-30	ABH-DELISTED	Stock	13.27	13.32	13.2	13.26	417394.0
2012-04-30	ABM	Stock	23.4	23.41	23.15	23.28	187000.0
2012-04-30	ABMD-DELISTED	Stock	24.65	24.7	24.0	24.32	515930.0
2012-04-30	ABR	Stock	5.79	5.82	5.52	5.61	22000.0
2012-04-30	ABT	Stock	29.6229	29.8676	29.6037	29.7764	12385786.0
2012-04-30	ABTL-DELISTED	Stock	4.6505	4.6505	4.4989	4.6	2219.0
2012-04-30	ABUS	Stock	2.45	2.49	2.34	2.42	1100.0
2012-04-30	ABV-DELISTED	Stock	42.86	43.12	41.72	41.99	4598929.0
2012-04-30	ABVT-DELISTED	Stock	83.28	83.28	83.1	83.17	359393.0
2012-04-30	ABX-DELISTED	Stock	40.41	40.57	39.73	40.41	5354465.0
2012-04-30	ACAD	Stock	1.55	1.59	1.5	1.5	298100.0

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

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