PREVIEW / stock_daily / 2021-03-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-16.parquet
  size:    252 KB
  rows:    7,651
  symbols: 2,873

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-03-16	AAPL	Stock	125.7	127.22	124.72	125.57	115227900.0
2021-03-16	MSFT	Stock	236.28	240.06	235.94	237.71	28092200.0
2021-03-16	NVDA	Stock	13.3565	13.5125	13.1168	13.2912	272128000.0
2021-03-16	AMZN	Stock	155.2485	156.4455	153.793	154.593	50776000.0
2021-03-16	GOOGL	Stock	103.2995	105.684	102.9645	104.1945	31900300.0
2021-03-16	META	Stock	276.08	282.14	274.8	279.28	22437700.0
2021-03-16	TSLA	Stock	234.45	235.9733	223.6667	225.6267	96587100.0
2021-03-16	TLT	Stock	137.02	137.12	135.75	136.31	15567907.0
2021-03-16	ES	Stock	82.6	83.01	82.22	82.72	955400.0
2021-03-16	CL	Stock	75.85	76.39	75.5	75.86	4268600.0
2021-03-16	A	Stock	124.75	125.31	122.45	123.0	1345500.0
2021-03-16	AA	Stock	30.75	30.785	29.29	29.52	5035700.0
2021-03-16	AACG	Stock	4.64	4.73	4.12	4.26	236300.0
2021-03-16	AACQ-DELISTED	Stock	10.6	10.62	10.39	10.45	1587463.0
2021-03-16	AACQU-DELISTED	Stock	11.34	11.6	11.17	11.24	48282.0
2021-03-16	AACQW-DELISTED	Stock	2.52	2.52	2.16	2.27	235101.0
2021-03-16	AAIC-DELISTED	Stock	4.25	4.25	4.01	4.03	172392.0
2021-03-16	AAIC.C-DELISTED	Stock	22.255	22.51	22.25	22.5	8155.0
2021-03-16	AAL	Stock	25.11	25.25	24.31	24.47	47923600.0
2021-03-16	AAM.A-DELISTED	Stock	25.9	25.97	25.899	25.97	15804.0
2021-03-16	AAM.B-DELISTED	Stock	26.65	26.67	26.64	26.66	3472.0
2021-03-16	AAMC-DELISTED	Stock	5.5235	5.7794	5.5235	5.7441	33327.0
2021-03-16	AAME	Stock	4.38	4.38	4.13	4.27	68800.0
2021-03-16	AAMI	Stock	20.09	20.29	19.7	19.72	257700.0
2021-03-16	AAN-DELISTED	Stock	26.44	27.02	25.86	26.83	268700.0
2021-03-16	AAOI	Stock	9.02	9.22	8.77	8.9	707100.0
2021-03-16	AAON	Stock	49.4867	50.0	48.38	48.6333	275550.0
2021-03-16	AAP	Stock	182.59	182.88	177.22	179.11	987300.0
2021-03-16	AAT	Stock	35.34	35.34	34.24	34.28	281400.0
2021-03-16	AAU-DELISTED	Stock	0.63	0.6432	0.6	0.6025	18790194.0
2021-03-16	AAUAF-DELISTED	Stock	0.63	0.6432	0.6	0.6058	19000663.0
2021-03-16	AAWW-DELISTED	Stock	59.3764	60.35	58.0	58.29	250820.0
2021-03-16	AAXJ	Stock	94.75	95.1	94.4	94.87	335495.0
2021-03-16	AB	Stock	39.65	39.71	39.05	39.2	746800.0
2021-03-16	ABB-DELISTED	Stock	31.05	31.08	30.84	30.92	1072341.0
2021-03-16	ABBNY-DELISTED	Stock	31.05	31.08	30.84	30.92	1398214.0
2021-03-16	ABBV	Stock	109.95	111.08	109.9	110.84	5570200.0
2021-03-16	ABC-DELISTED	Stock	113.62	113.7324	111.8201	112.81	719020.0
2021-03-16	ABCB	Stock	55.08	56.02	54.08	55.85	428400.0
2021-03-16	ABCL	Stock	37.87	39.19	37.35	37.88	963800.0
2021-03-16	ABCM-DELISTED	Stock	21.51	21.59	21.2901	21.51	32660.0
2021-03-16	ABEO	Stock	58.0	59.5	55.75	58.0	83780.0
2021-03-16	ABEV	Stock	2.74	2.78	2.69	2.71	11825800.0
2021-03-16	ABG	Stock	188.29	191.46	187.19	190.38	145700.0
2021-03-16	ABGI-DELISTED	Stock	9.98	9.98	9.9	9.98	203666.0
2021-03-16	ABM	Stock	51.53	51.96	50.6	51.41	263700.0
2021-03-16	ABMD-DELISTED	Stock	309.8	315.34	305.96	308.7	370310.0
2021-03-16	ABNB	Stock	209.11	215.49	198.18	200.01	4605600.0
2021-03-16	ABR	Stock	16.9	16.9	16.48	16.58	833700.0
2021-03-16	ABR.A-DELISTED	Stock	25.51	25.64	25.5	25.53	1200.0

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

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