PREVIEW / stock_daily / 2017-12-15

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-15.parquet
  size:    219 KB
  rows:    6,514
  symbols: 2,913

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-12-15	AAPL	Stock	43.4075	43.5425	43.115	43.4925	160677200.0
2017-12-15	MSFT	Stock	85.26	87.09	84.88	86.85	53936700.0
2017-12-15	NVDA	Stock	4.7062	4.8095	4.6405	4.789	670036000.0
2017-12-15	AMZN	Stock	58.9515	59.1375	58.4665	58.957	95572000.0
2017-12-15	GOOGL	Stock	53.189	53.7625	53.0045	53.6	63759700.0
2017-12-15	META	Stock	179.02	180.49	178.36	180.18	28463100.0
2017-12-15	TSLA	Stock	22.8027	22.9267	22.384	22.8967	103998000.0
2017-12-15	TLT	Stock	127.81	128.585	127.56	128.35	7239398.0
2017-12-15	ES	Stock	64.55	64.91	64.35	64.62	2786500.0
2017-12-15	CL	Stock	73.85	74.66	73.82	74.05	4444600.0
2017-12-15	A	Stock	67.0	67.86	66.69	67.61	2871900.0
2017-12-15	AA	Stock	42.8	43.14	42.28	42.61	4536800.0
2017-12-15	AAAP-DELISTED	Stock	81.63	81.74	81.52	81.6501	415147.0
2017-12-15	AABA-DELISTED	Stock	69.35	70.54	68.66	70.32	17699239.0
2017-12-15	AAC-DELISTED	Stock	8.48	8.85	8.37	8.4	245440.0
2017-12-15	AACG	Stock	5.41	5.65	5.1	5.39	47700.0
2017-12-15	AAIC-DELISTED	Stock	12.41	12.65	12.34	12.53	1036689.0
2017-12-15	AAL	Stock	50.67	51.5	50.4	51.06	9074200.0
2017-12-15	AAM.A-DELISTED	Stock	26.18	26.31	26.11	26.18	24479.0
2017-12-15	AAMC-DELISTED	Stock	23.799	23.799	22.2794	22.2794	1642.0
2017-12-15	AAME	Stock	3.39	3.6	3.21	3.55	10700.0
2017-12-15	AAMI	Stock	16.3	16.92	16.3	16.73	996700.0
2017-12-15	AAOI	Stock	39.35	39.549	38.76	38.99	1535000.0
2017-12-15	AAON	Stock	23.1	23.5333	23.1	23.4667	1076700.0
2017-12-15	AAP	Stock	100.84	101.72	100.17	100.7	1617000.0
2017-12-15	AAT	Stock	38.79	39.4	38.79	39.26	712500.0
2017-12-15	AAU-DELISTED	Stock	0.92	0.957	0.92	0.9388	97545.0
2017-12-15	AAUAF-DELISTED	Stock	0.92	0.957	0.92	0.9388	109025.0
2017-12-15	AAV-DELISTED	Stock	4.05	4.05	3.75	3.8	217539.0
2017-12-15	AAWW-DELISTED	Stock	57.05	58.7	57.05	57.5	346944.0
2017-12-15	AAXJ	Stock	75.44	75.59	75.21	75.47	2177634.0
2017-12-15	AAXN-DELISTED	Stock	25.85	26.4	25.53	26.35	1196914.0
2017-12-15	AB	Stock	24.8	25.2	24.75	25.0	459700.0
2017-12-15	ABAC-DELISTED	Stock	3.1	3.1	2.98	3.0999	7860.0
2017-12-15	ABAX-DELISTED	Stock	47.76	48.45	47.535	48.04	272477.0
2017-12-15	ABB-DELISTED	Stock	26.14	26.14	25.97	26.0	2282457.0
2017-12-15	ABBNY-DELISTED	Stock	26.14	26.14	25.97	26.0	2438490.0
2017-12-15	ABBV	Stock	96.86	97.88	96.64	97.45	11564700.0
2017-12-15	ABC-DELISTED	Stock	90.97	94.06	89.31	93.1629	3733304.0
2017-12-15	ABCB	Stock	46.5	48.35	46.48	48.3	1050400.0
2017-12-15	ABCD-DELISTED	Stock	5.3	5.73	5.3	5.64	77691.0
2017-12-15	ABDC-DELISTED	Stock	8.3	8.52	8.29	8.34	181315.0
2017-12-15	ABE-DELISTED	Stock	14.25	14.25	14.1598	14.17	8112.0
2017-12-15	ABEO	Stock	405.0	440.75	397.5	412.5	184432.0
2017-12-15	ABEOW-DELISTED	Stock	10.8	12.24	10.8	12.24	1909.0
2017-12-15	ABEV	Stock	6.26	6.29	6.22	6.23	11805200.0
2017-12-15	ABG	Stock	63.9	65.5	63.9	65.05	335100.0
2017-12-15	ABIL-DELISTED	Stock	0.4	0.4676	0.4	0.417	97997.0
2017-12-15	ABLX-DELISTED	Stock	24.04	24.44	23.99	24.35	39621.0
2017-12-15	ABM	Stock	37.92	38.27	36.7	37.36	2559400.0

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

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