PREVIEW / stock_daily / 2013-07-16

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-16.parquet
  size:    211 KB
  rows:    6,337
  symbols: 3,506

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-16	AAPL	Stock	15.2329	15.3825	15.1489	15.3643	216538000.0
2013-07-16	MSFT	Stock	36.01	36.43	35.96	36.27	36378500.0
2013-07-16	NVDA	Stock	0.3668	0.3692	0.365	0.3672	162560000.0
2013-07-16	AMZN	Stock	15.365	15.4695	15.2755	15.3435	53204000.0
2013-07-16	META	Stock	26.39	26.75	26.01	26.32	30817600.0
2013-07-16	TSLA	Stock	8.4187	8.4213	7.1533	7.27	485578500.0
2013-07-16	TLT	Stock	108.43	108.76	108.27	108.66	3650166.0
2013-07-16	ES	Stock	44.09	44.16	43.58	43.89	1532300.0
2013-07-16	CL	Stock	58.71	58.8	58.09	58.48	3068000.0
2013-07-16	A	Stock	32.9685	33.2403	32.7468	32.8398	2833466.0
2013-07-16	AABA-DELISTED	Stock	27.3	27.45	26.725	26.8851	29906201.0
2013-07-16	AACG	Stock	4.53	4.62	4.53	4.62	2300.0
2013-07-16	AAIC-DELISTED	Stock	25.48	25.64	25.2475	25.5	126169.0
2013-07-16	AAMC-DELISTED	Stock	78.3235	78.9706	78.3235	78.9706	2281.0
2013-07-16	AAME	Stock	3.76	3.76	3.7	3.75	8200.0
2013-07-16	AAMRQ-DELISTED	Stock	5.14	5.4	5.14	5.32	3765111.0
2013-07-16	AAON	Stock	11.36	11.3689	11.1733	11.2133	373950.0
2013-07-16	AAP	Stock	83.29	83.65	81.85	82.38	450300.0
2013-07-16	AAT	Stock	33.99	34.02	33.65	33.89	171400.0
2013-07-16	AAU-DELISTED	Stock	1.42	1.53	1.4	1.52	77161.0
2013-07-16	AAUAF-DELISTED	Stock	1.42	1.52	1.4	1.52	78516.0
2013-07-16	AAV-DELISTED	Stock	4.16	4.18	3.96	4.17	448282.0
2013-07-16	AAWW-DELISTED	Stock	43.9	44.61	43.75	44.36	298175.0
2013-07-16	AAXJ	Stock	56.15	56.42	56.06	56.39	283470.0
2013-07-16	AAXN-DELISTED	Stock	9.12	9.23	9.0701	9.11	142539.0
2013-07-16	AB	Stock	20.35	20.68	20.35	20.39	455300.0
2013-07-16	ABAC-DELISTED	Stock	0.59	0.59	0.53	0.58	39790.0
2013-07-16	ABAX-DELISTED	Stock	50.16	50.395	49.43	49.72	75439.0
2013-07-16	ABB-DELISTED	Stock	22.64	22.765	22.59	22.71	940207.0
2013-07-16	ABBNY-DELISTED	Stock	22.64	22.765	22.59	22.72	962152.0
2013-07-16	ABBV	Stock	44.54	44.77	43.7	43.81	3714500.0
2013-07-16	ABC-DELISTED	Stock	58.25	58.61	58.14	58.28	1959331.0
2013-07-16	ABCB	Stock	17.87	18.0	17.75	17.84	38500.0
2013-07-16	ABCD-DELISTED	Stock	1.26	1.26	1.23	1.23	4366.0
2013-07-16	ABCO-DELISTED	Stock	56.97	57.05	56.4	56.85	76383.0
2013-07-16	ABCW-DELISTED	Stock	0.36	0.38	0.36	0.38	38201.0
2013-07-16	ABE-DELISTED	Stock	19.93	20.04	19.87	20.04	15246.0
2013-07-16	ABEO	Stock	512.5	512.5	512.5	512.5	23.0
2013-07-16	ABFS-DELISTED	Stock	23.37	24.0	22.55	22.69	502446.0
2013-07-16	ABG	Stock	44.11	44.34	43.73	44.17	175300.0
2013-07-16	ABM	Stock	25.47	25.51	25.26	25.38	147300.0
2013-07-16	ABMD-DELISTED	Stock	23.73	23.84	23.53	23.7	183391.0
2013-07-16	ABR	Stock	6.47	6.53	6.45	6.53	40900.0
2013-07-16	ABR.A-DELISTED	Stock	25.25	25.35	24.71	25.26	16415.0
2013-07-16	ABR.B-DELISTED	Stock	24.06	24.2999	23.75	23.94	5226.0
2013-07-16	ABT	Stock	35.43	35.71	35.33	35.7	8492000.0
2013-07-16	ABTL-DELISTED	Stock	5.02	5.07	4.91	5.06	14407.0
2013-07-16	ABUS	Stock	5.45	5.45	4.93	5.13	141400.0
2013-07-16	ABV-DELISTED	Stock	37.33	37.36	36.39	36.62	1414723.0
2013-07-16	ABX-DELISTED	Stock	15.2	16.09	15.17	16.0201	20520082.0

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

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