PREVIEW / stock_daily / 2022-07-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-20.parquet
  size:    253 KB
  rows:    7,890
  symbols: 2,286

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-07-20	AAPL	Stock	151.12	153.72	150.37	153.04	64823400.0
2022-07-20	MSFT	Stock	259.9	264.87	258.91	262.27	22788300.0
2022-07-20	NVDA	Stock	16.947	17.933	16.801	17.807	760538000.0
2022-07-20	AMZN	Stock	118.62	123.48	118.32	122.77	71268300.0
2022-07-20	GOOGL	Stock	113.17	115.4	112.48	113.9	35600426.0
2022-07-20	META	Stock	177.49	183.6	176.7	183.09	24784300.0
2022-07-20	TSLA	Stock	246.7833	250.6633	243.4833	247.5	88864200.0
2022-07-20	TLT	Stock	115.48	115.55	114.05	114.61	9117311.0
2022-07-20	ES	Stock	83.41	83.81	82.34	82.48	1553100.0
2022-07-20	CL	Stock	77.13	77.18	75.19	75.61	5405900.0
2022-07-20	A	Stock	119.93	121.21	119.25	119.86	1316600.0
2022-07-20	AA	Stock	44.67	45.49	43.6	45.06	6823200.0
2022-07-20	AAC-DELISTED	Stock	9.85	9.86	9.84	9.86	188277.0
2022-07-20	AACG	Stock	1.3	1.4	1.3	1.4	22500.0
2022-07-20	AACIW-DELISTED	Stock	0.1999	0.2	0.1999	0.2	4214.0
2022-07-20	AAIC-DELISTED	Stock	3.1471	3.25	3.1414	3.225	79967.0
2022-07-20	AAIC.C-DELISTED	Stock	20.5	20.7525	20.47	20.49	2111.0
2022-07-20	AAL	Stock	15.14	15.42	14.9	15.21	39746400.0
2022-07-20	AAM.A-DELISTED	Stock	24.6	24.64	24.58	24.63	16448.0
2022-07-20	AAM.B-DELISTED	Stock	24.8	24.9794	24.8	24.835	6251.0
2022-07-20	AAMC-DELISTED	Stock	3.2647	3.3055	3.1471	3.2956	22964.0
2022-07-20	AAME	Stock	2.78	2.8	2.66	2.76	1800.0
2022-07-20	AAMI	Stock	17.93	18.69	17.93	18.61	276500.0
2022-07-20	AAN-DELISTED	Stock	15.98	16.61	15.9	16.57	220300.0
2022-07-20	AAOI	Stock	1.78	1.9	1.757	1.86	208900.0
2022-07-20	AAON	Stock	36.2533	37.2	36.1133	37.04	194700.0
2022-07-20	AAP	Stock	191.57	192.83	188.29	192.66	520200.0
2022-07-20	AAQC-DELISTED	Stock	9.79	9.79	9.78	9.78	849.0
2022-07-20	AAT	Stock	30.14	30.49	29.95	30.13	219700.0
2022-07-20	AATC	Stock	4.91	5.0299	4.91	5.01	41074.0
2022-07-20	AAU-DELISTED	Stock	0.2247	0.237	0.22	0.2243	579539.0
2022-07-20	AAUAF-DELISTED	Stock	0.2247	0.237	0.22	0.2243	585972.0
2022-07-20	AAWW-DELISTED	Stock	66.95	68.91	66.95	68.4	257758.0
2022-07-20	AAXJ	Stock	67.79	68.02	67.53	67.81	1326653.0
2022-07-20	AB	Stock	41.21	42.53	41.14	42.02	357500.0
2022-07-20	ABB-DELISTED	Stock	28.06	28.26	27.875	28.08	2545013.0
2022-07-20	ABBNY-DELISTED	Stock	28.06	28.26	27.875	28.09	2754236.0
2022-07-20	ABBV	Stock	149.53	150.45	147.34	147.69	5315700.0
2022-07-20	ABC-DELISTED	Stock	143.06	143.06	140.51	141.46	329223.0
2022-07-20	ABCB	Stock	41.81	42.53	40.52	42.5	287700.0
2022-07-20	ABCL	Stock	10.63	11.13	10.31	10.65	1803400.0
2022-07-20	ABCM-DELISTED	Stock	13.83	14.55	13.81	14.55	286617.0
2022-07-20	ABEO	Stock	4.9	5.15	4.87	5.08	120500.0
2022-07-20	ABEV	Stock	2.64	2.66	2.55	2.59	48392400.0
2022-07-20	ABG	Stock	171.69	174.98	168.19	172.74	300600.0
2022-07-20	ABGI-DELISTED	Stock	9.82	9.84	9.82	9.84	13577.0
2022-07-20	ABM	Stock	43.75	44.15	43.38	43.79	438100.0
2022-07-20	ABMD-DELISTED	Stock	270.41	277.73	268.3	276.16	100724.0
2022-07-20	ABNB	Stock	103.11	108.92	102.75	107.73	6834100.0
2022-07-20	ABOS	Stock	6.08	6.45	5.68	5.82	53700.0

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

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