PREVIEW / stock_daily / 2013-08-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-19.parquet
  size:    213 KB
  rows:    6,414
  symbols: 3,552

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-19	AAPL	Stock	18.0121	18.3479	18.0	18.1336	510518400.0
2013-08-19	MSFT	Stock	31.76	31.97	31.38	31.39	27902500.0
2013-08-19	NVDA	Stock	0.3775	0.3788	0.3735	0.3738	393432000.0
2013-08-19	AMZN	Stock	14.2595	14.478	14.174	14.2785	49548000.0
2013-08-19	META	Stock	37.43	38.28	37.14	37.81	57609600.0
2013-08-19	TSLA	Stock	9.562	9.8253	9.522	9.66	120565500.0
2013-08-19	TLT	Stock	102.93	103.01	102.21	102.47	9022473.0
2013-08-19	ES	Stock	41.26	41.49	41.05	41.22	1657000.0
2013-08-19	CL	Stock	59.28	59.38	58.91	59.15	2351400.0
2013-08-19	A	Stock	33.3548	33.5765	33.2046	33.2189	2415185.0
2013-08-19	AABA-DELISTED	Stock	27.27	27.44	26.91	26.92	11547732.0
2013-08-19	AACG	Stock	5.07	5.35	5.07	5.35	10900.0
2013-08-19	AAIC-DELISTED	Stock	24.15	24.204	22.87	22.89	287520.0
2013-08-19	AAMC-DELISTED	Stock	82.6912	95.2941	82.6912	95.2941	1890.0
2013-08-19	AAME	Stock	3.8	3.82	3.57	3.82	2600.0
2013-08-19	AAMRQ-DELISTED	Stock	2.825	2.94	2.7	2.88	14544297.0
2013-08-19	AAON	Stock	10.8711	11.0089	10.6978	10.7289	187650.0
2013-08-19	AAP	Stock	80.75	81.43	80.27	80.35	680900.0
2013-08-19	AAT	Stock	30.14	30.38	29.65	29.68	193400.0
2013-08-19	AAU-DELISTED	Stock	1.99	2.011	1.88	1.89	156068.0
2013-08-19	AAUAF-DELISTED	Stock	1.96	1.979	1.85	1.89	161130.0
2013-08-19	AAV-DELISTED	Stock	3.75	3.79	3.69	3.7	160509.0
2013-08-19	AAWW-DELISTED	Stock	44.12	44.48	43.82	44.2	232465.0
2013-08-19	AAXJ	Stock	55.91	55.95	55.36	55.4	244719.0
2013-08-19	AAXN-DELISTED	Stock	10.18	10.77	10.0	10.43	1703875.0
2013-08-19	AB	Stock	20.14	20.2	19.74	19.8	423200.0
2013-08-19	ABAC-DELISTED	Stock	0.73	0.9	0.62	0.8499	126808.0
2013-08-19	ABAX-DELISTED	Stock	39.22	40.63	39.22	40.24	129867.0
2013-08-19	ABB-DELISTED	Stock	22.45	22.48	22.33	22.35	506360.0
2013-08-19	ABBNY-DELISTED	Stock	22.45	22.48	22.33	22.34	557272.0
2013-08-19	ABBV	Stock	43.01	43.81	42.95	43.37	3326900.0
2013-08-19	ABC-DELISTED	Stock	56.54	57.095	56.49	56.86	1987671.0
2013-08-19	ABCB	Stock	18.77	18.92	18.55	18.6	97100.0
2013-08-19	ABCD-DELISTED	Stock	1.44	1.46	1.25	1.36	25648.0
2013-08-19	ABCO-DELISTED	Stock	56.05	56.73	55.57	55.87	111880.0
2013-08-19	ABE-DELISTED	Stock	19.52	19.544	19.2	19.33	5222.0
2013-08-19	ABEO	Stock	412.5	450.0	412.5	450.0	2.0
2013-08-19	ABFS-DELISTED	Stock	23.14	23.43	22.66	22.87	191254.0
2013-08-19	ABG	Stock	49.43	50.54	49.32	49.32	146100.0
2013-08-19	ABM	Stock	25.15	25.49	25.1	25.19	174300.0
2013-08-19	ABMD-DELISTED	Stock	22.3	22.86	22.15	22.58	297732.0
2013-08-19	ABR	Stock	7.1	7.13	6.68	6.68	237300.0
2013-08-19	ABR.A-DELISTED	Stock	24.4399	24.4399	23.65	23.9399	3874.0
2013-08-19	ABR.B-DELISTED	Stock	22.7499	22.7499	22.01	22.01	7194.0
2013-08-19	ABT	Stock	34.85	34.96	34.7	34.88	5603500.0
2013-08-19	ABTL-DELISTED	Stock	6.3	6.37	6.12	6.16	53994.0
2013-08-19	ABUS	Stock	5.3	5.32	5.18	5.18	14800.0
2013-08-19	ABV-DELISTED	Stock	36.54	36.76	35.8	35.85	2386436.0
2013-08-19	ABX-DELISTED	Stock	19.41	19.6099	19.03	19.23	16619071.0
2013-08-19	ACAD	Stock	19.71	20.05	19.53	19.61	1054700.0

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

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