PREVIEW / stock_daily / 2020-03-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-16.parquet
  size:    210 KB
  rows:    6,670
  symbols: 2,406

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-03-16	AAPL	Stock	60.4875	64.77	60.0	60.5525	322423600.0
2020-03-16	MSFT	Stock	140.0	149.35	135.0	135.42	87905900.0
2020-03-16	NVDA	Stock	5.3102	5.6525	4.85	4.91	726972000.0
2020-03-16	AMZN	Stock	82.0755	87.9725	81.3015	84.4575	178346000.0
2020-03-16	GOOGL	Stock	54.4805	57.2735	53.354	53.65	96519620.0
2020-03-16	META	Stock	152.32	159.13	143.1	146.01	39120400.0
2020-03-16	TSLA	Stock	31.3	32.9913	29.478	29.6713	307342500.0
2020-03-16	TLT	Stock	160.38	166.15	157.81	163.91	30496696.0
2020-03-16	ES	Stock	81.34	84.1	76.47	77.18	4690200.0
2020-03-16	CL	Stock	62.16	66.31	62.04	62.34	8849300.0
2020-03-16	A	Stock	63.41	66.62	61.13	64.13	4742800.0
2020-03-16	AA	Stock	6.94	7.67	6.73	6.82	7319000.0
2020-03-16	AACG	Stock	0.85	0.91	0.85	0.85	16200.0
2020-03-16	AAIC-DELISTED	Stock	3.19	3.61	3.1	3.1	1203201.0
2020-03-16	AAIC.C-DELISTED	Stock	15.9999	15.9999	13.9999	13.9999	3227.0
2020-03-16	AAL	Stock	12.41	16.2	12.0	15.92	84916800.0
2020-03-16	AAM.A-DELISTED	Stock	22.38	22.7806	21.3	21.75	78118.0
2020-03-16	AAM.B-DELISTED	Stock	21.0	22.68	21.0	21.75	49963.0
2020-03-16	AAMC-DELISTED	Stock	4.0857	4.7265	3.9721	4.1399	16708.0
2020-03-16	AAME	Stock	2.5	2.5	2.39	2.42	1400.0
2020-03-16	AAMI	Stock	5.72	5.865	5.05	5.05	1083000.0
2020-03-16	AAOI	Stock	5.53	6.16	5.36	5.64	763000.0
2020-03-16	AAON	Stock	28.0	35.2867	28.0	34.1933	838950.0
2020-03-16	AAP	Stock	102.83	107.49	93.88	95.25	1416100.0
2020-03-16	AAT	Stock	30.29	32.33	24.52	24.58	508300.0
2020-03-16	AAU-DELISTED	Stock	0.2501	0.28	0.24	0.2599	477715.0
2020-03-16	AAUAF-DELISTED	Stock	0.2501	0.28	0.24	0.255	500634.0
2020-03-16	AAWW-DELISTED	Stock	16.0	19.23	15.19	18.7	1058336.0
2020-03-16	AAXJ	Stock	55.59	58.07	53.89	55.41	1835655.0
2020-03-16	AAXN-DELISTED	Stock	54.32	58.65	52.7575	53.92	744439.0
2020-03-16	AB	Stock	20.0	23.67	19.95	19.97	827700.0
2020-03-16	ABB-DELISTED	Stock	15.35	16.25	15.35	15.49	3238628.0
2020-03-16	ABBNY-DELISTED	Stock	15.35	16.25	15.35	15.47	3485708.0
2020-03-16	ABBV	Stock	79.0	82.18	73.58	74.27	20916000.0
2020-03-16	ABC-DELISTED	Stock	76.0	87.42	76.0	80.49	2030063.0
2020-03-16	ABCB	Stock	21.7	22.81	21.45	21.83	984100.0
2020-03-16	ABEO	Stock	39.75	40.5	34.75	36.25	53512.0
2020-03-16	ABEV	Stock	2.27	2.4	2.11	2.11	26411000.0
2020-03-16	ABG	Stock	42.62	52.87	42.62	46.39	345300.0
2020-03-16	ABM	Stock	24.04	27.63	24.0	26.42	648400.0
2020-03-16	ABMD-DELISTED	Stock	132.13	148.45	132.13	142.14	936493.0
2020-03-16	ABR	Stock	7.5	8.12	7.26	7.26	3054200.0
2020-03-16	ABR.A-DELISTED	Stock	21.1	22.546	21.07	22.0	12205.0
2020-03-16	ABR.B-DELISTED	Stock	20.95	20.95	17.9	19.2	10459.0
2020-03-16	ABR.C-DELISTED	Stock	20.01	21.97	18.607	21.3	12627.0
2020-03-16	ABT	Stock	70.65	79.25	70.0	73.66	14358900.0
2020-03-16	ABTC	Stock	144300.0	144600.0	120600.0	124800.0	2.2800000000000002
2020-03-16	ABTS	Stock	15.0	18.345	15.0	15.0	640.0
2020-03-16	ABTX-DELISTED	Stock	24.5	25.305	22.76	23.23	120654.0
2020-03-16	ABUS	Stock	1.94	1.94	1.42	1.42	858600.0

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

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