PREVIEW / stock_daily / 2021-03-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-23.parquet
  size:    253 KB
  rows:    7,653
  symbols: 2,883

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-23	AAPL	Stock	123.33	124.24	122.14	122.54	95467100.0
2021-03-23	MSFT	Stock	237.49	241.05	237.07	237.58	31638400.0
2021-03-23	NVDA	Stock	13.2542	13.3445	13.0213	13.0708	222048000.0
2021-03-23	AMZN	Stock	156.35	159.1	156.0425	156.875	76346000.0
2021-03-23	GOOGL	Stock	101.9975	103.2055	101.4	102.0665	28509120.0
2021-03-23	META	Stock	293.15	298.0	289.81	290.63	23000900.0
2021-03-23	TSLA	Stock	225.2567	225.9333	219.17	220.72	91475700.0
2021-03-23	TLT	Stock	136.585	137.54	136.15	137.49	16768448.0
2021-03-23	ES	Stock	82.52	84.64	81.91	84.47	1653300.0
2021-03-23	CL	Stock	76.2	78.32	75.82	77.75	6060800.0
2021-03-23	A	Stock	123.15	124.23	121.47	121.98	1338300.0
2021-03-23	AA	Stock	28.39	29.25	27.11	27.42	8474600.0
2021-03-23	AACG	Stock	4.9	4.95	4.2	4.39	816000.0
2021-03-23	AACQ-DELISTED	Stock	10.35	10.358	10.11	10.12	1638431.0
2021-03-23	AACQU-DELISTED	Stock	10.8704	10.9	10.71	10.73	4003.0
2021-03-23	AACQW-DELISTED	Stock	2.14	2.165	1.87	1.91	314953.0
2021-03-23	AAIC-DELISTED	Stock	3.97	4.0305	3.91	3.93	184601.0
2021-03-23	AAIC.C-DELISTED	Stock	22.45	22.55	22.345	22.5062	16512.0
2021-03-23	AAL	Stock	23.35	23.66	22.08	22.27	55290700.0
2021-03-23	AAM.A-DELISTED	Stock	25.9	25.98	25.9	25.95	13883.0
2021-03-23	AAM.B-DELISTED	Stock	26.77	26.77	26.6913	26.7599	9049.0
2021-03-23	AAMC-DELISTED	Stock	5.2	5.2941	4.9588	5.2706	99338.0
2021-03-23	AAME	Stock	5.14	6.59	4.5	5.14	2657000.0
2021-03-23	AAMI	Stock	19.54	19.595	18.83	18.87	394100.0
2021-03-23	AAN-DELISTED	Stock	25.01	25.34	23.93	24.02	174200.0
2021-03-23	AAOI	Stock	8.35	8.45	8.05	8.09	642400.0
2021-03-23	AAON	Stock	46.98	47.2933	46.4267	46.7	277200.0
2021-03-23	AAP	Stock	182.87	185.13	179.03	179.53	802400.0
2021-03-23	AAT	Stock	33.21	33.35	32.43	32.53	326100.0
2021-03-23	AAU-DELISTED	Stock	0.5949	0.6028	0.5502	0.5627	3670098.0
2021-03-23	AAUAF-DELISTED	Stock	0.5949	0.6028	0.5502	0.5628	3741832.0
2021-03-23	AAWW-DELISTED	Stock	59.12	59.44	56.9	57.26	457876.0
2021-03-23	AAXJ	Stock	93.06	93.24	92.33	92.47	726757.0
2021-03-23	AB	Stock	41.68	41.77	40.41	40.86	521000.0
2021-03-23	ABB-DELISTED	Stock	31.52	31.66	31.03	31.03	2171372.0
2021-03-23	ABBNY-DELISTED	Stock	31.52	31.66	31.03	31.03	2546713.0
2021-03-23	ABBV	Stock	105.37	105.94	104.51	104.84	6111600.0
2021-03-23	ABC-DELISTED	Stock	116.0	116.34	113.18	113.82	620620.0
2021-03-23	ABCB	Stock	53.53	54.31	51.57	51.99	609900.0
2021-03-23	ABCL	Stock	30.65	30.77	28.5	29.23	565400.0
2021-03-23	ABCM-DELISTED	Stock	20.56	20.61	19.97	20.46	138756.0
2021-03-23	ABEO	Stock	50.75	51.5	47.0	47.5	73800.0
2021-03-23	ABEV	Stock	2.84	2.86	2.76	2.77	19780100.0
2021-03-23	ABG	Stock	182.65	185.43	180.0	180.36	134300.0
2021-03-23	ABGI-DELISTED	Stock	10.0	10.0	9.85	9.85	71128.0
2021-03-23	ABM	Stock	49.16	50.17	49.06	49.23	701800.0
2021-03-23	ABMD-DELISTED	Stock	305.17	308.89	297.1	298.4	195462.0
2021-03-23	ABNB	Stock	195.5	196.75	185.74	187.14	3460600.0
2021-03-23	ABR	Stock	16.3	16.45	15.86	15.94	898600.0
2021-03-23	ABR.A-DELISTED	Stock	25.955	25.955	25.9	25.9	1709.0

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

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