PREVIEW / stock_daily / 2020-01-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-30.parquet
  size:    221 KB
  rows:    6,577
  symbols: 2,402

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-01-30	AAPL	Stock	80.135	81.0225	79.6875	80.9675	126743200.0
2020-01-30	MSFT	Stock	174.05	174.05	170.79	172.78	51597500.0
2020-01-30	NVDA	Stock	6.0402	6.1588	5.985	6.1453	290504000.0
2020-01-30	AMZN	Stock	92.9	93.6435	92.5305	93.534	126548000.0
2020-01-30	GOOGL	Stock	71.905	72.7625	71.75	72.7125	27109440.0
2020-01-30	META	Stock	206.53	211.43	204.75	209.53	48775500.0
2020-01-30	TSLA	Stock	42.1613	43.392	41.2	42.7207	435085500.0
2020-01-30	TLT	Stock	144.9	145.67	144.29	144.58	14711787.0
2020-01-30	ES	Stock	92.25	93.29	92.1	93.21	1508300.0
2020-01-30	CL	Stock	68.8	69.7	68.56	69.47	3539300.0
2020-01-30	A	Stock	84.9	85.03	83.6	84.38	3026700.0
2020-01-30	AA	Stock	14.28	14.41	13.81	14.29	10570700.0
2020-01-30	AACG	Stock	1.16	1.24	1.15	1.16	7000.0
2020-01-30	AAIC-DELISTED	Stock	5.73	5.795	5.68	5.71	234145.0
2020-01-30	AAIC.C-DELISTED	Stock	22.4	22.54	22.3	22.52	5168.0
2020-01-30	AAL	Stock	26.3	27.79	26.26	27.72	10685500.0
2020-01-30	AAM.A-DELISTED	Stock	26.8	26.93	26.7983	26.868	24885.0
2020-01-30	AAM.B-DELISTED	Stock	27.37	27.37	27.27	27.31	18762.0
2020-01-30	AAMC-DELISTED	Stock	3.8882	3.9059	3.8037	3.8794	4444.0
2020-01-30	AAME	Stock	1.86	2.22	1.86	2.11	2200.0
2020-01-30	AAMI	Stock	9.35	9.49	9.26	9.43	311200.0
2020-01-30	AAOI	Stock	11.74	11.88	11.2	11.65	984300.0
2020-01-30	AAON	Stock	35.44	36.2267	35.44	36.1867	133200.0
2020-01-30	AAP	Stock	136.95	137.48	133.43	135.27	1018300.0
2020-01-30	AAT	Stock	46.87	47.21	46.37	46.63	250000.0
2020-01-30	AAU-DELISTED	Stock	0.505	0.515	0.495	0.5009	124741.0
2020-01-30	AAUAF-DELISTED	Stock	0.505	0.515	0.495	0.5082	127277.0
2020-01-30	AAWW-DELISTED	Stock	23.06	23.4	22.77	22.98	482497.0
2020-01-30	AAXJ	Stock	69.88	70.45	69.52	70.37	1646176.0
2020-01-30	AAXN-DELISTED	Stock	79.2	80.04	77.14	78.34	242217.0
2020-01-30	AB	Stock	33.7	33.84	33.25	33.55	174400.0
2020-01-30	ABB-DELISTED	Stock	23.4	23.62	23.3	23.6	1488288.0
2020-01-30	ABBNY-DELISTED	Stock	23.4	23.62	23.3	23.6	1567732.0
2020-01-30	ABBV	Stock	82.58	82.79	81.18	81.78	10870000.0
2020-01-30	ABC-DELISTED	Stock	89.33	92.36	86.9	88.88	1717648.0
2020-01-30	ABCB	Stock	40.26	41.51	40.05	41.13	305100.0
2020-01-30	ABDC-DELISTED	Stock	9.48	9.48	9.17	9.2	117584.0
2020-01-30	ABEO	Stock	58.75	60.25	57.5	59.25	31128.0
2020-01-30	ABEV	Stock	4.24	4.27	4.17	4.27	22839200.0
2020-01-30	ABG	Stock	98.28	99.7	98.01	99.43	107300.0
2020-01-30	ABM	Stock	38.7	39.05	38.26	38.88	170500.0
2020-01-30	ABMD-DELISTED	Stock	187.7	189.4	183.66	186.88	360956.0
2020-01-30	ABR	Stock	15.09	15.2	15.01	15.2	480700.0
2020-01-30	ABR.A-DELISTED	Stock	26.4	26.4	26.3	26.3	932.0
2020-01-30	ABR.B-DELISTED	Stock	26.1352	26.1352	26.1352	26.1352	200.0
2020-01-30	ABR.C-DELISTED	Stock	26.5675	26.65	26.55	26.65	776.0
2020-01-30	ABT	Stock	88.29	89.21	87.97	89.16	5248100.0
2020-01-30	ABTC	Stock	249300.0	253200.0	231000.0	235800.0	3.893333333333333
2020-01-30	ABTX-DELISTED	Stock	37.56	37.99	37.39	37.95	86525.0
2020-01-30	ABUS	Stock	2.86	2.86	2.64	2.79	493000.0

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

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