PREVIEW / stock_daily / 2012-08-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-15.parquet
  size:    198 KB
  rows:    6,139
  symbols: 3,483

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-08-15	AAPL	Stock	22.5464	22.6429	22.4196	22.5296	257342400.0
2012-08-15	MSFT	Stock	30.11	30.28	30.02	30.2	24351000.0
2012-08-15	NVDA	Stock	0.366	0.369	0.3602	0.362	594404000.0
2012-08-15	AMZN	Stock	11.613	11.907	11.6125	11.871	65294000.0
2012-08-15	META	Stock	20.64	21.41	20.4	21.2	47861100.0
2012-08-15	TSLA	Stock	1.9593	1.98	1.9207	1.96	7881000.0
2012-08-15	TLT	Stock	123.02	123.2	121.9	122.05	11191512.0
2012-08-15	ES	Stock	39.17	39.17	38.9	39.02	1492300.0
2012-08-15	CL	Stock	52.535	53.255	52.5	52.75	3286200.0
2012-08-15	A	Stock	28.8484	29.2203	28.4692	28.9557	3967943.0
2012-08-15	AABA-DELISTED	Stock	14.77	14.86	14.65	14.75	20507142.0
2012-08-15	AACC-DELISTED	Stock	5.71	5.79	5.7	5.76	37547.0
2012-08-15	AACG	Stock	4.88	4.88	4.78	4.78	2000.0
2012-08-15	AAIC-DELISTED	Stock	22.92	23.0	22.9	23.0	38308.0
2012-08-15	AAME	Stock	2.58	2.66	2.58	2.58	2500.0
2012-08-15	AAMRQ-DELISTED	Stock	0.5	0.508	0.496	0.5	729022.0
2012-08-15	AAON	Stock	5.5615	5.6326	5.5289	5.5881	154575.0
2012-08-15	AAP	Stock	70.73	71.79	70.5	71.3	1217100.0
2012-08-15	AAT	Stock	25.81	25.93	25.7	25.76	175400.0
2012-08-15	AAU-DELISTED	Stock	2.12	2.17	2.1	2.13	43053.0
2012-08-15	AAUAF-DELISTED	Stock	2.12	2.17	2.1	2.14	44253.0
2012-08-15	AAV-DELISTED	Stock	3.25	3.3	3.2	3.28	89959.0
2012-08-15	AAWW-DELISTED	Stock	51.12	52.44	50.9552	52.0	217755.0
2012-08-15	AAXJ	Stock	54.34	54.39	54.1368	54.27	128388.0
2012-08-15	AAXN-DELISTED	Stock	5.53	5.57	5.46	5.49	434627.0
2012-08-15	AB	Stock	12.72	12.96	12.6	12.8	131500.0
2012-08-15	ABAC-DELISTED	Stock	0.99	1.0	0.92	0.95	11795.0
2012-08-15	ABAX-DELISTED	Stock	37.63	38.51	37.63	38.45	50077.0
2012-08-15	ABB-DELISTED	Stock	17.77	17.825	17.73	17.77	1808184.0
2012-08-15	ABBNY-DELISTED	Stock	17.77	17.825	17.73	17.77	1826740.0
2012-08-15	ABC-DELISTED	Stock	38.36	38.51	37.93	38.0	2721552.0
2012-08-15	ABCB	Stock	11.34	11.7	11.34	11.65	22000.0
2012-08-15	ABCD-DELISTED	Stock	0.85	1.0	0.85	0.9	26285.0
2012-08-15	ABCO-DELISTED	Stock	41.12	42.22	40.97	41.83	161059.0
2012-08-15	ABCW-DELISTED	Stock	0.39	0.45	0.39	0.45	10949.0
2012-08-15	ABE-DELISTED	Stock	19.45	19.45	19.35	19.405	9300.0
2012-08-15	ABEO	Stock	612.5	612.5	562.5	612.5	3.0
2012-08-15	ABFS-DELISTED	Stock	10.16	10.44	10.16	10.22	297599.0
2012-08-15	ABG	Stock	26.49	26.93	26.4	26.71	212900.0
2012-08-15	ABM	Stock	18.92	19.42	18.9	19.38	349600.0
2012-08-15	ABMD-DELISTED	Stock	20.34	21.35	20.08	20.5	484192.0
2012-08-15	ABR	Stock	5.72	5.77	5.69	5.76	45600.0
2012-08-15	ABT	Stock	31.782	31.9931	31.71	31.8683	7341601.0
2012-08-15	ABTL-DELISTED	Stock	3.57	3.91	3.57	3.67	12178.0
2012-08-15	ABUS	Stock	3.79	3.84	3.72	3.79	54800.0
2012-08-15	ABV-DELISTED	Stock	37.79	38.07	37.74	37.96	657248.0
2012-08-15	ABVA-DELISTED	Stock	4.39	4.4	4.39	4.4	10861.0
2012-08-15	ABX-DELISTED	Stock	34.13	34.74	34.06	34.7	5250122.0
2012-08-15	ACAD	Stock	1.67	1.7	1.54	1.63	304300.0
2012-08-15	ACAS-DELISTED	Stock	10.96	11.07	10.96	11.02	2915637.0

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

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