PREVIEW / stock_daily / 2021-05-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-28.parquet
  size:    256 KB
  rows:    7,838
  symbols: 2,939

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
2021-05-28	AAPL	Stock	125.57	125.8	124.55	124.61	71311100.0
2021-05-28	MSFT	Stock	251.0	252.08	249.56	249.68	18270200.0
2021-05-28	NVDA	Stock	15.501	16.2775	15.501	16.2445	644536000.0
2021-05-28	AMZN	Stock	162.1	162.3995	160.985	161.1535	46596000.0
2021-05-28	GOOGL	Stock	118.721	118.8035	117.6425	117.8425	21490800.0
2021-05-28	META	Stock	331.0	332.87	328.33	328.73	12037400.0
2021-05-28	TSLA	Stock	209.5	211.8633	207.46	208.4067	68211000.0
2021-05-28	TLT	Stock	138.582	139.3	138.34	138.44	10258035.0
2021-05-28	ES	Stock	81.38	81.88	80.99	81.19	1447000.0
2021-05-28	CL	Stock	83.96	84.59	83.72	83.78	3971700.0
2021-05-28	A	Stock	138.6	139.21	138.0	138.13	1264400.0
2021-05-28	AA	Stock	38.64	39.7	38.22	39.67	4536800.0
2021-05-28	AAC-DELISTED	Stock	9.83	9.84	9.77	9.77	23474.0
2021-05-28	AACG	Stock	2.92	3.05	2.9	2.98	55000.0
2021-05-28	AACQ-DELISTED	Stock	9.95	9.975	9.95	9.96	996259.0
2021-05-28	AACQU-DELISTED	Stock	10.45	10.47	10.45	10.47	547.0
2021-05-28	AACQW-DELISTED	Stock	1.75	1.82	1.73	1.75	76888.0
2021-05-28	AAIC-DELISTED	Stock	4.04	4.1	4.02	4.07	112550.0
2021-05-28	AAIC.C-DELISTED	Stock	24.97	25.0033	24.97	25.0033	7970.0
2021-05-28	AAL	Stock	24.39	24.82	24.13	24.24	30594400.0
2021-05-28	AAM.A-DELISTED	Stock	25.73	25.89	25.69	25.89	45645.0
2021-05-28	AAM.B-DELISTED	Stock	26.75	26.91	26.7	26.91	18494.0
2021-05-28	AAMC-DELISTED	Stock	5.0059	5.2206	4.9691	5.0235	73998.0
2021-05-28	AAME	Stock	4.28	4.5	4.25	4.33	52900.0
2021-05-28	AAMI	Stock	22.6	22.6	22.26	22.27	227200.0
2021-05-28	AAN-DELISTED	Stock	36.45	36.53	35.39	35.97	131100.0
2021-05-28	AAOI	Stock	8.3	8.58	8.21	8.23	415900.0
2021-05-28	AAON	Stock	44.0333	44.5733	43.6867	44.1667	238800.0
2021-05-28	AAP	Stock	189.56	191.45	188.64	189.73	702500.0
2021-05-28	AAT	Stock	36.11	36.56	36.0	36.55	321000.0
2021-05-28	AAU-DELISTED	Stock	0.5499	0.56	0.5415	0.55	789735.0
2021-05-28	AAUAF-DELISTED	Stock	0.5499	0.56	0.5415	0.551	897923.0
2021-05-28	AAWW-DELISTED	Stock	75.89	75.89	73.8026	74.95	214009.0
2021-05-28	AAXJ	Stock	94.08	94.585	94.01	94.33	847374.0
2021-05-28	AB	Stock	44.96	45.59	44.86	45.03	205400.0
2021-05-28	ABB-DELISTED	Stock	34.07	34.25	34.04	34.145	1374644.0
2021-05-28	ABBNY-DELISTED	Stock	34.07	34.25	34.04	34.14	1554616.0
2021-05-28	ABBV	Stock	113.33	114.48	112.86	113.2	7104300.0
2021-05-28	ABC-DELISTED	Stock	115.74	116.0	114.3	114.76	719265.0
2021-05-28	ABCB	Stock	55.16	55.58	54.15	54.94	302200.0
2021-05-28	ABCL	Stock	27.3	28.36	26.65	26.83	1238700.0
2021-05-28	ABCM-DELISTED	Stock	19.98	20.3215	19.98	20.09	265499.0
2021-05-28	ABEO	Stock	41.75	43.5	40.75	41.25	42916.0
2021-05-28	ABEV	Stock	3.37	3.47	3.36	3.46	21358400.0
2021-05-28	ABG	Stock	201.04	201.04	193.92	198.29	119400.0
2021-05-28	ABGI-DELISTED	Stock	9.95	9.95	9.95	9.95	200.0
2021-05-28	ABM	Stock	50.2	50.2	49.26	49.89	200400.0
2021-05-28	ABMD-DELISTED	Stock	287.11	293.63	284.21	284.57	177414.0
2021-05-28	ABNB	Stock	144.76	145.0	140.25	140.4	12000600.0
2021-05-28	ABR	Stock	18.23	18.27	18.04	18.24	1183800.0

> showing 50 of 7,838 rows — these rows as CSV

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