PREVIEW / stock_daily / 2020-04-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-24.parquet
  size:    216 KB
  rows:    6,568
  symbols: 2,329

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-04-24	AAPL	Stock	69.3	70.7525	69.25	70.7425	126161200.0
2020-04-24	MSFT	Stock	172.06	174.56	170.71	174.55	34277600.0
2020-04-24	NVDA	Stock	7.09	7.2418	7.015	7.2398	352328000.0
2020-04-24	AMZN	Stock	120.85	121.0215	119.1	120.511	76498000.0
2020-04-24	GOOGL	Stock	62.75	63.8855	62.2	63.83	37440080.0
2020-04-24	META	Stock	183.23	190.41	180.83	190.07	28792000.0
2020-04-24	TSLA	Stock	47.3873	48.7153	46.5453	48.3433	198180000.0
2020-04-24	TLT	Stock	169.61	170.84	169.57	170.84	6211804.0
2020-04-24	ES	Stock	86.72	87.18	84.77	86.57	1571700.0
2020-04-24	CL	Stock	70.75	71.91	70.6	71.4	3549700.0
2020-04-24	A	Stock	75.62	75.91	74.02	75.75	1654300.0
2020-04-24	AA	Stock	7.29	7.45	7.015	7.15	11292100.0
2020-04-24	AACG	Stock	0.81	0.81	0.75	0.75	7100.0
2020-04-24	AAIC-DELISTED	Stock	2.59	2.64	2.51	2.62	300078.0
2020-04-24	AAIC.C-DELISTED	Stock	16.81	17.1934	16.81	17.1934	719.0
2020-04-24	AAL	Stock	10.4	10.5	9.9	10.31	67118200.0
2020-04-24	AAM.A-DELISTED	Stock	25.3	25.7	25.3	25.53	17065.0
2020-04-24	AAM.B-DELISTED	Stock	25.573	25.69	25.25	25.49	17946.0
2020-04-24	AAMC-DELISTED	Stock	3.8824	4.1029	3.8824	4.1029	10832.0
2020-04-24	AAME	Stock	1.9	1.92	1.61	1.63	30500.0
2020-04-24	AAMI	Stock	6.48	6.95	6.39	6.9	937000.0
2020-04-24	AAOI	Stock	8.65	9.29	8.37	9.09	783500.0
2020-04-24	AAON	Stock	32.0	32.0133	31.1733	31.78	296100.0
2020-04-24	AAP	Stock	115.15	118.3	114.0	117.59	1011400.0
2020-04-24	AAT	Stock	26.23	26.43	25.53	25.98	308000.0
2020-04-24	AAU-DELISTED	Stock	0.39	0.411	0.3642	0.3894	303895.0
2020-04-24	AAUAF-DELISTED	Stock	0.39	0.411	0.3642	0.39	308949.0
2020-04-24	AAWW-DELISTED	Stock	27.99	29.75	27.33	29.74	402118.0
2020-04-24	AAXJ	Stock	62.81	62.81	62.22	62.75	652517.0
2020-04-24	AAXN-DELISTED	Stock	71.09	72.2	69.35	71.69	644370.0
2020-04-24	AB	Stock	19.63	20.6	19.63	20.14	319700.0
2020-04-24	ABB-DELISTED	Stock	17.28	17.485	17.125	17.42	1879750.0
2020-04-24	ABBNY-DELISTED	Stock	17.28	17.485	17.125	17.41	2083964.0
2020-04-24	ABBV	Stock	82.87	83.67	82.35	83.59	6770700.0
2020-04-24	ABC-DELISTED	Stock	87.43	89.45	85.74	88.7	813859.0
2020-04-24	ABCB	Stock	21.06	22.71	20.52	22.52	600100.0
2020-04-24	ABEO	Stock	61.0	62.0	59.0	61.5	24668.0
2020-04-24	ABEV	Stock	2.06	2.07	1.9	2.0	60959200.0
2020-04-24	ABG	Stock	54.39	59.24	54.39	58.47	309900.0
2020-04-24	ABM	Stock	31.33	31.99	30.78	31.6	479700.0
2020-04-24	ABMD-DELISTED	Stock	171.89	172.47	167.58	168.49	461533.0
2020-04-24	ABR	Stock	6.14	6.14	5.8	6.0	1580700.0
2020-04-24	ABR.A-DELISTED	Stock	21.09	21.82	20.33	21.0	3442.0
2020-04-24	ABR.B-DELISTED	Stock	21.99	21.99	19.86	19.887	4700.0
2020-04-24	ABR.C-DELISTED	Stock	21.5	21.9839	21.0	21.02	1937.0
2020-04-24	ABT	Stock	94.5	94.58	92.78	94.06	9016100.0
2020-04-24	ABTC	Stock	249000.0	261000.0	246600.0	247200.0	2.2133333333333334
2020-04-24	ABTS	Stock	11.91	11.91	11.91	11.91	53.3
2020-04-24	ABTX-DELISTED	Stock	22.52	22.87	21.97	22.62	36752.0
2020-04-24	ABUS	Stock	1.22	1.24	1.17	1.21	331300.0

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

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