PREVIEW / stock_daily / 2020-08-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-12.parquet
  size:    224 KB
  rows:    6,765
  symbols: 2,396

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-08-12	AAPL	Stock	110.4975	113.275	110.2975	113.01	165598000.0
2020-08-12	MSFT	Stock	205.29	210.28	204.75	209.19	28013100.0
2020-08-12	NVDA	Stock	10.9908	11.467	10.9582	11.4402	464412000.0
2020-08-12	AMZN	Stock	155.4	158.7195	155.071	158.112	70442000.0
2020-08-12	GOOGL	Stock	74.3562	75.5835	74.25	75.362	22531200.0
2020-08-12	META	Stock	258.97	263.9	258.11	259.89	21415700.0
2020-08-12	TSLA	Stock	98.0	105.6667	95.6667	103.6507	327441000.0
2020-08-12	TLT	Stock	165.7	166.065	164.99	165.59	11745839.0
2020-08-12	ES	Stock	86.58	88.35	86.4	87.91	1255500.0
2020-08-12	CL	Stock	76.36	77.78	76.26	77.24	3844300.0
2020-08-12	A	Stock	96.66	98.28	96.52	97.63	1318100.0
2020-08-12	AA	Stock	15.27	15.415	14.82	14.96	3986500.0
2020-08-12	AACG	Stock	1.24	1.24	1.05	1.1	50600.0
2020-08-12	AACQU-DELISTED	Stock	10.15	10.17	10.11	10.15	411509.0
2020-08-12	AAIC-DELISTED	Stock	2.86	2.88	2.8	2.84	192686.0
2020-08-12	AAIC.C-DELISTED	Stock	19.4	19.4	19.4	19.4	195.0
2020-08-12	AAL	Stock	14.03	14.06	13.1	13.54	77379800.0
2020-08-12	AAM.A-DELISTED	Stock	27.09	27.09	27.0	27.01	4514.0
2020-08-12	AAM.B-DELISTED	Stock	27.38	27.45	27.35	27.45	5172.0
2020-08-12	AAMC-DELISTED	Stock	4.4412	4.7353	4.0735	4.1324	17347.0
2020-08-12	AAME	Stock	1.99	2.07	1.87	2.0	30900.0
2020-08-12	AAMI	Stock	13.78	13.98	13.655	13.89	704700.0
2020-08-12	AAOI	Stock	13.69	13.89	13.2	13.38	786500.0
2020-08-12	AAON	Stock	40.3133	40.4267	39.38	39.7267	282750.0
2020-08-12	AAP	Stock	153.58	156.0	153.45	154.28	681500.0
2020-08-12	AAT	Stock	28.19	28.28	27.37	27.66	255500.0
2020-08-12	AAU-DELISTED	Stock	0.7	0.7	0.67	0.6802	400340.0
2020-08-12	AAUAF-DELISTED	Stock	0.7	0.7	0.67	0.6831	430699.0
2020-08-12	AAWW-DELISTED	Stock	60.2	61.66	59.64	60.03	427664.0
2020-08-12	AAXJ	Stock	76.81	77.435	76.72	77.2	725903.0
2020-08-12	AAXN-DELISTED	Stock	79.6	80.1406	78.28	79.72	708632.0
2020-08-12	AB	Stock	28.61	29.0	28.22	28.94	328500.0
2020-08-12	ABB-DELISTED	Stock	26.46	26.66	26.365	26.525	978312.0
2020-08-12	ABBNY-DELISTED	Stock	26.46	26.66	26.365	26.53	1039276.0
2020-08-12	ABBV	Stock	93.45	95.58	93.33	95.51	7705600.0
2020-08-12	ABC-DELISTED	Stock	101.85	104.1	101.85	103.56	452131.0
2020-08-12	ABCB	Stock	27.43	27.43	25.85	26.45	237300.0
2020-08-12	ABEO	Stock	73.75	76.0	72.25	72.75	20036.0
2020-08-12	ABEV	Stock	2.49	2.51	2.4	2.49	25248100.0
2020-08-12	ABG	Stock	106.91	112.12	106.91	110.51	236500.0
2020-08-12	ABM	Stock	39.79	39.85	38.39	38.59	328400.0
2020-08-12	ABMD-DELISTED	Stock	294.85	307.24	294.85	302.08	131558.0
2020-08-12	ABR	Stock	11.84	11.94	11.72	11.83	1606900.0
2020-08-12	ABR.A-DELISTED	Stock	26.01	26.15	25.25	25.47	20590.0
2020-08-12	ABR.B-DELISTED	Stock	25.345	25.7	25.2999	25.7	3449.0
2020-08-12	ABR.C-DELISTED	Stock	26.236	26.72	25.95	26.42	4535.0
2020-08-12	ABT	Stock	99.55	101.1	99.32	100.65	2668900.0
2020-08-12	ABTC	Stock	186300.0	191400.0	177900.0	181500.0	2.0533333333333332
2020-08-12	ABTS	Stock	22.5	26.85	22.26	26.55	78080.0
2020-08-12	ABTX-DELISTED	Stock	27.75	27.75	26.36	26.93	25431.0

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

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