PREVIEW / stock_daily / 2019-01-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-18.parquet
  size:    220 KB
  rows:    6,552
  symbols: 2,660

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
2019-01-18	AAPL	Stock	39.375	39.47	38.995	39.205	135004000.0
2019-01-18	MSFT	Stock	107.46	107.9	105.91	107.71	37427600.0
2019-01-18	NVDA	Stock	3.8432	3.9495	3.7912	3.9232	651336000.0
2019-01-18	AMZN	Stock	85.6	85.81	84.577	84.81	120410000.0
2019-01-18	GOOGL	Stock	55.4295	55.9	54.9642	55.365	44891380.0
2019-01-18	META	Stock	149.75	152.43	148.55	150.04	31029600.0
2019-01-18	TSLA	Stock	21.5333	21.8087	19.982	20.1507	362262000.0
2019-01-18	TLT	Stock	119.84	120.12	119.385	119.56	14106447.0
2019-01-18	ES	Stock	67.36	67.82	67.21	67.67	1556900.0
2019-01-18	CL	Stock	62.43	63.7	62.33	62.63	5200400.0
2019-01-18	A	Stock	71.29	72.31	70.85	71.93	1551700.0
2019-01-18	AA	Stock	29.92	30.1	29.1	29.27	6601200.0
2019-01-18	AABA-DELISTED	Stock	65.06	65.45	63.89	64.64	5375541.0
2019-01-18	AAC-DELISTED	Stock	2.67	2.78	2.63	2.77	106052.0
2019-01-18	AACG	Stock	0.99	1.0	0.96	0.98	5800.0
2019-01-18	AAIC-DELISTED	Stock	8.1	8.25	8.02	8.15	296829.0
2019-01-18	AAL	Stock	33.84	34.04	33.15	33.97	5817700.0
2019-01-18	AAM.A-DELISTED	Stock	24.45	24.56	24.4	24.56	43082.0
2019-01-18	AAM.B-DELISTED	Stock	24.29	24.5	24.29	24.5	34862.0
2019-01-18	AAMC-DELISTED	Stock	7.4676	7.9412	7.4676	7.9235	3060.0
2019-01-18	AAME	Stock	2.46	2.82	2.46	2.73	3100.0
2019-01-18	AAMI	Stock	11.66	11.9	11.66	11.89	642700.0
2019-01-18	AAOI	Stock	16.22	17.05	15.93	16.59	839400.0
2019-01-18	AAON	Stock	24.64	25.32	24.6333	25.1067	150600.0
2019-01-18	AAP	Stock	167.23	168.78	163.66	167.61	1777300.0
2019-01-18	AAT	Stock	41.07	41.19	40.63	40.73	129300.0
2019-01-18	AAU-DELISTED	Stock	0.75	0.76	0.73	0.7507	285916.0
2019-01-18	AAUAF-DELISTED	Stock	0.75	0.76	0.73	0.7507	308420.0
2019-01-18	AAWW-DELISTED	Stock	49.42	50.91	49.27	50.51	235393.0
2019-01-18	AAXJ	Stock	66.73	67.08	66.63	66.9	915889.0
2019-01-18	AAXN-DELISTED	Stock	50.42	50.87	50.02	50.15	327711.0
2019-01-18	AB	Stock	29.84	30.2	29.7	30.09	392000.0
2019-01-18	ABB-DELISTED	Stock	19.26	19.53	19.24	19.46	3865508.0
2019-01-18	ABBNY-DELISTED	Stock	19.26	19.53	19.24	19.45	4507477.0
2019-01-18	ABBV	Stock	88.45	89.79	86.92	89.5	6190000.0
2019-01-18	ABC-DELISTED	Stock	76.82	79.95	76.5002	79.86	1915068.0
2019-01-18	ABCB	Stock	35.95	36.72	35.47	36.24	376600.0
2019-01-18	ABDC-DELISTED	Stock	6.8249	6.8249	6.68	6.68	7590.0
2019-01-18	ABEO	Stock	178.25	183.0	175.75	181.5	8228.0
2019-01-18	ABEV	Stock	4.75	4.76	4.68	4.75	17804600.0
2019-01-18	ABG	Stock	71.78	72.84	71.51	72.63	436900.0
2019-01-18	ABIL-DELISTED	Stock	2.2	2.2277	2.08	2.14	610480.0
2019-01-18	ABM	Stock	35.16	36.24	35.12	35.98	558400.0
2019-01-18	ABMD-DELISTED	Stock	335.2	337.16	326.495	333.74	318707.0
2019-01-18	ABR	Stock	11.41	11.47	11.28	11.33	636400.0
2019-01-18	ABR.A-DELISTED	Stock	25.511	25.69	25.5101	25.6	2539.0
2019-01-18	ABR.B-DELISTED	Stock	25.29	25.38	25.255	25.36	3638.0
2019-01-18	ABR.C-DELISTED	Stock	25.7571	25.7571	25.7571	25.7571	1000.0
2019-01-18	ABT	Stock	70.99	71.74	70.78	71.42	9404500.0
2019-01-18	ABTC	Stock	301770.0	301800.0	301710.0	301710.0	0.06666666666666667

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

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