PREVIEW / stock_daily / 2022-10-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-20.parquet
  size:    249 KB
  rows:    7,813
  symbols: 2,124

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-10-20	AAPL	Stock	143.02	145.89	142.65	143.39	64522000.0
2022-10-20	MSFT	Stock	235.77	241.31	234.87	236.15	21811000.0
2022-10-20	NVDA	Stock	12.113	12.769	12.105	12.194	652398000.0
2022-10-20	AMZN	Stock	113.83	118.24	113.51	115.25	48795100.0
2022-10-20	GOOGL	Stock	100.0	102.32	99.39	99.97	25323202.0
2022-10-20	META	Stock	132.93	136.77	131.31	131.53	26356300.0
2022-10-20	TSLA	Stock	208.28	215.55	202.0	207.28	117798100.0
2022-10-20	TLT	Stock	95.93	96.33	94.74	94.88	25434934.0
2022-10-20	ES	Stock	74.21	74.3	71.26	71.68	1661400.0
2022-10-20	CL	Stock	71.26	71.78	70.19	70.25	3436100.0
2022-10-20	A	Stock	127.83	129.74	125.61	125.94	1897200.0
2022-10-20	AA	Stock	35.82	41.67	35.4	38.91	36329500.0
2022-10-20	AAC-DELISTED	Stock	9.94	9.9575	9.94	9.945	1677.0
2022-10-20	AACG	Stock	1.91	1.92	1.86	1.9	14500.0
2022-10-20	AAIC-DELISTED	Stock	2.8	2.9	2.78	2.85	62911.0
2022-10-20	AAIC.C-DELISTED	Stock	19.56	19.68	19.56	19.6301	3138.0
2022-10-20	AAL	Stock	13.95	14.27	13.43	13.46	58239700.0
2022-10-20	AAM.A-DELISTED	Stock	22.47	22.5	21.75	21.77	23957.0
2022-10-20	AAM.B-DELISTED	Stock	22.72	22.947	22.34	22.35	8699.0
2022-10-20	AAME	Stock	2.7	2.76	2.7	2.76	1200.0
2022-10-20	AAMI	Stock	17.47	17.78	17.31	17.39	146900.0
2022-10-20	AAN-DELISTED	Stock	8.45	8.72	8.4	8.54	233900.0
2022-10-20	AAOI	Stock	2.8	2.91	2.66	2.83	152200.0
2022-10-20	AAON	Stock	37.4	37.4067	36.1467	36.1933	262050.0
2022-10-20	AAP	Stock	172.39	173.86	169.4	170.28	551700.0
2022-10-20	AAQC-DELISTED	Stock	9.885	9.885	9.875	9.88	20693.0
2022-10-20	AAT	Stock	25.54	26.05	25.39	25.83	256300.0
2022-10-20	AATC	Stock	4.3	4.3899	4.27	4.35	3762.0
2022-10-20	AAU-DELISTED	Stock	0.23	0.2376	0.22	0.235	574026.0
2022-10-20	AAUAF-DELISTED	Stock	0.23	0.2376	0.22	0.235	576071.0
2022-10-20	AAWW-DELISTED	Stock	100.37	100.78	100.36	100.585	357059.0
2022-10-20	AAXJ	Stock	57.28	58.07	57.0648	57.15	581460.0
2022-10-20	AB	Stock	34.19	34.19	33.59	33.7	260900.0
2022-10-20	ABB-DELISTED	Stock	26.51	26.91	26.38	26.42	1294322.0
2022-10-20	ABBNY-DELISTED	Stock	26.51	26.91	26.38	26.42	1406811.0
2022-10-20	ABBV	Stock	143.16	144.04	142.43	142.93	3880100.0
2022-10-20	ABC-DELISTED	Stock	143.33	143.33	141.58	142.71	526213.0
2022-10-20	ABCB	Stock	49.64	50.17	47.86	48.27	429600.0
2022-10-20	ABCL	Stock	10.15	10.41	10.01	10.1	1395000.0
2022-10-20	ABCM-DELISTED	Stock	13.99	14.25	13.84	13.91	386983.0
2022-10-20	ABEO	Stock	3.43	3.99	3.33	3.94	710000.0
2022-10-20	ABEV	Stock	2.8	2.88	2.8	2.83	40145200.0
2022-10-20	ABG	Stock	147.24	148.7	139.6	141.06	251300.0
2022-10-20	ABGI-DELISTED	Stock	9.95	9.95	9.95	9.95	1902.0
2022-10-20	ABM	Stock	41.32	42.19	40.52	40.96	269400.0
2022-10-20	ABMD-DELISTED	Stock	253.79	255.84	250.11	252.5	130124.0
2022-10-20	ABNB	Stock	116.35	120.56	116.0	117.0	3962200.0
2022-10-20	ABOS	Stock	7.32	7.68	7.32	7.44	76900.0
2022-10-20	ABR	Stock	12.45	12.54	12.17	12.21	1967300.0
2022-10-20	ABR.D	Stock	17.075	17.075	16.51	16.51	14134.0

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

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