PREVIEW / stock_daily / 2016-09-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-28.parquet
  size:    219 KB
  rows:    6,547
  symbols: 3,213

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
2016-09-28	AAPL	Stock	28.4225	28.66	28.3575	28.4875	118564400.0
2016-09-28	MSFT	Stock	57.88	58.06	57.67	58.03	20536400.0
2016-09-28	NVDA	Stock	1.666	1.6708	1.6483	1.6695	319788000.0
2016-09-28	AMZN	Stock	40.9	41.507	40.8515	41.436	88442000.0
2016-09-28	GOOGL	Stock	40.204	40.5125	40.139	40.503	29405600.0
2016-09-28	META	Stock	129.21	129.47	128.4	129.23	12047600.0
2016-09-28	TSLA	Stock	13.834	13.8833	13.684	13.7513	31326000.0
2016-09-28	TLT	Stock	138.5	139.15	138.22	138.4	7958732.0
2016-09-28	ES	Stock	55.51	55.58	54.81	55.24	1120300.0
2016-09-28	CL	Stock	73.86	73.95	72.99	73.6	2684600.0
2016-09-28	A	Stock	46.9	47.26	46.52	47.18	1502500.0
2016-09-28	AA.B-DELISTED	Stock	31.77	32.2399	31.41	32.16	222113.0
2016-09-28	AAAP-DELISTED	Stock	38.55	38.8	38.4	38.6	115958.0
2016-09-28	AABA-DELISTED	Stock	43.4	43.72	43.25	43.69	6938442.0
2016-09-28	AAC-DELISTED	Stock	16.86	17.16	16.54	16.66	170518.0
2016-09-28	AACG	Stock	4.2	4.52	4.18	4.35	20600.0
2016-09-28	AAIC-DELISTED	Stock	14.79	14.81	14.55	14.81	299981.0
2016-09-28	AAL	Stock	36.1	36.86	35.78	35.84	6291600.0
2016-09-28	AAMC-DELISTED	Stock	4.7824	4.9588	4.7824	4.9353	18649.0
2016-09-28	AAME	Stock	3.42	3.45	3.37	3.37	1800.0
2016-09-28	AAMI	Stock	13.57	13.86	13.57	13.82	130000.0
2016-09-28	AAOI	Stock	21.35	21.62	20.96	21.22	398700.0
2016-09-28	AAON	Stock	18.92	18.9933	18.76	18.9067	138600.0
2016-09-28	AAP	Stock	151.25	151.34	148.69	149.0	1120600.0
2016-09-28	AAT	Stock	43.81	44.12	43.52	44.11	149700.0
2016-09-28	AAU-DELISTED	Stock	1.35	1.37	1.33	1.36	125089.0
2016-09-28	AAUAF-DELISTED	Stock	1.35	1.39	1.33	1.39	127861.0
2016-09-28	AAV-DELISTED	Stock	6.71	7.022	6.66	6.98	89001.0
2016-09-28	AAWW-DELISTED	Stock	40.45	41.73	40.11	41.69	363318.0
2016-09-28	AAXJ	Stock	60.7	61.13	60.33	61.1	1027764.0
2016-09-28	AAXN-DELISTED	Stock	28.57	28.919	28.41	28.85	700911.0
2016-09-28	AB	Stock	22.26	22.5	22.24	22.25	284500.0
2016-09-28	ABAC-DELISTED	Stock	2.05	2.15	1.96	2.02	18968.0
2016-09-28	ABAX-DELISTED	Stock	50.73	51.635	50.64	50.88	70969.0
2016-09-28	ABB-DELISTED	Stock	22.49	22.71	22.43	22.7	1594914.0
2016-09-28	ABBNY-DELISTED	Stock	22.49	22.71	22.43	22.7	1634329.0
2016-09-28	ABBV	Stock	64.94	64.94	63.89	64.22	5645600.0
2016-09-28	ABC-DELISTED	Stock	83.25	83.3	82.46	83.19	1146728.0
2016-09-28	ABCB	Stock	34.55	34.81	34.25	34.8	185100.0
2016-09-28	ABCD-DELISTED	Stock	5.37	5.43	5.03	5.43	43697.0
2016-09-28	ABCO-DELISTED	Stock	43.06	43.74	42.84	43.74	218199.0
2016-09-28	ABDC-DELISTED	Stock	12.9	13.29	12.72	13.01	48047.0
2016-09-28	ABE-DELISTED	Stock	12.73	12.741	12.7	12.73	8075.0
2016-09-28	ABEO	Stock	141.25	145.75	140.25	143.5	13884.0
2016-09-28	ABEOW-DELISTED	Stock	2.85	3.23	2.85	3.21	1260.0
2016-09-28	ABEV	Stock	6.09	6.17	6.05	6.15	5670900.0
2016-09-28	ABG	Stock	55.26	55.74	53.53	54.56	171800.0
2016-09-28	ABIL-DELISTED	Stock	3.8799	3.8799	3.8799	3.8799	1400.0
2016-09-28	ABM	Stock	39.61	39.71	39.37	39.69	177900.0
2016-09-28	ABMD-DELISTED	Stock	129.12	130.22	127.74	129.89	251361.0

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

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