PREVIEW / stock_daily / 2013-03-14

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-14.parquet
  size:    207 KB
  rows:    6,248
  symbols: 3,467

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-03-14	AAPL	Stock	15.4582	15.5229	15.3732	15.4464	303875600.0
2013-03-14	MSFT	Stock	28.0	28.16	27.93	28.14	55914800.0
2013-03-14	NVDA	Stock	0.3205	0.3215	0.3168	0.3188	383304000.0
2013-03-14	AMZN	Stock	13.4835	13.5	13.1765	13.287	104534000.0
2013-03-14	META	Stock	27.1	27.43	26.83	27.04	27646400.0
2013-03-14	TSLA	Stock	2.5933	2.594	2.4513	2.4567	30315000.0
2013-03-14	TLT	Stock	115.09	115.64	114.98	115.22	9353089.0
2013-03-14	ES	Stock	42.33	42.56	42.22	42.52	995900.0
2013-03-14	CL	Stock	57.475	57.49	56.855	56.92	4585400.0
2013-03-14	A	Stock	30.7797	31.03	30.7582	30.9871	3970180.0
2013-03-14	AABA-DELISTED	Stock	22.47	22.75	22.405	22.42	12755307.0
2013-03-14	AACC-DELISTED	Stock	6.5	6.5	6.46	6.47	271167.0
2013-03-14	AAIC-DELISTED	Stock	26.07	26.18	26.0	26.07	309911.0
2013-03-14	AAMC-DELISTED	Stock	38.8235	41.4706	38.8235	40.7353	18873.0
2013-03-14	AAME	Stock	3.45	3.45	3.38	3.4	900.0
2013-03-14	AAMRQ-DELISTED	Stock	4.065	4.25	4.03	4.15	13743234.0
2013-03-14	AAON	Stock	7.5526	7.763	7.28	7.7363	829913.0
2013-03-14	AAP	Stock	78.9	79.12	77.36	77.67	763300.0
2013-03-14	AAT	Stock	32.07	32.71	32.03	32.64	203200.0
2013-03-14	AAU-DELISTED	Stock	2.19	2.26	2.13	2.15	100337.0
2013-03-14	AAUAF-DELISTED	Stock	2.16	2.23	2.1	2.15	104091.0
2013-03-14	AAV-DELISTED	Stock	3.33	3.42	3.27	3.39	859323.0
2013-03-14	AAWW-DELISTED	Stock	44.05	44.32	43.51	44.25	214408.0
2013-03-14	AAXJ	Stock	59.31	59.63	59.31	59.56	303003.0
2013-03-14	AAXN-DELISTED	Stock	7.89	7.9	7.75	7.87	602727.0
2013-03-14	AB	Stock	22.52	22.53	21.59	21.78	604800.0
2013-03-14	ABAC-DELISTED	Stock	0.701	0.75	0.701	0.7201	9776.0
2013-03-14	ABAX-DELISTED	Stock	47.28	47.28	46.31	46.67	172758.0
2013-03-14	ABB-DELISTED	Stock	22.71	22.96	22.7	22.96	1185543.0
2013-03-14	ABBNY-DELISTED	Stock	22.71	22.96	22.7	22.95	1221461.0
2013-03-14	ABBV	Stock	37.43	37.59	36.86	37.56	9859700.0
2013-03-14	ABC-DELISTED	Stock	49.0	49.39	48.91	49.27	1791778.0
2013-03-14	ABCB	Stock	14.36	14.41	14.12	14.3	43500.0
2013-03-14	ABCD-DELISTED	Stock	1.13	1.16	1.13	1.16	5474.0
2013-03-14	ABCO-DELISTED	Stock	49.92	49.92	48.85	49.4	684887.0
2013-03-14	ABCW-DELISTED	Stock	0.6	0.62	0.6	0.62	10495.0
2013-03-14	ABE-DELISTED	Stock	21.36	21.52	21.36	21.46	4480.0
2013-03-14	ABEO	Stock	687.5	725.0	687.5	700.0	19.0
2013-03-14	ABFS-DELISTED	Stock	12.3	12.48	12.22	12.315	222945.0
2013-03-14	ABG	Stock	37.31	37.64	36.88	37.32	703300.0
2013-03-14	ABM	Stock	21.96	22.24	21.88	22.04	328000.0
2013-03-14	ABMD-DELISTED	Stock	17.89	18.34	17.685	18.03	901418.0
2013-03-14	ABR	Stock	8.37	8.37	8.25	8.27	187700.0
2013-03-14	ABR.A-DELISTED	Stock	25.5	25.5	25.31	25.39	4192.0
2013-03-14	ABT	Stock	35.03	35.14	34.93	35.14	6809800.0
2013-03-14	ABTL-DELISTED	Stock	4.29	4.3	4.23	4.24	25631.0
2013-03-14	ABUS	Stock	4.49	4.49	4.42	4.45	17200.0
2013-03-14	ABV-DELISTED	Stock	43.72	44.2	43.72	44.14	1092230.0
2013-03-14	ABX-DELISTED	Stock	28.42	28.91	28.41	28.58	9434173.0
2013-03-14	ACAD	Stock	6.16	6.39	6.1	6.39	1352700.0

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

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