PREVIEW / stock_daily / 2022-10-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-19.parquet
  size:    250 KB
  rows:    7,849
  symbols: 2,146

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-19	AAPL	Stock	141.69	144.95	141.5	143.86	61758300.0
2022-10-19	MSFT	Stock	237.04	239.61	234.29	236.48	19985700.0
2022-10-19	NVDA	Stock	11.879	12.35	11.834	12.051	523131000.0
2022-10-19	AMZN	Stock	114.71	116.59	113.22	115.07	47198100.0
2022-10-19	GOOGL	Stock	100.01	101.0183	98.9201	99.63	23811064.0
2022-10-19	META	Stock	132.89	137.0	132.22	133.23	30691000.0
2022-10-19	TSLA	Stock	219.8	222.93	217.78	222.04	66571500.0
2022-10-19	TLT	Stock	97.19	97.42	96.32	96.53	25431577.0
2022-10-19	ES	Stock	74.83	75.25	73.79	74.5	1626500.0
2022-10-19	CL	Stock	72.87	73.3	71.57	71.75	5301800.0
2022-10-19	A	Stock	130.11	130.27	127.24	128.96	1034000.0
2022-10-19	AA	Stock	39.02	39.31	37.15	37.62	8372800.0
2022-10-19	AAC-DELISTED	Stock	9.94	9.955	9.94	9.95	8545.0
2022-10-19	AACG	Stock	1.9	1.96	1.88	1.88	1500.0
2022-10-19	AAIC-DELISTED	Stock	2.8	2.9282	2.7813	2.85	18532.0
2022-10-19	AAIC.C-DELISTED	Stock	19.59	20.1493	19.5	20.1493	1912.0
2022-10-19	AAL	Stock	13.98	14.28	13.72	13.99	55466400.0
2022-10-19	AAM.A-DELISTED	Stock	22.64	22.85	22.31	22.52	24473.0
2022-10-19	AAM.B-DELISTED	Stock	22.77	23.03	22.6	22.92	8076.0
2022-10-19	AAME	Stock	2.85	2.85	2.7	2.7	3400.0
2022-10-19	AAMI	Stock	17.46	17.755	17.18	17.46	135400.0
2022-10-19	AAN-DELISTED	Stock	8.83	8.88	8.35	8.53	414200.0
2022-10-19	AAOI	Stock	2.93	2.95	2.77	2.8	200700.0
2022-10-19	AAON	Stock	37.2933	37.6133	36.6667	37.56	271050.0
2022-10-19	AAP	Stock	171.81	174.18	170.18	171.25	908700.0
2022-10-19	AAQC-DELISTED	Stock	9.87	9.88	9.87	9.88	7700.0
2022-10-19	AAT	Stock	26.12	26.31	25.57	25.62	209300.0
2022-10-19	AATC	Stock	4.23	4.35	4.23	4.29	7490.0
2022-10-19	AAU-DELISTED	Stock	0.2304	0.2341	0.211	0.225	420991.0
2022-10-19	AAUAF-DELISTED	Stock	0.2304	0.2341	0.211	0.225	423994.0
2022-10-19	AAWW-DELISTED	Stock	100.5	100.65	100.31	100.49	441964.0
2022-10-19	AAXJ	Stock	57.09	57.415	56.69	56.83	493522.0
2022-10-19	AB	Stock	34.03	34.68	33.6	34.1	377500.0
2022-10-19	ABB-DELISTED	Stock	26.7	26.79	26.35	26.67	1408216.0
2022-10-19	ABBNY-DELISTED	Stock	26.7	26.79	26.35	26.66	1555918.0
2022-10-19	ABBV	Stock	144.8	145.45	142.31	143.13	3333300.0
2022-10-19	ABC-DELISTED	Stock	143.9	144.84	141.82	142.95	371204.0
2022-10-19	ABCB	Stock	50.01	50.63	49.06	49.71	412300.0
2022-10-19	ABCL	Stock	10.45	10.514	9.97	10.19	1521400.0
2022-10-19	ABCM-DELISTED	Stock	15.23	15.24	14.55	14.61	239208.0
2022-10-19	ABEO	Stock	3.75	3.77	3.37	3.41	350300.0
2022-10-19	ABEV	Stock	2.79	2.83	2.76	2.76	37919200.0
2022-10-19	ABG	Stock	156.0	159.1	145.22	147.48	210000.0
2022-10-19	ABGI-DELISTED	Stock	9.98	9.98	9.94	9.94	8255.0
2022-10-19	ABM	Stock	41.2	41.78	40.82	41.5	195200.0
2022-10-19	ABMD-DELISTED	Stock	255.61	258.14	251.23	253.43	92287.0
2022-10-19	ABNB	Stock	116.235	118.84	115.3	116.87	3408900.0
2022-10-19	ABOS	Stock	7.99	8.2	7.33	7.45	145300.0
2022-10-19	ABR	Stock	12.39	12.6	12.27	12.4	1924000.0
2022-10-19	ABR.D	Stock	17.3	17.3	17.0	17.0	20271.0

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

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