PREVIEW / stock_daily / 2021-01-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-14.parquet
  size:    243 KB
  rows:    7,326
  symbols: 2,670

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-01-14	AAPL	Stock	130.8	131.0	128.76	128.91	90221800.0
2021-01-14	MSFT	Stock	215.91	217.46	212.74	213.02	29480800.0
2021-01-14	NVDA	Stock	13.575	13.5998	13.1805	13.2002	283120000.0
2021-01-14	AMZN	Stock	158.376	158.9	156.0295	156.3735	61418000.0
2021-01-14	GOOGL	Stock	87.4435	88.3775	86.3035	86.546	29212340.0
2021-01-14	META	Stock	253.4	255.03	244.61	245.64	29739400.0
2021-01-14	TSLA	Stock	281.13	287.6667	279.5833	281.6667	93798900.0
2021-01-14	TLT	Stock	152.58	152.64	150.79	151.22	14835458.0
2021-01-14	ES	Stock	90.13	90.69	87.1	89.57	2001600.0
2021-01-14	CL	Stock	82.77	82.78	81.62	81.94	3732500.0
2021-01-14	A	Stock	127.27	128.19	125.82	126.03	924900.0
2021-01-14	AA	Stock	25.0	25.38	24.85	25.09	3991400.0
2021-01-14	AACG	Stock	1.23	1.3	1.22	1.26	43100.0
2021-01-14	AACQ-DELISTED	Stock	11.06	11.3	11.01	11.06	1603306.0
2021-01-14	AACQU-DELISTED	Stock	12.01	12.14	11.8	11.9	429653.0
2021-01-14	AACQW-DELISTED	Stock	2.75	2.75	2.4	2.455	431145.0
2021-01-14	AAIC-DELISTED	Stock	3.9	3.98	3.9	3.98	104955.0
2021-01-14	AAIC.C-DELISTED	Stock	21.32	21.35	21.0	21.35	2896.0
2021-01-14	AAL	Stock	15.83	16.6	15.82	16.44	79900900.0
2021-01-14	AAM.A-DELISTED	Stock	26.57	26.57	26.39	26.44	9318.0
2021-01-14	AAM.B-DELISTED	Stock	26.8	26.93	26.72	26.72	8599.0
2021-01-14	AAMC-DELISTED	Stock	6.1765	6.3603	6.1765	6.2265	11128.0
2021-01-14	AAME	Stock	2.22	2.29	2.2	2.22	20100.0
2021-01-14	AAMI	Stock	21.23	21.59	21.09	21.22	275500.0
2021-01-14	AAN-DELISTED	Stock	21.61	22.99	21.06	22.48	783600.0
2021-01-14	AAOI	Stock	10.2	10.55	10.19	10.47	756500.0
2021-01-14	AAON	Stock	46.8533	47.4333	46.6867	47.26	209850.0
2021-01-14	AAP	Stock	172.91	172.91	167.75	168.83	879800.0
2021-01-14	AAT	Stock	28.69	29.24	28.3	28.91	246600.0
2021-01-14	AAU-DELISTED	Stock	0.63	0.788	0.61	0.6297	15682060.0
2021-01-14	AAUAF-DELISTED	Stock	0.63	0.788	0.61	0.6314	15831062.0
2021-01-14	AAWW-DELISTED	Stock	53.85	55.7	53.69	54.47	279806.0
2021-01-14	AAXJ	Stock	96.08	96.42	95.69	95.83	1037771.0
2021-01-14	AAXN-DELISTED	Stock	146.09	152.0	145.41	149.64	598524.0
2021-01-14	AB	Stock	35.94	36.35	35.47	35.48	356200.0
2021-01-14	ABB-DELISTED	Stock	30.46	30.885	30.45	30.74	1529769.0
2021-01-14	ABBNY-DELISTED	Stock	30.46	30.885	30.45	30.74	1735893.0
2021-01-14	ABBV	Stock	110.7	112.69	109.5	111.63	8268800.0
2021-01-14	ABC-DELISTED	Stock	105.68	106.66	105.35	105.65	717590.0
2021-01-14	ABCB	Stock	44.45	45.18	44.14	44.88	485600.0
2021-01-14	ABCL	Stock	44.39	47.0	41.46	46.64	964800.0
2021-01-14	ABCM-DELISTED	Stock	23.42	24.69	23.25	23.33	157502.0
2021-01-14	ABEO	Stock	45.25	50.25	44.75	49.5	146292.0
2021-01-14	ABEV	Stock	3.11	3.19	3.1	3.18	13188700.0
2021-01-14	ABG	Stock	162.52	167.23	162.22	165.38	106600.0
2021-01-14	ABM	Stock	41.88	42.95	41.58	42.05	317300.0
2021-01-14	ABMD-DELISTED	Stock	322.77	326.18	316.83	318.28	274705.0
2021-01-14	ABNB	Stock	175.54	187.42	174.975	180.5	9926500.0
2021-01-14	ABR	Stock	14.27	14.47	14.19	14.47	771400.0
2021-01-14	ABR.A-DELISTED	Stock	25.51	25.651	25.51	25.63	3500.0

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

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