PREVIEW / stock_daily / 2020-05-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-15.parquet
  size:    215 KB
  rows:    6,545
  symbols: 2,319

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-15	AAPL	Stock	75.0875	76.975	75.0525	76.9275	166348400.0
2020-05-15	MSFT	Stock	179.06	187.06	177.0	183.16	46610400.0
2020-05-15	NVDA	Stock	7.8898	8.5005	7.874	8.4908	987660000.0
2020-05-15	AMZN	Stock	118.426	120.55	117.8185	120.489	84700000.0
2020-05-15	GOOGL	Stock	67.413	68.729	66.95	68.653	41543980.0
2020-05-15	META	Stock	205.27	211.34	204.12	210.88	19383200.0
2020-05-15	TSLA	Stock	52.69	53.67	52.4367	53.278	157776000.0
2020-05-15	TLT	Stock	168.3	168.49	166.33	166.71	7225634.0
2020-05-15	ES	Stock	76.0	76.78	74.36	76.39	4749300.0
2020-05-15	CL	Stock	66.77	68.97	66.4	68.95	7939700.0
2020-05-15	A	Stock	81.51	82.83	81.22	81.59	4529400.0
2020-05-15	AA	Stock	6.7	6.93	6.62	6.66	6718500.0
2020-05-15	AACG	Stock	0.82	0.85	0.7	0.71	32700.0
2020-05-15	AAIC-DELISTED	Stock	2.36	2.39	2.1999	2.24	512942.0
2020-05-15	AAIC.C-DELISTED	Stock	16.61	16.61	16.25	16.25	459.0
2020-05-15	AAL	Stock	8.85	9.36	8.76	9.04	39560500.0
2020-05-15	AAM.A-DELISTED	Stock	25.75	25.79	25.5	25.64	3806.0
2020-05-15	AAM.B-DELISTED	Stock	25.63	25.74	25.36	25.62	11434.0
2020-05-15	AAMC-DELISTED	Stock	4.7059	4.7059	4.4941	4.6529	2961.0
2020-05-15	AAMI	Stock	7.75	7.91	7.65	7.8	385200.0
2020-05-15	AAOI	Stock	8.31	8.4	8.09	8.15	556100.0
2020-05-15	AAON	Stock	31.7	31.9133	30.74	31.8333	395250.0
2020-05-15	AAP	Stock	119.91	127.03	118.73	126.06	1307700.0
2020-05-15	AAT	Stock	24.41	24.64	23.61	24.38	823900.0
2020-05-15	AAU-DELISTED	Stock	0.41	0.44	0.4044	0.4375	446573.0
2020-05-15	AAUAF-DELISTED	Stock	0.41	0.44	0.4044	0.4375	459035.0
2020-05-15	AAWW-DELISTED	Stock	37.15	37.34	35.36	35.52	405306.0
2020-05-15	AAXJ	Stock	63.04	63.36	62.85	63.21	604418.0
2020-05-15	AAXN-DELISTED	Stock	75.17	77.75	73.62	73.91	422062.0
2020-05-15	AB	Stock	21.25	22.12	20.91	21.27	347200.0
2020-05-15	ABB-DELISTED	Stock	17.57	17.7183	17.495	17.66	1752423.0
2020-05-15	ABBNY-DELISTED	Stock	17.57	17.7183	17.495	17.66	1865794.0
2020-05-15	ABBV	Stock	90.01	91.15	89.42	90.71	14071200.0
2020-05-15	ABC-DELISTED	Stock	83.36	85.82	83.05	85.74	1378478.0
2020-05-15	ABCB	Stock	18.78	19.55	18.39	19.36	869500.0
2020-05-15	ABEO	Stock	79.0	79.5	75.0	76.25	52444.0
2020-05-15	ABEV	Stock	2.02	2.08	1.98	2.02	31640900.0
2020-05-15	ABG	Stock	60.2	62.35	59.74	62.3	155300.0
2020-05-15	ABM	Stock	30.28	31.6	29.76	31.57	609500.0
2020-05-15	ABMD-DELISTED	Stock	183.15	187.58	182.018	184.87	153768.0
2020-05-15	ABR	Stock	6.33	6.61	6.25	6.46	1848800.0
2020-05-15	ABR.B-DELISTED	Stock	23.005	23.51	22.405	22.405	2080.0
2020-05-15	ABR.C-DELISTED	Stock	23.41	24.4533	23.41	24.4	3210.0
2020-05-15	ABT	Stock	89.96	91.16	88.79	89.89	13609400.0
2020-05-15	ABTC	Stock	208800.0	219000.0	204000.0	218400.0	1.04
2020-05-15	ABTS	Stock	9.99	10.515	8.25	9.33	5693.0
2020-05-15	ABTX-DELISTED	Stock	22.61	22.88	21.69	22.35	562746.0
2020-05-15	ABUS	Stock	1.86	2.19	1.86	2.1	1981800.0
2020-05-15	ACA	Stock	32.03	32.42	31.58	32.3	236448.0
2020-05-15	ACAD	Stock	47.45	50.85	46.99	50.83	1280800.0

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

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