PREVIEW / stock_daily / 2020-03-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-06.parquet
  size:    220 KB
  rows:    6,613
  symbols: 2,376

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-03-06	AAPL	Stock	70.5	72.705	70.3075	72.2575	226176800.0
2020-03-06	MSFT	Stock	162.61	163.11	156.0	161.57	72821100.0
2020-03-06	NVDA	Stock	6.652	6.7098	6.45	6.651	515412000.0
2020-03-06	AMZN	Stock	93.75	95.5435	93.475	95.0545	105472000.0
2020-03-06	GOOGL	Stock	63.4975	65.1375	62.8605	64.787	64646300.0
2020-03-06	META	Stock	178.33	183.78	176.26	181.09	24559600.0
2020-03-06	TSLA	Stock	46.0	47.1333	45.618	46.8987	189943500.0
2020-03-06	TLT	Stock	167.3	169.33	164.11	166.77	76288337.0
2020-03-06	ES	Stock	95.19	96.81	93.3	96.36	2262700.0
2020-03-06	CL	Stock	70.37	72.76	69.51	72.51	6339600.0
2020-03-06	A	Stock	77.95	78.9	76.5	78.56	2959900.0
2020-03-06	AA	Stock	11.36	11.77	10.8	11.01	10566400.0
2020-03-06	AACG	Stock	0.96	1.01	0.96	1.0	8900.0
2020-03-06	AAIC-DELISTED	Stock	5.69	5.72	5.485	5.62	647690.0
2020-03-06	AAIC.C-DELISTED	Stock	21.95	22.32	20.99	22.3	14961.0
2020-03-06	AAL	Stock	15.02	17.12	14.8	15.97	54505000.0
2020-03-06	AAM.A-DELISTED	Stock	25.86	26.2	25.85	26.06	21671.0
2020-03-06	AAM.B-DELISTED	Stock	26.75	26.83	26.5	26.75	43235.0
2020-03-06	AAMC-DELISTED	Stock	6.4706	7.0588	5.8824	7.0412	8789.0
2020-03-06	AAME	Stock	2.52	2.52	2.5	2.5	700.0
2020-03-06	AAMI	Stock	7.67	8.05	7.375	7.48	489800.0
2020-03-06	AAOI	Stock	8.75	8.94	8.535	8.79	800700.0
2020-03-06	AAON	Stock	37.74	39.4933	37.7333	39.3133	373800.0
2020-03-06	AAP	Stock	123.81	128.48	121.51	127.91	1207800.0
2020-03-06	AAT	Stock	41.25	41.88	40.04	41.28	372100.0
2020-03-06	AAU-DELISTED	Stock	0.39	0.3987	0.365	0.3681	352696.0
2020-03-06	AAUAF-DELISTED	Stock	0.39	0.3987	0.365	0.3684	366525.0
2020-03-06	AAWW-DELISTED	Stock	23.77	23.895	22.23	22.86	820861.0
2020-03-06	AAXJ	Stock	68.18	68.36	67.43	68.09	1706291.0
2020-03-06	AAXN-DELISTED	Stock	72.46	75.64	71.55	74.45	596331.0
2020-03-06	AB	Stock	29.85	30.72	29.6	30.51	688300.0
2020-03-06	ABB-DELISTED	Stock	20.9	21.2	20.7508	21.025	2422397.0
2020-03-06	ABBNY-DELISTED	Stock	20.9	21.2	20.7508	21.02	2586702.0
2020-03-06	ABBV	Stock	88.73	89.76	87.26	88.82	12664600.0
2020-03-06	ABC-DELISTED	Stock	84.29	86.23	83.39	85.82	1344910.0
2020-03-06	ABCB	Stock	32.73	33.5	31.72	32.3	761100.0
2020-03-06	ABEO	Stock	72.0	72.5	66.5	68.0	77616.0
2020-03-06	ABEV	Stock	3.25	3.36	3.24	3.33	84144100.0
2020-03-06	ABG	Stock	85.11	87.36	84.42	87.02	231500.0
2020-03-06	ABM	Stock	33.83	34.92	32.87	33.9	520500.0
2020-03-06	ABMD-DELISTED	Stock	152.04	158.17	150.89	157.08	519342.0
2020-03-06	ABR	Stock	11.9	12.47	11.71	12.09	1874300.0
2020-03-06	ABR.A-DELISTED	Stock	25.58	25.8326	25.55	25.6737	3259.0
2020-03-06	ABR.B-DELISTED	Stock	25.3	25.38	25.15	25.15	4272.0
2020-03-06	ABR.C-DELISTED	Stock	25.77	25.8864	25.65	25.65	2700.0
2020-03-06	ABT	Stock	78.6	82.3	78.09	81.74	10647600.0
2020-03-06	ABTC	Stock	219900.0	219900.0	207300.0	207300.0	1.32
2020-03-06	ABTS	Stock	17.7	17.7	16.2	17.25	740.0
2020-03-06	ABTX-DELISTED	Stock	30.88	31.42	29.72	30.16	184174.0
2020-03-06	ABUS	Stock	3.25	3.25	2.9	2.97	252000.0

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

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