PREVIEW / stock_daily / 2013-07-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-18.parquet
  size:    211 KB
  rows:    6,321
  symbols: 3,499

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-18	AAPL	Stock	15.4779	15.5311	15.3789	15.42	218878800.0
2013-07-18	MSFT	Stock	35.72	35.89	35.22	35.44	49547100.0
2013-07-18	NVDA	Stock	0.3648	0.366	0.359	0.3638	344488000.0
2013-07-18	AMZN	Stock	15.3135	15.317	15.0935	15.2055	61276000.0
2013-07-18	META	Stock	26.75	26.77	26.12	26.18	24806900.0
2013-07-18	TSLA	Stock	8.0647	8.182	7.7453	7.9353	170971500.0
2013-07-18	TLT	Stock	108.61	108.67	107.48	107.5	9066875.0
2013-07-18	ES	Stock	44.06	44.67	43.98	44.62	1004900.0
2013-07-18	CL	Stock	58.33	58.99	58.21	58.8	3242900.0
2013-07-18	A	Stock	32.6609	32.9399	32.5823	32.8326	2793484.0
2013-07-18	AABA-DELISTED	Stock	29.57	29.83	28.73	29.66	32910721.0
2013-07-18	AACG	Stock	4.5	4.88	4.49	4.64	7600.0
2013-07-18	AAIC-DELISTED	Stock	26.24	26.7	26.24	26.42	93293.0
2013-07-18	AAMC-DELISTED	Stock	80.4412	81.1765	80.4412	81.1765	5664.0
2013-07-18	AAME	Stock	3.64	3.7	3.62	3.7	6200.0
2013-07-18	AAMRQ-DELISTED	Stock	5.98	6.24	5.79	5.82	11270408.0
2013-07-18	AAON	Stock	10.6578	10.7378	10.5067	10.6578	321750.0
2013-07-18	AAP	Stock	81.5	82.66	81.4	82.5	1014800.0
2013-07-18	AAT	Stock	33.73	34.03	33.67	33.85	65700.0
2013-07-18	AAU-DELISTED	Stock	1.46	1.55	1.43	1.44	52497.0
2013-07-18	AAUAF-DELISTED	Stock	1.45	1.54	1.43	1.45	52945.0
2013-07-18	AAV-DELISTED	Stock	4.12	4.28	4.12	4.23	204628.0
2013-07-18	AAWW-DELISTED	Stock	44.65	45.69	44.65	45.5	329522.0
2013-07-18	AAXJ	Stock	56.35	56.35	55.94	56.0	275428.0
2013-07-18	AAXN-DELISTED	Stock	9.13	9.18	9.05	9.09	152463.0
2013-07-18	AB	Stock	20.55	21.43	20.35	21.28	395500.0
2013-07-18	ABAC-DELISTED	Stock	0.56	0.61	0.56	0.6	24775.0
2013-07-18	ABAX-DELISTED	Stock	50.18	50.19	49.58	50.035	100931.0
2013-07-18	ABB-DELISTED	Stock	22.66	22.79	22.62	22.74	1010596.0
2013-07-18	ABBNY-DELISTED	Stock	22.66	22.79	22.62	22.76	1329868.0
2013-07-18	ABBV	Stock	43.96	44.56	43.81	44.32	3043700.0
2013-07-18	ABC-DELISTED	Stock	58.58	58.95	58.04	58.3	2049636.0
2013-07-18	ABCB	Stock	17.93	18.03	17.88	17.95	171100.0
2013-07-18	ABCD-DELISTED	Stock	1.31	1.34	1.23	1.33	18504.0
2013-07-18	ABCO-DELISTED	Stock	56.13	56.41	55.59	55.64	157502.0
2013-07-18	ABCW-DELISTED	Stock	0.58	0.58	0.4	0.4	18155.0
2013-07-18	ABE-DELISTED	Stock	20.42	20.42	19.9501	20.072	5890.0
2013-07-18	ABEO	Stock	562.5	587.5	500.0	550.0	35.0
2013-07-18	ABFS-DELISTED	Stock	22.94	23.25	22.865	22.98	324889.0
2013-07-18	ABG	Stock	44.46	45.31	44.26	45.1	228800.0
2013-07-18	ABM	Stock	25.75	26.12	25.64	26.12	270700.0
2013-07-18	ABMD-DELISTED	Stock	24.5	24.59	24.13	24.35	225738.0
2013-07-18	ABR	Stock	7.3	7.42	7.2	7.38	721400.0
2013-07-18	ABR.A-DELISTED	Stock	25.3	25.41	25.2	25.41	3850.0
2013-07-18	ABT	Stock	35.92	36.03	35.6	35.7	6896400.0
2013-07-18	ABTL-DELISTED	Stock	5.09	5.2499	5.09	5.15	69681.0
2013-07-18	ABUS	Stock	5.2	5.26	5.1	5.15	133200.0
2013-07-18	ABV-DELISTED	Stock	36.67	36.71	36.06	36.14	1975002.0
2013-07-18	ABX-DELISTED	Stock	15.92	15.99	15.6099	15.74	12625600.0
2013-07-18	ACAD	Stock	19.88	20.68	19.64	20.12	3511300.0

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

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