PREVIEW / stock_daily / 2013-08-21

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-21.parquet
  size:    211 KB
  rows:    6,369
  symbols: 3,530

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-21	AAPL	Stock	17.9854	18.1125	17.9	17.9414	335879600.0
2013-08-21	MSFT	Stock	31.61	32.01	31.54	31.61	37409100.0
2013-08-21	NVDA	Stock	0.3715	0.3763	0.3705	0.372	261540000.0
2013-08-21	AMZN	Stock	14.2545	14.425	14.1915	14.2285	36306000.0
2013-08-21	META	Stock	38.38	38.85	38.15	38.32	46116900.0
2013-08-21	TSLA	Stock	10.0	10.0207	9.75	9.8573	93994500.0
2013-08-21	TLT	Stock	102.77	103.2	102.11	102.13	13250259.0
2013-08-21	ES	Stock	41.53	41.53	40.81	41.01	1787500.0
2013-08-21	CL	Stock	59.0	59.05	58.44	58.51	3036800.0
2013-08-21	A	Stock	33.5694	33.7911	33.3619	33.5408	2724842.0
2013-08-21	AABA-DELISTED	Stock	27.09	27.49	27.0	27.06	8754369.0
2013-08-21	AAIC-DELISTED	Stock	23.36	23.49	22.92	23.21	84423.0
2013-08-21	AAMC-DELISTED	Stock	88.6765	88.6765	88.6765	88.6765	1153.0
2013-08-21	AAME	Stock	3.71	3.8	3.71	3.8	1500.0
2013-08-21	AAMRQ-DELISTED	Stock	3.22	3.28	3.01	3.06	11185827.0
2013-08-21	AAON	Stock	10.7556	10.9067	10.64	10.7422	213975.0
2013-08-21	AAP	Stock	81.58	82.22	81.2	81.73	685600.0
2013-08-21	AAT	Stock	29.85	30.14	29.5	29.67	86300.0
2013-08-21	AAU-DELISTED	Stock	1.92	1.92	1.86	1.8825	36950.0
2013-08-21	AAUAF-DELISTED	Stock	1.92	1.92	1.86	1.89	37450.0
2013-08-21	AAV-DELISTED	Stock	3.69	3.72	3.63	3.63	269522.0
2013-08-21	AAWW-DELISTED	Stock	46.61	46.61	45.26	45.66	172468.0
2013-08-21	AAXJ	Stock	54.19	54.34	53.61	53.78	577812.0
2013-08-21	AAXN-DELISTED	Stock	11.05	11.5	10.9	11.18	3009581.0
2013-08-21	AB	Stock	19.8	20.01	19.29	19.37	303200.0
2013-08-21	ABAC-DELISTED	Stock	1.1	1.28	0.89	0.913	699230.0
2013-08-21	ABAX-DELISTED	Stock	40.81	41.36	40.53	40.88	61188.0
2013-08-21	ABB-DELISTED	Stock	22.32	22.38	22.02	22.12	1053577.0
2013-08-21	ABBNY-DELISTED	Stock	22.32	22.38	22.02	22.11	1077882.0
2013-08-21	ABBV	Stock	42.82	42.88	42.25	42.31	4118800.0
2013-08-21	ABC-DELISTED	Stock	57.26	57.54	56.94	57.08	1399772.0
2013-08-21	ABCB	Stock	18.73	18.84	18.26	18.61	190000.0
2013-08-21	ABCO-DELISTED	Stock	56.56	56.71	55.75	56.13	71808.0
2013-08-21	ABE-DELISTED	Stock	19.11	19.14	18.5101	18.87	36481.0
2013-08-21	ABEO	Stock	425.0	425.0	425.0	425.0	3.0
2013-08-21	ABFS-DELISTED	Stock	23.27	24.34	23.1901	24.09	452012.0
2013-08-21	ABG	Stock	49.86	50.6	49.71	50.07	238900.0
2013-08-21	ABM	Stock	25.44	25.61	25.07	25.13	105600.0
2013-08-21	ABMD-DELISTED	Stock	22.27	22.5	22.11	22.23	198869.0
2013-08-21	ABR	Stock	6.9	6.94	6.76	6.86	58000.0
2013-08-21	ABR.B-DELISTED	Stock	21.9	21.95	21.85	21.91	2059.0
2013-08-21	ABT	Stock	34.68	34.86	34.44	34.64	5413200.0
2013-08-21	ABTL-DELISTED	Stock	5.98	6.2	5.94	6.09	48138.0
2013-08-21	ABUS	Stock	5.24	5.24	5.17	5.22	22900.0
2013-08-21	ABV-DELISTED	Stock	34.27	34.57	33.77	33.935	3238475.0
2013-08-21	ABX-DELISTED	Stock	19.65	19.838	19.0484	19.052	18400773.0
2013-08-21	ACAD	Stock	19.87	20.74	19.86	20.18	2229700.0
2013-08-21	ACAS-DELISTED	Stock	12.69	12.8965	12.67	12.72	3254173.0
2013-08-21	ACAT-DELISTED	Stock	56.65	56.83	55.65	55.78	59011.0
2013-08-21	ACC-DELISTED	Stock	34.42	35.19	33.95	34.71	660908.0

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

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