PREVIEW / stock_daily / 2020-04-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-20.parquet
  size:    215 KB
  rows:    6,589
  symbols: 2,353

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-20	AAPL	Stock	69.4875	70.42	69.2125	69.2325	130015200.0
2020-04-20	MSFT	Stock	176.63	178.75	174.99	175.06	36669600.0
2020-04-20	NVDA	Stock	7.181	7.3375	7.1318	7.1762	449388000.0
2020-04-20	AMZN	Stock	119.4975	122.249	119.3025	119.6805	115414000.0
2020-04-20	GOOGL	Stock	63.4945	63.841	62.822	63.0575	35292160.0
2020-04-20	META	Stock	177.41	180.5	176.77	178.24	16110700.0
2020-04-20	TSLA	Stock	48.8467	51.038	47.4807	49.7573	221199000.0
2020-04-20	TLT	Stock	168.44	169.29	167.96	169.16	6462639.0
2020-04-20	ES	Stock	92.02	93.5	87.53	87.77	1996300.0
2020-04-20	CL	Stock	72.93	73.31	72.13	72.16	3187400.0
2020-04-20	A	Stock	79.05	79.05	76.98	77.37	1679400.0
2020-04-20	AA	Stock	7.27	7.869	7.26	7.45	7393600.0
2020-04-20	AACG	Stock	0.83	0.85	0.83	0.83	3000.0
2020-04-20	AAIC-DELISTED	Stock	2.65	2.79	2.59	2.69	351604.0
2020-04-20	AAIC.C-DELISTED	Stock	17.09	17.1735	16.63	16.86	7570.0
2020-04-20	AAL	Stock	11.15	11.35	10.72	11.06	58984900.0
2020-04-20	AAM.A-DELISTED	Stock	25.06	25.236	25.0	25.1	51803.0
2020-04-20	AAM.B-DELISTED	Stock	25.08	25.41	24.9498	25.4	68627.0
2020-04-20	AAMC-DELISTED	Stock	4.0941	4.1309	4.0941	4.0941	5018.0
2020-04-20	AAME	Stock	1.95	1.95	1.84	1.85	900.0
2020-04-20	AAMI	Stock	5.29	5.39	5.05	5.23	520000.0
2020-04-20	AAOI	Stock	8.3	8.652	8.21	8.37	673300.0
2020-04-20	AAON	Stock	31.6667	31.6667	30.1733	30.92	321600.0
2020-04-20	AAP	Stock	116.83	117.98	115.08	115.4	941400.0
2020-04-20	AAT	Stock	25.61	26.46	25.3	25.55	203300.0
2020-04-20	AAU-DELISTED	Stock	0.38	0.388	0.3602	0.3649	265839.0
2020-04-20	AAUAF-DELISTED	Stock	0.38	0.388	0.3602	0.3656	276783.0
2020-04-20	AAWW-DELISTED	Stock	24.1	24.83	23.55	24.66	452368.0
2020-04-20	AAXJ	Stock	63.22	63.7199	62.94	63.03	940476.0
2020-04-20	AAXN-DELISTED	Stock	74.48	80.16	74.38	76.67	1356697.0
2020-04-20	AB	Stock	20.05	21.1	20.02	20.14	362900.0
2020-04-20	ABB-DELISTED	Stock	17.47	17.83	17.4	17.5	1638707.0
2020-04-20	ABBNY-DELISTED	Stock	17.47	17.83	17.4	17.5	1769654.0
2020-04-20	ABBV	Stock	83.54	85.33	82.63	83.99	9126300.0
2020-04-20	ABC-DELISTED	Stock	87.99	90.11	87.1	89.63	840518.0
2020-04-20	ABCB	Stock	21.88	23.12	21.59	22.15	340900.0
2020-04-20	ABEO	Stock	57.5	63.75	57.0	62.75	40412.0
2020-04-20	ABEV	Stock	2.2	2.25	2.16	2.24	20430600.0
2020-04-20	ABG	Stock	56.9	56.9	54.73	54.82	211300.0
2020-04-20	ABM	Stock	32.24	32.85	30.59	30.69	543300.0
2020-04-20	ABMD-DELISTED	Stock	166.0	170.18	163.9825	166.205	218938.0
2020-04-20	ABR	Stock	6.35	6.45	6.0	6.04	2570400.0
2020-04-20	ABR.A-DELISTED	Stock	21.23	21.23	20.02	20.74	1848.0
2020-04-20	ABR.B-DELISTED	Stock	19.79	19.8935	18.82	19.7	5010.0
2020-04-20	ABR.C-DELISTED	Stock	20.65	21.6237	20.3536	20.7	15615.0
2020-04-20	ABT	Stock	94.82	100.0	94.65	98.0	17251400.0
2020-04-20	ABTC	Stock	237000.0	264900.0	205800.0	216300.0	7.6
2020-04-20	ABTS	Stock	13.35	13.35	10.95	13.08	700.0
2020-04-20	ABTX-DELISTED	Stock	22.4	23.28	21.86	22.36	50747.0
2020-04-20	ABUS	Stock	1.19	1.25	1.16	1.24	756700.0

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

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