PREVIEW / stock_daily / 2019-03-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-21.parquet
  size:    220 KB
  rows:    6,546
  symbols: 2,615

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-03-21	AAPL	Stock	47.505	49.0825	47.4525	48.7725	204136800.0
2019-03-21	MSFT	Stock	117.14	120.82	117.09	120.22	29854400.0
2019-03-21	NVDA	Stock	4.3832	4.625	4.3783	4.5985	824312000.0
2019-03-21	AMZN	Stock	89.813	91.1875	89.364	90.963	115356000.0
2019-03-21	GOOGL	Stock	61.0	61.822	60.8288	61.8065	28149600.0
2019-03-21	META	Stock	164.89	166.39	163.75	166.08	16223000.0
2019-03-21	TSLA	Stock	18.1733	18.43	17.8967	18.268	89206500.0
2019-03-21	TLT	Stock	122.96	123.09	122.74	122.95	7182572.0
2019-03-21	ES	Stock	70.27	71.0	69.9	70.86	1386500.0
2019-03-21	CL	Stock	65.0	65.95	64.95	65.83	2793800.0
2019-03-21	A	Stock	80.55	82.27	80.55	82.0	986600.0
2019-03-21	AA	Stock	28.54	29.53	28.5	29.41	3234800.0
2019-03-21	AABA-DELISTED	Stock	73.28	74.09	72.93	73.71	7228622.0
2019-03-21	AAC-DELISTED	Stock	2.31	2.37	2.3	2.32	62625.0
2019-03-21	AACG	Stock	1.01	1.03	1.01	1.03	10200.0
2019-03-21	AAIC-DELISTED	Stock	8.19	8.33	8.11	8.24	406997.0
2019-03-21	AAIC.C-DELISTED	Stock	23.7	23.7	23.37	23.37	23945.0
2019-03-21	AAL	Stock	30.89	31.77	30.79	31.45	5725100.0
2019-03-21	AAM.A-DELISTED	Stock	25.01	25.15	25.01	25.0611	25175.0
2019-03-21	AAM.B-DELISTED	Stock	24.88	24.92	24.7062	24.8	59238.0
2019-03-21	AAMC-DELISTED	Stock	10.0559	10.1866	9.9732	10.1029	29862.0
2019-03-21	AAME	Stock	2.91	2.92	2.89	2.89	1000.0
2019-03-21	AAMI	Stock	13.25	13.37	13.17	13.24	454600.0
2019-03-21	AAOI	Stock	13.42	13.82	13.4	13.75	515000.0
2019-03-21	AAON	Stock	28.38	29.7067	28.38	29.52	227250.0
2019-03-21	AAP	Stock	163.83	169.17	163.83	169.07	864700.0
2019-03-21	AAT	Stock	44.95	46.02	44.95	45.73	213100.0
2019-03-21	AAU-DELISTED	Stock	0.6112	0.6188	0.5913	0.6063	134644.0
2019-03-21	AAUAF-DELISTED	Stock	0.6112	0.6188	0.5913	0.6032	135857.0
2019-03-21	AAWW-DELISTED	Stock	47.62	49.56	47.51	49.04	150344.0
2019-03-21	AAXJ	Stock	70.59	71.31	70.54	71.31	1537373.0
2019-03-21	AAXN-DELISTED	Stock	52.28	54.55	52.28	54.55	578181.0
2019-03-21	AB	Stock	28.75	29.07	28.5	28.88	237400.0
2019-03-21	ABB-DELISTED	Stock	19.28	19.38	19.2432	19.31	1984067.0
2019-03-21	ABBNY-DELISTED	Stock	19.28	19.38	19.2432	19.3	2047399.0
2019-03-21	ABBV	Stock	79.88	81.31	79.26	81.24	5159200.0
2019-03-21	ABC-DELISTED	Stock	79.0	80.425	79.0	80.37	699532.0
2019-03-21	ABCB	Stock	35.25	35.33	34.41	34.97	786800.0
2019-03-21	ABDC-DELISTED	Stock	7.7	7.7	7.52	7.58	35142.0
2019-03-21	ABEO	Stock	194.25	209.75	193.75	207.75	19032.0
2019-03-21	ABEOW-DELISTED	Stock	3.705	3.8	3.68	3.8	1500.0
2019-03-21	ABEV	Stock	4.49	4.53	4.33	4.46	49642900.0
2019-03-21	ABG	Stock	67.88	69.53	67.88	69.31	129700.0
2019-03-21	ABIL-DELISTED	Stock	1.91	2.0	1.881	1.9833	246167.0
2019-03-21	ABM	Stock	34.46	35.22	34.46	34.96	629300.0
2019-03-21	ABMD-DELISTED	Stock	337.94	348.275	337.1	337.47	370652.0
2019-03-21	ABR	Stock	12.76	12.93	12.72	12.91	828600.0
2019-03-21	ABR.A-DELISTED	Stock	25.7669	25.7674	25.55	25.6025	3570.0
2019-03-21	ABR.B-DELISTED	Stock	25.6046	25.6046	25.5931	25.5931	2200.0
2019-03-21	ABR.C-DELISTED	Stock	25.89	25.9904	25.8282	25.9904	2720.0

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

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