PREVIEW / stock_daily / 2012-08-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-21.parquet
  size:    199 KB
  rows:    6,136
  symbols: 3,475

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-21	AAPL	Stock	23.9579	24.1029	23.2261	23.4307	812719600.0
2012-08-21	MSFT	Stock	30.76	30.96	30.61	30.8	28822700.0
2012-08-21	NVDA	Stock	0.3675	0.3698	0.3615	0.3652	340248000.0
2012-08-21	AMZN	Stock	12.044	12.1925	11.9275	11.9725	51430000.0
2012-08-21	META	Stock	19.58	19.98	19.09	19.16	70640600.0
2012-08-21	TSLA	Stock	1.972	2.0	1.9333	1.9407	11424000.0
2012-08-21	TLT	Stock	121.47	122.45	120.66	122.39	9532673.0
2012-08-21	ES	Stock	38.65	38.65	38.19	38.21	2065100.0
2012-08-21	CL	Stock	52.94	53.205	52.695	52.85	2243800.0
2012-08-21	A	Stock	26.3948	26.6166	26.2232	26.5594	7515508.0
2012-08-21	AABA-DELISTED	Stock	14.95	15.01	14.88	14.97	27178254.0
2012-08-21	AACC-DELISTED	Stock	6.21	6.67	6.13	6.39	39408.0
2012-08-21	AACG	Stock	4.5	4.5	4.4	4.4	800.0
2012-08-21	AAIC-DELISTED	Stock	22.85	23.02	22.81	22.91	34757.0
2012-08-21	AAME	Stock	2.7	2.7	2.68	2.7	600.0
2012-08-21	AAMRQ-DELISTED	Stock	0.5	0.5075	0.4901	0.494	658517.0
2012-08-21	AAON	Stock	5.7541	5.8637	5.6889	5.8015	206550.0
2012-08-21	AAP	Stock	71.76	72.07	71.36	72.0	736600.0
2012-08-21	AAT	Stock	27.05	27.53	26.95	27.08	211200.0
2012-08-21	AAU-DELISTED	Stock	2.23	2.33	2.2	2.3	285558.0
2012-08-21	AAUAF-DELISTED	Stock	2.23	2.33	2.2	2.3	286658.0
2012-08-21	AAV-DELISTED	Stock	3.29	3.35	3.28	3.3	144893.0
2012-08-21	AAWW-DELISTED	Stock	53.07	53.56	52.26	52.33	266135.0
2012-08-21	AAXJ	Stock	54.59	54.72	54.17	54.29	503840.0
2012-08-21	AAXN-DELISTED	Stock	5.55	5.59	5.5	5.52	437320.0
2012-08-21	AB	Stock	12.89	13.12	12.81	12.94	628500.0
2012-08-21	ABAC-DELISTED	Stock	1.17	1.2	1.14	1.14	875.0
2012-08-21	ABAX-DELISTED	Stock	39.0	39.79	38.638	38.74	54164.0
2012-08-21	ABB-DELISTED	Stock	17.84	17.95	17.76	17.8	2044100.0
2012-08-21	ABBNY-DELISTED	Stock	17.84	17.95	17.76	17.79	2076271.0
2012-08-21	ABC-DELISTED	Stock	37.68	38.06	37.5	37.57	2293459.0
2012-08-21	ABCB	Stock	12.3	12.47	12.06	12.11	30200.0
2012-08-21	ABCD-DELISTED	Stock	0.92	0.998	0.91	0.95	75716.0
2012-08-21	ABCO-DELISTED	Stock	41.75	42.5	40.95	41.05	289507.0
2012-08-21	ABCW-DELISTED	Stock	0.365	0.44	0.35	0.44	13158.0
2012-08-21	ABE-DELISTED	Stock	19.48	19.62	19.48	19.5	14954.0
2012-08-21	ABEO	Stock	625.0	625.0	512.5	612.5	21.0
2012-08-21	ABFS-DELISTED	Stock	10.26	10.51	10.19	10.38	236050.0
2012-08-21	ABG	Stock	26.91	27.36	26.52	26.63	136200.0
2012-08-21	ABM	Stock	20.48	20.83	20.42	20.47	195800.0
2012-08-21	ABMD-DELISTED	Stock	21.79	21.96	21.25	21.34	406048.0
2012-08-21	ABR	Stock	5.5	5.62	5.48	5.57	105700.0
2012-08-21	ABT	Stock	31.5373	31.6428	31.307	31.3309	8775323.0
2012-08-21	ABTL-DELISTED	Stock	3.79	3.94	3.69	3.88	23836.0
2012-08-21	ABUS	Stock	3.59	3.73	3.52	3.52	7400.0
2012-08-21	ABV-DELISTED	Stock	37.96	38.12	36.845	36.89	2323641.0
2012-08-21	ABVA-DELISTED	Stock	4.4	4.4	4.4	4.4	900.0
2012-08-21	ABX-DELISTED	Stock	37.24	37.8	36.75	36.89	10219893.0
2012-08-21	ACAD	Stock	1.77	1.81	1.75	1.77	687200.0
2012-08-21	ACAS-DELISTED	Stock	11.25	11.31	11.16	11.16	3797067.0

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

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