PREVIEW / stock_daily / 2012-06-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-15.parquet
  size:    199 KB
  rows:    6,185
  symbols: 3,540

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-06-15	AAPL	Stock	20.3929	20.5221	20.3411	20.5046	335255200.0
2012-06-15	MSFT	Stock	29.59	30.08	29.49	30.02	62314400.0
2012-06-15	NVDA	Stock	0.303	0.3075	0.3002	0.3073	385288000.0
2012-06-15	AMZN	Stock	10.7645	10.9665	10.723	10.9175	75704000.0
2012-06-15	META	Stock	28.51	30.1	28.35	30.01	43563800.0
2012-06-15	TSLA	Stock	1.9593	1.9967	1.9207	1.994	9702000.0
2012-06-15	TLT	Stock	126.58	126.85	126.14	126.4	6421386.0
2012-06-15	ES	Stock	38.43	38.57	38.03	38.48	2070600.0
2012-06-15	CL	Stock	50.8	50.965	50.655	50.765	4105600.0
2012-06-15	A	Stock	28.3763	28.6481	28.2332	28.6195	4036725.0
2012-06-15	AABA-DELISTED	Stock	15.44	15.44	15.33	15.37	11606434.0
2012-06-15	AACC-DELISTED	Stock	5.81	5.88	5.63	5.8	34595.0
2012-06-15	AACG	Stock	4.35	4.36	3.09	3.18	41400.0
2012-06-15	AAIC-DELISTED	Stock	22.63	22.76	22.45	22.51	98714.0
2012-06-15	AAME	Stock	2.7	2.72	2.67	2.72	10200.0
2012-06-15	AAMRQ-DELISTED	Stock	0.469	0.47	0.455	0.455	422030.0
2012-06-15	AAON	Stock	5.7778	6.0296	5.7778	5.9941	330750.0
2012-06-15	AAP	Stock	70.41	71.0	69.39	69.74	1823800.0
2012-06-15	AAT	Stock	23.1	23.23	22.98	23.08	293700.0
2012-06-15	AAU-DELISTED	Stock	2.3	2.3	2.2	2.23	91422.0
2012-06-15	AAUAF-DELISTED	Stock	2.3	2.3	2.22	2.23	105458.0
2012-06-15	AAV-DELISTED	Stock	2.74	2.86	2.74	2.85	178273.0
2012-06-15	AAWW-DELISTED	Stock	42.95	43.2	41.53	42.44	274903.0
2012-06-15	AAXJ	Stock	52.01	52.48	51.79	52.43	920142.0
2012-06-15	AAXN-DELISTED	Stock	5.17	5.2	5.06	5.08	416381.0
2012-06-15	AB	Stock	11.85	11.88	11.73	11.82	460900.0
2012-06-15	ABAC-DELISTED	Stock	1.34	1.5	1.25	1.44	21249.0
2012-06-15	ABAX-DELISTED	Stock	34.12	34.59	34.12	34.48	162753.0
2012-06-15	ABB-DELISTED	Stock	15.86	16.02	15.812	16.01	2548023.0
2012-06-15	ABBNY-DELISTED	Stock	15.86	16.02	15.812	16.0	2553069.0
2012-06-15	ABC-DELISTED	Stock	37.15	37.3	36.905	37.29	2535809.0
2012-06-15	ABCB	Stock	11.76	11.95	11.53	11.9	107700.0
2012-06-15	ABCD-DELISTED	Stock	1.13	1.21	1.06	1.19	65034.0
2012-06-15	ABCO-DELISTED	Stock	48.03	48.39	47.89	48.0	414331.0
2012-06-15	ABCW-DELISTED	Stock	0.4227	0.483	0.4217	0.483	2330.0
2012-06-15	ABE-DELISTED	Stock	17.86	18.05	17.86	18.05	2522.0
2012-06-15	ABEO	Stock	825.0	925.0	825.0	925.0	6.0
2012-06-15	ABFS-DELISTED	Stock	11.87	12.42	11.68	12.29	764420.0
2012-06-15	ABG	Stock	24.48	24.53	24.0	24.5	264100.0
2012-06-15	ABM	Stock	20.8	20.85	20.47	20.49	350200.0
2012-06-15	ABMD-DELISTED	Stock	21.44	22.27	21.15	22.15	528517.0
2012-06-15	ABR	Stock	5.25	5.3	4.99	5.05	296600.0
2012-06-15	ABT	Stock	29.9443	30.1266	29.9011	29.9875	16113797.0
2012-06-15	ABTL-DELISTED	Stock	3.8121	3.9094	3.7615	3.8879	7391.0
2012-06-15	ABUS	Stock	2.0	2.0	1.93	1.98	2600.0
2012-06-15	ABV-DELISTED	Stock	36.92	37.06	36.16	36.48	4473698.0
2012-06-15	ABVA-DELISTED	Stock	4.31	4.31	4.1	4.22	1842.0
2012-06-15	ABVT-DELISTED	Stock	83.85	83.91	83.85	83.87	311009.0
2012-06-15	ABX-DELISTED	Stock	39.23	39.45	38.75	39.4	19590061.0
2012-06-15	ACAD	Stock	1.42	1.56	1.42	1.49	636900.0

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

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