PREVIEW / stock_daily / 2021-10-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-19.parquet
  size:    258 KB
  rows:    7,862
  symbols: 2,650

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
2021-10-19	AAPL	Stock	147.01	149.17	146.55	148.76	76378900.0
2021-10-19	MSFT	Stock	308.35	309.3	307.22	308.23	17682100.0
2021-10-19	NVDA	Stock	22.276	22.379	22.037	22.29	161473000.0
2021-10-19	AMZN	Stock	171.7145	172.7345	171.1	172.2075	47722000.0
2021-10-19	GOOGL	Stock	143.3875	143.6625	142.6	143.237	20163000.0
2021-10-19	META	Stock	339.65	342.46	337.28	339.99	18786300.0
2021-10-19	TSLA	Stock	292.51	292.65	287.5033	288.09	52143300.0
2021-10-19	TLT	Stock	144.66	144.73	143.65	143.7	12156566.0
2021-10-19	ES	Stock	86.81	86.81	85.59	86.16	1449900.0
2021-10-19	CL	Stock	74.7	74.9	74.29	74.78	5206800.0
2021-10-19	A	Stock	155.96	157.46	155.55	155.62	1025500.0
2021-10-19	AA	Stock	57.24	57.24	53.61	53.68	10860800.0
2021-10-19	AAC-DELISTED	Stock	9.75	9.78	9.75	9.75	48129.0
2021-10-19	AACG	Stock	2.49	2.67	2.31	2.56	223700.0
2021-10-19	AAIC-DELISTED	Stock	3.93	3.945	3.89	3.92	54492.0
2021-10-19	AAIC.C-DELISTED	Stock	25.1	25.1	25.085	25.085	531.0
2021-10-19	AAL	Stock	19.93	19.94	19.5	19.53	25758300.0
2021-10-19	AAM.A-DELISTED	Stock	25.98	26.06	25.9211	25.99	23093.0
2021-10-19	AAM.B-DELISTED	Stock	27.01	27.1234	26.9	27.04	21119.0
2021-10-19	AAMC-DELISTED	Stock	7.0059	7.2059	6.7932	7.1382	19057.0
2021-10-19	AAME	Stock	4.3	4.39	4.15	4.15	13500.0
2021-10-19	AAMI	Stock	26.57	26.77	26.46	26.63	304900.0
2021-10-19	AAN-DELISTED	Stock	28.33	28.84	28.26	28.51	134100.0
2021-10-19	AAOI	Stock	7.259	7.45	7.17	7.42	233500.0
2021-10-19	AAON	Stock	47.4067	47.64	47.0	47.64	208050.0
2021-10-19	AAP	Stock	224.04	225.59	222.24	224.14	721100.0
2021-10-19	AAQC-DELISTED	Stock	9.72	9.77	9.715	9.76	417927.0
2021-10-19	AAT	Stock	39.42	39.55	38.69	38.76	119600.0
2021-10-19	AATC	Stock	7.13	7.1783	7.05	7.13	13932.0
2021-10-19	AAU-DELISTED	Stock	0.38	0.388	0.3784	0.38	509900.0
2021-10-19	AAUAF-DELISTED	Stock	0.38	0.388	0.3784	0.38	516114.0
2021-10-19	AAWW-DELISTED	Stock	79.56	79.56	77.44	77.51	225038.0
2021-10-19	AAXJ	Stock	88.1	88.77	87.93	88.74	1146971.0
2021-10-19	AB	Stock	52.55	52.99	52.25	52.8	141300.0
2021-10-19	ABB-DELISTED	Stock	34.55	34.7167	34.485	34.54	801387.0
2021-10-19	ABBNY-DELISTED	Stock	34.55	34.7167	34.485	34.54	907658.0
2021-10-19	ABBV	Stock	107.75	108.07	106.86	107.45	4614900.0
2021-10-19	ABC-DELISTED	Stock	119.1	120.38	118.74	119.84	360431.0
2021-10-19	ABCB	Stock	51.71	52.05	51.06	51.97	417500.0
2021-10-19	ABCL	Stock	15.3	16.378	15.3	15.97	1395300.0
2021-10-19	ABCM-DELISTED	Stock	22.06	22.35	22.03	22.35	18482.0
2021-10-19	ABEO	Stock	22.25	22.75	22.25	22.5	15708.0
2021-10-19	ABEV	Stock	2.72	2.73	2.65	2.67	21279300.0
2021-10-19	ABG	Stock	214.94	214.94	209.69	213.34	92800.0
2021-10-19	ABGI-DELISTED	Stock	9.71	9.75	9.7	9.7	12221.0
2021-10-19	ABM	Stock	45.09	45.27	44.45	45.12	295500.0
2021-10-19	ABMD-DELISTED	Stock	353.26	355.66	348.03	349.41	80353.0
2021-10-19	ABNB	Stock	172.57	172.81	170.06	170.74	2776600.0
2021-10-19	ABOS	Stock	13.46	13.95	13.15	13.88	49500.0
2021-10-19	ABR	Stock	19.61	19.7	19.45	19.65	1416900.0

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

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