PREVIEW / stock_daily / 2020-08-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-14.parquet
  size:    223 KB
  rows:    6,761
  symbols: 2,395

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-08-14	AAPL	Stock	114.83	115.0	113.045	114.9075	165565200.0
2020-08-14	MSFT	Stock	208.76	209.59	207.51	208.9	17958900.0
2020-08-14	NVDA	Stock	11.53	11.7048	11.4405	11.564	366436000.0
2020-08-14	AMZN	Stock	158.909	158.912	156.0	157.401	55034000.0
2020-08-14	GOOGL	Stock	75.6805	75.9893	74.95	75.2315	21941180.0
2020-08-14	META	Stock	262.31	262.65	258.68	261.24	14792700.0
2020-08-14	TSLA	Stock	110.9993	111.2533	108.4427	110.0473	188664000.0
2020-08-14	TLT	Stock	163.81	164.15	163.16	163.18	6398178.0
2020-08-14	ES	Stock	87.66	88.07	86.77	87.15	617200.0
2020-08-14	CL	Stock	76.89	77.36	76.66	77.05	2538400.0
2020-08-14	A	Stock	98.45	98.83	96.9	97.37	957400.0
2020-08-14	AA	Stock	14.33	14.78	14.18	14.64	2991500.0
2020-08-14	AACG	Stock	1.19	1.19	1.05	1.1	54600.0
2020-08-14	AACQU-DELISTED	Stock	10.125	10.13	10.05	10.1	140988.0
2020-08-14	AAIC-DELISTED	Stock	2.81	2.8799	2.79	2.87	156717.0
2020-08-14	AAIC.C-DELISTED	Stock	19.06	19.06	19.03	19.05	502.0
2020-08-14	AAL	Stock	13.11	13.56	13.01	13.33	45670200.0
2020-08-14	AAM.A-DELISTED	Stock	26.9172	26.962	26.8	26.8	7048.0
2020-08-14	AAM.B-DELISTED	Stock	27.44	27.44	27.2409	27.25	6721.0
2020-08-14	AAMC-DELISTED	Stock	4.4118	7.1029	4.2353	4.477	862815.0
2020-08-14	AAME	Stock	2.1	2.19	1.94	2.1	7600.0
2020-08-14	AAMI	Stock	13.64	13.66	13.33	13.46	453100.0
2020-08-14	AAOI	Stock	13.44	13.73	12.98	13.28	991300.0
2020-08-14	AAON	Stock	39.2133	39.2133	38.3467	38.54	319200.0
2020-08-14	AAP	Stock	155.11	159.31	155.11	158.66	1130300.0
2020-08-14	AAT	Stock	27.15	27.65	27.01	27.16	147300.0
2020-08-14	AAU-DELISTED	Stock	0.7	0.741	0.7	0.741	373937.0
2020-08-14	AAUAF-DELISTED	Stock	0.7	0.741	0.7	0.7401	390234.0
2020-08-14	AAWW-DELISTED	Stock	60.08	60.65	59.4214	59.99	401762.0
2020-08-14	AAXJ	Stock	76.62	76.74	76.48	76.69	1305757.0
2020-08-14	AAXN-DELISTED	Stock	80.87	81.83	79.13	79.64	172803.0
2020-08-14	AB	Stock	29.12	29.5	29.02	29.07	318800.0
2020-08-14	ABB-DELISTED	Stock	26.23	26.32	26.05	26.14	871145.0
2020-08-14	ABBNY-DELISTED	Stock	26.23	26.32	26.05	26.14	944612.0
2020-08-14	ABBV	Stock	95.38	95.67	94.54	95.07	5488100.0
2020-08-14	ABC-DELISTED	Stock	101.94	104.25	101.6	103.76	509395.0
2020-08-14	ABCB	Stock	25.52	26.7	25.33	26.35	288700.0
2020-08-14	ABEO	Stock	70.75	70.75	67.75	68.75	29580.0
2020-08-14	ABEV	Stock	2.48	2.51	2.43	2.45	15272900.0
2020-08-14	ABG	Stock	107.65	109.33	107.0	108.55	99600.0
2020-08-14	ABM	Stock	38.02	38.48	37.72	37.84	248500.0
2020-08-14	ABMD-DELISTED	Stock	307.48	310.615	303.67	307.27	127539.0
2020-08-14	ABR	Stock	11.15	11.41	10.91	11.33	1101100.0
2020-08-14	ABR.A-DELISTED	Stock	25.09	25.5	25.09	25.45	7100.0
2020-08-14	ABR.B-DELISTED	Stock	25.13	25.18	25.13	25.18	300.0
2020-08-14	ABR.C-DELISTED	Stock	25.43	26.302	25.41	25.6899	7717.0
2020-08-14	ABT	Stock	100.93	101.22	99.58	99.99	2739900.0
2020-08-14	ABTC	Stock	175500.0	180000.0	170700.0	174900.0	2.2
2020-08-14	ABTS	Stock	23.55	24.6	21.75	22.65	10820.0
2020-08-14	ABTX-DELISTED	Stock	26.15	26.79	25.362	26.58	33114.0

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

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