PREVIEW / stock_daily / 2020-04-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-03.parquet
  size:    213 KB
  rows:    6,589
  symbols: 2,350

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-03	AAPL	Stock	60.7	61.425	59.7425	60.3525	129880000.0
2020-04-03	MSFT	Stock	155.1	157.38	152.19	153.83	41243300.0
2020-04-03	NVDA	Stock	6.349	6.3908	5.9598	6.0978	663212000.0
2020-04-03	AMZN	Stock	95.5575	96.3165	94.4575	95.3295	72198000.0
2020-04-03	GOOGL	Stock	55.7355	55.9395	53.754	54.635	51373880.0
2020-04-03	META	Stock	157.15	157.91	150.83	154.18	25983300.0
2020-04-03	TSLA	Stock	33.9667	34.366	31.226	32.0007	338431500.0
2020-04-03	TLT	Stock	168.55	170.33	168.14	168.5	6570840.0
2020-04-03	ES	Stock	78.2	79.09	74.4	75.06	2394000.0
2020-04-03	CL	Stock	67.95	68.69	66.75	67.62	4720800.0
2020-04-03	A	Stock	71.71	72.33	69.66	70.42	2052600.0
2020-04-03	AA	Stock	6.05	6.28	5.78	5.97	7951900.0
2020-04-03	AACG	Stock	0.95	0.95	0.95	0.95	700.0
2020-04-03	AAIC-DELISTED	Stock	2.11	2.11	1.72	1.75	850685.0
2020-04-03	AAIC.C-DELISTED	Stock	12.69	12.69	11.685	12.15	9500.0
2020-04-03	AAL	Stock	10.34	10.49	9.09	9.39	87018900.0
2020-04-03	AAM.A-DELISTED	Stock	21.35	21.5	21.0	21.35	23480.0
2020-04-03	AAM.B-DELISTED	Stock	21.33	21.72	21.2	21.72	35658.0
2020-04-03	AAMC-DELISTED	Stock	3.6764	3.6764	3.503	3.5779	4151.0
2020-04-03	AAME	Stock	2.09	2.1	2.03	2.1	500.0
2020-04-03	AAMI	Stock	6.03	6.18	5.78	5.99	430200.0
2020-04-03	AAOI	Stock	7.69	7.84	7.06	7.45	557800.0
2020-04-03	AAON	Stock	31.8	33.0	29.2267	29.94	397800.0
2020-04-03	AAP	Stock	86.14	86.91	82.73	84.65	1148400.0
2020-04-03	AAT	Stock	22.42	22.9	20.83	21.48	322000.0
2020-04-03	AAU-DELISTED	Stock	0.27	0.318	0.27	0.2712	338108.0
2020-04-03	AAUAF-DELISTED	Stock	0.27	0.318	0.27	0.2712	360415.0
2020-04-03	AAWW-DELISTED	Stock	23.59	24.28	20.0	20.16	630260.0
2020-04-03	AAXJ	Stock	58.88	59.08	57.79	58.09	1397796.0
2020-04-03	AAXN-DELISTED	Stock	61.99	62.415	60.55	61.48	423588.0
2020-04-03	AB	Stock	18.4	18.53	17.25	17.34	321500.0
2020-04-03	ABB-DELISTED	Stock	16.69	16.79	16.23	16.47	2719507.0
2020-04-03	ABBNY-DELISTED	Stock	16.69	16.79	16.23	16.47	2906861.0
2020-04-03	ABBV	Stock	74.65	75.44	72.55	73.37	8062700.0
2020-04-03	ABC-DELISTED	Stock	83.27	84.625	80.39	81.27	1253399.0
2020-04-03	ABCB	Stock	22.7	22.96	20.32	20.66	501700.0
2020-04-03	ABEO	Stock	53.75	56.75	51.5	52.25	38628.0
2020-04-03	ABEV	Stock	2.22	2.24	2.13	2.18	28022500.0
2020-04-03	ABG	Stock	46.88	46.88	41.91	42.1	304500.0
2020-04-03	ABM	Stock	23.86	24.36	22.28	22.78	384300.0
2020-04-03	ABMD-DELISTED	Stock	142.51	145.7	140.82	141.525	296254.0
2020-04-03	ABR	Stock	4.36	4.43	3.78	4.06	3640300.0
2020-04-03	ABR.A-DELISTED	Stock	14.47	15.02	11.62	13.5	19029.0
2020-04-03	ABR.B-DELISTED	Stock	15.07	15.6848	10.29	12.55	21606.0
2020-04-03	ABR.C-DELISTED	Stock	13.5	13.75	10.0	13.0	55434.0
2020-04-03	ABT	Stock	78.79	79.99	78.18	79.45	9139400.0
2020-04-03	ABTC	Stock	164700.0	174900.0	158700.0	160500.0	1.1733333333333333
2020-04-03	ABTS	Stock	9.3	9.75	9.0	9.225	907.0
2020-04-03	ABTX-DELISTED	Stock	22.81	22.89	21.26	21.63	46061.0
2020-04-03	ABUS	Stock	1.01	1.04	0.88	0.91	1082900.0

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

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