PREVIEW / stock_daily / 2021-11-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-08.parquet
  size:    262 KB
  rows:    7,984
  symbols: 2,685

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-11-08	AAPL	Stock	151.41	151.57	150.16	150.44	55020900.0
2021-11-08	MSFT	Stock	337.3	337.65	334.44	336.99	20897000.0
2021-11-08	NVDA	Stock	30.149	31.1	29.907	30.804	503101000.0
2021-11-08	AMZN	Stock	176.162	178.95	174.393	174.449	61480000.0
2021-11-08	GOOGL	Stock	149.825	150.6148	148.4305	149.031	23052500.0
2021-11-08	META	Stock	344.42	344.79	338.34	338.62	18342500.0
2021-11-08	TSLA	Stock	383.2633	399.0	377.6667	387.6467	100337100.0
2021-11-08	TLT	Stock	148.96	149.28	148.51	149.02	12083905.0
2021-11-08	ES	Stock	84.42	84.42	82.24	82.62	1222400.0
2021-11-08	CL	Stock	77.85	77.95	77.01	77.74	3335900.0
2021-11-08	A	Stock	157.0	161.15	156.55	160.94	1467000.0
2021-11-08	AA	Stock	49.2	50.62	48.16	48.86	10550300.0
2021-11-08	AAC-DELISTED	Stock	9.82	9.82	9.8	9.8	202547.0
2021-11-08	AACG	Stock	2.4	2.4	2.31	2.32	20000.0
2021-11-08	AACIU	Stock	9.95	9.95	9.95	9.95	1629.0
2021-11-08	AAIC-DELISTED	Stock	3.84	3.9	3.8302	3.89	65040.0
2021-11-08	AAIC.C-DELISTED	Stock	25.95	25.95	25.53	25.54	700.0
2021-11-08	AAL	Stock	22.19	22.35	21.84	22.25	35774400.0
2021-11-08	AAM.A-DELISTED	Stock	26.02	26.02	25.88	25.89	20850.0
2021-11-08	AAM.B-DELISTED	Stock	27.042	27.1343	27.042	27.1189	1785.0
2021-11-08	AAMC-DELISTED	Stock	7.2882	7.3265	7.1765	7.1765	16045.0
2021-11-08	AAME	Stock	4.45	4.49	4.26	4.3	19200.0
2021-11-08	AAMI	Stock	30.36	30.479	30.07	30.23	1202500.0
2021-11-08	AAN-DELISTED	Stock	26.68	27.42	26.468	26.93	301100.0
2021-11-08	AAOI	Stock	5.98	6.0	5.61	5.85	7146500.0
2021-11-08	AAON	Stock	49.4533	50.1	49.2733	49.8733	160650.0
2021-11-08	AAP	Stock	229.55	230.3	224.56	227.91	486700.0
2021-11-08	AAQC-DELISTED	Stock	9.87	9.92	9.81	9.86	284237.0
2021-11-08	AAT	Stock	40.83	40.83	39.06	39.1	305800.0
2021-11-08	AATC	Stock	6.85	7.0	6.8084	6.99	18687.0
2021-11-08	AAU-DELISTED	Stock	0.3701	0.387	0.3701	0.3869	833564.0
2021-11-08	AAUAF-DELISTED	Stock	0.3701	0.387	0.37	0.3869	966586.0
2021-11-08	AAWW-DELISTED	Stock	86.11	87.62	85.02	86.3	464349.0
2021-11-08	AAXJ	Stock	86.54	86.86	86.53	86.86	502950.0
2021-11-08	AB	Stock	56.6	57.3	56.26	56.51	176600.0
2021-11-08	ABB-DELISTED	Stock	34.7	34.95	34.675	34.87	674826.0
2021-11-08	ABBNY-DELISTED	Stock	34.7	34.95	34.675	34.88	784057.0
2021-11-08	ABBV	Stock	117.2	117.45	115.78	116.06	7015000.0
2021-11-08	ABC-DELISTED	Stock	127.38	128.0	125.76	125.99	534658.0
2021-11-08	ABCB	Stock	55.53	56.64	54.74	55.24	203100.0
2021-11-08	ABCL	Stock	15.19	15.65	15.155	15.33	2193600.0
2021-11-08	ABCM-DELISTED	Stock	23.0	23.4	22.82	23.33	61468.0
2021-11-08	ABEO	Stock	22.5	24.5	22.0	24.25	71840.0
2021-11-08	ABEV	Stock	3.17	3.2	3.13	3.15	26782500.0
2021-11-08	ABG	Stock	182.43	184.82	178.32	184.82	651200.0
2021-11-08	ABGI-DELISTED	Stock	9.75	9.8	9.75	9.8	4472.0
2021-11-08	ABM	Stock	48.41	48.72	47.72	47.78	358600.0
2021-11-08	ABMD-DELISTED	Stock	362.27	362.55	351.08	360.33	126256.0
2021-11-08	ABNB	Stock	203.35	211.336	199.75	200.32	12855300.0
2021-11-08	ABOS	Stock	14.92	15.12	14.43	14.58	24500.0

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

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