PREVIEW / stock_daily / 2012-04-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-19.parquet
  size:    198 KB
  rows:    6,147
  symbols: 3,527

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-19	AAPL	Stock	21.4364	21.5975	20.8757	20.98	834719200.0
2012-04-19	MSFT	Stock	31.13	31.68	30.94	31.01	54781200.0
2012-04-19	NVDA	Stock	0.3422	0.3553	0.3398	0.3415	667188000.0
2012-04-19	AMZN	Stock	9.6465	9.7275	9.4875	9.555	80048000.0
2012-04-19	TSLA	Stock	2.1833	2.2287	2.1667	2.2107	11623500.0
2012-04-19	TLT	Stock	117.25	117.47	117.02	117.05	5374260.0
2012-04-19	ES	Stock	36.14	36.25	35.84	35.92	1884400.0
2012-04-19	CL	Stock	49.345	49.385	48.875	49.09	3531200.0
2012-04-19	A	Stock	30.3362	30.4649	29.7282	29.9857	3800463.0
2012-04-19	AABA-DELISTED	Stock	15.44	15.57	15.36	15.39	18215309.0
2012-04-19	AACC-DELISTED	Stock	5.0	5.0	4.92	5.0	10431.0
2012-04-19	AACG	Stock	6.44	6.44	6.44	6.44	300.0
2012-04-19	AAIC-DELISTED	Stock	22.47	22.94	22.46	22.88	93481.0
2012-04-19	AAME	Stock	2.92	2.96	2.89	2.93	4300.0
2012-04-19	AAMRQ-DELISTED	Stock	0.481	0.58	0.47	0.58	11453874.0
2012-04-19	AAON	Stock	5.7363	5.7363	5.5793	5.6267	155588.0
2012-04-19	AAP	Stock	90.75	91.6	90.41	90.87	586700.0
2012-04-19	AAT	Stock	22.63	22.67	22.33	22.5	99900.0
2012-04-19	AAU-DELISTED	Stock	2.25	2.28	2.21	2.23	89926.0
2012-04-19	AAUAF-DELISTED	Stock	2.25	2.28	2.21	2.23	90326.0
2012-04-19	AAV-DELISTED	Stock	2.97	3.05	2.925	2.93	150012.0
2012-04-19	AAWW-DELISTED	Stock	47.25	47.46	45.84	46.67	244482.0
2012-04-19	AAXJ	Stock	56.17	56.44	55.6505	55.91	225764.0
2012-04-19	AAXN-DELISTED	Stock	4.17	4.19	4.07	4.12	177714.0
2012-04-19	AB	Stock	14.28	14.3	14.05	14.1	107800.0
2012-04-19	ABAC-DELISTED	Stock	2.15	2.58	2.13	2.13	268816.0
2012-04-19	ABAX-DELISTED	Stock	26.71	26.89	26.11	26.61	82816.0
2012-04-19	ABB-DELISTED	Stock	20.19	20.34	19.89	20.09	2642347.0
2012-04-19	ABBNY-DELISTED	Stock	20.19	20.34	19.89	20.09	2643760.0
2012-04-19	ABC-DELISTED	Stock	37.54	37.74	37.23	37.48	2576630.0
2012-04-19	ABCB	Stock	12.93	13.05	12.67	12.73	34900.0
2012-04-19	ABCD-DELISTED	Stock	2.31	2.46	2.2	2.2	9454.0
2012-04-19	ABCO-DELISTED	Stock	44.19	44.7	43.75	44.34	161956.0
2012-04-19	ABCW-DELISTED	Stock	0.7028	0.753	0.7028	0.753	510.0
2012-04-19	ABD-DELISTED	Stock	11.3	11.36	10.76	10.99	2211090.0
2012-04-19	ABE-DELISTED	Stock	19.23	19.23	19.041	19.058	3996.0
2012-04-19	ABEO	Stock	1475.0	1475.0	1362.5	1462.5	11.0
2012-04-19	ABFS-DELISTED	Stock	18.4	18.46	17.98	17.99	230753.0
2012-04-19	ABG	Stock	27.38	27.46	26.5	26.51	615900.0
2012-04-19	ABH-DELISTED	Stock	13.12	13.12	12.87	13.08	137850.0
2012-04-19	ABM	Stock	23.41	23.51	22.88	23.1	141500.0
2012-04-19	ABMD-DELISTED	Stock	20.83	20.84	20.43	20.7	164435.0
2012-04-19	ABR	Stock	5.59	5.76	5.55	5.64	22600.0
2012-04-19	ABT	Stock	28.7016	28.7352	28.3274	28.5529	22913506.0
2012-04-19	ABTL-DELISTED	Stock	4.55	4.65	4.4	4.45	9465.0
2012-04-19	ABUS	Stock	2.4	2.4	2.4	2.4	400.0
2012-04-19	ABV-DELISTED	Stock	43.29	43.67	42.99	43.31	3521680.0
2012-04-19	ABVA-DELISTED	Stock	4.27	4.27	4.27	4.27	102.0
2012-04-19	ABVT-DELISTED	Stock	82.93	83.01	82.91	82.95	527152.0
2012-04-19	ABX-DELISTED	Stock	41.34	41.48	40.81	40.96	5491493.0

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

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