PREVIEW / stock_daily / 2021-08-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-16.parquet
  size:    258 KB
  rows:    7,912
  symbols: 2,789

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-08-16	AAPL	Stock	148.54	151.19	146.47	151.12	103296000.0
2021-08-16	MSFT	Stock	293.19	294.82	290.02	294.6	22507600.0
2021-08-16	NVDA	Stock	20.135	20.287	19.453	19.95	210876000.0
2021-08-16	AMZN	Stock	164.15	165.0	160.5565	164.9495	66394000.0
2021-08-16	GOOGL	Stock	137.5249	138.3625	135.2988	138.3095	22398360.0
2021-08-16	META	Stock	362.52	366.95	357.38	366.56	11222100.0
2021-08-16	TSLA	Stock	235.0233	236.5	225.4667	228.7233	68032200.0
2021-08-16	TLT	Stock	149.19	150.02	148.81	148.91	19171543.0
2021-08-16	ES	Stock	90.6	91.49	90.47	90.81	1272900.0
2021-08-16	CL	Stock	79.49	80.15	79.49	79.78	6098900.0
2021-08-16	A	Stock	159.39	162.52	158.5	162.07	2154300.0
2021-08-16	AA	Stock	44.1	44.19	42.82	43.42	4963300.0
2021-08-16	AAC-DELISTED	Stock	9.72	9.73	9.69	9.72	160718.0
2021-08-16	AACG	Stock	2.65	2.74	2.59	2.63	54700.0
2021-08-16	AACIU	Stock	9.8	9.84	9.76	9.79	321808.0
2021-08-16	AAIC-DELISTED	Stock	3.81	3.83	3.78	3.8	63458.0
2021-08-16	AAIC.C-DELISTED	Stock	25.05	25.1	24.95	25.1	3000.0
2021-08-16	AAL	Stock	19.63	20.02	19.34	19.76	25610400.0
2021-08-16	AAM.A-DELISTED	Stock	26.26	26.335	26.26	26.32	3104.0
2021-08-16	AAM.B-DELISTED	Stock	27.03	27.04	26.92	26.98	59236.0
2021-08-16	AAMC-DELISTED	Stock	4.1412	4.4718	4.1059	4.4412	240268.0
2021-08-16	AAME	Stock	3.83	3.83	3.51	3.54	113700.0
2021-08-16	AAMI	Stock	26.61	26.98	26.335	26.98	310600.0
2021-08-16	AAN-DELISTED	Stock	28.86	29.2	27.77	27.8	212400.0
2021-08-16	AAOI	Stock	7.04	7.15	6.76	6.76	450200.0
2021-08-16	AAON	Stock	45.68	46.4067	45.2067	46.2267	131100.0
2021-08-16	AAP	Stock	205.5	212.32	204.62	212.26	590800.0
2021-08-16	AAQC-DELISTED	Stock	9.73	9.73	9.63	9.63	5696.0
2021-08-16	AAT	Stock	38.18	38.71	38.0	38.1	394200.0
2021-08-16	AATC	Stock	7.15	7.1999	6.81	7.07	63911.0
2021-08-16	AAU-DELISTED	Stock	0.42	0.43	0.4094	0.4102	339297.0
2021-08-16	AAUAF-DELISTED	Stock	0.42	0.43	0.4094	0.4097	348405.0
2021-08-16	AAWW-DELISTED	Stock	76.45	78.45	75.38	78.07	368895.0
2021-08-16	AAXJ	Stock	86.94	86.95	86.38	86.95	1265282.0
2021-08-16	AB	Stock	50.45	50.81	50.05	50.53	171200.0
2021-08-16	ABB-DELISTED	Stock	37.83	37.98	37.74	37.97	680795.0
2021-08-16	ABBNY-DELISTED	Stock	37.83	37.98	37.74	37.98	771413.0
2021-08-16	ABBV	Stock	117.0	118.62	116.71	118.41	8180500.0
2021-08-16	ABC-DELISTED	Stock	119.7	120.9193	119.25	120.01	420636.0
2021-08-16	ABCB	Stock	49.9	50.49	49.29	50.15	237200.0
2021-08-16	ABCL	Stock	17.83	17.94	16.68	17.66	2011700.0
2021-08-16	ABCM-DELISTED	Stock	20.46	20.74	20.26	20.62	37591.0
2021-08-16	ABEO	Stock	31.25	31.25	28.5	28.75	31240.0
2021-08-16	ABEV	Stock	3.11	3.12	3.05	3.06	18156700.0
2021-08-16	ABG	Stock	193.58	202.95	189.89	201.53	174200.0
2021-08-16	ABGI-DELISTED	Stock	9.62	9.64	9.62	9.64	468.0
2021-08-16	ABM	Stock	47.44	47.44	46.81	47.19	191800.0
2021-08-16	ABMD-DELISTED	Stock	322.67	326.06	318.22	323.76	60124.0
2021-08-16	ABNB	Stock	151.99	152.03	144.9	148.57	7715200.0
2021-08-16	ABOS	Stock	15.3	15.385	14.95	15.29	62300.0

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

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