PREVIEW / stock_daily / 2021-02-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-19.parquet
  size:    249 KB
  rows:    7,540
  symbols: 2,802

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-02-19	AAPL	Stock	130.24	130.71	128.8	129.87	87668800.0
2021-02-19	MSFT	Stock	243.75	243.86	240.18	240.97	25262600.0
2021-02-19	NVDA	Stock	15.0245	15.177	14.8468	14.9265	271724000.0
2021-02-19	AMZN	Stock	166.4115	166.675	162.2875	162.495	86104000.0
2021-02-19	GOOGL	Stock	105.3895	105.929	104.1715	104.4405	37938780.0
2021-02-19	META	Stock	269.86	270.27	260.15	261.56	25622600.0
2021-02-19	TSLA	Stock	265.0	265.5967	259.1233	260.4333	56874900.0
2021-02-19	TLT	Stock	144.06	144.32	142.8517	143.27	12741726.0
2021-02-19	ES	Stock	82.55	82.6	81.12	81.46	1490300.0
2021-02-19	CL	Stock	78.62	78.75	77.11	77.2	4540200.0
2021-02-19	A	Stock	128.41	128.9	126.49	126.87	1263900.0
2021-02-19	AA	Stock	21.56	23.34	21.55	23.13	7262300.0
2021-02-19	AACG	Stock	5.67	5.86	5.45	5.66	498100.0
2021-02-19	AACQ-DELISTED	Stock	12.99	13.48	12.85	13.185	5121565.0
2021-02-19	AACQU-DELISTED	Stock	14.01	15.35	14.0001	14.46	511487.0
2021-02-19	AACQW-DELISTED	Stock	3.64	3.95	3.6	3.8	1423626.0
2021-02-19	AAIC-DELISTED	Stock	3.9	4.035	3.9	3.99	192031.0
2021-02-19	AAIC.C-DELISTED	Stock	22.45	22.76	22.45	22.63	7662.0
2021-02-19	AAL	Stock	17.9	18.83	17.78	18.68	48663800.0
2021-02-19	AAM.A-DELISTED	Stock	26.18	26.19	26.1	26.19	8643.0
2021-02-19	AAM.B-DELISTED	Stock	26.58	26.7041	26.58	26.68	6835.0
2021-02-19	AAMC-DELISTED	Stock	7.4118	7.8088	6.8147	7.2353	52669.0
2021-02-19	AAME	Stock	5.17	5.19	4.53	4.64	308200.0
2021-02-19	AAMI	Stock	19.45	19.83	19.075	19.18	327600.0
2021-02-19	AAN-DELISTED	Stock	20.5	21.3	20.35	21.17	295900.0
2021-02-19	AAOI	Stock	12.0	12.5	11.9	12.3	572500.0
2021-02-19	AAON	Stock	50.4533	51.76	50.4533	51.3333	292950.0
2021-02-19	AAP	Stock	167.55	167.67	164.05	165.98	918300.0
2021-02-19	AAT	Stock	29.28	29.65	29.16	29.3	327900.0
2021-02-19	AAU-DELISTED	Stock	0.83	0.8843	0.83	0.846	2239663.0
2021-02-19	AAUAF-DELISTED	Stock	0.83	0.8843	0.83	0.846	2312272.0
2021-02-19	AAWW-DELISTED	Stock	57.69	62.26	57.0	62.23	1123121.0
2021-02-19	AAXJ	Stock	101.2	101.66	100.94	101.2	868104.0
2021-02-19	AB	Stock	37.77	37.77	36.73	37.05	487700.0
2021-02-19	ABB-DELISTED	Stock	29.9	30.34	29.87	30.135	2498814.0
2021-02-19	ABBNY-DELISTED	Stock	29.9	30.34	29.87	30.14	5099944.0
2021-02-19	ABBV	Stock	106.23	106.7	104.91	105.01	6702400.0
2021-02-19	ABC-DELISTED	Stock	105.61	106.32	105.0	105.87	602295.0
2021-02-19	ABCB	Stock	46.66	47.61	46.41	47.53	206400.0
2021-02-19	ABCL	Stock	43.56	45.44	43.56	44.07	415900.0
2021-02-19	ABCM-DELISTED	Stock	24.09	24.3265	23.78	23.79	144101.0
2021-02-19	ABEO	Stock	62.25	62.5	58.0	60.25	141160.0
2021-02-19	ABEV	Stock	2.75	2.82	2.74	2.81	32743800.0
2021-02-19	ABG	Stock	157.87	161.96	157.87	160.9	88000.0
2021-02-19	ABGI-DELISTED	Stock	10.39	10.5	10.33	10.4	130853.0
2021-02-19	ABM	Stock	42.48	43.05	41.98	42.58	203900.0
2021-02-19	ABMD-DELISTED	Stock	320.88	333.62	317.01	331.96	224888.0
2021-02-19	ABNB	Stock	203.95	205.55	200.18	201.07	2605800.0
2021-02-19	ABR	Stock	15.45	16.18	15.45	16.17	1578400.0
2021-02-19	ABR.A-DELISTED	Stock	25.67	25.7	25.639	25.7	900.0

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

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