PREVIEW / stock_daily / 2017-02-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-24.parquet
  size:    216 KB
  rows:    6,490
  symbols: 3,080

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
2017-02-24	AAPL	Stock	33.9775	34.165	33.82	34.165	87106400.0
2017-02-24	MSFT	Stock	64.53	64.8	64.14	64.62	21796800.0
2017-02-24	NVDA	Stock	2.4268	2.55	2.3925	2.5365	1029904000.0
2017-02-24	AMZN	Stock	42.2345	42.2905	41.8875	42.262	73760000.0
2017-02-24	GOOGL	Stock	42.3825	42.418	42.148	42.3905	26923780.0
2017-02-24	META	Stock	134.16	135.62	134.16	135.44	12625700.0
2017-02-24	TSLA	Stock	16.844	17.2167	16.68	17.1333	122574000.0
2017-02-24	TLT	Stock	121.35	122.14	121.26	122.01	11335989.0
2017-02-24	ES	Stock	58.2	59.11	58.17	59.03	2113200.0
2017-02-24	CL	Stock	73.57	74.11	72.81	73.35	6461600.0
2017-02-24	A	Stock	51.38	51.83	51.33	51.74	1612700.0
2017-02-24	AA	Stock	33.81	34.64	33.35	34.48	5763800.0
2017-02-24	AAAP-DELISTED	Stock	35.98	36.99	35.6501	36.96	162039.0
2017-02-24	AABA-DELISTED	Stock	45.14	45.54	44.95	45.54	3470129.0
2017-02-24	AAC-DELISTED	Stock	7.72	7.73	7.51	7.58	65495.0
2017-02-24	AACG	Stock	3.85	3.85	3.82	3.83	5300.0
2017-02-24	AAIC-DELISTED	Stock	14.93	15.0478	14.76	14.88	216164.0
2017-02-24	AAL	Stock	46.0	46.3	45.58	46.28	4489600.0
2017-02-24	AAMC-DELISTED	Stock	20.9412	20.9412	20.4619	20.75	18625.0
2017-02-24	AAMI	Stock	14.89	15.19	14.89	15.18	450800.0
2017-02-24	AAOI	Stock	42.11	49.34	40.55	45.98	6549800.0
2017-02-24	AAON	Stock	23.2	23.2	22.0667	23.0	441150.0
2017-02-24	AAP	Stock	156.46	158.23	155.45	157.33	1599600.0
2017-02-24	AAT	Stock	44.3	44.3	43.88	44.13	201600.0
2017-02-24	AAU-DELISTED	Stock	1.14	1.18	1.08	1.17	448848.0
2017-02-24	AAUAF-DELISTED	Stock	1.14	1.18	1.08	1.17	450227.0
2017-02-24	AAV-DELISTED	Stock	6.2	6.25	6.1	6.15	107847.0
2017-02-24	AAWW-DELISTED	Stock	55.15	57.15	55.05	56.45	190416.0
2017-02-24	AAXJ	Stock	60.8	61.02	60.73	61.02	343763.0
2017-02-24	AAXN-DELISTED	Stock	25.47	25.78	25.26	25.64	795600.0
2017-02-24	AB	Stock	23.75	23.78	23.55	23.7	222700.0
2017-02-24	ABAC-DELISTED	Stock	2.8	2.8956	2.8	2.89	11465.0
2017-02-24	ABAX-DELISTED	Stock	48.91	49.91	48.23	49.74	61026.0
2017-02-24	ABB-DELISTED	Stock	22.39	22.57	22.37	22.54	1370305.0
2017-02-24	ABBNY-DELISTED	Stock	22.39	22.57	22.37	22.55	1413193.0
2017-02-24	ABBV	Stock	61.92	62.23	61.49	62.09	6536400.0
2017-02-24	ABC-DELISTED	Stock	91.54	92.16	90.56	92.15	759061.0
2017-02-24	ABCB	Stock	48.2	48.9	47.5	48.75	77000.0
2017-02-24	ABCD-DELISTED	Stock	4.901	5.06	4.85	4.95	16495.0
2017-02-24	ABCO-DELISTED	Stock	46.35	46.7	45.3	45.3	1078495.0
2017-02-24	ABDC-DELISTED	Stock	12.9	12.9	12.53	12.59	40121.0
2017-02-24	ABE-DELISTED	Stock	12.17	12.2199	12.1	12.16	27874.0
2017-02-24	ABEO	Stock	125.0	131.25	122.5	131.25	11560.0
2017-02-24	ABEV	Stock	5.76	5.81	5.71	5.71	14407600.0
2017-02-24	ABG	Stock	65.65	67.35	64.8	66.7	246300.0
2017-02-24	ABIL-DELISTED	Stock	2.8	2.8	2.78	2.8	6496.0
2017-02-24	ABM	Stock	40.94	41.16	40.72	41.09	178300.0
2017-02-24	ABMD-DELISTED	Stock	116.0	117.5	114.2836	117.14	166481.0
2017-02-24	ABR	Stock	7.48	7.5	7.36	7.36	75200.0
2017-02-24	ABR.A-DELISTED	Stock	25.207	25.2375	25.07	25.2375	1719.0

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

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