PREVIEW / stock_daily / 2021-09-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-15.parquet
  size:    258 KB
  rows:    7,867
  symbols: 2,705

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-09-15	AAPL	Stock	148.56	149.44	146.37	149.03	83281300.0
2021-09-15	MSFT	Stock	303.26	305.32	301.82	304.82	28356300.0
2021-09-15	NVDA	Stock	22.309	22.367	21.966	22.341	166538000.0
2021-09-15	AMZN	Stock	172.126	174.271	170.1005	173.7895	59150000.0
2021-09-15	GOOGL	Stock	142.7715	144.4505	141.3475	144.4295	27407580.0
2021-09-15	META	Stock	377.0	377.56	367.67	373.92	17940300.0
2021-09-15	TSLA	Stock	248.3333	252.2867	246.12	251.9433	46073100.0
2021-09-15	TLT	Stock	151.21	151.25	149.93	150.58	11940558.0
2021-09-15	ES	Stock	86.22	86.29	85.18	85.31	1905700.0
2021-09-15	CL	Stock	77.48	77.84	77.08	77.21	3662100.0
2021-09-15	A	Stock	172.07	175.13	171.39	173.79	1535300.0
2021-09-15	AA	Stock	49.72	51.89	49.51	51.68	9413900.0
2021-09-15	AAC-DELISTED	Stock	9.77	9.77	9.75	9.76	11390.0
2021-09-15	AACG	Stock	2.83	2.83	2.73	2.81	14800.0
2021-09-15	AAIC-DELISTED	Stock	3.79	3.8	3.76	3.77	71319.0
2021-09-15	AAIC.C-DELISTED	Stock	25.35	25.47	25.15	25.1501	5431.0
2021-09-15	AAL	Stock	19.19	19.41	18.86	19.38	22989100.0
2021-09-15	AAM.A-DELISTED	Stock	26.04	26.05	25.8	25.8	33194.0
2021-09-15	AAM.B-DELISTED	Stock	26.99	26.99	26.88	26.89	13609.0
2021-09-15	AAMC-DELISTED	Stock	8.1618	8.2845	7.6882	7.7059	75354.0
2021-09-15	AAME	Stock	3.87	4.0	3.83	3.83	10900.0
2021-09-15	AAMI	Stock	26.65	27.02	26.605	26.84	451800.0
2021-09-15	AAN-DELISTED	Stock	25.7	26.29	25.56	26.16	227200.0
2021-09-15	AAOI	Stock	7.25	7.375	7.05	7.28	486300.0
2021-09-15	AAON	Stock	43.6733	44.0667	43.3267	43.5467	227550.0
2021-09-15	AAP	Stock	201.34	206.66	200.33	206.21	528300.0
2021-09-15	AAQC-DELISTED	Stock	9.68	9.77	9.67	9.77	46342.0
2021-09-15	AAT	Stock	39.42	39.85	39.17	39.65	291600.0
2021-09-15	AATC	Stock	7.7843	8.2269	7.7843	8.15	20088.0
2021-09-15	AAU-DELISTED	Stock	0.401	0.412	0.3988	0.4012	616004.0
2021-09-15	AAUAF-DELISTED	Stock	0.401	0.412	0.3988	0.4115	630303.0
2021-09-15	AAWW-DELISTED	Stock	75.93	78.19	75.77	76.91	352279.0
2021-09-15	AAXJ	Stock	87.84	88.065	87.46	88.01	900292.0
2021-09-15	AB	Stock	50.81	52.3	50.81	52.02	155700.0
2021-09-15	ABB-DELISTED	Stock	36.57	36.695	36.47	36.62	876156.0
2021-09-15	ABBNY-DELISTED	Stock	36.57	36.695	36.47	36.63	998947.0
2021-09-15	ABBV	Stock	106.59	108.8	106.03	107.77	7444300.0
2021-09-15	ABC-DELISTED	Stock	122.66	125.88	121.9	125.84	503998.0
2021-09-15	ABCB	Stock	46.71	47.53	46.62	47.09	335800.0
2021-09-15	ABCL	Stock	19.18	19.54	17.95	18.81	7188100.0
2021-09-15	ABCM-DELISTED	Stock	20.8	20.81	20.54	20.8	31046.0
2021-09-15	ABEO	Stock	30.75	31.75	30.5	31.0	13432.0
2021-09-15	ABEV	Stock	3.05	3.09	3.0	3.03	20669400.0
2021-09-15	ABG	Stock	172.12	175.39	171.0	174.56	165700.0
2021-09-15	ABGI-DELISTED	Stock	9.7	9.71	9.7	9.71	2200.0
2021-09-15	ABM	Stock	46.18	46.53	45.48	46.49	354400.0
2021-09-15	ABMD-DELISTED	Stock	353.19	359.16	348.71	355.3	124074.0
2021-09-15	ABNB	Stock	162.32	166.63	160.49	166.37	5656000.0
2021-09-15	ABOS	Stock	15.77	16.22	14.9	15.33	491500.0
2021-09-15	ABR	Stock	17.97	18.2	17.88	18.17	905000.0

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

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