PREVIEW / stock_daily / 2012-08-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-02.parquet
  size:    196 KB
  rows:    6,106
  symbols: 3,476

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-02	AAPL	Stock	21.53	21.8104	21.4375	21.7068	332158400.0
2012-08-02	MSFT	Stock	29.21	29.53	28.97	29.19	39520500.0
2012-08-02	NVDA	Stock	0.333	0.341	0.3275	0.336	367912000.0
2012-08-02	AMZN	Stock	11.528	11.717	11.433	11.5405	60962000.0
2012-08-02	META	Stock	20.77	20.84	19.82	20.04	56374500.0
2012-08-02	TSLA	Stock	1.7893	1.79	1.7013	1.74	19576500.0
2012-08-02	TLT	Stock	129.59	130.69	129.13	129.51	7971931.0
2012-08-02	ES	Stock	38.93	39.26	38.62	39.25	2152200.0
2012-08-02	CL	Stock	52.935	53.19	52.39	52.685	4284200.0
2012-08-02	A	Stock	27.1102	27.3462	26.5021	27.0029	3109432.0
2012-08-02	AABA-DELISTED	Stock	15.86	16.0	15.64	15.74	12367133.0
2012-08-02	AACC-DELISTED	Stock	5.68	5.83	5.68	5.81	58296.0
2012-08-02	AACG	Stock	4.3	4.33	4.1	4.33	9200.0
2012-08-02	AAIC-DELISTED	Stock	22.17	22.32	22.0	22.02	66546.0
2012-08-02	AAME	Stock	2.62	2.7	2.55	2.7	3000.0
2012-08-02	AAMRQ-DELISTED	Stock	0.5085	0.528	0.502	0.51	1179280.0
2012-08-02	AAON	Stock	5.2326	5.4252	5.2	5.3837	221738.0
2012-08-02	AAP	Stock	66.63	68.1	66.6	67.14	1766800.0
2012-08-02	AAT	Stock	25.25	25.55	24.76	25.29	349200.0
2012-08-02	AAU-DELISTED	Stock	1.94	1.95	1.8	1.87	577492.0
2012-08-02	AAUAF-DELISTED	Stock	1.94	1.95	1.8	1.87	578492.0
2012-08-02	AAV-DELISTED	Stock	3.8	3.85	3.75	3.79	216574.0
2012-08-02	AAWW-DELISTED	Stock	48.17	48.2	44.52	46.87	421379.0
2012-08-02	AAXJ	Stock	52.63	52.87	52.15	52.48	144196.0
2012-08-02	AAXN-DELISTED	Stock	5.3	5.59	5.26	5.51	1159475.0
2012-08-02	AB	Stock	12.05	12.7	11.8	12.45	339000.0
2012-08-02	ABAC-DELISTED	Stock	0.8	0.93	0.78	0.799	28290.0
2012-08-02	ABAX-DELISTED	Stock	35.47	36.21	35.47	35.93	51614.0
2012-08-02	ABB-DELISTED	Stock	17.26	17.405	16.94	17.11	2846938.0
2012-08-02	ABBNY-DELISTED	Stock	17.26	17.405	16.94	17.12	3406502.0
2012-08-02	ABC-DELISTED	Stock	39.07	39.28	38.48	38.86	3503468.0
2012-08-02	ABCB	Stock	11.48	11.57	11.27	11.35	55500.0
2012-08-02	ABCD-DELISTED	Stock	1.07	1.2	1.06	1.07	17199.0
2012-08-02	ABCO-DELISTED	Stock	43.85	44.2	43.03	43.74	440205.0
2012-08-02	ABCW-DELISTED	Stock	0.41	0.41	0.38	0.39	10824.0
2012-08-02	ABE-DELISTED	Stock	19.19	19.22	18.99	19.05	87854.0
2012-08-02	ABEO	Stock	912.5	912.5	725.0	850.0	2.0
2012-08-02	ABFS-DELISTED	Stock	11.02	11.46	9.875	10.01	828538.0
2012-08-02	ABG	Stock	25.0	25.98	24.87	25.57	384400.0
2012-08-02	ABM	Stock	18.01	18.39	17.98	18.17	260100.0
2012-08-02	ABMD-DELISTED	Stock	23.86	24.0	21.36	22.86	1262678.0
2012-08-02	ABR	Stock	5.35	5.38	5.34	5.38	31000.0
2012-08-02	ABT	Stock	31.9547	32.209	31.5037	31.8299	14975406.0
2012-08-02	ABTL-DELISTED	Stock	3.75	3.76	3.59	3.68	30725.0
2012-08-02	ABUS	Stock	3.75	3.81	3.21	3.29	87400.0
2012-08-02	ABV-DELISTED	Stock	38.67	39.22	37.66	37.75	2290643.0
2012-08-02	ABX-DELISTED	Stock	32.33	33.03	32.0	32.15	8076530.0
2012-08-02	ACAD	Stock	1.54	1.62	1.51	1.57	228000.0
2012-08-02	ACAS-DELISTED	Stock	10.2	10.46	10.135	10.4	4979549.0
2012-08-02	ACAT-DELISTED	Stock	43.88	44.18	43.28	43.81	240606.0

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

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