PREVIEW / stock_daily / 2020-05-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-28.parquet
  size:    218 KB
  rows:    6,624
  symbols: 2,352

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
2020-05-28	AAPL	Stock	79.1925	80.86	78.9075	79.5625	133560800.0
2020-05-28	MSFT	Stock	180.74	184.15	180.38	181.4	33810200.0
2020-05-28	NVDA	Stock	8.4122	8.7605	8.3793	8.487	734896000.0
2020-05-28	AMZN	Stock	119.2165	121.8485	118.9115	120.055	63804000.0
2020-05-28	GOOGL	Stock	70.0	72.223	69.9538	70.912	35195740.0
2020-05-28	META	Stock	224.3	231.63	224.0	225.46	29377200.0
2020-05-28	TSLA	Stock	54.234	54.9833	53.446	53.7207	108834000.0
2020-05-28	TLT	Stock	161.96	162.57	161.66	162.43	10276172.0
2020-05-28	ES	Stock	78.69	81.14	78.14	80.89	1882800.0
2020-05-28	CL	Stock	71.6	72.47	71.2	72.09	4685600.0
2020-05-28	A	Stock	86.87	87.85	86.06	86.69	1908700.0
2020-05-28	AA	Stock	9.96	10.67	9.41	9.48	15641300.0
2020-05-28	AACG	Stock	0.92	0.95	0.92	0.94	10100.0
2020-05-28	AAIC-DELISTED	Stock	2.56	2.56	2.42	2.47	761072.0
2020-05-28	AAIC.C-DELISTED	Stock	17.0798	17.74	17.02	17.45	7309.0
2020-05-28	AAL	Stock	11.78	11.83	10.9	10.98	70488800.0
2020-05-28	AAM.A-DELISTED	Stock	26.25	26.56	26.25	26.53	14189.0
2020-05-28	AAM.B-DELISTED	Stock	26.25	26.74	26.25	26.66	20965.0
2020-05-28	AAMC-DELISTED	Stock	5.5882	5.5882	4.9215	5.2853	18928.0
2020-05-28	AAME	Stock	1.95	1.95	1.86	1.86	1100.0
2020-05-28	AAMI	Stock	8.94	8.94	8.48	8.5	405800.0
2020-05-28	AAOI	Stock	9.0	9.07	8.77	8.9	791200.0
2020-05-28	AAON	Stock	36.8	37.1133	35.9467	36.1467	308550.0
2020-05-28	AAP	Stock	142.39	142.48	138.0	138.44	1069900.0
2020-05-28	AAT	Stock	28.51	28.51	26.85	27.16	548100.0
2020-05-28	AAU-DELISTED	Stock	0.49	0.49	0.46	0.466	217159.0
2020-05-28	AAUAF-DELISTED	Stock	0.49	0.49	0.46	0.466	226939.0
2020-05-28	AAWW-DELISTED	Stock	39.3	39.95	37.52	38.91	359250.0
2020-05-28	AAXJ	Stock	63.91	64.24	63.37	63.45	1207957.0
2020-05-28	AAXN-DELISTED	Stock	77.08	78.68	73.04	73.37	454990.0
2020-05-28	AB	Stock	26.72	26.75	25.0	25.25	366700.0
2020-05-28	ABB-DELISTED	Stock	19.78	19.995	19.6505	19.67	2130849.0
2020-05-28	ABBNY-DELISTED	Stock	19.78	19.995	19.6505	19.68	2286401.0
2020-05-28	ABBV	Stock	90.87	91.19	90.0	90.03	8765900.0
2020-05-28	ABC-DELISTED	Stock	94.36	96.49	93.83	94.45	948582.0
2020-05-28	ABCB	Stock	27.16	27.16	24.54	24.78	506000.0
2020-05-28	ABEO	Stock	82.75	84.5	80.0	81.0	26388.0
2020-05-28	ABEV	Stock	2.55	2.55	2.37	2.38	47949000.0
2020-05-28	ABG	Stock	80.02	80.05	75.84	76.21	172700.0
2020-05-28	ABM	Stock	33.87	34.12	33.25	33.48	310600.0
2020-05-28	ABMD-DELISTED	Stock	207.88	218.98	207.16	217.36	573385.0
2020-05-28	ABR	Stock	8.69	8.97	8.52	8.56	2360500.0
2020-05-28	ABR.A-DELISTED	Stock	24.29	24.73	23.86	24.5	3201.0
2020-05-28	ABR.B-DELISTED	Stock	23.75	24.13	23.75	23.75	1478.0
2020-05-28	ABR.C-DELISTED	Stock	24.8471	25.1	24.35	24.86	5702.0
2020-05-28	ABT	Stock	91.95	93.33	91.21	92.1	5316300.0
2020-05-28	ABTC	Stock	305400.0	330000.0	301350.0	310500.0	5.413333333333333
2020-05-28	ABTS	Stock	9.225	10.125	9.195	9.645	1427.0
2020-05-28	ABTX-DELISTED	Stock	28.28	28.28	25.95	26.16	57690.0
2020-05-28	ABUS	Stock	2.22	2.25	2.1	2.16	466200.0

> showing 50 of 6,624 rows — these rows as CSV

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