PREVIEW / stock_daily / 2013-07-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-23.parquet
  size:    212 KB
  rows:    6,345
  symbols: 3,514

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-23	AAPL	Stock	15.2143	15.2486	14.9539	14.9639	369395600.0
2013-07-23	MSFT	Stock	31.91	32.04	31.71	31.82	65810400.0
2013-07-23	NVDA	Stock	0.3602	0.3602	0.3535	0.3553	246792000.0
2013-07-23	AMZN	Stock	15.158	15.253	15.028	15.053	39992000.0
2013-07-23	META	Stock	26.1	26.3	25.97	26.13	28221600.0
2013-07-23	TSLA	Stock	8.2667	8.3707	8.1213	8.1827	116046000.0
2013-07-23	TLT	Stock	108.67	109.0	108.32	108.9	5015436.0
2013-07-23	ES	Stock	44.69	45.0	44.51	44.92	803700.0
2013-07-23	CL	Stock	58.61	58.79	58.23	58.41	2627100.0
2013-07-23	A	Stock	33.1259	33.505	33.1259	33.2403	4099216.0
2013-07-23	AABA-DELISTED	Stock	28.03	28.05	27.21	27.35	25851783.0
2013-07-23	AACG	Stock	4.99	5.15	4.95	5.1	10100.0
2013-07-23	AAIC-DELISTED	Stock	26.49	26.7	26.39	26.46	147027.0
2013-07-23	AAMC-DELISTED	Stock	88.0882	95.5882	88.0882	95.5882	60211.0
2013-07-23	AAME	Stock	3.65	3.74	3.65	3.74	1700.0
2013-07-23	AAMRQ-DELISTED	Stock	5.3	5.38	5.04	5.25	3943821.0
2013-07-23	AAON	Stock	10.4489	10.4622	10.2889	10.2978	151200.0
2013-07-23	AAP	Stock	82.99	83.59	82.46	82.7	583200.0
2013-07-23	AAT	Stock	33.95	34.01	33.71	33.99	49100.0
2013-07-23	AAU-DELISTED	Stock	1.72	1.79	1.63	1.79	180670.0
2013-07-23	AAUAF-DELISTED	Stock	1.72	1.81	1.63	1.81	180970.0
2013-07-23	AAV-DELISTED	Stock	4.19	4.19	4.01	4.05	614780.0
2013-07-23	AAWW-DELISTED	Stock	46.14	46.34	45.29	45.3	211020.0
2013-07-23	AAXJ	Stock	57.04	57.22	56.75	57.0	825034.0
2013-07-23	AAXN-DELISTED	Stock	9.02	9.06	8.75	8.91	261486.0
2013-07-23	AB	Stock	22.8	22.83	22.56	22.66	264300.0
2013-07-23	ABAC-DELISTED	Stock	0.61	0.6279	0.6	0.6098	21770.0
2013-07-23	ABAX-DELISTED	Stock	49.69	49.98	48.84	49.95	85852.0
2013-07-23	ABB-DELISTED	Stock	22.81	22.93	22.7	22.87	1281521.0
2013-07-23	ABBNY-DELISTED	Stock	22.81	22.93	22.7	22.88	1338211.0
2013-07-23	ABBV	Stock	44.92	45.09	44.23	44.31	3535100.0
2013-07-23	ABC-DELISTED	Stock	58.97	59.0	57.595	57.66	3743906.0
2013-07-23	ABCB	Stock	18.58	18.58	18.38	18.51	70100.0
2013-07-23	ABCO-DELISTED	Stock	56.6	57.3	56.42	57.04	124425.0
2013-07-23	ABCW-DELISTED	Stock	0.43	0.45	0.4015	0.4058	10372.0
2013-07-23	ABE-DELISTED	Stock	20.09	20.3937	20.09	20.2	3080.0
2013-07-23	ABEO	Stock	500.0	500.0	487.5	500.0	14.0
2013-07-23	ABFS-DELISTED	Stock	22.77	22.77	21.575	21.66	276268.0
2013-07-23	ABG	Stock	48.0	51.85	45.78	46.82	1140200.0
2013-07-23	ABM	Stock	26.23	26.25	26.06	26.17	174300.0
2013-07-23	ABMD-DELISTED	Stock	24.51	25.03	24.432	24.5	244500.0
2013-07-23	ABR	Stock	7.49	7.53	7.44	7.51	144700.0
2013-07-23	ABR.A-DELISTED	Stock	25.23	25.42	25.21	25.42	6645.0
2013-07-23	ABR.B-DELISTED	Stock	24.27	24.5	24.269	24.5	2600.0
2013-07-23	ABT	Stock	35.93	36.8	35.9	36.68	9104400.0
2013-07-23	ABTL-DELISTED	Stock	5.28	5.29	5.09	5.25	31503.0
2013-07-23	ABUS	Stock	5.16	5.16	4.91	4.93	89100.0
2013-07-23	ABV-DELISTED	Stock	37.05	37.27	36.76	37.11	2312537.0
2013-07-23	ABX-DELISTED	Stock	17.57	18.13	17.35	18.11	20586274.0
2013-07-23	ACAD	Stock	20.15	20.3	19.16	19.22	2248200.0

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

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