PREVIEW / stock_daily / 2020-03-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-04.parquet
  size:    221 KB
  rows:    6,597
  symbols: 2,369

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-03-04	AAPL	Stock	74.11	75.85	73.2825	75.685	219178400.0
2020-03-04	MSFT	Stock	168.49	170.7	165.62	170.55	49814400.0
2020-03-04	NVDA	Stock	6.755	7.1222	6.68	7.1128	597408000.0
2020-03-04	AMZN	Stock	97.3285	98.9	96.1	98.7915	95458000.0
2020-03-04	GOOGL	Stock	67.948	69.139	66.85	69.08	47597120.0
2020-03-04	META	Stock	189.17	191.83	186.39	191.76	23062500.0
2020-03-04	TSLA	Stock	50.9307	51.1013	48.3153	49.9667	225735000.0
2020-03-04	TLT	Stock	156.41	157.35	154.19	154.67	23463690.0
2020-03-04	ES	Stock	93.19	98.64	93.18	98.54	1989600.0
2020-03-04	CL	Stock	73.9	75.47	73.01	75.37	7174700.0
2020-03-04	A	Stock	81.77	84.43	80.72	84.35	1905300.0
2020-03-04	AA	Stock	13.17	13.19	12.58	12.88	7371300.0
2020-03-04	AACG	Stock	0.97	1.08	0.96	1.0	23800.0
2020-03-04	AAIC-DELISTED	Stock	6.1	6.1	5.895	6.04	252205.0
2020-03-04	AAIC.C-DELISTED	Stock	22.73	22.74	22.572	22.73	910.0
2020-03-04	AAL	Stock	18.36	18.55	17.3	18.53	44362100.0
2020-03-04	AAM.A-DELISTED	Stock	26.07	26.3788	26.03	26.26	21573.0
2020-03-04	AAM.B-DELISTED	Stock	26.26	26.74	26.26	26.74	18076.0
2020-03-04	AAMC-DELISTED	Stock	6.0294	6.7294	6.0294	6.3235	23715.0
2020-03-04	AAMI	Stock	8.5	8.54	8.12	8.43	563000.0
2020-03-04	AAOI	Stock	9.61	9.61	9.13	9.38	540500.0
2020-03-04	AAON	Stock	38.1933	40.0	37.8067	39.8533	309900.0
2020-03-04	AAP	Stock	131.22	133.03	128.07	132.9	861300.0
2020-03-04	AAT	Stock	42.52	43.27	42.52	43.06	414800.0
2020-03-04	AAU-DELISTED	Stock	0.4	0.4149	0.39	0.409	264212.0
2020-03-04	AAUAF-DELISTED	Stock	0.4	0.4149	0.39	0.409	272809.0
2020-03-04	AAWW-DELISTED	Stock	26.22	26.79	25.31	26.23	627752.0
2020-03-04	AAXJ	Stock	69.89	70.16	69.58	70.07	868603.0
2020-03-04	AAXN-DELISTED	Stock	79.8	81.27	78.28	80.54	497279.0
2020-03-04	AB	Stock	32.06	32.71	31.71	32.69	625800.0
2020-03-04	ABB-DELISTED	Stock	21.9	22.29	21.7	22.27	1911353.0
2020-03-04	ABBNY-DELISTED	Stock	21.9	22.29	21.7	22.27	2048987.0
2020-03-04	ABBV	Stock	89.27	91.86	88.95	91.75	16590400.0
2020-03-04	ABC-DELISTED	Stock	89.3	90.43	87.985	90.4	1040178.0
2020-03-04	ABCB	Stock	35.0	35.38	33.56	34.98	806200.0
2020-03-04	ABEO	Stock	82.0	82.5	76.25	82.25	44024.0
2020-03-04	ABEV	Stock	3.28	3.4	3.28	3.4	54380800.0
2020-03-04	ABG	Stock	92.39	94.41	91.25	94.14	194200.0
2020-03-04	ABM	Stock	34.5	35.27	34.29	35.12	501400.0
2020-03-04	ABMD-DELISTED	Stock	151.81	154.6	148.7	154.22	391030.0
2020-03-04	ABR	Stock	12.87	13.14	12.71	12.99	1239400.0
2020-03-04	ABR.A-DELISTED	Stock	25.77	25.77	25.6	25.626	3089.0
2020-03-04	ABR.B-DELISTED	Stock	25.44	25.6299	25.348	25.6299	1606.0
2020-03-04	ABR.C-DELISTED	Stock	25.987	26.0494	25.55	26.0494	3110.0
2020-03-04	ABT	Stock	80.66	82.33	79.46	82.09	8660000.0
2020-03-04	ABTC	Stock	218400.0	238800.0	218400.0	228000.0	1.24
2020-03-04	ABTS	Stock	20.55	20.55	18.15	18.15	33.3
2020-03-04	ABTX-DELISTED	Stock	33.65	34.13	33.08	33.85	81226.0
2020-03-04	ABUS	Stock	2.85	3.1	2.76	3.03	368000.0
2020-03-04	ACA	Stock	43.16	43.8	42.185	43.8	453239.0

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

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