PREVIEW / stock_daily / 2020-09-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-14.parquet
  size:    227 KB
  rows:    6,883
  symbols: 2,461

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-14	AAPL	Stock	114.72	115.93	112.8	115.36	140150100.0
2020-09-14	MSFT	Stock	204.24	209.2	204.03	205.41	30375800.0
2020-09-14	NVDA	Stock	13.081	13.315	12.6313	12.8723	1201744000.0
2020-09-14	AMZN	Stock	158.647	159.3695	154.8	155.1485	90592000.0
2020-09-14	GOOGL	Stock	76.5824	77.85	75.2555	75.4415	42660140.0
2020-09-14	META	Stock	270.95	276.64	265.7	266.15	24093800.0
2020-09-14	TSLA	Stock	126.9833	140.0	124.4333	139.8733	249061800.0
2020-09-14	TLT	Stock	164.79	165.08	164.23	164.47	4274947.0
2020-09-14	ES	Stock	82.55	83.49	81.68	82.91	2033900.0
2020-09-14	CL	Stock	76.97	77.69	76.95	77.15	2529300.0
2020-09-14	A	Stock	99.73	100.23	98.97	99.42	1207700.0
2020-09-14	AA	Stock	14.19	14.22	13.87	14.05	2691600.0
2020-09-14	AACG	Stock	1.08	1.09	1.06	1.09	11500.0
2020-09-14	AACQ-DELISTED	Stock	10.05	10.1	9.95	10.0	45538.0
2020-09-14	AACQU-DELISTED	Stock	10.31	10.5	10.31	10.43	313786.0
2020-09-14	AACQW-DELISTED	Stock	1.8	1.8	1.59	1.6	1044604.0
2020-09-14	AAIC-DELISTED	Stock	2.68	2.745	2.665	2.71	268262.0
2020-09-14	AAIC.C-DELISTED	Stock	19.65	19.65	18.95	19.2	3352.0
2020-09-14	AAL	Stock	13.02	13.29	12.9	13.26	39859100.0
2020-09-14	AAM.A-DELISTED	Stock	26.48	26.48	26.43	26.45	10584.0
2020-09-14	AAM.B-DELISTED	Stock	27.265	27.28	27.01	27.1075	10609.0
2020-09-14	AAMC-DELISTED	Stock	6.5029	6.9118	6.5029	6.6882	15630.0
2020-09-14	AAME	Stock	2.0	2.0	1.93	2.0	10900.0
2020-09-14	AAMI	Stock	13.2	13.39	13.15	13.31	393100.0
2020-09-14	AAOI	Stock	9.84	10.32	9.73	10.21	545300.0
2020-09-14	AAON	Stock	37.8133	37.96	37.56	37.76	361650.0
2020-09-14	AAP	Stock	156.9	158.92	156.13	157.31	785900.0
2020-09-14	AAT	Stock	24.83	25.61	24.77	25.48	512000.0
2020-09-14	AAU-DELISTED	Stock	0.8	0.8963	0.7801	0.8751	1710557.0
2020-09-14	AAUAF-DELISTED	Stock	0.8	0.8963	0.7801	0.885	1786252.0
2020-09-14	AAWW-DELISTED	Stock	57.45	57.8499	56.76	57.76	184607.0
2020-09-14	AAXJ	Stock	77.44	77.76	77.39	77.64	634750.0
2020-09-14	AAXN-DELISTED	Stock	84.26	85.44	82.82	83.84	281488.0
2020-09-14	AB	Stock	27.51	27.62	27.1	27.3	339900.0
2020-09-14	ABB-DELISTED	Stock	26.36	26.45	26.15	26.15	784614.0
2020-09-14	ABBNY-DELISTED	Stock	26.35	26.45	26.15	26.15	848262.0
2020-09-14	ABBV	Stock	90.05	91.26	89.46	90.49	5212300.0
2020-09-14	ABC-DELISTED	Stock	94.5	95.065	92.6406	94.6	814450.0
2020-09-14	ABCB	Stock	23.56	24.3	23.56	23.99	191800.0
2020-09-14	ABEO	Stock	49.0	49.75	48.0	49.75	35568.0
2020-09-14	ABEV	Stock	2.33	2.4	2.3	2.39	19561500.0
2020-09-14	ABG	Stock	105.24	107.81	104.61	107.44	107300.0
2020-09-14	ABM	Stock	36.45	37.15	36.1	36.71	284900.0
2020-09-14	ABMD-DELISTED	Stock	272.75	280.605	272.38	275.94	197610.0
2020-09-14	ABR	Stock	11.5	11.98	11.45	11.82	1436000.0
2020-09-14	ABR.A-DELISTED	Stock	25.5762	25.5762	25.2001	25.47	8260.0
2020-09-14	ABR.B-DELISTED	Stock	25.13	25.2304	25.0359	25.0899	4070.0
2020-09-14	ABR.C-DELISTED	Stock	25.5	25.5	25.28	25.4415	3388.0
2020-09-14	ABT	Stock	105.59	106.66	105.12	105.69	3824100.0
2020-09-14	ABTC	Stock	138900.0	141000.0	135300.0	137100.0	2.0533333333333332

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

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