PREVIEW / stock_daily / 2020-02-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-24.parquet
  size:    222 KB
  rows:    6,642
  symbols: 2,409

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-02-24	AAPL	Stock	74.315	76.045	72.3075	74.545	222195200.0
2020-02-24	MSFT	Stock	167.77	174.55	163.23	170.89	68311100.0
2020-02-24	NVDA	Stock	6.7548	7.0468	6.7	6.832	856916000.0
2020-02-24	AMZN	Stock	100.159	101.965	99.3985	100.4645	130940000.0
2020-02-24	GOOGL	Stock	71.1525	71.819	70.3395	70.993	49560780.0
2020-02-24	META	Stock	201.8	203.65	198.17	200.72	23080100.0
2020-02-24	TSLA	Stock	55.9333	57.5667	54.8133	55.586	227883000.0
2020-02-24	TLT	Stock	150.83	150.96	150.0	150.25	15929281.0
2020-02-24	ES	Stock	95.87	96.44	95.11	95.21	2160400.0
2020-02-24	CL	Stock	71.71	75.72	71.19	74.42	5584400.0
2020-02-24	A	Stock	82.22	82.59	80.02	80.5	2919200.0
2020-02-24	AA	Stock	15.21	15.42	14.978	15.36	5465700.0
2020-02-24	AACG	Stock	1.06	1.17	1.02	1.05	36100.0
2020-02-24	AAIC-DELISTED	Stock	6.58	6.6	6.5	6.58	465222.0
2020-02-24	AAIC.C-DELISTED	Stock	23.51	23.5925	23.25	23.275	20007.0
2020-02-24	AAL	Stock	25.98	26.11	25.0	25.45	21713200.0
2020-02-24	AAM.A-DELISTED	Stock	26.81	26.89	26.7441	26.79	24260.0
2020-02-24	AAM.B-DELISTED	Stock	27.4388	27.45	27.29	27.3	12209.0
2020-02-24	AAMC-DELISTED	Stock	5.8647	8.0176	5.7176	7.6441	121601.0
2020-02-24	AAME	Stock	2.55	2.55	2.53	2.53	700.0
2020-02-24	AAMI	Stock	10.42	10.67	10.32	10.6	807800.0
2020-02-24	AAOI	Stock	10.54	10.75	10.42	10.585	725600.0
2020-02-24	AAON	Stock	35.5333	36.1467	35.5067	35.84	216000.0
2020-02-24	AAP	Stock	137.42	140.84	136.56	139.91	1199400.0
2020-02-24	AAT	Stock	44.77	45.57	44.77	45.28	249300.0
2020-02-24	AAU-DELISTED	Stock	0.461	0.4885	0.425	0.4283	575070.0
2020-02-24	AAUAF-DELISTED	Stock	0.461	0.4885	0.425	0.4283	615124.0
2020-02-24	AAWW-DELISTED	Stock	30.04	30.17	28.53	28.71	752499.0
2020-02-24	AAXJ	Stock	68.67	69.435	68.67	68.98	1900616.0
2020-02-24	AAXN-DELISTED	Stock	79.74	84.81	77.95	82.35	723414.0
2020-02-24	AB	Stock	33.1	33.3	31.81	33.02	625000.0
2020-02-24	ABB-DELISTED	Stock	22.71	22.9673	22.66	22.8	2193692.0
2020-02-24	ABBNY-DELISTED	Stock	22.71	22.9673	22.66	22.8	2321520.0
2020-02-24	ABBV	Stock	92.17	93.87	92.15	93.14	10705100.0
2020-02-24	ABC-DELISTED	Stock	94.72	96.04	94.0	94.94	1244253.0
2020-02-24	ABCB	Stock	39.11	39.74	38.83	39.48	298400.0
2020-02-24	ABEO	Stock	94.25	99.75	90.5	97.75	53972.0
2020-02-24	ABEV	Stock	3.59	3.63	3.57	3.58	40853900.0
2020-02-24	ABG	Stock	96.05	98.58	95.89	97.9	235200.0
2020-02-24	ABM	Stock	37.08	37.5	36.8	37.27	257000.0
2020-02-24	ABMD-DELISTED	Stock	163.88	166.27	160.7289	165.39	552401.0
2020-02-24	ABR	Stock	14.66	14.68	14.15	14.44	1998200.0
2020-02-24	ABR.A-DELISTED	Stock	26.38	26.45	26.1	26.1	10380.0
2020-02-24	ABR.B-DELISTED	Stock	25.89	25.89	25.76	25.76	2853.0
2020-02-24	ABR.C-DELISTED	Stock	28.0	28.0	26.6208	26.75	14816.0
2020-02-24	ABT	Stock	85.45	85.67	84.07	84.63	5667200.0
2020-02-24	ABTC	Stock	214800.0	216900.0	196800.0	213600.0	2.9733333333333336
2020-02-24	ABTS	Stock	27.6	29.4	19.8	25.5	933.0
2020-02-24	ABTX-DELISTED	Stock	36.78	36.9	36.45	36.76	38957.0
2020-02-24	ABUS	Stock	3.1	3.1	2.64	3.03	755100.0

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

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