PREVIEW / stock_daily / 2015-08-13

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-13.parquet
  size:    222 KB
  rows:    6,647
  symbols: 3,455

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
2015-08-13	AAPL	Stock	29.01	29.1	28.635	28.7875	194143200.0
2015-08-13	MSFT	Stock	47.06	47.1	46.49	46.73	22627200.0
2015-08-13	NVDA	Stock	0.5938	0.595	0.5865	0.588	276884000.0
2015-08-13	AMZN	Stock	26.3685	26.733	26.2745	26.483	57904000.0
2015-08-13	GOOGL	Stock	34.46	34.7015	34.109	34.3255	36353940.0
2015-08-13	META	Stock	94.05	94.73	93.35	93.43	17451800.0
2015-08-13	TSLA	Stock	15.9907	16.432	15.9413	16.1673	70338000.0
2015-08-13	TLT	Stock	123.83	124.42	123.22	123.67	7691434.0
2015-08-13	ES	Stock	50.61	51.03	50.2	50.79	1413800.0
2015-08-13	CL	Stock	68.03	68.18	67.57	67.66	2225900.0
2015-08-13	A	Stock	38.94	38.94	38.46	38.56	2848900.0
2015-08-13	AA.B-DELISTED	Stock	35.25	35.44	34.63	34.66	46340.0
2015-08-13	AABA-DELISTED	Stock	35.08	36.61	34.82	35.93	27796069.0
2015-08-13	AAC-DELISTED	Stock	19.3	22.97	19.3	22.68	1138437.0
2015-08-13	AACG	Stock	2.9	3.24	2.9	3.01	7000.0
2015-08-13	AAIC-DELISTED	Stock	18.16	18.24	18.04	18.06	190246.0
2015-08-13	AAL	Stock	42.76	43.28	42.27	42.67	6605800.0
2015-08-13	AAMC-DELISTED	Stock	29.1176	29.7059	28.2353	28.4941	18326.0
2015-08-13	AAME	Stock	3.58	3.66	3.53	3.65	4000.0
2015-08-13	AAMI	Stock	17.34	17.44	17.058	17.17	50200.0
2015-08-13	AAOI	Stock	22.32	22.79	22.21	22.51	623900.0
2015-08-13	AAON	Stock	15.3067	15.46	15.12	15.2533	150000.0
2015-08-13	AAP	Stock	173.9	192.27	173.0	187.79	3745800.0
2015-08-13	AAT	Stock	41.08	41.63	40.78	41.42	166200.0
2015-08-13	AAU-DELISTED	Stock	0.65	0.6968	0.65	0.67	72886.0
2015-08-13	AAUAF-DELISTED	Stock	0.65	0.6968	0.65	0.67	77639.0
2015-08-13	AAV-DELISTED	Stock	5.41	5.53	5.37	5.5	92996.0
2015-08-13	AAVL-DELISTED	Stock	14.28	14.84	13.82	13.82	534580.0
2015-08-13	AAWW-DELISTED	Stock	45.23	46.535	44.6	44.78	366238.0
2015-08-13	AAXJ	Stock	56.96	57.13	56.74	56.84	1645145.0
2015-08-13	AAXN-DELISTED	Stock	23.76	24.4801	23.2407	24.0899	1597333.0
2015-08-13	AB	Stock	27.99	28.48	27.69	28.19	300200.0
2015-08-13	ABAC-DELISTED	Stock	1.0	1.0	0.93	0.96	4100.0
2015-08-13	ABAX-DELISTED	Stock	48.36	48.58	47.58	47.94	105796.0
2015-08-13	ABB-DELISTED	Stock	20.16	20.18	20.04	20.05	1846253.0
2015-08-13	ABBNY-DELISTED	Stock	20.16	20.18	20.04	20.05	1982609.0
2015-08-13	ABBV	Stock	68.68	69.09	68.21	68.54	7184900.0
2015-08-13	ABC-DELISTED	Stock	104.73	105.294	102.291	103.86	1389664.0
2015-08-13	ABCB	Stock	27.81	28.0	27.66	27.76	56600.0
2015-08-13	ABCD-DELISTED	Stock	4.18	4.89	4.18	4.58	172040.0
2015-08-13	ABCO-DELISTED	Stock	49.61	51.3	49.61	50.05	394863.0
2015-08-13	ABCW-DELISTED	Stock	39.81	41.2	39.7	41.11	9625.0
2015-08-13	ABDC-DELISTED	Stock	12.75	12.75	12.5	12.61	53377.0
2015-08-13	ABE-DELISTED	Stock	11.93	12.02	11.93	12.02	3016.0
2015-08-13	ABEO	Stock	142.5	145.5	139.25	140.75	4984.0
2015-08-13	ABEOW-DELISTED	Stock	2.12	2.17	2.08	2.12	2448.0
2015-08-13	ABEV	Stock	5.41	5.43	5.27	5.28	20182700.0
2015-08-13	ABG	Stock	82.16	83.41	81.67	82.28	268500.0
2015-08-13	ABGB-DELISTED	Stock	5.26	5.29	5.06	5.14	55823.0
2015-08-13	ABM	Stock	33.06	33.25	32.79	33.0	131100.0

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

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