PREVIEW / stock_daily / 2012-07-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-23.parquet
  size:    197 KB
  rows:    6,145
  symbols: 3,492

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-23	AAPL	Stock	21.2286	21.6393	20.9896	21.5654	487975600.0
2012-07-23	MSFT	Stock	29.57	29.58	29.01	29.28	55151900.0
2012-07-23	NVDA	Stock	0.3118	0.3268	0.3083	0.3245	451584000.0
2012-07-23	AMZN	Stock	11.236	11.329	11.077	11.3005	110302000.0
2012-07-23	META	Stock	28.12	29.0	28.01	28.75	12390700.0
2012-07-23	TSLA	Stock	2.07	2.0867	2.0413	2.044	20802000.0
2012-07-23	TLT	Stock	131.31	131.44	130.51	130.79	6141343.0
2012-07-23	ES	Stock	39.96	40.06	39.54	39.78	1039000.0
2012-07-23	CL	Stock	51.61	51.905	51.3	51.395	2995000.0
2012-07-23	A	Stock	26.3376	26.3662	25.9442	26.2446	3074202.0
2012-07-23	AABA-DELISTED	Stock	15.7	15.81	15.59	15.77	12752715.0
2012-07-23	AACC-DELISTED	Stock	6.55	6.55	6.26	6.26	43047.0
2012-07-23	AACG	Stock	3.67	4.0	3.5	3.86	27600.0
2012-07-23	AAIC-DELISTED	Stock	22.04	22.38	22.0	22.27	40854.0
2012-07-23	AAME	Stock	2.77	2.77	2.68	2.7	5200.0
2012-07-23	AAMRQ-DELISTED	Stock	0.509	0.546	0.509	0.5325	710862.0
2012-07-23	AAON	Stock	5.7541	5.8607	5.7393	5.7393	157950.0
2012-07-23	AAP	Stock	71.14	72.19	70.52	71.92	589500.0
2012-07-23	AAT	Stock	24.76	24.76	24.59	24.63	197200.0
2012-07-23	AAU-DELISTED	Stock	1.9	1.91	1.81	1.8201	150853.0
2012-07-23	AAUAF-DELISTED	Stock	1.9	1.91	1.81	1.82	154153.0
2012-07-23	AAV-DELISTED	Stock	3.34	3.54	3.27	3.53	261542.0
2012-07-23	AAWW-DELISTED	Stock	42.43	42.78	41.72	42.16	144762.0
2012-07-23	AAXJ	Stock	50.63	51.0434	50.26	50.87	312610.0
2012-07-23	AAXN-DELISTED	Stock	4.75	4.77	4.62	4.685	274830.0
2012-07-23	AB	Stock	11.74	12.07	11.44	11.95	328200.0
2012-07-23	ABAC-DELISTED	Stock	1.12	1.14	1.12	1.13	5300.0
2012-07-23	ABAX-DELISTED	Stock	36.58	36.92	35.76	36.49	229963.0
2012-07-23	ABB-DELISTED	Stock	15.7	15.88	15.63	15.85	3030213.0
2012-07-23	ABBNY-DELISTED	Stock	15.7	15.88	15.63	15.83	3110786.0
2012-07-23	ABC-DELISTED	Stock	38.95	38.99	38.46	38.66	1906585.0
2012-07-23	ABCB	Stock	11.85	11.97	11.69	11.81	27700.0
2012-07-23	ABCD-DELISTED	Stock	1.08	1.09	1.05	1.05	23772.0
2012-07-23	ABCO-DELISTED	Stock	45.5	45.77	44.855	45.34	320866.0
2012-07-23	ABCW-DELISTED	Stock	0.4	0.43	0.4	0.4	32159.0
2012-07-23	ABE-DELISTED	Stock	18.93	19.07	18.73	19.07	15439.0
2012-07-23	ABEO	Stock	425.0	425.0	387.5	400.0	73.0
2012-07-23	ABFS-DELISTED	Stock	11.44	11.4783	11.21	11.31	188757.0
2012-07-23	ABG	Stock	26.47	27.11	26.2	26.62	308300.0
2012-07-23	ABM	Stock	18.61	18.74	18.4	18.64	467900.0
2012-07-23	ABMD-DELISTED	Stock	22.82	22.9395	22.2	22.54	304084.0
2012-07-23	ABR	Stock	5.27	5.37	5.27	5.34	53600.0
2012-07-23	ABT	Stock	30.6688	31.1102	30.6688	31.0143	11488537.0
2012-07-23	ABTL-DELISTED	Stock	3.61	3.73	3.6	3.72	6955.0
2012-07-23	ABUS	Stock	2.65	2.8	2.65	2.77	27400.0
2012-07-23	ABV-DELISTED	Stock	36.67	37.15	36.28	37.019	1582317.0
2012-07-23	ABVA-DELISTED	Stock	4.4	4.51	4.4	4.51	300.0
2012-07-23	ABX-DELISTED	Stock	34.02	34.07	33.51	33.59	6863969.0
2012-07-23	ACAD	Stock	1.5	1.58	1.42	1.53	334700.0
2012-07-23	ACAS-DELISTED	Stock	9.79	9.99	9.63	9.91	3470259.0

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

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