PREVIEW / stock_daily / 2020-06-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-29.parquet
  size:    222 KB
  rows:    6,745
  symbols: 2,413

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-06-29	AAPL	Stock	88.3125	90.5425	87.82	90.445	130646000.0
2020-06-29	MSFT	Stock	195.78	198.53	193.55	198.44	26701600.0
2020-06-29	NVDA	Stock	9.1698	9.2045	8.9	9.2	342248000.0
2020-06-29	AMZN	Stock	134.5005	134.84	131.504	134.019	84468000.0
2020-06-29	GOOGL	Stock	68.017	69.9	67.5825	69.8585	45073560.0
2020-06-29	META	Stock	209.75	220.75	207.11	220.64	58514300.0
2020-06-29	TSLA	Stock	64.6007	67.3333	63.2347	67.29	135396000.0
2020-06-29	TLT	Stock	164.85	165.27	164.38	164.73	7274571.0
2020-06-29	ES	Stock	82.62	83.12	81.67	83.09	1135600.0
2020-06-29	CL	Stock	71.89	72.5	71.89	72.43	3176600.0
2020-06-29	A	Stock	86.56	87.36	86.11	87.29	1302500.0
2020-06-29	AA	Stock	11.04	11.19	10.7	10.99	7397600.0
2020-06-29	AACG	Stock	1.15	1.25	1.15	1.17	46900.0
2020-06-29	AAIC-DELISTED	Stock	2.9	2.98	2.83	2.98	453393.0
2020-06-29	AAIC.C-DELISTED	Stock	19.53	19.85	19.35	19.72	16505.0
2020-06-29	AAL	Stock	12.57	13.51	12.02	13.32	115051100.0
2020-06-29	AAM.A-DELISTED	Stock	25.6844	25.9109	25.55	25.84	6485.0
2020-06-29	AAM.B-DELISTED	Stock	25.63	26.08	25.63	25.93	12137.0
2020-06-29	AAMC-DELISTED	Stock	5.0	5.0	4.6735	4.9951	3478.0
2020-06-29	AAME	Stock	1.75	1.79	1.64	1.65	5800.0
2020-06-29	AAMI	Stock	12.11	13.0	11.795	12.6	2120700.0
2020-06-29	AAOI	Stock	9.39	9.57	9.16	9.41	330700.0
2020-06-29	AAON	Stock	34.3333	35.9067	34.1467	35.78	373050.0
2020-06-29	AAP	Stock	141.49	143.66	138.76	142.75	676500.0
2020-06-29	AAT	Stock	28.52	28.7	27.85	28.2	382600.0
2020-06-29	AAU-DELISTED	Stock	0.4875	0.4904	0.47	0.4869	360582.0
2020-06-29	AAUAF-DELISTED	Stock	0.4875	0.4904	0.47	0.4881	377724.0
2020-06-29	AAWW-DELISTED	Stock	39.57	40.6089	39.12	40.44	274622.0
2020-06-29	AAXJ	Stock	69.05	69.38	68.715	69.38	1165717.0
2020-06-29	AAXN-DELISTED	Stock	97.35	97.35	92.41	95.8	536723.0
2020-06-29	AB	Stock	25.27	26.47	25.21	26.43	294400.0
2020-06-29	ABB-DELISTED	Stock	22.16	22.33	22.02	22.16	2556730.0
2020-06-29	ABBNY-DELISTED	Stock	22.1	22.33	22.02	22.16	2837338.0
2020-06-29	ABBV	Stock	96.5	97.33	95.68	96.44	6676400.0
2020-06-29	ABC-DELISTED	Stock	99.61	100.62	98.43	99.0	766717.0
2020-06-29	ABCB	Stock	21.65	23.5	21.43	23.4	612100.0
2020-06-29	ABEO	Stock	71.25	74.75	70.0	71.75	21692.0
2020-06-29	ABEV	Stock	2.6	2.69	2.57	2.68	33534500.0
2020-06-29	ABG	Stock	74.74	79.03	73.1	78.45	136100.0
2020-06-29	ABM	Stock	35.5	36.95	35.43	36.49	495900.0
2020-06-29	ABMD-DELISTED	Stock	240.76	241.62	234.39	240.22	215534.0
2020-06-29	ABR	Stock	9.06	9.2	8.67	9.14	2076000.0
2020-06-29	ABR.A-DELISTED	Stock	24.1701	24.9	24.1701	24.84	4288.0
2020-06-29	ABR.B-DELISTED	Stock	23.41	23.7607	23.18	23.655	3604.0
2020-06-29	ABR.C-DELISTED	Stock	25.24	25.24	23.99	24.7	15316.0
2020-06-29	ABT	Stock	89.58	89.7	88.09	89.01	4669300.0
2020-06-29	ABTC	Stock	267000.0	268500.0	255000.0	267600.0	3.6
2020-06-29	ABTS	Stock	12.75	13.05	12.54	12.675	1760.0
2020-06-29	ABTX-DELISTED	Stock	23.79	25.0	23.79	24.73	38723.0
2020-06-29	ABUS	Stock	1.97	2.0	1.88	1.92	402100.0

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

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