PREVIEW / stock_daily / 2021-10-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-28.parquet
  size:    260 KB
  rows:    7,942
  symbols: 2,675

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-28	AAPL	Stock	149.82	153.17	149.72	152.57	100077900.0
2021-10-28	MSFT	Stock	324.33	324.87	321.36	324.35	26297900.0
2021-10-28	NVDA	Stock	24.878	24.95	24.523	24.941	234204000.0
2021-10-28	AMZN	Stock	170.105	173.95	169.3	172.3285	114174000.0
2021-10-28	GOOGL	Stock	147.1345	147.158	144.6267	145.849	36206380.0
2021-10-28	META	Stock	312.99	325.52	308.11	316.92	50806800.0
2021-10-28	TSLA	Stock	356.1033	360.3333	351.4	359.0133	81639600.0
2021-10-28	TLT	Stock	147.79	148.33	146.835	147.24	17497586.0
2021-10-28	ES	Stock	85.88	86.37	85.26	85.66	1017100.0
2021-10-28	CL	Stock	75.9	76.91	75.7	76.88	4849900.0
2021-10-28	A	Stock	155.98	157.79	154.19	155.76	1752600.0
2021-10-28	AA	Stock	47.17	47.48	45.51	46.45	10235700.0
2021-10-28	AAC-DELISTED	Stock	9.85	9.85	9.79	9.81	49347.0
2021-10-28	AACG	Stock	2.25	2.29	2.22	2.25	18800.0
2021-10-28	AAIC-DELISTED	Stock	3.87	3.88	3.84	3.87	57398.0
2021-10-28	AAIC.C-DELISTED	Stock	25.2084	25.25	25.2084	25.25	768.0
2021-10-28	AAL	Stock	19.11	19.24	18.85	19.19	26506900.0
2021-10-28	AAM.A-DELISTED	Stock	25.9728	26.0	25.97	25.97	5704.0
2021-10-28	AAM.B-DELISTED	Stock	27.05	27.1	27.05	27.05	7389.0
2021-10-28	AAMC-DELISTED	Stock	7.2206	7.5294	7.2206	7.3118	26683.0
2021-10-28	AAME	Stock	4.01	4.18	4.01	4.11	9400.0
2021-10-28	AAMI	Stock	27.25	29.25	27.1	28.85	2604000.0
2021-10-28	AAN-DELISTED	Stock	23.45	23.82	22.89	23.11	393600.0
2021-10-28	AAOI	Stock	7.72	7.74	7.57	7.66	380400.0
2021-10-28	AAON	Stock	46.36	47.84	46.36	47.68	114750.0
2021-10-28	AAP	Stock	230.28	231.82	220.93	225.0	1090500.0
2021-10-28	AAQC-DELISTED	Stock	9.7293	9.74	9.7	9.73	37386.0
2021-10-28	AAT	Stock	38.11	38.36	37.84	38.17	137400.0
2021-10-28	AATC	Stock	6.79	6.9	6.75	6.75	20521.0
2021-10-28	AAU-DELISTED	Stock	0.38	0.3881	0.3707	0.3771	846260.0
2021-10-28	AAUAF-DELISTED	Stock	0.38	0.3881	0.3707	0.3771	857671.0
2021-10-28	AAWW-DELISTED	Stock	79.8	82.045	79.61	81.275	158544.0
2021-10-28	AAXJ	Stock	86.86	87.45	86.75	87.41	502652.0
2021-10-28	AB	Stock	56.25	57.54	55.51	55.84	333800.0
2021-10-28	ABB-DELISTED	Stock	32.95	33.235	32.93	33.2	792548.0
2021-10-28	ABBNY-DELISTED	Stock	32.95	33.235	32.93	33.2	894347.0
2021-10-28	ABBV	Stock	108.39	109.9	108.2	109.67	5193300.0
2021-10-28	ABC-DELISTED	Stock	119.99	121.05	119.68	120.64	321404.0
2021-10-28	ABCB	Stock	52.91	53.96	52.89	53.65	253800.0
2021-10-28	ABCL	Stock	15.39	16.05	15.19	15.92	1239600.0
2021-10-28	ABCM-DELISTED	Stock	23.04	23.27	22.97	23.22	19135.0
2021-10-28	ABEO	Stock	21.25	21.25	19.75	20.25	61228.0
2021-10-28	ABEV	Stock	2.89	2.96	2.83	2.94	52305600.0
2021-10-28	ABG	Stock	201.08	203.94	195.3	196.07	189100.0
2021-10-28	ABGI-DELISTED	Stock	9.78	9.78	9.78	9.78	901.0
2021-10-28	ABM	Stock	43.23	44.08	43.23	43.81	240400.0
2021-10-28	ABMD-DELISTED	Stock	330.0	350.43	315.59	342.76	341493.0
2021-10-28	ABNB	Stock	170.2	171.85	168.71	171.7	2143700.0
2021-10-28	ABOS	Stock	14.71	14.84	14.235	14.4	45300.0
2021-10-28	ABR	Stock	19.89	19.96	19.67	19.95	840900.0

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

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