PREVIEW / stock_daily / 2013-07-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-09.parquet
  size:    210 KB
  rows:    6,358
  symbols: 3,523

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-07-09	AAPL	Stock	14.7714	15.125	14.6564	15.0839	352584400.0
2013-07-09	MSFT	Stock	34.58	34.6	34.14	34.35	25318500.0
2013-07-09	NVDA	Stock	0.355	0.3582	0.354	0.356	157364000.0
2013-07-09	AMZN	Stock	14.55	14.6285	14.4005	14.5765	55512000.0
2013-07-09	META	Stock	25.07	25.49	25.03	25.48	30387900.0
2013-07-09	TSLA	Stock	8.3093	8.3547	8.1273	8.23	129049500.0
2013-07-09	TLT	Stock	107.49	107.62	107.07	107.4	4700763.0
2013-07-09	ES	Stock	41.99	42.23	41.83	42.19	1161500.0
2013-07-09	CL	Stock	59.03	59.24	58.82	58.98	2916100.0
2013-07-09	A	Stock	31.9027	32.1602	31.7167	31.9027	4859728.0
2013-07-09	AABA-DELISTED	Stock	25.74	26.7	25.74	26.68	17097503.0
2013-07-09	AACG	Stock	4.73	4.75	4.73	4.73	1100.0
2013-07-09	AAIC-DELISTED	Stock	24.51	25.18	24.194	24.75	214926.0
2013-07-09	AAMC-DELISTED	Stock	78.8235	78.8235	78.8235	78.8235	8588.0
2013-07-09	AAME	Stock	3.81	3.81	3.7	3.8	3300.0
2013-07-09	AAMRQ-DELISTED	Stock	4.33	4.75	4.33	4.72	5819192.0
2013-07-09	AAON	Stock	10.56	11.0311	10.48	11.0044	253575.0
2013-07-09	AAP	Stock	84.02	84.16	83.14	83.2	376600.0
2013-07-09	AAT	Stock	32.5	32.8	32.35	32.63	134100.0
2013-07-09	AAU-DELISTED	Stock	1.34	1.399	1.325	1.35	90701.0
2013-07-09	AAUAF-DELISTED	Stock	1.34	1.399	1.325	1.35	91001.0
2013-07-09	AAV-DELISTED	Stock	4.06	4.069	4.0	4.02	136595.0
2013-07-09	AAWW-DELISTED	Stock	43.25	43.78	42.98	43.55	185572.0
2013-07-09	AAXJ	Stock	54.26	54.39	53.97	54.29	313062.0
2013-07-09	AAXN-DELISTED	Stock	8.95	8.99	8.77	8.9	304192.0
2013-07-09	AB	Stock	19.32	19.41	19.11	19.2	1131300.0
2013-07-09	ABAC-DELISTED	Stock	0.56	0.59	0.54	0.58	15734.0
2013-07-09	ABAX-DELISTED	Stock	49.7	50.48	48.882	50.39	108062.0
2013-07-09	ABB-DELISTED	Stock	21.73	21.75	21.58	21.67	1250690.0
2013-07-09	ABBNY-DELISTED	Stock	21.73	21.75	21.58	21.69	1309456.0
2013-07-09	ABBV	Stock	44.0	44.23	43.25	43.32	3805700.0
2013-07-09	ABC-DELISTED	Stock	56.47	56.84	55.81	55.92	2091377.0
2013-07-09	ABCB	Stock	18.79	18.79	18.47	18.5	143300.0
2013-07-09	ABCD-DELISTED	Stock	1.33	1.33	1.33	1.33	1000.0
2013-07-09	ABCO-DELISTED	Stock	55.54	55.71	52.86	54.69	245956.0
2013-07-09	ABCW-DELISTED	Stock	0.35	0.385	0.35	0.38	33294.0
2013-07-09	ABE-DELISTED	Stock	19.31	19.55	19.31	19.46	6656.0
2013-07-09	ABEO	Stock	537.5	562.5	537.5	562.5	16.0
2013-07-09	ABFS-DELISTED	Stock	23.28	23.63	22.93	23.04	391192.0
2013-07-09	ABG	Stock	43.35	44.0	43.13	43.73	210600.0
2013-07-09	ABM	Stock	24.84	24.94	24.65	24.75	276500.0
2013-07-09	ABMD-DELISTED	Stock	22.92	23.4	22.71	23.24	278266.0
2013-07-09	ABR	Stock	6.32	6.39	6.23	6.34	67100.0
2013-07-09	ABR.A-DELISTED	Stock	25.18	25.2	25.18	25.2	650.0
2013-07-09	ABR.B-DELISTED	Stock	24.175	24.175	24.175	24.175	100.0
2013-07-09	ABT	Stock	35.46	35.56	34.73	34.74	10291400.0
2013-07-09	ABTL-DELISTED	Stock	4.76	5.08	4.7	5.0	56299.0
2013-07-09	ABUS	Stock	4.83	4.97	4.83	4.92	36900.0
2013-07-09	ABV-DELISTED	Stock	36.38	36.94	36.27	36.47	1367183.0
2013-07-09	ABX-DELISTED	Stock	14.14	14.355	13.85	13.905	17745281.0

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

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