PREVIEW / stock_daily / 2020-09-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-28.parquet
  size:    227 KB
  rows:    6,913
  symbols: 2,467

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-09-28	AAPL	Stock	115.01	115.32	112.78	114.96	137672400.0
2020-09-28	MSFT	Stock	210.88	212.57	208.06	209.44	32004900.0
2020-09-28	NVDA	Stock	13.0402	13.0518	12.75	13.035	573808000.0
2020-09-28	AMZN	Stock	157.4425	158.752	155.8585	158.7025	84484000.0
2020-09-28	GOOGL	Stock	73.5995	73.6495	72.314	72.933	30784720.0
2020-09-28	META	Stock	259.4	259.6	254.82	256.82	18826300.0
2020-09-28	TSLA	Stock	141.54	142.6933	138.5167	140.4	149158800.0
2020-09-28	TLT	Stock	164.87	164.9	164.37	164.65	4470504.0
2020-09-28	ES	Stock	83.0	83.74	81.92	82.65	1293200.0
2020-09-28	CL	Stock	76.73	77.51	76.42	76.61	2586300.0
2020-09-28	A	Stock	98.64	99.73	98.12	99.51	1336600.0
2020-09-28	AA	Stock	11.83	12.33	11.82	12.24	5121100.0
2020-09-28	AACG	Stock	1.15	1.21	1.08	1.15	239000.0
2020-09-28	AACQ-DELISTED	Stock	10.05	10.0584	9.91	9.95	251591.0
2020-09-28	AACQU-DELISTED	Stock	10.47	10.48	10.3627	10.48	5836.0
2020-09-28	AACQW-DELISTED	Stock	1.41	1.7	1.41	1.5301	270561.0
2020-09-28	AAIC-DELISTED	Stock	2.76	2.89	2.76	2.83	371724.0
2020-09-28	AAIC.C-DELISTED	Stock	18.92	18.9966	18.92	18.9966	842.0
2020-09-28	AAL	Stock	12.74	13.15	12.49	12.76	63558200.0
2020-09-28	AAM.A-DELISTED	Stock	26.27	26.396	26.1801	26.32	17428.0
2020-09-28	AAM.B-DELISTED	Stock	27.21	27.36	27.16	27.28	11247.0
2020-09-28	AAMC-DELISTED	Stock	6.2222	6.2309	5.9926	5.9926	8694.0
2020-09-28	AAME	Stock	2.19	2.2	2.07	2.07	5800.0
2020-09-28	AAMI	Stock	12.99	13.38	12.97	13.01	611300.0
2020-09-28	AAOI	Stock	10.95	11.18	10.66	10.95	453700.0
2020-09-28	AAON	Stock	38.62	39.3	38.5867	38.9333	226350.0
2020-09-28	AAP	Stock	150.88	154.17	150.01	153.39	726400.0
2020-09-28	AAT	Stock	23.71	24.64	23.71	24.48	205500.0
2020-09-28	AAU-DELISTED	Stock	0.88	0.8944	0.8425	0.861	475195.0
2020-09-28	AAUAF-DELISTED	Stock	0.88	0.8944	0.8425	0.852	505914.0
2020-09-28	AAWW-DELISTED	Stock	60.65	63.04	60.55	62.36	316244.0
2020-09-28	AAXJ	Stock	76.02	76.14	75.69	76.06	396806.0
2020-09-28	AAXN-DELISTED	Stock	88.09	89.52	87.55	87.9	383998.0
2020-09-28	AB	Stock	27.48	27.8	26.85	27.45	521200.0
2020-09-28	ABB-DELISTED	Stock	25.21	25.47	25.2	25.38	1382685.0
2020-09-28	ABBNY-DELISTED	Stock	25.21	25.47	25.2	25.39	1486336.0
2020-09-28	ABBV	Stock	87.29	88.2	86.87	87.28	6306900.0
2020-09-28	ABC-DELISTED	Stock	97.75	98.76	96.79	97.67	490224.0
2020-09-28	ABCB	Stock	22.11	23.08	22.11	22.81	386000.0
2020-09-28	ABEO	Stock	36.25	36.5	26.75	27.25	554196.0
2020-09-28	ABEV	Stock	2.33	2.35	2.21	2.23	43705400.0
2020-09-28	ABG	Stock	94.99	98.93	94.99	98.66	178800.0
2020-09-28	ABM	Stock	37.28	37.86	37.1	37.46	497200.0
2020-09-28	ABMD-DELISTED	Stock	269.98	275.32	268.48	273.52	183546.0
2020-09-28	ABR	Stock	11.84	12.06	11.73	11.88	1185200.0
2020-09-28	ABR.A-DELISTED	Stock	25.2	25.3491	25.2	25.22	1780.0
2020-09-28	ABR.B-DELISTED	Stock	25.03	25.085	25.0	25.085	400.0
2020-09-28	ABR.C-DELISTED	Stock	25.29	25.6	25.29	25.595	4131.0
2020-09-28	ABT	Stock	104.24	105.25	103.82	104.44	5515500.0
2020-09-28	ABTC	Stock	108000.0	108600.0	106200.0	107100.0	3.253333333333333

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

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