PREVIEW / stock_daily / 2022-11-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-04.parquet
  size:    250 KB
  rows:    7,779
  symbols: 2,091

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-11-04	AAPL	Stock	142.09	142.67	134.38	138.38	140814800.0
2022-11-04	MSFT	Stock	217.55	221.59	213.43	221.39	36789100.0
2022-11-04	NVDA	Stock	13.986	14.229	13.697	14.156	612576000.0
2022-11-04	AMZN	Stock	91.49	92.44	88.04	90.98	129101300.0
2022-11-04	GOOGL	Stock	85.4	86.64	83.71	86.58	51124904.0
2022-11-04	META	Stock	90.35	91.39	88.09	90.79	55638100.0
2022-11-04	TSLA	Stock	222.6	223.8	203.08	207.47	98622200.0
2022-11-04	TLT	Stock	95.1	95.655	94.22	94.22	23561369.0
2022-11-04	ES	Stock	76.27	77.28	75.58	77.18	1268200.0
2022-11-04	CL	Stock	73.0	73.68	72.31	73.19	3947400.0
2022-11-04	A	Stock	135.65	137.01	133.11	136.08	1272100.0
2022-11-04	AA	Stock	41.54	43.52	40.8	42.4	11099400.0
2022-11-04	AAC-DELISTED	Stock	9.97	9.985	9.97	9.98	97531.0
2022-11-04	AACG	Stock	1.79	1.84	1.79	1.8	5100.0
2022-11-04	AACIW-DELISTED	Stock	0.07	0.079	0.0501	0.0501	6701.0
2022-11-04	AAIC-DELISTED	Stock	2.98	3.0655	2.98	3.01	69962.0
2022-11-04	AAIC.C-DELISTED	Stock	21.0	21.0	20.8	21.0	1025.0
2022-11-04	AAL	Stock	14.06	14.4	13.86	14.11	28238500.0
2022-11-04	AAM.A-DELISTED	Stock	21.46	21.62	21.2	21.325	10787.0
2022-11-04	AAM.B-DELISTED	Stock	21.46	21.718	21.11	21.45	2971.0
2022-11-04	AAMC-DELISTED	Stock	5.4941	5.4941	5.4882	5.4941	2445.0
2022-11-04	AAME	Stock	3.02	3.03	3.01	3.03	900.0
2022-11-04	AAMI	Stock	19.11	19.78	18.67	19.3	293800.0
2022-11-04	AAN-DELISTED	Stock	10.0	10.16	9.5	9.71	334900.0
2022-11-04	AAOI	Stock	2.27	2.42	2.07	2.08	458300.0
2022-11-04	AAON	Stock	43.06	43.9333	42.8867	43.8733	159450.0
2022-11-04	AAP	Stock	185.99	185.99	178.1	181.07	849600.0
2022-11-04	AAQC-DELISTED	Stock	9.95	9.95	9.9454	9.95	9256.0
2022-11-04	AAT	Stock	28.52	28.68	27.87	28.25	502300.0
2022-11-04	AATC	Stock	4.27	4.4399	4.1856	4.2972	2562.0
2022-11-04	AAU-DELISTED	Stock	0.2278	0.2351	0.223	0.235	358120.0
2022-11-04	AAUAF-DELISTED	Stock	0.2278	0.2351	0.223	0.235	361693.0
2022-11-04	AAWW-DELISTED	Stock	100.35	100.9	100.13	100.445	1151345.0
2022-11-04	AAXJ	Stock	58.97	59.36	58.31	59.26	1678303.0
2022-11-04	AB	Stock	35.81	36.66	35.41	36.6	238900.0
2022-11-04	ABB-DELISTED	Stock	28.17	28.67	28.125	28.66	1374779.0
2022-11-04	ABBNY-DELISTED	Stock	28.17	28.67	28.125	28.65	1589548.0
2022-11-04	ABBV	Stock	145.35	145.58	143.08	145.28	4623700.0
2022-11-04	ABC-DELISTED	Stock	159.97	167.29	159.3	161.74	1701319.0
2022-11-04	ABCB	Stock	50.76	51.75	50.67	51.75	342700.0
2022-11-04	ABCL	Stock	12.2	12.36	11.7	11.91	1857200.0
2022-11-04	ABCM-DELISTED	Stock	14.38	14.65	14.16	14.64	256787.0
2022-11-04	ABEO	Stock	3.88	4.03	3.71	3.83	886300.0
2022-11-04	ABEV	Stock	3.15	3.24	3.14	3.24	47683400.0
2022-11-04	ABG	Stock	158.08	158.41	150.73	153.88	145600.0
2022-11-04	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	100.0
2022-11-04	ABLV	Stock	10.05	10.05	10.05	10.05	2400.0
2022-11-04	ABM	Stock	43.85	44.13	42.81	43.05	215100.0
2022-11-04	ABMD-DELISTED	Stock	373.98	374.28	373.25	374.0	1637606.0
2022-11-04	ABNB	Stock	94.995	96.16	92.01	96.09	9717400.0

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

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