PREVIEW / stock_daily / 2013-08-02

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-02.parquet
  size:    212 KB
  rows:    6,353
  symbols: 3,523

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
2013-08-02	AAPL	Stock	16.3575	16.5304	16.3093	16.5193	274783600.0
2013-08-02	MSFT	Stock	31.69	31.9	31.57	31.89	29199900.0
2013-08-02	NVDA	Stock	0.3652	0.3698	0.3628	0.369	209628000.0
2013-08-02	AMZN	Stock	15.2315	15.2665	15.075	15.2105	50052000.0
2013-08-02	META	Stock	37.66	38.49	37.5	38.05	73058500.0
2013-08-02	TSLA	Stock	8.9727	9.2167	8.9073	9.2	94048500.0
2013-08-02	TLT	Stock	106.01	106.6101	105.98	106.52	9570793.0
2013-08-02	ES	Stock	44.89	45.05	44.5	44.69	1060100.0
2013-08-02	CL	Stock	60.26	60.58	60.01	60.53	2508800.0
2013-08-02	A	Stock	32.9471	33.269	32.897	33.176	3354082.0
2013-08-02	AABA-DELISTED	Stock	28.07	28.09	27.55	27.65	11718034.0
2013-08-02	AACG	Stock	5.06	5.06	4.9	4.9	2100.0
2013-08-02	AAIC-DELISTED	Stock	25.02	25.1524	24.805	25.12	155502.0
2013-08-02	AAMC-DELISTED	Stock	103.5294	110.2941	103.5294	107.6471	66582.0
2013-08-02	AAME	Stock	3.89	3.89	3.63	3.87	4500.0
2013-08-02	AAMRQ-DELISTED	Stock	6.05	6.06	5.81	5.89	3874689.0
2013-08-02	AAON	Stock	9.9778	10.2133	9.9778	10.1733	353700.0
2013-08-02	AAP	Stock	83.29	83.52	82.83	83.47	412700.0
2013-08-02	AAT	Stock	32.53	32.73	32.47	32.64	139800.0
2013-08-02	AAU-DELISTED	Stock	1.75	1.79	1.72	1.77	98096.0
2013-08-02	AAUAF-DELISTED	Stock	1.75	1.79	1.72	1.77	98396.0
2013-08-02	AAV-DELISTED	Stock	3.69	3.73	3.65	3.68	106678.0
2013-08-02	AAWW-DELISTED	Stock	43.82	44.0899	43.55	43.79	190408.0
2013-08-02	AAXJ	Stock	56.58	56.9	56.435	56.77	332940.0
2013-08-02	AAXN-DELISTED	Stock	8.89	8.9	8.73	8.83	408197.0
2013-08-02	AB	Stock	22.96	22.96	22.63	22.96	255100.0
2013-08-02	ABAC-DELISTED	Stock	0.6201	0.65	0.6201	0.64	1700.0
2013-08-02	ABAX-DELISTED	Stock	40.7	41.03	40.26	40.7	215927.0
2013-08-02	ABB-DELISTED	Stock	22.08	22.29	22.01	22.27	1101834.0
2013-08-02	ABBNY-DELISTED	Stock	22.08	22.29	22.01	22.28	1128558.0
2013-08-02	ABBV	Stock	45.11	45.42	44.81	45.32	3190700.0
2013-08-02	ABC-DELISTED	Stock	58.75	58.8	58.25	58.49	1508373.0
2013-08-02	ABCB	Stock	19.32	19.57	19.28	19.37	25500.0
2013-08-02	ABCD-DELISTED	Stock	1.4	1.4	1.2601	1.3899	2000.0
2013-08-02	ABCO-DELISTED	Stock	58.48	59.65	57.31	58.07	176166.0
2013-08-02	ABCW-DELISTED	Stock	0.4	0.425	0.4	0.415	11338.0
2013-08-02	ABE-DELISTED	Stock	19.57	19.98	19.535	19.78	9288.0
2013-08-02	ABEO	Stock	537.5	537.5	537.5	537.5	16.0
2013-08-02	ABFS-DELISTED	Stock	22.68	22.89	22.16	22.75	265655.0
2013-08-02	ABG	Stock	50.84	51.05	50.46	50.91	353300.0
2013-08-02	ABM	Stock	26.0	26.19	25.82	26.01	75500.0
2013-08-02	ABMD-DELISTED	Stock	24.0	24.19	22.97	23.02	514043.0
2013-08-02	ABR	Stock	7.33	7.4	7.29	7.4	169500.0
2013-08-02	ABR.A-DELISTED	Stock	25.25	25.25	25.15	25.24	6811.0
2013-08-02	ABR.B-DELISTED	Stock	24.3801	24.3801	24.38	24.38	688.0
2013-08-02	ABT	Stock	36.79	36.97	36.68	36.75	7944100.0
2013-08-02	ABTL-DELISTED	Stock	5.7	5.7	5.36	5.49	95623.0
2013-08-02	ABUS	Stock	5.62	5.96	5.62	5.79	170500.0
2013-08-02	ABV-DELISTED	Stock	37.81	38.62	37.77	38.39	3986472.0
2013-08-02	ABX-DELISTED	Stock	16.74	17.45	16.63	16.68	16257424.0

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

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