PREVIEW / stock_daily / 2013-08-08

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-08.parquet
  size:    212 KB
  rows:    6,369
  symbols: 3,518

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-08-08	AAPL	Stock	16.5664	16.575	16.3554	16.4646	255777200.0
2013-08-08	MSFT	Stock	32.24	33.07	32.05	32.89	59034400.0
2013-08-08	NVDA	Stock	0.367	0.3692	0.3628	0.3675	345696000.0
2013-08-08	AMZN	Stock	14.926	14.926	14.6275	14.787	46868000.0
2013-08-08	META	Stock	39.13	39.19	38.43	38.54	41301000.0
2013-08-08	TSLA	Stock	10.29	10.592	10.0307	10.232	408702000.0
2013-08-08	TLT	Stock	106.98	107.6	106.79	107.09	5510944.0
2013-08-08	ES	Stock	44.24	44.42	43.95	44.21	1155500.0
2013-08-08	CL	Stock	61.27	61.5	60.5	60.91	2817000.0
2013-08-08	A	Stock	33.2618	33.2976	32.6466	32.7969	2379955.0
2013-08-08	AABA-DELISTED	Stock	27.55	27.62	27.23	27.47	8926004.0
2013-08-08	AACG	Stock	5.1	5.2	4.91	5.0	7500.0
2013-08-08	AAIC-DELISTED	Stock	24.19	24.39	23.96	23.98	109380.0
2013-08-08	AAMC-DELISTED	Stock	102.6471	102.8235	102.6471	102.8235	11652.0
2013-08-08	AAME	Stock	3.8	3.85	3.8	3.85	2300.0
2013-08-08	AAMRQ-DELISTED	Stock	5.85	5.98	5.85	5.89	1909394.0
2013-08-08	AAON	Stock	10.3511	10.6889	10.2	10.6756	431100.0
2013-08-08	AAP	Stock	83.0	83.14	79.33	81.65	2492100.0
2013-08-08	AAT	Stock	32.74	33.14	32.19	32.38	86800.0
2013-08-08	AAU-DELISTED	Stock	1.64	1.66	1.58	1.65	165284.0
2013-08-08	AAUAF-DELISTED	Stock	1.66	1.68	1.6	1.65	163916.0
2013-08-08	AAV-DELISTED	Stock	3.5	3.64	3.39	3.59	238348.0
2013-08-08	AAWW-DELISTED	Stock	43.16	43.6	42.6	42.74	285701.0
2013-08-08	AAXJ	Stock	55.64	55.97	55.24	55.84	334077.0
2013-08-08	AAXN-DELISTED	Stock	8.75	8.84	8.63	8.74	280115.0
2013-08-08	AB	Stock	22.85	22.85	22.0	22.26	142300.0
2013-08-08	ABAC-DELISTED	Stock	0.5899	0.59	0.5899	0.59	1100.0
2013-08-08	ABAX-DELISTED	Stock	40.98	41.44	39.8934	40.48	82658.0
2013-08-08	ABB-DELISTED	Stock	22.3	22.58	22.29	22.51	1686156.0
2013-08-08	ABBNY-DELISTED	Stock	22.3	22.58	22.29	22.52	1705266.0
2013-08-08	ABBV	Stock	44.86	45.18	44.61	45.06	2892400.0
2013-08-08	ABC-DELISTED	Stock	59.12	59.67	58.89	59.6	1562880.0
2013-08-08	ABCB	Stock	19.47	19.47	19.25	19.27	18300.0
2013-08-08	ABCD-DELISTED	Stock	1.285	1.285	1.23	1.23	7184.0
2013-08-08	ABCO-DELISTED	Stock	60.09	60.09	58.45	58.52	104522.0
2013-08-08	ABCW-DELISTED	Stock	0.43	0.43	0.35	0.35	27100.0
2013-08-08	ABE-DELISTED	Stock	19.67	19.89	19.64	19.81	21874.0
2013-08-08	ABEO	Stock	500.0	537.5	450.0	537.5	27.0
2013-08-08	ABFS-DELISTED	Stock	19.71	19.95	19.4	19.7	736313.0
2013-08-08	ABG	Stock	51.15	52.35	50.79	51.87	162400.0
2013-08-08	ABM	Stock	25.96	25.97	25.74	25.78	84500.0
2013-08-08	ABMD-DELISTED	Stock	22.19	22.66	21.79	22.31	504547.0
2013-08-08	ABR	Stock	7.53	7.62	7.5	7.54	78400.0
2013-08-08	ABR.A-DELISTED	Stock	25.18	25.36	25.12	25.24	5352.0
2013-08-08	ABR.B-DELISTED	Stock	24.32	24.39	24.32	24.3316	1130.0
2013-08-08	ABT	Stock	36.2	36.35	35.66	35.92	4804500.0
2013-08-08	ABTL-DELISTED	Stock	6.26	6.26	6.03	6.15	31543.0
2013-08-08	ABUS	Stock	5.43	5.61	5.43	5.59	76200.0
2013-08-08	ABV-DELISTED	Stock	37.39	37.79	37.05	37.62	2718013.0
2013-08-08	ABX-DELISTED	Stock	15.85	17.1244	15.8	17.08	25884751.0

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

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