PREVIEW / stock_daily / 2013-11-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-22.parquet
  size:    216 KB
  rows:    6,486
  symbols: 3,572

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-11-22	AAPL	Stock	18.5543	18.6486	18.5189	18.5643	223725600.0
2013-11-22	MSFT	Stock	37.53	37.68	37.33	37.57	27982000.0
2013-11-22	NVDA	Stock	0.3838	0.3838	0.3788	0.3795	158668000.0
2013-11-22	AMZN	Stock	18.5	18.725	18.3155	18.6155	59310000.0
2013-11-22	META	Stock	47.04	47.27	45.96	46.23	40545000.0
2013-11-22	TSLA	Stock	8.1053	8.1833	7.862	8.092	166450500.0
2013-11-22	TLT	Stock	103.49	104.1301	103.48	103.91	7950686.0
2013-11-22	ES	Stock	42.11	42.29	41.9	42.18	1444800.0
2013-11-22	CL	Stock	65.96	66.42	65.84	66.26	2780700.0
2013-11-22	A	Stock	38.6981	38.8698	38.4478	38.5193	2671298.0
2013-11-22	AABA-DELISTED	Stock	36.16	36.63	35.955	36.49	12408171.0
2013-11-22	AACG	Stock	4.08	4.16	4.08	4.1	9300.0
2013-11-22	AAIC-DELISTED	Stock	25.91	26.22	25.85	26.21	121436.0
2013-11-22	AAMC-DELISTED	Stock	211.4647	211.4706	211.0235	211.4706	1363.0
2013-11-22	AAME	Stock	4.03	4.05	4.03	4.04	1900.0
2013-11-22	AAMRQ-DELISTED	Stock	12.01	12.25	12.01	12.06	8137816.0
2013-11-22	AAOI	Stock	12.58	12.58	12.31	12.57	39300.0
2013-11-22	AAON	Stock	12.9333	13.1244	12.7822	13.0311	216675.0
2013-11-22	AAP	Stock	100.0	100.22	99.21	100.1	915500.0
2013-11-22	AAT	Stock	32.2	32.2	31.67	31.93	113600.0
2013-11-22	AAU-DELISTED	Stock	1.1	1.1	1.07	1.1	64906.0
2013-11-22	AAUAF-DELISTED	Stock	1.1	1.12	1.09	1.1	63943.0
2013-11-22	AAV-DELISTED	Stock	4.0	4.0	3.96	3.98	61888.0
2013-11-22	AAWW-DELISTED	Stock	37.47	37.8499	36.292	36.38	455304.0
2013-11-22	AAXJ	Stock	60.0	60.33	59.86	60.25	199989.0
2013-11-22	AAXN-DELISTED	Stock	17.04	17.65	16.791	17.51	1382497.0
2013-11-22	AB	Stock	21.66	22.0	21.6	21.83	894300.0
2013-11-22	ABAC-DELISTED	Stock	1.8	1.869	1.79	1.79	38748.0
2013-11-22	ABAX-DELISTED	Stock	35.42	36.108	35.0601	35.82	71739.0
2013-11-22	ABB-DELISTED	Stock	25.36	25.51	25.3	25.5	1274376.0
2013-11-22	ABBNY-DELISTED	Stock	25.36	25.51	25.3	25.48	1298635.0
2013-11-22	ABBV	Stock	48.65	49.14	48.57	48.94	5810100.0
2013-11-22	ABC-DELISTED	Stock	69.81	70.19	69.79	70.0	1283286.0
2013-11-22	ABCB	Stock	19.64	19.95	19.33	19.86	48800.0
2013-11-22	ABCD-DELISTED	Stock	1.51	1.54	1.4	1.5	44709.0
2013-11-22	ABCO-DELISTED	Stock	61.25	61.755	60.8	61.13	133232.0
2013-11-22	ABE-DELISTED	Stock	19.7	19.732	19.681	19.7	3919.0
2013-11-22	ABEO	Stock	362.5	375.0	350.0	375.0	176.0
2013-11-22	ABEV	Stock	7.52	7.67	7.49	7.56	5975200.0
2013-11-22	ABFS-DELISTED	Stock	32.32	32.63	31.8	31.96	272669.0
2013-11-22	ABG	Stock	51.51	51.76	50.99	51.66	127000.0
2013-11-22	ABGB-DELISTED	Stock	11.32	11.6	11.319	11.6	26500.0
2013-11-22	ABM	Stock	27.8	28.0	27.77	27.88	145100.0
2013-11-22	ABMD-DELISTED	Stock	28.5	29.24	28.46	28.78	490321.0
2013-11-22	ABR	Stock	6.58	6.66	6.51	6.62	58200.0
2013-11-22	ABR.A-DELISTED	Stock	24.57	24.57	24.57	24.57	400.0
2013-11-22	ABR.B-DELISTED	Stock	22.9	22.9	22.45	22.45	1100.0
2013-11-22	ABT	Stock	38.13	38.37	38.04	38.25	4463500.0
2013-11-22	ABTL-DELISTED	Stock	10.71	11.2	10.71	10.99	113862.0
2013-11-22	ABUS	Stock	7.92	8.01	7.75	7.96	104800.0

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

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