PREVIEW / stock_daily / 2012-07-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-16.parquet
  size:    197 KB
  rows:    6,137
  symbols: 3,493

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-07-16	AAPL	Stock	21.6114	21.8436	21.6079	21.6754	301260400.0
2012-07-16	MSFT	Stock	29.48	29.53	29.04	29.44	27900600.0
2012-07-16	NVDA	Stock	0.312	0.3175	0.309	0.315	334460000.0
2012-07-16	AMZN	Stock	10.83	10.9155	10.723	10.8005	40084000.0
2012-07-16	META	Stock	30.5	30.5	28.21	28.25	24672100.0
2012-07-16	TSLA	Stock	2.288	2.4	2.26	2.3973	26160000.0
2012-07-16	TLT	Stock	130.3	130.61	129.61	129.77	5283451.0
2012-07-16	ES	Stock	39.71	39.93	39.48	39.58	1233800.0
2012-07-16	CL	Stock	52.54	52.73	52.175	52.185	3687600.0
2012-07-16	A	Stock	26.3376	26.5308	26.166	26.3448	2448457.0
2012-07-16	AABA-DELISTED	Stock	15.69	15.8	15.6	15.66	14836775.0
2012-07-16	AACC-DELISTED	Stock	6.9	6.92	6.72	6.81	34969.0
2012-07-16	AACG	Stock	4.26	4.68	4.17	4.4	17000.0
2012-07-16	AAIC-DELISTED	Stock	22.29	22.45	22.2	22.44	36495.0
2012-07-16	AAME	Stock	2.77	2.8	2.7	2.8	52000.0
2012-07-16	AAMRQ-DELISTED	Stock	0.536	0.55	0.516	0.528	508400.0
2012-07-16	AAON	Stock	6.0593	6.1007	5.9704	5.9852	79650.0
2012-07-16	AAP	Stock	71.3	71.41	70.33	70.43	738300.0
2012-07-16	AAT	Stock	24.92	25.16	24.78	25.13	162500.0
2012-07-16	AAU-DELISTED	Stock	1.94	1.98	1.91	1.93	57686.0
2012-07-16	AAUAF-DELISTED	Stock	1.94	1.98	1.91	1.93	59486.0
2012-07-16	AAV-DELISTED	Stock	3.15	3.24	3.15	3.21	92479.0
2012-07-16	AAWW-DELISTED	Stock	44.9843	46.14	44.87	44.9	110471.0
2012-07-16	AAXJ	Stock	51.52	51.79	51.34	51.59	292544.0
2012-07-16	AAXN-DELISTED	Stock	5.08	5.215	5.07	5.21	179596.0
2012-07-16	AB	Stock	12.42	12.59	12.35	12.35	171100.0
2012-07-16	ABAC-DELISTED	Stock	1.13	1.18	1.13	1.15	3200.0
2012-07-16	ABAX-DELISTED	Stock	39.41	39.635	39.1	39.36	87848.0
2012-07-16	ABB-DELISTED	Stock	16.18	16.27	16.03	16.22	1491025.0
2012-07-16	ABBNY-DELISTED	Stock	16.18	16.27	16.03	16.22	1517289.0
2012-07-16	ABC-DELISTED	Stock	39.55	39.55	39.29	39.4	1231685.0
2012-07-16	ABCB	Stock	12.66	12.66	12.36	12.44	24100.0
2012-07-16	ABCD-DELISTED	Stock	1.12	1.12	1.05	1.09	63067.0
2012-07-16	ABCO-DELISTED	Stock	50.23	50.66	50.14	50.38	335879.0
2012-07-16	ABE-DELISTED	Stock	18.95	18.95	18.89	18.9101	14583.0
2012-07-16	ABEO	Stock	712.5	712.5	650.0	650.0	4.0
2012-07-16	ABFS-DELISTED	Stock	11.96	11.96	11.5909	11.8	312664.0
2012-07-16	ABG	Stock	26.23	26.51	26.01	26.27	150000.0
2012-07-16	ABM	Stock	17.9	18.49	17.85	18.25	757000.0
2012-07-16	ABMD-DELISTED	Stock	24.28	24.35	23.94	24.27	310484.0
2012-07-16	ABR	Stock	5.3	5.38	5.26	5.36	66700.0
2012-07-16	ABT	Stock	31.307	31.4749	31.2302	31.4173	9152147.0
2012-07-16	ABTL-DELISTED	Stock	3.83	3.83	3.76	3.76	8413.0
2012-07-16	ABUS	Stock	2.29	3.2	2.29	2.77	321400.0
2012-07-16	ABV-DELISTED	Stock	36.85	36.94	36.5	36.6	1438040.0
2012-07-16	ABVA-DELISTED	Stock	4.29	4.29	4.29	4.29	575.0
2012-07-16	ABX-DELISTED	Stock	35.08	35.1	34.47	34.85	6887204.0
2012-07-16	ACAD	Stock	1.55	1.62	1.52	1.57	348900.0
2012-07-16	ACAS-DELISTED	Stock	10.0	10.0	9.86	9.91	699784.0
2012-07-16	ACAT-DELISTED	Stock	35.94	36.79	35.59	36.3	76666.0

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

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