PREVIEW / stock_daily / 2020-10-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-16.parquet
  size:    229 KB
  rows:    6,948
  symbols: 2,458

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-10-16	AAPL	Stock	121.28	121.55	118.81	119.02	115393800.0
2020-10-16	MSFT	Stock	220.15	222.29	219.32	219.66	26057900.0
2020-10-16	NVDA	Stock	14.0368	14.1215	13.7925	13.8115	242392000.0
2020-10-16	AMZN	Stock	168.1615	169.983	158.0	163.6355	129488000.0
2020-10-16	GOOGL	Stock	78.0915	78.8855	77.883	78.385	34206500.0
2020-10-16	META	Stock	267.38	271.37	265.3	265.93	16622700.0
2020-10-16	TSLA	Stock	151.48	151.9833	146.2833	146.5567	98327700.0
2020-10-16	TLT	Stock	161.66	162.32	161.1	161.39	8418197.0
2020-10-16	ES	Stock	91.02	92.18	90.46	91.42	1821300.0
2020-10-16	CL	Stock	80.12	80.59	80.03	80.31	2963600.0
2020-10-16	A	Stock	105.95	107.54	105.71	106.7	1039400.0
2020-10-16	AA	Stock	12.31	12.66	12.03	12.62	5378000.0
2020-10-16	AACG	Stock	1.16	1.26	1.14	1.19	173200.0
2020-10-16	AACQ-DELISTED	Stock	9.75	9.79	9.75	9.78	6264.0
2020-10-16	AACQU-DELISTED	Stock	10.3	10.3	10.25	10.26	850.0
2020-10-16	AACQW-DELISTED	Stock	1.3998	1.4	1.35	1.37	40022.0
2020-10-16	AAIC-DELISTED	Stock	2.77	2.83	2.76	2.76	146518.0
2020-10-16	AAIC.C-DELISTED	Stock	18.75	18.85	18.74	18.85	3410.0
2020-10-16	AAL	Stock	12.31	12.56	12.2	12.46	32717300.0
2020-10-16	AAM.A-DELISTED	Stock	26.38	26.393	26.1191	26.15	16370.0
2020-10-16	AAM.B-DELISTED	Stock	27.26	27.28	27.09	27.09	5812.0
2020-10-16	AAMC-DELISTED	Stock	5.7324	6.0	5.7324	5.8588	2808.0
2020-10-16	AAME	Stock	2.15	2.26	2.08	2.2	9200.0
2020-10-16	AAMI	Stock	15.92	15.94	15.65	15.8	243600.0
2020-10-16	AAOI	Stock	11.21	11.4	10.96	10.98	263100.0
2020-10-16	AAON	Stock	42.1467	42.5267	41.9333	42.0533	163650.0
2020-10-16	AAP	Stock	157.52	157.61	154.83	154.99	477200.0
2020-10-16	AAT	Stock	24.45	24.56	23.95	24.16	275800.0
2020-10-16	AAU-DELISTED	Stock	1.02	1.02	0.96	0.9665	400296.0
2020-10-16	AAUAF-DELISTED	Stock	1.02	1.02	0.96	0.9677	426891.0
2020-10-16	AAWW-DELISTED	Stock	67.1	67.48	65.13	66.05	200937.0
2020-10-16	AAXJ	Stock	79.69	79.95	79.445	79.64	749256.0
2020-10-16	AAXN-DELISTED	Stock	107.51	109.735	105.7701	109.16	543621.0
2020-10-16	AB	Stock	33.35	33.49	32.88	32.96	353300.0
2020-10-16	ABB-DELISTED	Stock	26.73	26.895	26.68	26.74	1181071.0
2020-10-16	ABBNY-DELISTED	Stock	26.73	26.895	26.68	26.74	1245724.0
2020-10-16	ABBV	Stock	85.89	87.15	85.76	86.27	5358500.0
2020-10-16	ABC-DELISTED	Stock	99.6	100.61	98.9	99.51	973918.0
2020-10-16	ABCB	Stock	26.04	26.31	25.26	25.98	200100.0
2020-10-16	ABEO	Stock	33.5	35.0	32.75	33.75	36776.0
2020-10-16	ABEV	Stock	2.4	2.41	2.34	2.35	13408300.0
2020-10-16	ABG	Stock	116.55	116.56	113.42	114.52	235300.0
2020-10-16	ABM	Stock	34.84	35.24	34.51	34.73	322400.0
2020-10-16	ABMD-DELISTED	Stock	282.86	289.31	279.97	286.37	154055.0
2020-10-16	ABR	Stock	11.76	11.84	11.41	11.56	959700.0
2020-10-16	ABR.A-DELISTED	Stock	25.4351	25.4351	25.325	25.325	650.0
2020-10-16	ABR.B-DELISTED	Stock	25.1549	25.1549	25.15	25.15	775.0
2020-10-16	ABR.C-DELISTED	Stock	25.5	25.5582	25.5	25.5582	400.0
2020-10-16	ABT	Stock	107.7	110.38	107.7	109.67	4363500.0
2020-10-16	ABTC	Stock	134100.0	137400.0	129000.0	132900.0	5.093333333333334

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

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