PREVIEW / stock_daily / 2020-02-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-19.parquet
  size:    222 KB
  rows:    6,614
  symbols: 2,398

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-19	AAPL	Stock	80.0	81.1425	80.0	80.905	93984000.0
2020-02-19	MSFT	Stock	188.06	188.18	186.47	187.28	29997500.0
2020-02-19	NVDA	Stock	7.5372	7.8853	7.5372	7.8675	694332000.0
2020-02-19	AMZN	Stock	108.39	109.255	108.056	108.511	51224000.0
2020-02-19	GOOGL	Stock	76.36	76.537	76.0488	76.2435	22746760.0
2020-02-19	META	Stock	217.99	218.32	216.11	217.49	12135100.0
2020-02-19	TSLA	Stock	61.5667	62.9853	60.068	61.1613	381345000.0
2020-02-19	TLT	Stock	145.12	145.62	144.98	145.53	5707712.0
2020-02-19	ES	Stock	94.84	94.93	94.3	94.3	1695000.0
2020-02-19	CL	Stock	76.0	76.27	75.5	75.54	2686700.0
2020-02-19	A	Stock	84.7	85.84	83.45	85.35	4741300.0
2020-02-19	AA	Stock	16.04	16.8	16.04	16.7	8725500.0
2020-02-19	AACG	Stock	1.3	1.32	1.1	1.17	29200.0
2020-02-19	AAIC-DELISTED	Stock	6.42	6.65	6.42	6.61	1124907.0
2020-02-19	AAIC.C-DELISTED	Stock	23.17	24.71	23.16	23.85	19719.0
2020-02-19	AAL	Stock	28.84	28.88	28.31	28.33	8400700.0
2020-02-19	AAM.A-DELISTED	Stock	27.0	27.0	26.87	26.87	37514.0
2020-02-19	AAM.B-DELISTED	Stock	27.75	27.8426	27.71	27.74	20569.0
2020-02-19	AAMC-DELISTED	Stock	4.5588	7.2728	4.4431	5.7529	242729.0
2020-02-19	AAMI	Stock	10.64	10.67	10.33	10.51	403100.0
2020-02-19	AAOI	Stock	11.78	12.2	11.45	12.08	978700.0
2020-02-19	AAON	Stock	37.2267	38.2133	37.1867	38.0933	128550.0
2020-02-19	AAP	Stock	141.51	142.42	137.74	140.12	1015600.0
2020-02-19	AAT	Stock	46.05	46.22	45.07	45.52	223900.0
2020-02-19	AAU-DELISTED	Stock	0.4525	0.459	0.4322	0.446	259877.0
2020-02-19	AAUAF-DELISTED	Stock	0.4525	0.459	0.4322	0.446	272345.0
2020-02-19	AAWW-DELISTED	Stock	27.66	29.79	27.61	29.66	781265.0
2020-02-19	AAXJ	Stock	73.12	73.27	73.035	73.08	491963.0
2020-02-19	AAXN-DELISTED	Stock	87.88	90.1	87.46	88.875	454162.0
2020-02-19	AB	Stock	35.42	35.72	35.4	35.69	460000.0
2020-02-19	ABB-DELISTED	Stock	24.34	24.43	24.3	24.43	1239136.0
2020-02-19	ABBNY-DELISTED	Stock	24.34	24.43	24.3	24.43	1306545.0
2020-02-19	ABBV	Stock	93.77	94.79	93.02	94.14	6349100.0
2020-02-19	ABC-DELISTED	Stock	94.59	95.2	93.84	95.12	735304.0
2020-02-19	ABCB	Stock	40.46	40.59	40.2	40.42	226900.0
2020-02-19	ABEO	Stock	89.5	104.5	87.5	102.0	174792.0
2020-02-19	ABEV	Stock	3.66	3.67	3.63	3.67	14004200.0
2020-02-19	ABG	Stock	97.03	99.56	96.12	98.9	176900.0
2020-02-19	ABM	Stock	38.72	39.1	38.68	38.82	209400.0
2020-02-19	ABMD-DELISTED	Stock	170.14	171.21	167.6601	167.83	443993.0
2020-02-19	ABR	Stock	14.85	14.98	14.65	14.66	1221000.0
2020-02-19	ABR.A-DELISTED	Stock	26.4	26.4662	26.09	26.1926	6294.0
2020-02-19	ABR.B-DELISTED	Stock	25.95	25.95	25.7672	25.78	18578.0
2020-02-19	ABR.C-DELISTED	Stock	26.42	26.5358	26.4	26.5358	1744.0
2020-02-19	ABT	Stock	88.83	89.93	88.69	89.36	3464900.0
2020-02-19	ABTC	Stock	205800.0	210000.0	195000.0	208800.0	2.853333333333333
2020-02-19	ABTS	Stock	27.885	27.885	27.6	27.6	320.0
2020-02-19	ABTX-DELISTED	Stock	37.51	37.71	37.37	37.65	42885.0
2020-02-19	ABUS	Stock	3.41	3.48	3.2	3.27	461700.0
2020-02-19	ACA	Stock	46.82	46.82	44.56	44.76	385149.0

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

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