PREVIEW / stock_daily / 2020-02-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-21.parquet
  size:    222 KB
  rows:    6,577
  symbols: 2,376

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-21	AAPL	Stock	79.655	80.1125	77.625	78.2625	129554000.0
2020-02-21	MSFT	Stock	183.17	183.5	177.25	178.59	48572600.0
2020-02-21	NVDA	Stock	7.6048	7.63	7.2665	7.3518	768180000.0
2020-02-21	AMZN	Stock	107.1075	107.2275	104.4	104.7985	92926000.0
2020-02-21	GOOGL	Stock	75.229	75.5472	73.9245	74.173	42536860.0
2020-02-21	META	Stock	213.48	214.24	208.83	210.18	14092300.0
2020-02-21	TSLA	Stock	60.4653	60.8707	58.6967	60.0667	214722000.0
2020-02-21	TLT	Stock	147.8	148.88	147.65	148.04	13861573.0
2020-02-21	ES	Stock	95.72	97.24	95.46	95.96	2462300.0
2020-02-21	CL	Stock	75.19	76.54	75.11	76.27	5341500.0
2020-02-21	A	Stock	83.9	85.09	83.4	85.07	1762500.0
2020-02-21	AA	Stock	16.01	16.299	15.92	16.1	5528200.0
2020-02-21	AACG	Stock	1.22	1.22	1.11	1.11	17500.0
2020-02-21	AAIC-DELISTED	Stock	6.7	6.77	6.621	6.65	472757.0
2020-02-21	AAIC.C-DELISTED	Stock	23.5404	23.7897	23.4127	23.56	19542.0
2020-02-21	AAL	Stock	28.12	28.3	27.17	27.82	11253600.0
2020-02-21	AAM.A-DELISTED	Stock	27.0558	27.0558	26.88	26.88	22472.0
2020-02-21	AAM.B-DELISTED	Stock	27.7	27.7	27.44	27.449	12879.0
2020-02-21	AAMC-DELISTED	Stock	6.3235	6.8735	5.9765	6.4324	65402.0
2020-02-21	AAME	Stock	2.61	2.61	2.57	2.6	1200.0
2020-02-21	AAMI	Stock	10.87	10.96	10.64	10.95	655200.0
2020-02-21	AAOI	Stock	11.7	11.7	10.874	11.28	1419700.0
2020-02-21	AAON	Stock	37.5667	37.5667	36.82	36.8333	208800.0
2020-02-21	AAP	Stock	141.62	142.13	139.87	140.61	791800.0
2020-02-21	AAT	Stock	45.49	45.68	45.3	45.5	360900.0
2020-02-21	AAU-DELISTED	Stock	0.435	0.4558	0.431	0.454	572894.0
2020-02-21	AAUAF-DELISTED	Stock	0.435	0.4558	0.431	0.454	592871.0
2020-02-21	AAWW-DELISTED	Stock	32.84	32.96	31.48	31.76	539843.0
2020-02-21	AAXJ	Stock	71.8	71.9	71.4	71.47	1372416.0
2020-02-21	AAXN-DELISTED	Stock	86.74	87.09	84.61	85.93	339051.0
2020-02-21	AB	Stock	34.75	34.84	34.04	34.1	531100.0
2020-02-21	ABB-DELISTED	Stock	24.06	24.08	23.9	24.0	1328617.0
2020-02-21	ABBNY-DELISTED	Stock	24.06	24.08	23.9	23.99	1423949.0
2020-02-21	ABBV	Stock	93.96	95.52	93.38	94.96	6676000.0
2020-02-21	ABC-DELISTED	Stock	96.15	97.39	95.3	97.0	881859.0
2020-02-21	ABCB	Stock	40.93	40.93	40.25	40.31	828000.0
2020-02-21	ABEO	Stock	100.75	108.5	98.0	101.25	76260.0
2020-02-21	ABEV	Stock	3.6	3.68	3.59	3.67	37231200.0
2020-02-21	ABG	Stock	99.89	100.47	99.05	99.49	179000.0
2020-02-21	ABM	Stock	38.9	39.1	38.42	38.42	828800.0
2020-02-21	ABMD-DELISTED	Stock	167.39	168.02	164.8747	166.74	313672.0
2020-02-21	ABR	Stock	14.75	14.84	14.67	14.8	856100.0
2020-02-21	ABR.A-DELISTED	Stock	26.3891	26.3891	26.1	26.1	350.0
2020-02-21	ABR.B-DELISTED	Stock	25.8545	25.8545	25.76	25.8	600.0
2020-02-21	ABR.C-DELISTED	Stock	26.56	26.56	26.5108	26.5108	756.0
2020-02-21	ABT	Stock	88.04	88.25	87.16	87.45	5570900.0
2020-02-21	ABTC	Stock	214200.0	223500.0	206130.0	218400.0	2.5733333333333333
2020-02-21	ABTS	Stock	26.85	27.045	26.4	26.535	400.0
2020-02-21	ABTX-DELISTED	Stock	37.8	37.8	37.24	37.66	114243.0
2020-02-21	ABUS	Stock	3.4	3.49	3.19	3.25	685300.0

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

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