PREVIEW / stock_daily / 2020-02-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-18.parquet
  size:    221 KB
  rows:    6,580
  symbols: 2,375

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-18	AAPL	Stock	78.84	79.9375	78.6525	79.75	152531200.0
2020-02-18	MSFT	Stock	185.61	187.7	185.5	187.23	27792200.0
2020-02-18	NVDA	Stock	7.141	7.4328	7.1215	7.4142	620164000.0
2020-02-18	AMZN	Stock	106.251	108.3035	106.2055	107.7835	58912000.0
2020-02-18	GOOGL	Stock	75.717	76.5278	75.5505	75.972	25680220.0
2020-02-18	META	Stock	213.55	217.98	213.4	217.8	15609200.0
2020-02-18	TSLA	Stock	56.1067	57.3333	55.4907	57.2267	245725500.0
2020-02-18	TLT	Stock	145.34	146.05	144.92	145.54	6912053.0
2020-02-18	ES	Stock	94.13	94.9	93.75	94.81	1628400.0
2020-02-18	CL	Stock	76.61	76.69	76.05	76.07	4370500.0
2020-02-18	A	Stock	85.66	86.08	84.53	84.79	2872500.0
2020-02-18	AA	Stock	15.54	15.98	15.46	15.98	3164800.0
2020-02-18	AACG	Stock	1.17	1.62	1.17	1.29	71700.0
2020-02-18	AAIC-DELISTED	Stock	5.95	6.41	5.95	6.39	1277128.0
2020-02-18	AAIC.C-DELISTED	Stock	22.6	23.19	22.6	22.9899	22166.0
2020-02-18	AAL	Stock	29.04	29.35	28.49	28.63	10485100.0
2020-02-18	AAM.A-DELISTED	Stock	27.05	27.051	26.9952	27.0	9350.0
2020-02-18	AAM.B-DELISTED	Stock	27.77	27.862	27.76	27.85	13065.0
2020-02-18	AAMC-DELISTED	Stock	4.0158	4.5853	3.9099	4.4118	55719.0
2020-02-18	AAME	Stock	2.38	2.62	2.35	2.57	6800.0
2020-02-18	AAMI	Stock	10.24	10.7	10.17	10.64	471700.0
2020-02-18	AAOI	Stock	11.77	12.1	11.58	11.75	653300.0
2020-02-18	AAON	Stock	37.8	38.1733	37.1067	37.16	139350.0
2020-02-18	AAP	Stock	145.39	150.66	140.76	141.81	2881700.0
2020-02-18	AAT	Stock	46.72	46.72	45.97	46.04	156000.0
2020-02-18	AAU-DELISTED	Stock	0.445	0.445	0.43	0.437	472734.0
2020-02-18	AAUAF-DELISTED	Stock	0.445	0.445	0.43	0.4369	512203.0
2020-02-18	AAWW-DELISTED	Stock	27.1	27.79	26.93	27.59	368624.0
2020-02-18	AAXJ	Stock	72.59	72.8	72.47	72.58	921266.0
2020-02-18	AAXN-DELISTED	Stock	87.22	87.73	86.12	87.31	343885.0
2020-02-18	AB	Stock	34.76	35.61	34.57	35.34	748400.0
2020-02-18	ABB-DELISTED	Stock	24.17	24.235	24.1	24.17	1071578.0
2020-02-18	ABBNY-DELISTED	Stock	24.17	24.235	24.1	24.16	1139024.0
2020-02-18	ABBV	Stock	93.67	94.5	93.26	93.61	9406300.0
2020-02-18	ABC-DELISTED	Stock	94.29	94.89	93.14	94.31	1365678.0
2020-02-18	ABCB	Stock	40.9	41.15	39.96	40.22	267700.0
2020-02-18	ABEO	Stock	83.75	93.75	80.5	87.5	132932.0
2020-02-18	ABEV	Stock	3.75	3.75	3.63	3.63	24066000.0
2020-02-18	ABG	Stock	95.79	97.4	95.79	96.4	211600.0
2020-02-18	ABM	Stock	38.81	39.0	38.24	38.7	186200.0
2020-02-18	ABMD-DELISTED	Stock	167.22	170.91	166.51	169.12	457975.0
2020-02-18	ABR	Stock	14.8	15.07	14.71	14.8	1323100.0
2020-02-18	ABR.A-DELISTED	Stock	26.45	26.45	26.2376	26.33	5420.0
2020-02-18	ABR.B-DELISTED	Stock	25.91	25.91	25.79	25.859	2234.0
2020-02-18	ABR.C-DELISTED	Stock	26.5021	26.64	26.5	26.5	4680.0
2020-02-18	ABT	Stock	89.42	89.49	88.31	88.88	4492300.0
2020-02-18	ABTC	Stock	211500.0	213180.0	204210.0	206400.0	2.12
2020-02-18	ABTS	Stock	27.96	27.96	27.45	27.6	167.0
2020-02-18	ABTX-DELISTED	Stock	38.37	38.37	37.37	37.53	47186.0
2020-02-18	ABUS	Stock	3.29	3.48	3.26	3.4	527400.0

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

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