PREVIEW / stock_daily / 2022-03-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-21.parquet
  size:    260 KB
  rows:    8,042
  symbols: 2,504

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
2022-03-21	AAPL	Stock	163.51	166.35	163.01	165.38	95811400.0
2022-03-21	MSFT	Stock	298.89	300.14	294.9	299.16	28351200.0
2022-03-21	NVDA	Stock	26.507	27.152	25.967	26.734	591727000.0
2022-03-21	AMZN	Stock	161.121	163.084	159.553	161.4915	66538000.0
2022-03-21	GOOGL	Stock	136.1635	137.05	134.0922	136.1015	26831680.0
2022-03-21	META	Stock	214.5	214.71	207.63	211.49	30142300.0
2022-03-21	TSLA	Stock	304.9933	314.2833	302.3633	307.0533	81981600.0
2022-03-21	TLT	Stock	131.28	131.67	129.75	130.35	26122048.0
2022-03-21	ES	Stock	83.49	84.78	83.49	84.52	1567000.0
2022-03-21	CL	Stock	73.6	74.2	72.86	74.15	10092700.0
2022-03-21	A	Stock	137.63	139.79	137.01	138.14	1285100.0
2022-03-21	AA	Stock	85.57	92.11	85.3	90.69	9901000.0
2022-03-21	AAC-DELISTED	Stock	9.77	9.77	9.75	9.76	261972.0
2022-03-21	AACG	Stock	1.48	1.49	1.4	1.42	42400.0
2022-03-21	AACIW-DELISTED	Stock	0.298	0.3198	0.27495	0.29	3392.0
2022-03-21	AAIC-DELISTED	Stock	3.32	3.49	3.31	3.43	110941.0
2022-03-21	AAIC.C-DELISTED	Stock	24.7501	24.7501	24.3301	24.55	3870.0
2022-03-21	AAL	Stock	16.5	16.54	15.9	16.09	45852600.0
2022-03-21	AAM.A-DELISTED	Stock	25.12	25.15	25.0605	25.0605	6937.0
2022-03-21	AAM.B-DELISTED	Stock	25.39	25.45	25.21	25.21	11275.0
2022-03-21	AAMC-DELISTED	Stock	4.9676	5.5	4.1176	4.6324	247445.0
2022-03-21	AAME	Stock	2.55	2.63	2.44	2.62	6800.0
2022-03-21	AAMI	Stock	25.85	25.95	25.16	25.27	609700.0
2022-03-21	AAN-DELISTED	Stock	23.15	23.21	21.9	22.02	243300.0
2022-03-21	AAOI	Stock	3.57	3.61	3.3	3.33	308400.0
2022-03-21	AAON	Stock	38.74	38.7667	37.68	37.8667	244650.0
2022-03-21	AAP	Stock	206.4	207.26	203.27	205.75	888500.0
2022-03-21	AAQC-DELISTED	Stock	9.72	9.72	9.715	9.72	10252.0
2022-03-21	AAT	Stock	36.92	37.25	36.26	36.34	235600.0
2022-03-21	AATC	Stock	6.79	6.79	6.5612	6.63	5440.0
2022-03-21	AAU-DELISTED	Stock	0.359	0.38	0.35	0.3726	1005586.0
2022-03-21	AAUAF-DELISTED	Stock	0.359	0.38	0.35	0.38	1015940.0
2022-03-21	AAWW-DELISTED	Stock	88.17	88.87	85.58	85.85	345856.0
2022-03-21	AAXJ	Stock	75.24	75.4	74.365	74.94	1555071.0
2022-03-21	AB	Stock	46.8	47.12	46.13	46.51	313800.0
2022-03-21	ABB-DELISTED	Stock	35.23	35.355	34.82	35.06	2053676.0
2022-03-21	ABBNY-DELISTED	Stock	35.23	35.355	34.82	35.06	2237594.0
2022-03-21	ABBV	Stock	159.95	160.95	158.99	160.05	5825000.0
2022-03-21	ABC-DELISTED	Stock	152.6	155.76	152.45	153.2	758470.0
2022-03-21	ABCB	Stock	47.46	47.84	46.16	46.55	269600.0
2022-03-21	ABCL	Stock	8.82	9.0	8.64	8.82	1270000.0
2022-03-21	ABCM-DELISTED	Stock	17.87	18.07	17.725	17.89	121754.0
2022-03-21	ABEO	Stock	7.5	7.5	7.0	7.25	67152.0
2022-03-21	ABEV	Stock	2.86	2.89	2.84	2.86	17109400.0
2022-03-21	ABG	Stock	190.57	192.5	185.88	188.47	185600.0
2022-03-21	ABGI-DELISTED	Stock	9.77	9.77	9.77	9.77	1141.0
2022-03-21	ABM	Stock	44.54	45.68	44.54	45.54	485200.0
2022-03-21	ABMD-DELISTED	Stock	303.06	307.83	300.8	305.84	98954.0
2022-03-21	ABNB	Stock	164.57	165.95	159.0	161.8	4584400.0
2022-03-21	ABOS	Stock	6.4	6.43	5.825	6.0	339500.0

> showing 50 of 8,042 rows — these rows as CSV

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