PREVIEW / stock_daily / 2020-04-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-22.parquet
  size:    216 KB
  rows:    6,574
  symbols: 2,335

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-22	AAPL	Stock	68.4025	69.475	68.05	69.025	116862400.0
2020-04-22	MSFT	Stock	171.39	174.0	170.82	173.52	34620200.0
2020-04-22	NVDA	Stock	6.9308	7.1968	6.885	7.1538	483356000.0
2020-04-22	AMZN	Stock	118.45	119.7	117.55	118.1745	84244000.0
2020-04-22	GOOGL	Stock	62.0555	63.994	61.86	62.9205	46315840.0
2020-04-22	META	Stock	178.45	184.78	178.14	182.28	33242000.0
2020-04-22	TSLA	Stock	46.932	48.9333	45.914	48.8073	212482500.0
2020-04-22	TLT	Stock	169.97	170.39	168.705	169.54	6230495.0
2020-04-22	ES	Stock	88.5	89.08	87.47	88.01	1434300.0
2020-04-22	CL	Stock	71.2	71.73	70.56	71.21	3498100.0
2020-04-22	A	Stock	74.75	75.58	73.78	75.17	2347400.0
2020-04-22	AA	Stock	7.63	7.8	7.33	7.55	8429500.0
2020-04-22	AACG	Stock	0.77	0.78	0.75	0.76	16500.0
2020-04-22	AAIC-DELISTED	Stock	2.95	2.95	2.665	2.71	391245.0
2020-04-22	AAIC.C-DELISTED	Stock	17.0	17.2	16.9175	17.0	10015.0
2020-04-22	AAL	Stock	11.09	11.13	10.02	10.27	76140100.0
2020-04-22	AAM.A-DELISTED	Stock	25.12	25.62	25.11	25.22	22490.0
2020-04-22	AAM.B-DELISTED	Stock	25.2	25.74	25.11	25.2	52468.0
2020-04-22	AAMC-DELISTED	Stock	4.1506	4.1506	3.8412	3.8412	1108.0
2020-04-22	AAME	Stock	1.91	1.92	1.72	1.79	2800.0
2020-04-22	AAMI	Stock	5.56	6.21	5.43	6.15	695000.0
2020-04-22	AAOI	Stock	8.45	8.57	8.31	8.42	566800.0
2020-04-22	AAON	Stock	30.4733	30.9133	29.6067	30.3867	310350.0
2020-04-22	AAP	Stock	115.07	116.34	112.41	113.02	751200.0
2020-04-22	AAT	Stock	25.89	26.35	25.23	26.15	391200.0
2020-04-22	AAU-DELISTED	Stock	0.347	0.3745	0.34	0.373	399870.0
2020-04-22	AAUAF-DELISTED	Stock	0.347	0.3745	0.34	0.373	454702.0
2020-04-22	AAWW-DELISTED	Stock	27.22	28.8	27.12	27.76	644719.0
2020-04-22	AAXJ	Stock	62.92	63.01	62.76	62.87	556157.0
2020-04-22	AAXN-DELISTED	Stock	73.05	74.02	71.238	73.26	246142.0
2020-04-22	AB	Stock	19.7	19.92	19.32	19.66	203400.0
2020-04-22	ABB-DELISTED	Stock	17.15	17.19	16.9619	17.05	1774319.0
2020-04-22	ABBNY-DELISTED	Stock	17.15	17.19	16.9619	17.06	1933844.0
2020-04-22	ABBV	Stock	81.23	82.45	80.73	81.47	7033300.0
2020-04-22	ABC-DELISTED	Stock	86.98	88.13	86.19	86.38	696597.0
2020-04-22	ABCB	Stock	23.11	23.16	21.69	21.97	241100.0
2020-04-22	ABEO	Stock	61.5	61.5	57.75	59.75	28596.0
2020-04-22	ABEV	Stock	2.19	2.21	2.16	2.17	16706400.0
2020-04-22	ABG	Stock	53.34	54.01	50.42	52.07	293200.0
2020-04-22	ABM	Stock	30.79	31.17	30.21	30.78	336900.0
2020-04-22	ABMD-DELISTED	Stock	167.26	168.275	165.22	166.86	211850.0
2020-04-22	ABR	Stock	6.32	6.38	5.78	6.0	1716400.0
2020-04-22	ABR.A-DELISTED	Stock	20.34	22.0	20.34	21.98	3379.0
2020-04-22	ABR.B-DELISTED	Stock	20.9792	21.9366	20.85	21.9366	2100.0
2020-04-22	ABR.C-DELISTED	Stock	23.5	23.5	20.9168	22.33	5197.0
2020-04-22	ABT	Stock	94.28	95.98	92.79	95.48	8369000.0
2020-04-22	ABTC	Stock	231000.0	237000.0	227610.0	231900.0	1.6133333333333333
2020-04-22	ABTS	Stock	11.385	11.85	10.95	11.85	260.0
2020-04-22	ABTX-DELISTED	Stock	22.48	22.51	21.72	22.18	57590.0
2020-04-22	ABUS	Stock	1.21	1.22	1.16	1.17	198700.0

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

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