PREVIEW / stock_daily / 2020-01-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-17.parquet
  size:    222 KB
  rows:    6,614
  symbols: 2,420

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
2020-01-17	AAPL	Stock	79.0675	79.685	78.75	79.6825	137816400.0
2020-01-17	MSFT	Stock	167.42	167.47	165.43	167.1	34371700.0
2020-01-17	NVDA	Stock	6.2425	6.25	6.1843	6.232	253792000.0
2020-01-17	AMZN	Stock	94.2945	94.332	92.8625	93.236	79946000.0
2020-01-17	GOOGL	Stock	73.127	74.0275	72.8275	73.976	52423500.0
2020-01-17	META	Stock	222.03	222.29	220.53	222.14	15905900.0
2020-01-17	TSLA	Stock	33.8407	34.378	33.544	34.0333	204436500.0
2020-01-17	TLT	Stock	137.58	138.14	137.36	138.02	9693280.0
2020-01-17	ES	Stock	87.9	88.82	87.4	88.73	2209600.0
2020-01-17	CL	Stock	70.43	71.3	70.43	71.18	4019700.0
2020-01-17	A	Stock	89.97	90.28	89.21	90.12	3718300.0
2020-01-17	AA	Stock	18.06	18.25	17.51	17.69	9067000.0
2020-01-17	AACG	Stock	1.67	1.67	1.4	1.4	52000.0
2020-01-17	AAIC-DELISTED	Stock	5.74	5.7539	5.7	5.72	337105.0
2020-01-17	AAIC.C-DELISTED	Stock	22.04	22.3487	22.02	22.08	22660.0
2020-01-17	AAL	Stock	28.3	28.72	28.06	28.4	7379400.0
2020-01-17	AAM.A-DELISTED	Stock	26.9	26.92	26.817	26.92	11733.0
2020-01-17	AAM.B-DELISTED	Stock	27.26	27.34	27.1713	27.2	19118.0
2020-01-17	AAMC-DELISTED	Stock	3.9559	3.9588	3.7706	3.8216	18625.0
2020-01-17	AAMI	Stock	10.3	10.36	10.14	10.17	197200.0
2020-01-17	AAOI	Stock	14.58	14.89	13.61	14.12	988400.0
2020-01-17	AAON	Stock	35.4067	35.7267	35.12	35.2533	197250.0
2020-01-17	AAP	Stock	151.78	152.08	150.36	151.05	817400.0
2020-01-17	AAT	Stock	46.58	47.03	46.29	46.83	305600.0
2020-01-17	AAU-DELISTED	Stock	0.525	0.5833	0.5091	0.5743	344331.0
2020-01-17	AAUAF-DELISTED	Stock	0.525	0.5833	0.5091	0.5792	360619.0
2020-01-17	AAWW-DELISTED	Stock	27.98	28.0812	27.18	27.85	158320.0
2020-01-17	AAXJ	Stock	76.15	76.23	75.94	76.23	1091550.0
2020-01-17	AAXN-DELISTED	Stock	75.53	75.85	73.55	73.6	251348.0
2020-01-17	AB	Stock	33.2	33.37	32.85	33.11	248800.0
2020-01-17	ABB-DELISTED	Stock	24.02	24.05	23.88	23.92	1611095.0
2020-01-17	ABBNY-DELISTED	Stock	24.02	24.05	23.88	23.91	1711902.0
2020-01-17	ABBV	Stock	89.13	89.27	87.79	88.0	10122300.0
2020-01-17	ABC-DELISTED	Stock	91.0	91.58	90.41	91.05	1267016.0
2020-01-17	ABCB	Stock	43.41	43.79	42.92	43.53	319000.0
2020-01-17	ABDC-DELISTED	Stock	9.29	9.3	9.2085	9.26	8440.0
2020-01-17	ABEO	Stock	64.25	65.0	63.0	63.5	54516.0
2020-01-17	ABEV	Stock	4.47	4.49	4.42	4.43	30769000.0
2020-01-17	ABG	Stock	103.02	103.5	102.07	102.26	136800.0
2020-01-17	ABM	Stock	40.53	40.55	39.43	39.79	334900.0
2020-01-17	ABMD-DELISTED	Stock	180.77	184.945	179.39	181.28	805655.0
2020-01-17	ABR	Stock	14.55	14.73	14.51	14.7	828400.0
2020-01-17	ABR.A-DELISTED	Stock	26.455	26.4923	26.455	26.467	867.0
2020-01-17	ABR.B-DELISTED	Stock	26.165	26.165	26.165	26.165	100.0
2020-01-17	ABT	Stock	88.45	89.2	88.31	89.0	5879700.0
2020-01-17	ABTC	Stock	259800.0	273000.0	255600.0	265200.0	5.053333333333333
2020-01-17	ABTS	Stock	30.6	30.795	30.45	30.45	213.0
2020-01-17	ABTX-DELISTED	Stock	37.76	37.76	37.25	37.38	59651.0
2020-01-17	ABUS	Stock	3.07	3.1	3.01	3.07	217300.0
2020-01-17	ACA	Stock	47.29	47.47	46.24	46.52	258686.0

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

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