PREVIEW / stock_daily / 2021-07-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-12.parquet
  size:    257 KB
  rows:    7,877
  symbols: 2,852

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-07-12	AAPL	Stock	146.21	146.32	144.0	144.5	76299700.0
2021-07-12	MSFT	Stock	279.16	279.77	276.58	277.32	18931700.0
2021-07-12	NVDA	Stock	20.24	20.5328	20.1878	20.5125	321984000.0
2021-07-12	AMZN	Stock	187.2	187.8645	184.8395	185.9275	51432000.0
2021-07-12	GOOGL	Stock	126.178	127.0694	125.6108	126.9755	17667780.0
2021-07-12	META	Stock	351.23	354.19	349.64	353.16	10018600.0
2021-07-12	TSLA	Stock	220.7333	229.08	220.72	228.5667	77781000.0
2021-07-12	TLT	Stock	147.09	147.23	146.17	146.34	10610428.0
2021-07-12	ES	Stock	82.33	82.68	81.89	82.5	950400.0
2021-07-12	CL	Stock	82.51	83.12	82.48	82.93	4482600.0
2021-07-12	A	Stock	150.65	151.0	149.17	149.51	1480500.0
2021-07-12	AA	Stock	36.88	37.94	36.58	37.29	5139500.0
2021-07-12	AAC-DELISTED	Stock	9.84	9.84	9.8	9.8	110239.0
2021-07-12	AACG	Stock	2.76	2.95	2.7	2.87	113300.0
2021-07-12	AAIC-DELISTED	Stock	3.91	3.98	3.8992	3.95	205213.0
2021-07-12	AAIC.C-DELISTED	Stock	25.23	25.315	25.23	25.23	650.0
2021-07-12	AAL	Stock	20.72	20.98	20.35	20.84	20782200.0
2021-07-12	AAM.A-DELISTED	Stock	26.62	26.6499	26.43	26.6499	5037.0
2021-07-12	AAM.B-DELISTED	Stock	26.99	27.08	26.99	27.04	9173.0
2021-07-12	AAMC-DELISTED	Stock	5.2059	5.2411	5.0088	5.1537	72774.0
2021-07-12	AAME	Stock	4.4	4.4	4.3	4.38	22000.0
2021-07-12	AAMI	Stock	23.93	24.33	23.93	24.21	228200.0
2021-07-12	AAN-DELISTED	Stock	30.71	31.28	30.3	30.95	316800.0
2021-07-12	AAOI	Stock	8.05	8.1	7.92	7.955	358200.0
2021-07-12	AAON	Stock	42.08	42.2467	41.3267	41.7733	138300.0
2021-07-12	AAP	Stock	212.44	213.94	211.16	211.93	379700.0
2021-07-12	AAQC-DELISTED	Stock	9.69	9.73	9.69	9.7	233239.0
2021-07-12	AAT	Stock	37.69	38.09	37.59	38.04	335400.0
2021-07-12	AAU-DELISTED	Stock	0.469	0.4827	0.462	0.4802	824768.0
2021-07-12	AAUAF-DELISTED	Stock	0.469	0.4827	0.462	0.482	849253.0
2021-07-12	AAWW-DELISTED	Stock	67.85	68.15	66.4	67.79	194766.0
2021-07-12	AAXJ	Stock	91.56	91.79	91.29	91.79	447501.0
2021-07-12	AB	Stock	46.5	47.03	46.2	46.64	183500.0
2021-07-12	ABB-DELISTED	Stock	35.89	35.98	35.8095	35.95	722197.0
2021-07-12	ABBNY-DELISTED	Stock	35.89	35.98	35.8095	35.96	809218.0
2021-07-12	ABBV	Stock	116.8	118.35	116.62	117.63	8148400.0
2021-07-12	ABC-DELISTED	Stock	114.7	116.25	114.26	115.52	410335.0
2021-07-12	ABCB	Stock	49.1	49.89	48.66	49.81	418600.0
2021-07-12	ABCL	Stock	19.39	20.2	18.62	18.65	1150600.0
2021-07-12	ABCM-DELISTED	Stock	19.26	19.26	18.67	18.75	80788.0
2021-07-12	ABEO	Stock	38.25	38.25	35.25	35.5	25852.0
2021-07-12	ABEV	Stock	3.31	3.41	3.28	3.41	16338500.0
2021-07-12	ABG	Stock	182.46	187.62	181.21	187.53	180900.0
2021-07-12	ABGI-DELISTED	Stock	9.87	9.88	9.8	9.88	3028.0
2021-07-12	ABM	Stock	42.66	44.3	42.62	44.24	482400.0
2021-07-12	ABMD-DELISTED	Stock	325.35	326.02	319.45	322.37	100916.0
2021-07-12	ABNB	Stock	148.99	150.42	146.01	146.69	3276300.0
2021-07-12	ABOS	Stock	19.06	19.48	17.9	18.5	245700.0
2021-07-12	ABR	Stock	18.12	18.35	17.99	18.28	1231800.0
2021-07-12	ABR.D	Stock	25.64	25.7	25.6	25.64	46160.0

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

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