PREVIEW / stock_daily / 2020-03-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-26.parquet
  size:    216 KB
  rows:    6,646
  symbols: 2,396

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-26	AAPL	Stock	61.63	64.67	61.59	64.61	252087200.0
2020-03-26	MSFT	Stock	148.4	156.66	148.37	156.11	64568100.0
2020-03-26	NVDA	Stock	6.3485	6.5555	6.25	6.431	696108000.0
2020-03-26	AMZN	Stock	95.1	97.8245	94.4645	97.7745	124426000.0
2020-03-26	GOOGL	Stock	55.736	58.574	54.6015	58.146	76688440.0
2020-03-26	META	Stock	158.25	164.0	157.02	163.34	26556800.0
2020-03-26	TSLA	Stock	36.4927	37.3333	34.15	35.2107	260710500.0
2020-03-26	TLT	Stock	163.995	165.68	162.27	163.34	10576587.0
2020-03-26	ES	Stock	71.99	79.48	71.5	78.74	2771100.0
2020-03-26	CL	Stock	60.36	64.34	60.19	63.82	9053300.0
2020-03-26	A	Stock	70.0	74.45	69.65	73.72	3267500.0
2020-03-26	AA	Stock	7.27	7.386	6.73	6.84	11916400.0
2020-03-26	AACG	Stock	0.95	1.0	0.9	1.0	11000.0
2020-03-26	AAIC-DELISTED	Stock	2.75	3.53	2.71	3.4	1660414.0
2020-03-26	AAIC.C-DELISTED	Stock	12.81	18.2755	12.67	17.75	34915.0
2020-03-26	AAL	Stock	16.06	17.24	15.16	15.66	77530600.0
2020-03-26	AAM.A-DELISTED	Stock	22.54	24.17	22.28	23.77	47768.0
2020-03-26	AAM.B-DELISTED	Stock	21.99	24.0	21.99	23.58	55740.0
2020-03-26	AAMC-DELISTED	Stock	4.706	4.7062	3.9676	4.1118	17333.0
2020-03-26	AAME	Stock	2.29	2.29	2.08	2.28	1600.0
2020-03-26	AAMI	Stock	5.43	6.57	5.25	6.45	957400.0
2020-03-26	AAOI	Stock	7.52	7.747	6.94	6.96	936900.0
2020-03-26	AAON	Stock	28.86	32.6733	28.86	32.2733	525450.0
2020-03-26	AAP	Stock	91.42	97.65	90.58	97.12	1713800.0
2020-03-26	AAT	Stock	23.39	24.82	22.46	24.43	963000.0
2020-03-26	AAU-DELISTED	Stock	0.325	0.3348	0.27	0.2814	608940.0
2020-03-26	AAUAF-DELISTED	Stock	0.325	0.3348	0.27	0.2814	646502.0
2020-03-26	AAWW-DELISTED	Stock	22.93	26.17	22.09	24.11	513330.0
2020-03-26	AAXJ	Stock	59.62	61.59	59.48	61.35	1985737.0
2020-03-26	AAXN-DELISTED	Stock	72.64	77.86	72.305	76.52	520412.0
2020-03-26	AB	Stock	18.88	20.7	18.51	19.77	1183300.0
2020-03-26	ABB-DELISTED	Stock	18.29	19.065	18.22	18.97	3266444.0
2020-03-26	ABBNY-DELISTED	Stock	18.29	19.065	18.22	18.96	3440513.0
2020-03-26	ABBV	Stock	68.82	74.31	68.76	73.83	15979400.0
2020-03-26	ABC-DELISTED	Stock	75.87	85.179	75.595	84.06	2621746.0
2020-03-26	ABCB	Stock	21.95	23.42	21.46	22.96	656400.0
2020-03-26	ABEO	Stock	54.25	60.5	50.0	52.5	56092.0
2020-03-26	ABEV	Stock	2.4	2.69	2.4	2.64	56548700.0
2020-03-26	ABG	Stock	61.17	62.74	58.49	60.82	388800.0
2020-03-26	ABM	Stock	21.0	22.45	20.73	22.05	1031800.0
2020-03-26	ABMD-DELISTED	Stock	147.4	155.31	147.0	149.14	452602.0
2020-03-26	ABR	Stock	5.46	7.47	5.3	6.47	6282300.0
2020-03-26	ABR.A-DELISTED	Stock	17.1113	20.88	16.99	20.5	21589.0
2020-03-26	ABR.B-DELISTED	Stock	16.4	21.55	16.4	20.79	49440.0
2020-03-26	ABR.C-DELISTED	Stock	19.26	21.27	18.64	20.5	13563.0
2020-03-26	ABT	Stock	71.08	75.97	71.0	75.81	10530500.0
2020-03-26	ABTC	Stock	158700.0	192900.0	157440.0	179100.0	6.8
2020-03-26	ABTS	Stock	13.2	13.2	10.95	12.0	1973.0
2020-03-26	ABTX-DELISTED	Stock	24.28	26.24	24.05	25.54	87088.0
2020-03-26	ABUS	Stock	2.22	2.3	2.15	2.26	423200.0

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

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