PREVIEW / stock_daily / 2013-05-29

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-29.parquet
  size:    210 KB
  rows:    6,337
  symbols: 3,520

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-05-29	AAPL	Stock	15.7143	15.9821	15.6929	15.8911	330576400.0
2013-05-29	MSFT	Stock	34.74	35.02	34.57	34.88	38412200.0
2013-05-29	NVDA	Stock	0.361	0.3632	0.3595	0.361	335052000.0
2013-05-29	AMZN	Stock	13.273	13.4125	13.242	13.2765	38068000.0
2013-05-29	META	Stock	23.79	23.81	23.26	23.32	64237800.0
2013-05-29	TSLA	Stock	7.57	7.66	6.6	6.9753	376492500.0
2013-05-29	TLT	Stock	114.62	115.185	114.46	115.118	11298927.0
2013-05-29	ES	Stock	41.94	41.98	41.38	41.73	2055400.0
2013-05-29	CL	Stock	61.09	61.18	59.4	59.58	4483400.0
2013-05-29	A	Stock	32.8898	33.1545	32.475	32.9399	5062438.0
2013-05-29	AABA-DELISTED	Stock	25.9	26.04	25.321	25.815	18348787.0
2013-05-29	AACC-DELISTED	Stock	6.72	6.79	6.72	6.77	70655.0
2013-05-29	AACG	Stock	4.23	4.51	4.07	4.4	6000.0
2013-05-29	AAIC-DELISTED	Stock	27.67	27.85	26.56	27.46	463312.0
2013-05-29	AAMC-DELISTED	Stock	83.5294	85.2941	78.5294	85.2941	22484.0
2013-05-29	AAME	Stock	3.85	3.93	3.85	3.93	9700.0
2013-05-29	AAMRQ-DELISTED	Stock	5.74	6.71	5.45	5.46	5864533.0
2013-05-29	AAON	Stock	10.1926	10.3881	10.0267	10.0711	181238.0
2013-05-29	AAP	Stock	83.14	83.48	81.81	82.16	770200.0
2013-05-29	AAT	Stock	33.93	34.22	32.88	33.22	263000.0
2013-05-29	AAU-DELISTED	Stock	1.59	1.62	1.56	1.62	60812.0
2013-05-29	AAUAF-DELISTED	Stock	1.59	1.62	1.56	1.62	61312.0
2013-05-29	AAV-DELISTED	Stock	4.49	4.49	4.26	4.38	354102.0
2013-05-29	AAWW-DELISTED	Stock	45.49	46.38	45.21	46.24	203135.0
2013-05-29	AAXJ	Stock	59.36	59.46	59.07	59.14	1160354.0
2013-05-29	AAXN-DELISTED	Stock	9.5	9.68	9.4	9.57	547931.0
2013-05-29	AB	Stock	25.56	26.0	25.26	25.44	183400.0
2013-05-29	ABAC-DELISTED	Stock	0.65	0.6779	0.57	0.63	49180.0
2013-05-29	ABAX-DELISTED	Stock	44.42	45.1	43.952	44.67	204376.0
2013-05-29	ABB-DELISTED	Stock	22.15	22.24	22.02	22.09	1571442.0
2013-05-29	ABBNY-DELISTED	Stock	22.15	22.24	22.02	22.1	1686247.0
2013-05-29	ABBV	Stock	44.89	45.18	43.79	43.88	6908400.0
2013-05-29	ABC-DELISTED	Stock	54.17	54.5	53.22	53.91	2599698.0
2013-05-29	ABCB	Stock	16.55	16.72	16.35	16.54	39300.0
2013-05-29	ABCD-DELISTED	Stock	1.4	1.5	1.4	1.43	37164.0
2013-05-29	ABCO-DELISTED	Stock	51.31	52.09	51.25	51.93	274638.0
2013-05-29	ABCW-DELISTED	Stock	0.55	0.61	0.55	0.56	23124.0
2013-05-29	ABE-DELISTED	Stock	21.55	21.98	21.4	21.4569	25514.0
2013-05-29	ABEO	Stock	575.0	575.0	575.0	575.0	1.0
2013-05-29	ABFS-DELISTED	Stock	18.57	19.56	18.55	18.9	881474.0
2013-05-29	ABG	Stock	41.78	41.95	41.06	41.51	110100.0
2013-05-29	ABM	Stock	23.87	24.02	23.74	23.9	122100.0
2013-05-29	ABMD-DELISTED	Stock	21.98	21.98	20.83	21.3	588031.0
2013-05-29	ABR	Stock	6.82	7.03	6.68	7.0	241400.0
2013-05-29	ABR.A-DELISTED	Stock	25.13	25.249	24.95	25.106	17975.0
2013-05-29	ABR.B-DELISTED	Stock	24.9	24.95	24.12	24.95	11293.0
2013-05-29	ABT	Stock	38.26	38.46	37.33	37.72	8678100.0
2013-05-29	ABTL-DELISTED	Stock	4.91	5.04	4.74	5.04	39136.0
2013-05-29	ABUS	Stock	4.74	4.81	4.68	4.81	43400.0
2013-05-29	ABV-DELISTED	Stock	41.16	41.63	39.98	40.26	2317471.0

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

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