PREVIEW / stock_daily / 2019-11-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-08.parquet
  size:    222 KB
  rows:    6,611
  symbols: 2,467

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
2019-11-08	AAPL	Stock	64.6725	65.11	64.2125	65.035	69986400.0
2019-11-08	MSFT	Stock	143.98	145.99	143.76	145.96	16732700.0
2019-11-08	NVDA	Stock	5.1915	5.2262	5.1538	5.1945	189100000.0
2019-11-08	AMZN	Stock	89.3945	89.494	88.702	89.294	42466000.0
2019-11-08	GOOGL	Stock	65.076	65.8555	65.076	65.45	30437840.0
2019-11-08	META	Stock	190.0	192.34	189.7	190.84	10760800.0
2019-11-08	TSLA	Stock	22.3	22.4973	22.1667	22.476	91038000.0
2019-11-08	TLT	Stock	135.15	135.95	134.78	134.91	10227217.0
2019-11-08	ES	Stock	79.12	79.6	78.58	79.41	1324600.0
2019-11-08	CL	Stock	66.76	67.06	66.38	66.63	3489400.0
2019-11-08	A	Stock	75.9	76.65	75.65	76.64	1231500.0
2019-11-08	AA	Stock	22.38	22.95	22.25	22.53	4674800.0
2019-11-08	AACG	Stock	1.75	1.75	1.71	1.73	12500.0
2019-11-08	AAIC-DELISTED	Stock	5.72	5.89	5.39	5.78	570042.0
2019-11-08	AAIC.C-DELISTED	Stock	21.37	21.45	21.34	21.42	5292.0
2019-11-08	AAL	Stock	30.72	30.85	29.96	30.76	6352900.0
2019-11-08	AAM.A-DELISTED	Stock	26.6	26.64	26.49	26.545	3651.0
2019-11-08	AAM.B-DELISTED	Stock	26.92	27.06	26.92	27.06	18632.0
2019-11-08	AAME	Stock	1.86	1.95	1.81	1.81	5900.0
2019-11-08	AAMI	Stock	10.06	10.19	10.03	10.16	349900.0
2019-11-08	AAOI	Stock	10.62	11.2	10.52	10.88	986800.0
2019-11-08	AAON	Stock	32.88	33.4867	32.76	33.42	179400.0
2019-11-08	AAP	Stock	170.36	170.7	165.8	167.4	1243000.0
2019-11-08	AAT	Stock	46.9	47.15	46.65	46.76	165600.0
2019-11-08	AAU-DELISTED	Stock	0.46	0.4955	0.455	0.4585	424020.0
2019-11-08	AAUAF-DELISTED	Stock	0.46	0.4955	0.455	0.458	470630.0
2019-11-08	AAWW-DELISTED	Stock	26.2	26.907	26.02	26.68	235205.0
2019-11-08	AAXJ	Stock	71.62	71.695	71.36	71.64	1268361.0
2019-11-08	AAXN-DELISTED	Stock	61.94	71.0	61.0	65.31	3709229.0
2019-11-08	AB	Stock	29.62	29.72	29.23	29.35	316600.0
2019-11-08	ABB-DELISTED	Stock	21.58	21.77	21.52	21.77	1341395.0
2019-11-08	ABBNY-DELISTED	Stock	21.58	21.77	21.52	21.77	1483623.0
2019-11-08	ABBV	Stock	82.1	85.46	82.09	85.21	11364100.0
2019-11-08	ABC-DELISTED	Stock	83.63	86.15	83.06	86.07	755226.0
2019-11-08	ABCB	Stock	44.3	44.56	44.11	44.44	239500.0
2019-11-08	ABDC-DELISTED	Stock	8.9	8.94	8.778	8.94	22449.0
2019-11-08	ABEO	Stock	66.75	68.0	64.5	65.75	10656.0
2019-11-08	ABEV	Stock	4.19	4.22	4.1	4.12	21999300.0
2019-11-08	ABG	Stock	108.15	109.62	107.61	109.06	97000.0
2019-11-08	ABIL-DELISTED	Stock	0.43	0.479	0.428	0.4595	7438.0
2019-11-08	ABM	Stock	37.4	37.89	37.19	37.81	224700.0
2019-11-08	ABMD-DELISTED	Stock	218.02	219.99	214.395	219.42	250522.0
2019-11-08	ABR	Stock	15.72	15.77	14.54	15.42	7006000.0
2019-11-08	ABR.A-DELISTED	Stock	25.92	26.05	25.9	25.98	3015.0
2019-11-08	ABR.B-DELISTED	Stock	25.83	25.9583	25.83	25.9583	1155.0
2019-11-08	ABR.C-DELISTED	Stock	26.2607	26.53	26.2607	26.5	6031.0
2019-11-08	ABT	Stock	83.33	83.89	83.18	83.74	3462800.0
2019-11-08	ABTC	Stock	133200.0	133200.0	120000.0	127200.0	7.466666666666667
2019-11-08	ABTS	Stock	29.25	29.25	29.25	29.25	73.3
2019-11-08	ABTX-DELISTED	Stock	35.46	35.68	35.13	35.19	102432.0

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

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