PREVIEW / stock_daily / 2013-07-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-22.parquet
  size:    212 KB
  rows:    6,355
  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-07-22	AAPL	Stock	15.3379	15.3482	15.1954	15.2254	207796400.0
2013-07-22	MSFT	Stock	31.7	32.01	31.6	32.01	79040700.0
2013-07-22	NVDA	Stock	0.3588	0.362	0.3542	0.3558	292384000.0
2013-07-22	AMZN	Stock	15.4625	15.4625	15.1	15.174	50414000.0
2013-07-22	META	Stock	25.99	26.13	25.72	26.05	27526300.0
2013-07-22	TSLA	Stock	7.9927	8.4453	7.992	8.162	146967000.0
2013-07-22	TLT	Stock	109.36	109.6884	109.1299	109.36	3972518.0
2013-07-22	ES	Stock	44.78	44.86	44.53	44.68	935500.0
2013-07-22	CL	Stock	58.76	59.07	58.45	58.65	2303700.0
2013-07-22	A	Stock	33.0687	33.5122	32.9757	33.4764	2565050.0
2013-07-22	AABA-DELISTED	Stock	28.08	28.42	27.63	27.87	45313521.0
2013-07-22	AACG	Stock	4.97	4.98	4.88	4.88	10500.0
2013-07-22	AAIC-DELISTED	Stock	26.82	26.8342	26.4	26.48	95129.0
2013-07-22	AAMC-DELISTED	Stock	87.6471	88.3971	87.0882	88.2353	12186.0
2013-07-22	AAME	Stock	3.62	3.84	3.62	3.69	6300.0
2013-07-22	AAMRQ-DELISTED	Stock	5.455	5.46	5.22	5.28	6035452.0
2013-07-22	AAON	Stock	10.5378	10.5644	10.3333	10.44	261675.0
2013-07-22	AAP	Stock	82.05	82.99	81.58	82.75	548300.0
2013-07-22	AAT	Stock	33.71	34.06	33.48	33.95	62700.0
2013-07-22	AAU-DELISTED	Stock	1.71	1.7404	1.639	1.72	141683.0
2013-07-22	AAUAF-DELISTED	Stock	1.68	1.72	1.6104	1.72	166261.0
2013-07-22	AAV-DELISTED	Stock	4.3	4.311	4.12	4.18	313669.0
2013-07-22	AAWW-DELISTED	Stock	45.5	46.41	45.5	46.1	236474.0
2013-07-22	AAXJ	Stock	55.86	56.35	55.86	56.29	227250.0
2013-07-22	AAXN-DELISTED	Stock	8.98	9.08	8.97	8.99	154836.0
2013-07-22	AB	Stock	21.91	22.89	21.77	22.6	443200.0
2013-07-22	ABAC-DELISTED	Stock	0.5999	0.6	0.5901	0.5999	10351.0
2013-07-22	ABAX-DELISTED	Stock	49.69	49.968	48.16	49.51	132797.0
2013-07-22	ABB-DELISTED	Stock	22.86	22.98	22.84	22.94	1304292.0
2013-07-22	ABBNY-DELISTED	Stock	22.86	22.98	22.84	22.95	1421158.0
2013-07-22	ABBV	Stock	44.3	45.1	43.8	44.97	3810500.0
2013-07-22	ABC-DELISTED	Stock	58.74	59.1	58.6	58.98	1133407.0
2013-07-22	ABCB	Stock	18.14	18.55	18.05	18.43	82700.0
2013-07-22	ABCO-DELISTED	Stock	55.81	56.53	55.5	56.45	51778.0
2013-07-22	ABCW-DELISTED	Stock	0.445	0.445	0.4	0.401	3300.0
2013-07-22	ABE-DELISTED	Stock	19.9	20.1	19.8701	20.06	8334.0
2013-07-22	ABEO	Stock	500.0	500.0	487.5	500.0	9.0
2013-07-22	ABFS-DELISTED	Stock	22.45	22.8	22.29	22.57	391893.0
2013-07-22	ABG	Stock	44.61	45.53	44.03	45.05	504400.0
2013-07-22	ABM	Stock	26.59	26.7	26.19	26.19	206100.0
2013-07-22	ABMD-DELISTED	Stock	24.36	24.61	24.18	24.5	329419.0
2013-07-22	ABR	Stock	7.4	7.48	7.37	7.45	283600.0
2013-07-22	ABR.A-DELISTED	Stock	25.42	25.42	25.1701	25.4099	735.0
2013-07-22	ABR.B-DELISTED	Stock	24.24	24.27	24.24	24.27	920.0
2013-07-22	ABT	Stock	35.76	35.94	35.58	35.8	4782400.0
2013-07-22	ABTL-DELISTED	Stock	5.23	5.3203	5.21	5.27	49529.0
2013-07-22	ABUS	Stock	5.09	5.14	4.99	5.09	22700.0
2013-07-22	ABV-DELISTED	Stock	35.9	36.74	35.85	36.725	1636816.0
2013-07-22	ABX-DELISTED	Stock	17.34	17.86	17.24	17.57	25880465.0
2013-07-22	ACAD	Stock	20.09	20.23	19.8	20.03	1950700.0

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

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