PREVIEW / stock_daily / 2020-04-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-13.parquet
  size:    214 KB
  rows:    6,591
  symbols: 2,336

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-13	AAPL	Stock	67.0775	68.425	66.4575	68.3125	131022800.0
2020-04-13	MSFT	Stock	164.35	165.57	162.3	165.51	41905300.0
2020-04-13	NVDA	Stock	6.5138	6.755	6.425	6.7463	398408000.0
2020-04-13	AMZN	Stock	102.0	109.0	101.9	108.4435	134334000.0
2020-04-13	GOOGL	Stock	60.075	60.726	59.1166	60.5205	38702560.0
2020-04-13	META	Stock	173.67	175.0	169.45	174.79	19355400.0
2020-04-13	TSLA	Stock	39.344	43.4667	38.702	43.3967	337131000.0
2020-04-13	TLT	Stock	164.75	165.71	163.88	163.88	8750297.0
2020-04-13	ES	Stock	88.73	89.8	85.48	86.72	2258500.0
2020-04-13	CL	Stock	69.63	70.21	69.21	69.49	3335000.0
2020-04-13	A	Stock	77.44	77.99	75.02	76.21	1533000.0
2020-04-13	AA	Stock	7.48	7.75	7.12	7.55	9563900.0
2020-04-13	AACG	Stock	0.82	0.86	0.82	0.82	5700.0
2020-04-13	AAIC-DELISTED	Stock	2.94	3.07	2.65	3.03	847693.0
2020-04-13	AAIC.C-DELISTED	Stock	17.1	17.3	17.0	17.15	1640.0
2020-04-13	AAL	Stock	12.9	12.95	11.25	11.56	73385500.0
2020-04-13	AAM.A-DELISTED	Stock	24.59	24.69	24.0	24.69	31648.0
2020-04-13	AAM.B-DELISTED	Stock	24.16	24.648	24.1	24.58	37429.0
2020-04-13	AAMC-DELISTED	Stock	3.9005	4.1374	3.8676	4.1374	5362.0
2020-04-13	AAMI	Stock	6.18	6.55	5.92	6.34	349300.0
2020-04-13	AAOI	Stock	7.73	8.0	7.56	7.99	379900.0
2020-04-13	AAON	Stock	31.7267	32.4267	31.1267	31.84	361500.0
2020-04-13	AAP	Stock	109.02	110.05	103.6	110.0	1175500.0
2020-04-13	AAT	Stock	29.24	29.29	27.8	28.3	326400.0
2020-04-13	AAU-DELISTED	Stock	0.3234	0.3849	0.3229	0.38	724665.0
2020-04-13	AAUAF-DELISTED	Stock	0.3234	0.3849	0.3232	0.3778	758403.0
2020-04-13	AAWW-DELISTED	Stock	25.32	25.48	23.11	24.15	287578.0
2020-04-13	AAXJ	Stock	61.57	61.73	61.07	61.68	1039424.0
2020-04-13	AAXN-DELISTED	Stock	73.76	74.38	71.67	73.5	234483.0
2020-04-13	AB	Stock	21.45	21.79	19.86	20.24	742100.0
2020-04-13	ABB-DELISTED	Stock	17.9	18.11	17.5	17.82	1775252.0
2020-04-13	ABBNY-DELISTED	Stock	17.9	18.11	17.5	17.81	1894940.0
2020-04-13	ABBV	Stock	80.66	81.33	78.66	80.3	9293500.0
2020-04-13	ABC-DELISTED	Stock	87.56	87.56	84.215	85.44	1815754.0
2020-04-13	ABCB	Stock	27.03	27.03	24.56	24.95	422800.0
2020-04-13	ABEO	Stock	59.75	61.0	56.75	60.0	26476.0
2020-04-13	ABEV	Stock	2.34	2.37	2.32	2.36	30193500.0
2020-04-13	ABG	Stock	60.48	60.6	55.53	57.04	207200.0
2020-04-13	ABM	Stock	28.37	28.81	27.83	28.69	446400.0
2020-04-13	ABMD-DELISTED	Stock	159.81	159.81	152.2144	156.44	305130.0
2020-04-13	ABR	Stock	7.96	8.12	6.92	7.05	3765600.0
2020-04-13	ABR.A-DELISTED	Stock	18.65	20.45	18.65	19.4782	2656.0
2020-04-13	ABR.B-DELISTED	Stock	20.25	20.25	20.25	20.25	200.0
2020-04-13	ABR.C-DELISTED	Stock	20.25	20.81	19.0	19.0	7504.0
2020-04-13	ABT	Stock	86.32	86.48	83.52	85.85	6665800.0
2020-04-13	ABTC	Stock	230100.0	242700.0	221310.0	239100.0	3.48
2020-04-13	ABTS	Stock	13.95	16.05	12.75	15.9	8820.0
2020-04-13	ABTX-DELISTED	Stock	26.95	28.47	24.84	25.28	35142.0
2020-04-13	ABUS	Stock	1.09	1.1	1.02	1.05	536000.0
2020-04-13	ACA	Stock	41.5	41.5	40.02	40.53	306005.0

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

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