PREVIEW / stock_daily / 2013-06-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-18.parquet
  size:    211 KB
  rows:    6,341
  symbols: 3,527

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-06-18	AAPL	Stock	15.4129	15.5321	15.3646	15.4204	195025600.0
2013-06-18	MSFT	Stock	34.97	35.17	34.9	34.98	28616500.0
2013-06-18	NVDA	Stock	0.364	0.368	0.357	0.36	486772000.0
2013-06-18	AMZN	Stock	13.954	14.1455	13.9055	14.088	42922000.0
2013-06-18	META	Stock	24.09	24.69	24.08	24.21	36709100.0
2013-06-18	TSLA	Stock	6.7833	6.932	6.6133	6.8927	131929500.0
2013-06-18	TLT	Stock	112.85	113.685	112.72	113.28	5192646.0
2013-06-18	ES	Stock	42.18	42.68	42.02	42.56	1093300.0
2013-06-18	CL	Stock	59.7	59.92	59.48	59.7	3156100.0
2013-06-18	A	Stock	31.7454	32.0529	31.6667	32.0458	3524638.0
2013-06-18	AABA-DELISTED	Stock	26.565	26.89	26.505	26.66	9705782.0
2013-06-18	AACG	Stock	4.15	4.15	4.15	4.15	1200.0
2013-06-18	AAIC-DELISTED	Stock	28.57	28.71	28.15	28.61	184717.0
2013-06-18	AAMC-DELISTED	Stock	82.3529	82.3529	82.3529	82.3529	340.0
2013-06-18	AAME	Stock	3.93	3.93	3.9	3.91	2400.0
2013-06-18	AAMRQ-DELISTED	Stock	4.58	4.77	4.53	4.7	3925864.0
2013-06-18	AAON	Stock	9.5941	9.8548	9.5348	9.763	159638.0
2013-06-18	AAP	Stock	82.5	83.71	82.14	83.69	345100.0
2013-06-18	AAT	Stock	31.72	32.36	31.46	32.19	131400.0
2013-06-18	AAU-DELISTED	Stock	1.63	1.65	1.5796	1.59	97306.0
2013-06-18	AAUAF-DELISTED	Stock	1.57	1.59	1.52	1.59	101330.0
2013-06-18	AAV-DELISTED	Stock	4.3	4.32	4.27	4.29	122836.0
2013-06-18	AAWW-DELISTED	Stock	46.07	47.23	45.52	46.69	154910.0
2013-06-18	AAXJ	Stock	56.4	56.42	56.17	56.4	3658969.0
2013-06-18	AAXN-DELISTED	Stock	9.39	9.43	9.27	9.4	646328.0
2013-06-18	AB	Stock	24.11	24.95	24.1	24.78	275000.0
2013-06-18	ABAC-DELISTED	Stock	0.75	0.7501	0.662	0.72	64998.0
2013-06-18	ABAX-DELISTED	Stock	46.77	46.97	46.43	46.89	65815.0
2013-06-18	ABB-DELISTED	Stock	22.43	22.59	22.4	22.42	2079376.0
2013-06-18	ABBNY-DELISTED	Stock	22.43	22.59	22.4	22.44	2125018.0
2013-06-18	ABBV	Stock	42.97	43.56	42.63	43.54	3644900.0
2013-06-18	ABC-DELISTED	Stock	55.68	55.98	55.39	55.87	1783107.0
2013-06-18	ABCB	Stock	16.34	16.47	16.24	16.45	26200.0
2013-06-18	ABCD-DELISTED	Stock	1.28	1.33	1.275	1.2799	2134.0
2013-06-18	ABCO-DELISTED	Stock	54.12	54.93	53.76	54.53	102312.0
2013-06-18	ABCW-DELISTED	Stock	0.59	0.6	0.56	0.58	4784.0
2013-06-18	ABE-DELISTED	Stock	20.28	20.28	19.324	20.12	14553.0
2013-06-18	ABEO	Stock	575.0	625.0	575.0	625.0	34.0
2013-06-18	ABFS-DELISTED	Stock	19.48	19.95	19.36	19.63	392389.0
2013-06-18	ABG	Stock	40.55	41.55	40.51	41.3	219800.0
2013-06-18	ABM	Stock	24.79	24.9	24.71	24.79	167600.0
2013-06-18	ABMD-DELISTED	Stock	21.71	22.06	21.71	22.01	306007.0
2013-06-18	ABR	Stock	6.56	6.64	6.51	6.55	151000.0
2013-06-18	ABR.A-DELISTED	Stock	24.81	24.82	24.71	24.7999	8428.0
2013-06-18	ABT	Stock	36.98	37.64	36.87	37.51	5541500.0
2013-06-18	ABTL-DELISTED	Stock	4.8	4.8	4.71	4.8	6774.0
2013-06-18	ABUS	Stock	4.8	4.8	4.7	4.78	28500.0
2013-06-18	ABV-DELISTED	Stock	36.11	36.46	35.6	35.85	3305567.0
2013-06-18	ABX-DELISTED	Stock	19.3	19.34	18.74	18.9	12724465.0
2013-06-18	ACAD	Stock	19.0	19.25	18.32	18.43	3491600.0

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

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