PREVIEW / stock_daily / 2013-02-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-02-27.parquet
  size:    207 KB
  rows:    6,285
  symbols: 3,500

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-02-27	AAPL	Stock	16.0154	16.1586	15.7375	15.8775	587350400.0
2013-02-27	MSFT	Stock	27.42	28.0	27.33	27.81	36394700.0
2013-02-27	NVDA	Stock	0.3093	0.3173	0.3085	0.315	476980000.0
2013-02-27	AMZN	Stock	12.97	13.2915	12.843	13.1625	58162000.0
2013-02-27	META	Stock	27.34	27.34	26.63	26.87	44319700.0
2013-02-27	TSLA	Stock	2.294	2.3607	2.2933	2.34	29388000.0
2013-02-27	TLT	Stock	119.49	119.54	118.0	118.29	7459783.0
2013-02-27	ES	Stock	40.69	41.33	40.56	41.27	1668900.0
2013-02-27	CL	Stock	56.775	57.46	56.415	57.23	4004200.0
2013-02-27	A	Stock	29.3205	29.9714	29.206	29.8498	4982752.0
2013-02-27	AABA-DELISTED	Stock	20.81	21.31	20.69	21.155	15439466.0
2013-02-27	AACC-DELISTED	Stock	5.29	5.38	5.08	5.15	61863.0
2013-02-27	AACG	Stock	4.02	4.23	4.0	4.05	6000.0
2013-02-27	AAIC-DELISTED	Stock	25.34	25.93	25.34	25.6	175861.0
2013-02-27	AAMC-DELISTED	Stock	36.1765	36.1765	35.0	35.0	19591.0
2013-02-27	AAME	Stock	3.3	3.33	3.13	3.33	3800.0
2013-02-27	AAMRQ-DELISTED	Stock	2.585	2.6	2.54	2.57	3059943.0
2013-02-27	AAON	Stock	7.0815	7.3007	7.037	7.203	206213.0
2013-02-27	AAP	Stock	77.29	77.58	76.22	77.3	720800.0
2013-02-27	AAT	Stock	30.28	30.78	30.15	30.32	96900.0
2013-02-27	AAU-DELISTED	Stock	2.19	2.221	2.08	2.08	174361.0
2013-02-27	AAUAF-DELISTED	Stock	2.17	2.2	2.06	2.08	179067.0
2013-02-27	AAV-DELISTED	Stock	2.86	3.02	2.86	3.02	631088.0
2013-02-27	AAWW-DELISTED	Stock	46.47	47.62	46.47	47.3	432019.0
2013-02-27	AAXJ	Stock	59.53	60.34	59.53	60.18	346560.0
2013-02-27	AAXN-DELISTED	Stock	6.93	7.13	6.93	7.01	621580.0
2013-02-27	AB	Stock	21.96	22.18	21.92	22.08	285800.0
2013-02-27	ABAC-DELISTED	Stock	0.85	0.8701	0.85	0.868	7650.0
2013-02-27	ABAX-DELISTED	Stock	41.94	42.805	41.905	42.17	90664.0
2013-02-27	ABB-DELISTED	Stock	22.53	22.92	22.51	22.83	1539181.0
2013-02-27	ABBNY-DELISTED	Stock	22.53	22.92	22.51	22.82	1569616.0
2013-02-27	ABBV	Stock	36.97	36.98	36.4	36.73	12238400.0
2013-02-27	ABC-DELISTED	Stock	46.66	47.21	46.58	47.02	838665.0
2013-02-27	ABCB	Stock	13.7	14.09	13.68	13.96	48200.0
2013-02-27	ABCD-DELISTED	Stock	1.255	1.255	1.255	1.255	100.0
2013-02-27	ABCO-DELISTED	Stock	50.4	51.02	50.18	50.72	172839.0
2013-02-27	ABCW-DELISTED	Stock	0.61	0.63	0.61	0.63	3365.0
2013-02-27	ABE-DELISTED	Stock	21.525	21.525	21.284	21.48	5548.0
2013-02-27	ABEO	Stock	625.0	637.5	625.0	625.0	19.0
2013-02-27	ABFS-DELISTED	Stock	10.86	11.33	10.86	11.23	335942.0
2013-02-27	ABG	Stock	33.0	34.12	32.87	33.79	347100.0
2013-02-27	ABM	Stock	22.7	22.89	22.65	22.71	243600.0
2013-02-27	ABMD-DELISTED	Stock	15.57	16.57	15.52	16.355	1358890.0
2013-02-27	ABR	Stock	7.58	7.96	7.49	7.91	175400.0
2013-02-27	ABR.A-DELISTED	Stock	25.327	25.41	25.29	25.41	6000.0
2013-02-27	ABT	Stock	34.05	34.45	33.85	34.26	10667200.0
2013-02-27	ABTL-DELISTED	Stock	4.3	4.4	4.139	4.26	17942.0
2013-02-27	ABUS	Stock	4.44	4.5	4.39	4.5	20300.0
2013-02-27	ABV-DELISTED	Stock	44.06	44.11	43.64	43.85	2580183.0
2013-02-27	ABX-DELISTED	Stock	31.12	31.22	30.62	30.91	9534669.0

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

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