PREVIEW / stock_daily / 2019-09-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-06.parquet
  size:    220 KB
  rows:    6,574
  symbols: 2,515

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-09-06	AAPL	Stock	53.5125	53.605	53.1275	53.315	77449200.0
2019-09-06	MSFT	Stock	140.03	140.18	138.2	139.1	20824500.0
2019-09-06	NVDA	Stock	4.47	4.5273	4.428	4.4663	376976000.0
2019-09-06	AMZN	Stock	91.911	92.0325	91.32	91.6755	49938000.0
2019-09-06	GOOGL	Stock	60.457	60.6472	60.163	60.316	18971600.0
2019-09-06	META	Stock	190.21	190.21	186.35	187.49	15226800.0
2019-09-06	TSLA	Stock	15.1467	15.3093	15.0113	15.1633	62841000.0
2019-09-06	TLT	Stock	145.26	146.03	145.08	145.79	9466371.0
2019-09-06	ES	Stock	82.11	82.46	81.94	82.35	1704800.0
2019-09-06	CL	Stock	74.41	74.71	74.23	74.7	2333300.0
2019-09-06	A	Stock	73.69	74.37	73.69	74.28	3117600.0
2019-09-06	AA	Stock	19.52	19.64	18.98	19.11	2970600.0
2019-09-06	AABA-DELISTED	Stock	69.71	70.16	69.7	70.1	11084673.0
2019-09-06	AAC-DELISTED	Stock	0.53	0.61	0.525	0.5905	94467.0
2019-09-06	AACG	Stock	1.95	1.95	1.89	1.89	16400.0
2019-09-06	AAIC-DELISTED	Stock	5.07	5.1	5.04	5.07	190507.0
2019-09-06	AAIC.C-DELISTED	Stock	22.25	22.3	21.7	21.94	27197.0
2019-09-06	AAL	Stock	28.16	28.23	27.73	27.79	5791900.0
2019-09-06	AAM.A-DELISTED	Stock	26.43	26.45	26.3	26.41	46884.0
2019-09-06	AAM.B-DELISTED	Stock	26.38	26.44	25.9612	26.39	60629.0
2019-09-06	AAMC-DELISTED	Stock	2.9882	3.1471	2.9882	3.1471	3070.0
2019-09-06	AAME	Stock	2.75	2.75	2.75	2.75	400.0
2019-09-06	AAMI	Stock	9.5	9.61	9.33	9.35	4058600.0
2019-09-06	AAOI	Stock	9.8	10.3	9.75	10.3	697400.0
2019-09-06	AAON	Stock	32.5667	32.7667	31.6133	31.6667	136350.0
2019-09-06	AAP	Stock	146.89	147.67	146.32	147.21	818200.0
2019-09-06	AAT	Stock	47.64	48.16	47.43	47.77	393100.0
2019-09-06	AAU-DELISTED	Stock	0.68	0.68	0.65	0.6603	179858.0
2019-09-06	AAUAF-DELISTED	Stock	0.68	0.68	0.65	0.6603	201340.0
2019-09-06	AAWW-DELISTED	Stock	27.33	27.71	26.8	27.55	148245.0
2019-09-06	AAXJ	Stock	67.23	67.3	67.06	67.19	1512170.0
2019-09-06	AAXN-DELISTED	Stock	61.16	62.49	60.64	62.015	257244.0
2019-09-06	AB	Stock	29.0	29.19	28.64	28.79	151000.0
2019-09-06	ABB-DELISTED	Stock	19.37	19.49	19.33	19.46	977909.0
2019-09-06	ABBNY-DELISTED	Stock	19.37	19.49	19.33	19.46	1046686.0
2019-09-06	ABBV	Stock	67.26	68.12	67.0	67.62	7502500.0
2019-09-06	ABC-DELISTED	Stock	86.12	86.61	85.5642	86.32	708117.0
2019-09-06	ABCB	Stock	35.27	35.49	35.0	35.17	279300.0
2019-09-06	ABDC-DELISTED	Stock	8.96	9.01	8.96	9.0	28727.0
2019-09-06	ABEO	Stock	74.75	84.75	71.25	74.5	114560.0
2019-09-06	ABEOW-DELISTED	Stock	0.1216	0.44	0.12	0.44	3486.0
2019-09-06	ABEV	Stock	4.63	4.66	4.56	4.61	17169800.0
2019-09-06	ABG	Stock	97.81	98.48	96.27	96.55	104500.0
2019-09-06	ABIL-DELISTED	Stock	0.6149	0.64	0.6001	0.61	18364.0
2019-09-06	ABM	Stock	38.6	38.91	35.27	35.34	515500.0
2019-09-06	ABMD-DELISTED	Stock	191.0	192.38	188.35	189.44	162565.0
2019-09-06	ABR	Stock	12.61	12.61	12.35	12.35	1426500.0
2019-09-06	ABR.A-DELISTED	Stock	26.02	26.02	25.96	26.0	900.0
2019-09-06	ABR.B-DELISTED	Stock	25.6686	25.7	25.6686	25.7	207.0
2019-09-06	ABR.C-DELISTED	Stock	26.32	26.34	26.232	26.256	800.0

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

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