PREVIEW / stock_daily / 2020-04-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-14.parquet
  size:    217 KB
  rows:    6,642
  symbols: 2,383

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-04-14	AAPL	Stock	70.0	72.0625	69.5125	71.7625	194994800.0
2020-04-14	MSFT	Stock	169.0	173.75	168.0	173.7	52874300.0
2020-04-14	NVDA	Stock	6.875	7.133	6.8472	7.0988	530948000.0
2020-04-14	AMZN	Stock	110.0235	114.6	109.3105	114.166	161744000.0
2020-04-14	GOOGL	Stock	61.9987	63.7875	61.4271	63.2615	63357240.0
2020-04-14	META	Stock	178.98	181.23	176.62	178.17	21011800.0
2020-04-14	TSLA	Stock	46.598	49.4587	46.162	47.326	458647500.0
2020-04-14	TLT	Stock	163.84	164.74	163.48	163.84	9019531.0
2020-04-14	ES	Stock	88.9	91.73	88.56	91.4	2359700.0
2020-04-14	CL	Stock	71.33	73.89	70.61	73.11	4940600.0
2020-04-14	A	Stock	77.3	79.2	77.24	78.83	2650300.0
2020-04-14	AA	Stock	7.87	8.38	7.62	7.72	10641700.0
2020-04-14	AACG	Stock	0.83	0.89	0.82	0.82	9100.0
2020-04-14	AAIC-DELISTED	Stock	3.09	3.15	2.94	2.98	450092.0
2020-04-14	AAIC.C-DELISTED	Stock	17.75	17.75	16.53	17.0	2750.0
2020-04-14	AAL	Stock	12.22	12.6	11.75	11.95	68039500.0
2020-04-14	AAM.A-DELISTED	Stock	24.76	25.1	24.685	25.07	54030.0
2020-04-14	AAM.B-DELISTED	Stock	24.7	25.1	24.6634	25.1	137589.0
2020-04-14	AAMC-DELISTED	Stock	4.1176	4.1954	3.6853	3.8824	15973.0
2020-04-14	AAME	Stock	1.96	2.04	1.9	2.04	1800.0
2020-04-14	AAMI	Stock	6.46	6.52	6.08	6.12	473600.0
2020-04-14	AAOI	Stock	8.08	8.5	8.08	8.19	456500.0
2020-04-14	AAON	Stock	32.32	32.96	31.0	31.6267	551400.0
2020-04-14	AAP	Stock	111.24	116.33	111.14	115.39	922500.0
2020-04-14	AAT	Stock	29.06	29.76	28.92	29.37	404700.0
2020-04-14	AAU-DELISTED	Stock	0.4	0.43	0.3621	0.3749	540333.0
2020-04-14	AAUAF-DELISTED	Stock	0.4	0.42	0.3621	0.3749	577700.0
2020-04-14	AAWW-DELISTED	Stock	24.84	25.82	24.3453	25.59	407498.0
2020-04-14	AAXJ	Stock	62.98	63.42	62.79	63.1	1644828.0
2020-04-14	AAXN-DELISTED	Stock	75.1	77.54	74.9	76.33	310857.0
2020-04-14	AB	Stock	20.18	21.71	20.18	20.86	587800.0
2020-04-14	ABB-DELISTED	Stock	18.27	18.44	18.15	18.24	2226503.0
2020-04-14	ABBNY-DELISTED	Stock	18.27	18.44	18.15	18.24	2374492.0
2020-04-14	ABBV	Stock	80.62	82.85	80.29	82.13	11072700.0
2020-04-14	ABC-DELISTED	Stock	87.59	89.9	87.07	89.42	755675.0
2020-04-14	ABCB	Stock	25.56	25.75	23.83	24.08	549800.0
2020-04-14	ABEO	Stock	61.0	65.75	61.0	65.0	39104.0
2020-04-14	ABEV	Stock	2.4	2.44	2.35	2.36	19319700.0
2020-04-14	ABG	Stock	58.65	60.83	57.54	60.45	366800.0
2020-04-14	ABM	Stock	29.5	31.05	29.1	30.98	810800.0
2020-04-14	ABMD-DELISTED	Stock	158.26	164.615	157.155	161.19	376598.0
2020-04-14	ABR	Stock	7.43	7.54	6.79	6.99	2637000.0
2020-04-14	ABR.A-DELISTED	Stock	21.2971	21.64	20.77	21.64	3578.0
2020-04-14	ABR.B-DELISTED	Stock	20.5	21.8582	19.16	21.8582	2979.0
2020-04-14	ABR.C-DELISTED	Stock	20.6245	20.85	20.0	20.5	6885.0
2020-04-14	ABT	Stock	87.0	89.54	86.5	89.14	9861300.0
2020-04-14	ABTC	Stock	246000.0	250500.0	238500.0	242100.0	2.8
2020-04-14	ABTS	Stock	15.9	17.25	13.5	14.4	7367.0
2020-04-14	ABTX-DELISTED	Stock	25.91	26.28	24.0	24.68	52463.0
2020-04-14	ABUS	Stock	1.08	1.15	1.03	1.07	629400.0

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

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