PREVIEW / stock_daily / 2020-05-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-04.parquet
  size:    214 KB
  rows:    6,560
  symbols: 2,332

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-05-04	AAPL	Stock	72.2925	73.4225	71.58	73.29	133568000.0
2020-05-04	MSFT	Stock	174.49	179.0	173.8	178.84	30372900.0
2020-05-04	NVDA	Stock	7.022	7.296	7.022	7.2823	317556000.0
2020-05-04	AMZN	Stock	112.819	116.349	112.819	115.7995	97318000.0
2020-05-04	GOOGL	Stock	65.4065	66.2235	64.8005	66.145	30806940.0
2020-05-04	META	Stock	200.2	205.91	198.76	205.26	19250700.0
2020-05-04	TSLA	Stock	46.7333	50.8	46.5333	50.746	288556500.0
2020-05-04	TLT	Stock	167.56	167.68	166.48	167.16	8300923.0
2020-05-04	ES	Stock	80.31	81.28	79.38	80.8	1255900.0
2020-05-04	CL	Stock	68.65	69.86	68.02	69.48	5031500.0
2020-05-04	A	Stock	74.28	74.62	73.42	74.56	1555400.0
2020-05-04	AA	Stock	7.52	7.9	7.34	7.8	6870700.0
2020-05-04	AACG	Stock	0.74	0.74	0.7	0.71	11300.0
2020-05-04	AAIC-DELISTED	Stock	2.68	2.75	2.55	2.64	263178.0
2020-05-04	AAIC.C-DELISTED	Stock	17.39	17.39	16.9	17.31	1333.0
2020-05-04	AAL	Stock	9.41	10.17	9.15	9.82	125580000.0
2020-05-04	AAM.A-DELISTED	Stock	25.77	25.86	25.6426	25.85	19134.0
2020-05-04	AAM.B-DELISTED	Stock	25.58	25.77	25.5	25.77	22116.0
2020-05-04	AAMC-DELISTED	Stock	4.823	5.5647	4.7059	4.7206	70105.0
2020-05-04	AAME	Stock	1.8	1.8	1.72	1.77	900.0
2020-05-04	AAMI	Stock	7.29	7.605	7.2	7.53	518900.0
2020-05-04	AAOI	Stock	10.01	10.54	9.765	10.42	499000.0
2020-05-04	AAON	Stock	29.7667	31.24	29.34	30.2733	383100.0
2020-05-04	AAP	Stock	115.43	120.41	115.0	120.11	460300.0
2020-05-04	AAT	Stock	26.65	27.48	26.52	27.32	423300.0
2020-05-04	AAU-DELISTED	Stock	0.429	0.43	0.4099	0.4274	303178.0
2020-05-04	AAUAF-DELISTED	Stock	0.429	0.429	0.4099	0.4274	361884.0
2020-05-04	AAWW-DELISTED	Stock	31.73	33.09	30.53	32.88	743407.0
2020-05-04	AAXJ	Stock	62.18	62.51	61.91	62.51	586447.0
2020-05-04	AAXN-DELISTED	Stock	68.14	69.0	65.5	66.98	719624.0
2020-05-04	AB	Stock	21.68	22.59	21.33	22.54	261200.0
2020-05-04	ABB-DELISTED	Stock	17.96	18.12	17.88	18.12	1958461.0
2020-05-04	ABBNY-DELISTED	Stock	17.96	18.12	17.88	18.11	2271094.0
2020-05-04	ABBV	Stock	82.22	82.84	81.12	81.86	6833000.0
2020-05-04	ABC-DELISTED	Stock	85.97	87.05	85.31	86.42	1082909.0
2020-05-04	ABCB	Stock	23.22	24.27	22.69	24.11	349800.0
2020-05-04	ABEO	Stock	56.25	61.0	55.75	61.0	34404.0
2020-05-04	ABEV	Stock	2.03	2.16	2.02	2.15	25316900.0
2020-05-04	ABG	Stock	64.58	66.0	64.12	65.98	267900.0
2020-05-04	ABM	Stock	32.72	33.01	31.96	32.36	551200.0
2020-05-04	ABMD-DELISTED	Stock	182.58	183.12	177.69	181.01	382433.0
2020-05-04	ABR	Stock	6.5	6.79	6.18	6.75	1936400.0
2020-05-04	ABR.A-DELISTED	Stock	23.3	23.3	22.0	22.5	3634.0
2020-05-04	ABR.B-DELISTED	Stock	21.07	22.0	20.81	21.8875	4350.0
2020-05-04	ABR.C-DELISTED	Stock	22.4499	23.1247	22.4499	22.95	7382.0
2020-05-04	ABT	Stock	89.79	90.16	88.71	89.83	5036800.0
2020-05-04	ABTC	Stock	211500.0	221700.0	205500.0	216300.0	2.3466666666666667
2020-05-04	ABTS	Stock	9.855	10.5	9.855	10.2	393.0
2020-05-04	ABTX-DELISTED	Stock	24.31	24.49	23.29	23.64	73213.0
2020-05-04	ABUS	Stock	1.09	1.25	1.07	1.21	878600.0

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

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