PREVIEW / stock_daily / 2019-06-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-19.parquet
  size:    220 KB
  rows:    6,551
  symbols: 2,531

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-06-19	AAPL	Stock	49.92	49.97	49.3275	49.4675	84496800.0
2019-06-19	MSFT	Stock	135.0	135.93	133.81	135.69	23744400.0
2019-06-19	NVDA	Stock	3.8575	3.869	3.8018	3.828	331644000.0
2019-06-19	AMZN	Stock	95.392	95.979	94.6235	95.4395	57906000.0
2019-06-19	GOOGL	Stock	55.362	55.4715	54.8015	55.2255	26720300.0
2019-06-19	META	Stock	187.0	188.1	184.55	187.48	21417100.0
2019-06-19	TSLA	Stock	15.0073	15.1847	14.7373	15.0953	98626500.0
2019-06-19	TLT	Stock	131.86	132.72	131.58	132.54	11962501.0
2019-06-19	ES	Stock	75.99	77.43	75.85	77.17	1280900.0
2019-06-19	CL	Stock	72.7	73.63	72.38	73.53	3096500.0
2019-06-19	A	Stock	71.89	72.73	71.89	72.65	1916700.0
2019-06-19	AA	Stock	22.67	23.03	22.3	22.4	2708100.0
2019-06-19	AABA-DELISTED	Stock	69.12	69.5	68.04	68.48	2620991.0
2019-06-19	AAC-DELISTED	Stock	0.6981	0.7245	0.653	0.6715	431041.0
2019-06-19	AACG	Stock	2.33	2.58	2.26	2.48	447300.0
2019-06-19	AAIC-DELISTED	Stock	7.0	7.0	6.91	6.98	278485.0
2019-06-19	AAIC.C-DELISTED	Stock	21.6	21.6	21.4932	21.55	3005.0
2019-06-19	AAL	Stock	32.72	33.3	32.51	33.21	5535500.0
2019-06-19	AAM.A-DELISTED	Stock	25.73	25.84	25.73	25.75	18771.0
2019-06-19	AAM.B-DELISTED	Stock	25.9055	25.9055	25.82	25.82	17936.0
2019-06-19	AAMC-DELISTED	Stock	4.2647	4.2941	4.125	4.2941	19625.0
2019-06-19	AAME	Stock	2.48	2.48	2.44	2.48	2500.0
2019-06-19	AAMI	Stock	10.76	11.01	10.67	10.98	590900.0
2019-06-19	AAOI	Stock	8.98	9.03	8.74	8.79	446100.0
2019-06-19	AAON	Stock	32.4133	32.48	31.6333	32.18	123000.0
2019-06-19	AAP	Stock	154.87	155.06	152.12	153.77	1092600.0
2019-06-19	AAT	Stock	47.11	47.79	46.72	47.69	476600.0
2019-06-19	AAU-DELISTED	Stock	0.57	0.57	0.5315	0.5401	124498.0
2019-06-19	AAUAF-DELISTED	Stock	0.57	0.57	0.5315	0.5401	141183.0
2019-06-19	AAWW-DELISTED	Stock	41.43	41.95	40.87	41.8	253512.0
2019-06-19	AAXJ	Stock	68.26	68.87	68.1219	68.57	644900.0
2019-06-19	AAXN-DELISTED	Stock	64.5	69.92	64.1503	69.9	2057733.0
2019-06-19	AB	Stock	29.26	29.45	28.91	29.21	253500.0
2019-06-19	ABB-DELISTED	Stock	19.34	19.38	19.26	19.335	973142.0
2019-06-19	ABBNY-DELISTED	Stock	19.34	19.38	19.26	19.34	1039843.0
2019-06-19	ABBV	Stock	78.4	78.48	77.29	77.61	6147300.0
2019-06-19	ABC-DELISTED	Stock	85.74	86.79	85.53	86.05	1130541.0
2019-06-19	ABCB	Stock	38.26	38.88	38.04	38.19	313000.0
2019-06-19	ABDC-DELISTED	Stock	8.5	8.55	8.475	8.51	13528.0
2019-06-19	ABEO	Stock	127.5	129.5	120.5	122.25	42388.0
2019-06-19	ABEOW-DELISTED	Stock	1.08	1.16	1.08	1.16	400.0
2019-06-19	ABEV	Stock	4.67	4.76	4.65	4.75	29055700.0
2019-06-19	ABG	Stock	82.76	82.83	81.52	82.14	109000.0
2019-06-19	ABIL-DELISTED	Stock	1.11	1.15	1.01	1.056	117793.0
2019-06-19	ABM	Stock	39.88	40.06	39.64	40.0	263300.0
2019-06-19	ABMD-DELISTED	Stock	257.85	258.39	252.57	256.31	342613.0
2019-06-19	ABR	Stock	12.34	12.42	12.28	12.41	839200.0
2019-06-19	ABR.A-DELISTED	Stock	26.2297	26.2297	26.2297	26.2297	328.0
2019-06-19	ABR.C-DELISTED	Stock	26.1	26.1201	26.044	26.1201	1000.0
2019-06-19	ABT	Stock	83.4	84.5	83.05	84.33	4113400.0

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

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