PREVIEW / stock_daily / 2013-07-31

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-31.parquet
  size:    213 KB
  rows:    6,377
  symbols: 3,526

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-07-31	AAPL	Stock	16.2496	16.3336	16.0511	16.1618	322957600.0
2013-07-31	MSFT	Stock	31.97	32.05	31.71	31.84	43898400.0
2013-07-31	NVDA	Stock	0.3585	0.3645	0.3582	0.361	270160000.0
2013-07-31	AMZN	Stock	15.1955	15.2575	15.05	15.061	37826000.0
2013-07-31	META	Stock	37.96	38.31	36.33	36.8	154828700.0
2013-07-31	TSLA	Stock	8.838	8.998	8.7633	8.952	95275500.0
2013-07-31	TLT	Stock	106.06	107.92	105.85	107.7	10483288.0
2013-07-31	ES	Stock	44.58	44.62	44.03	44.41	1744500.0
2013-07-31	CL	Stock	60.34	60.67	59.85	59.87	3867500.0
2013-07-31	A	Stock	32.2175	32.4034	31.9456	31.9957	3924745.0
2013-07-31	AABA-DELISTED	Stock	27.92	28.21	27.57	28.09	20222932.0
2013-07-31	AACG	Stock	5.27	5.27	5.0	5.23	9600.0
2013-07-31	AAIC-DELISTED	Stock	25.82	25.86	25.05	25.28	140195.0
2013-07-31	AAMC-DELISTED	Stock	98.5294	101.1794	98.5294	98.8235	6324.0
2013-07-31	AAME	Stock	3.85	3.89	3.85	3.88	3100.0
2013-07-31	AAMRQ-DELISTED	Stock	5.93	6.09	5.85	5.93	11748277.0
2013-07-31	AAON	Stock	9.5556	9.7156	9.5333	9.5867	478125.0
2013-07-31	AAP	Stock	82.25	83.07	82.01	82.49	521400.0
2013-07-31	AAT	Stock	33.0	33.44	32.4	32.4	113000.0
2013-07-31	AAU-DELISTED	Stock	1.75	1.763	1.68	1.75	68379.0
2013-07-31	AAUAF-DELISTED	Stock	1.75	1.763	1.68	1.75	69079.0
2013-07-31	AAV-DELISTED	Stock	3.52	3.6793	3.52	3.62	227842.0
2013-07-31	AAWW-DELISTED	Stock	44.76	44.99	44.56	44.75	226230.0
2013-07-31	AAXJ	Stock	56.07	56.45	55.67	55.89	441182.0
2013-07-31	AAXN-DELISTED	Stock	9.0	9.02	8.43	8.88	487254.0
2013-07-31	AB	Stock	22.2	22.68	21.9	22.2	308500.0
2013-07-31	ABAC-DELISTED	Stock	0.61	0.7	0.61	0.64	29512.0
2013-07-31	ABAX-DELISTED	Stock	41.31	42.23	41.24	42.1	170855.0
2013-07-31	ABB-DELISTED	Stock	21.88	22.24	21.87	22.04	1113954.0
2013-07-31	ABBNY-DELISTED	Stock	21.89	22.24	21.87	22.04	1181937.0
2013-07-31	ABBV	Stock	44.84	45.91	44.81	45.48	6020600.0
2013-07-31	ABC-DELISTED	Stock	58.55	58.97	58.0	58.27	1690270.0
2013-07-31	ABCB	Stock	19.3	19.45	19.1	19.25	67600.0
2013-07-31	ABCO-DELISTED	Stock	57.76	58.85	57.29	58.76	172107.0
2013-07-31	ABCW-DELISTED	Stock	0.425	0.43	0.37	0.419	25424.0
2013-07-31	ABE-DELISTED	Stock	20.09	20.09	19.6172	19.6172	18101.0
2013-07-31	ABEO	Stock	375.0	537.5	375.0	500.0	16.0
2013-07-31	ABFS-DELISTED	Stock	21.71	22.08	21.474	21.72	287877.0
2013-07-31	ABG	Stock	48.17	49.41	48.17	48.84	222000.0
2013-07-31	ABM	Stock	25.78	26.09	25.77	25.9	159800.0
2013-07-31	ABMD-DELISTED	Stock	25.0	25.25	24.85	25.19	375626.0
2013-07-31	ABR	Stock	7.48	7.65	7.26	7.54	280600.0
2013-07-31	ABR.A-DELISTED	Stock	25.22	25.3899	25.01	25.36	1646.0
2013-07-31	ABR.B-DELISTED	Stock	24.2	24.59	23.67	24.59	5200.0
2013-07-31	ABT	Stock	36.87	37.16	36.58	36.63	7966200.0
2013-07-31	ABTL-DELISTED	Stock	5.38	5.38	5.3	5.38	37882.0
2013-07-31	ABUS	Stock	5.13	5.46	5.13	5.46	176300.0
2013-07-31	ABV-DELISTED	Stock	36.82	37.94	36.61	37.78	4539477.0
2013-07-31	ABX-DELISTED	Stock	17.1	17.53	16.62	16.96	19554562.0
2013-07-31	ACAD	Stock	20.04	20.14	19.63	19.7	1311100.0

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

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