PREVIEW / stock_daily / 2012-07-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-24.parquet
  size:    197 KB
  rows:    6,133
  symbols: 3,488

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-24	AAPL	Stock	21.6921	21.7743	21.3754	21.4614	565132400.0
2012-07-24	MSFT	Stock	29.24	29.36	28.9	29.15	47723300.0
2012-07-24	NVDA	Stock	0.325	0.327	0.3173	0.321	351164000.0
2012-07-24	AMZN	Stock	11.3135	11.3305	11.0615	11.152	100174000.0
2012-07-24	META	Stock	28.82	29.45	28.1	28.45	11539800.0
2012-07-24	TSLA	Stock	2.044	2.0693	1.9747	1.9893	22504500.0
2012-07-24	TLT	Stock	130.35	132.04	130.28	131.82	6749386.0
2012-07-24	ES	Stock	39.71	39.77	39.1	39.33	1425900.0
2012-07-24	CL	Stock	51.395	51.425	50.76	51.05	3574400.0
2012-07-24	A	Stock	26.1803	26.2303	25.2647	25.4721	5394183.0
2012-07-24	AABA-DELISTED	Stock	15.74	15.76	15.23	15.43	19198848.0
2012-07-24	AACC-DELISTED	Stock	6.3	6.3	5.941	6.16	69519.0
2012-07-24	AACG	Stock	3.71	3.84	3.65	3.67	3000.0
2012-07-24	AAIC-DELISTED	Stock	22.32	22.32	22.02	22.05	67842.0
2012-07-24	AAME	Stock	2.69	2.7	2.68	2.69	800.0
2012-07-24	AAMRQ-DELISTED	Stock	0.5305	0.5313	0.5115	0.515	583364.0
2012-07-24	AAON	Stock	5.7511	5.8489	5.4519	5.4963	125888.0
2012-07-24	AAP	Stock	72.02	72.02	70.83	71.36	756900.0
2012-07-24	AAT	Stock	24.72	25.09	24.57	24.75	288200.0
2012-07-24	AAU-DELISTED	Stock	1.83	1.92	1.8	1.85	59147.0
2012-07-24	AAUAF-DELISTED	Stock	1.83	1.92	1.8	1.85	61897.0
2012-07-24	AAV-DELISTED	Stock	3.52	3.59	3.41	3.46	201761.0
2012-07-24	AAWW-DELISTED	Stock	42.19	42.4146	41.18	42.12	266661.0
2012-07-24	AAXJ	Stock	50.97	51.17	50.48	50.77	153482.0
2012-07-24	AAXN-DELISTED	Stock	4.7	4.75	4.6	4.73	496229.0
2012-07-24	AB	Stock	11.95	11.95	11.44	11.9	243700.0
2012-07-24	ABAC-DELISTED	Stock	1.14	1.14	1.1	1.14	6350.0
2012-07-24	ABAX-DELISTED	Stock	36.69	36.69	35.69	35.96	194751.0
2012-07-24	ABB-DELISTED	Stock	15.92	15.93	15.65	15.79	2404788.0
2012-07-24	ABBNY-DELISTED	Stock	15.92	15.93	15.65	15.77	2584164.0
2012-07-24	ABC-DELISTED	Stock	38.78	38.8	37.97	38.21	1400805.0
2012-07-24	ABCB	Stock	11.89	11.89	11.43	11.66	29700.0
2012-07-24	ABCD-DELISTED	Stock	1.0527	1.08	1.0	1.0	60837.0
2012-07-24	ABCO-DELISTED	Stock	45.13	45.48	44.33	44.68	299796.0
2012-07-24	ABCW-DELISTED	Stock	0.34	0.49	0.34	0.4	4536.0
2012-07-24	ABE-DELISTED	Stock	19.09	19.09	18.9	18.9147	8932.0
2012-07-24	ABEO	Stock	375.0	462.5	287.5	462.5	94.0
2012-07-24	ABFS-DELISTED	Stock	11.38	11.4	11.04	11.2	196327.0
2012-07-24	ABG	Stock	27.15	27.96	25.3	25.9	725600.0
2012-07-24	ABM	Stock	18.73	18.73	18.41	18.53	451400.0
2012-07-24	ABMD-DELISTED	Stock	22.75	22.8284	21.65	21.91	315123.0
2012-07-24	ABR	Stock	5.35	5.39	5.31	5.35	70400.0
2012-07-24	ABT	Stock	30.9567	31.0191	30.4721	30.6784	11446019.0
2012-07-24	ABTL-DELISTED	Stock	3.62	3.75	3.6	3.65	21455.0
2012-07-24	ABUS	Stock	2.8	2.81	2.69	2.72	14900.0
2012-07-24	ABV-DELISTED	Stock	37.11	37.16	36.38	36.71	1498868.0
2012-07-24	ABVA-DELISTED	Stock	4.39	4.39	4.34	4.34	1832.0
2012-07-24	ABX-DELISTED	Stock	34.15	34.15	32.88	33.14	8955751.0
2012-07-24	ACAD	Stock	1.53	1.69	1.52	1.57	1304400.0
2012-07-24	ACAS-DELISTED	Stock	9.89	9.9	9.5	9.63	4022806.0

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

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