PREVIEW / stock_daily / 2020-05-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-21.parquet
  size:    217 KB
  rows:    6,604
  symbols: 2,334

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-05-21	AAPL	Stock	79.665	80.2225	78.9675	79.2125	102688800.0
2020-05-21	MSFT	Stock	185.4	186.67	183.29	183.43	29119500.0
2020-05-21	NVDA	Stock	9.0515	9.0525	8.7375	8.7752	761068000.0
2020-05-21	AMZN	Stock	125.0	126.2725	122.127	122.337	102288000.0
2020-05-21	GOOGL	Stock	70.5495	70.823	69.7195	70.3375	30899520.0
2020-05-21	META	Stock	234.72	237.2	231.2	231.39	47782600.0
2020-05-21	TSLA	Stock	54.4	55.5	53.0667	55.1733	183819000.0
2020-05-21	TLT	Stock	164.86	165.36	164.29	164.56	8920309.0
2020-05-21	ES	Stock	79.11	79.43	78.3	78.82	1655200.0
2020-05-21	CL	Stock	71.01	71.01	69.76	70.26	5171900.0
2020-05-21	A	Stock	81.72	82.19	80.46	80.75	2576500.0
2020-05-21	AA	Stock	8.26	8.4	8.03	8.28	9117500.0
2020-05-21	AACG	Stock	0.96	0.96	0.88	0.9	37700.0
2020-05-21	AAIC-DELISTED	Stock	2.45	2.46	2.3621	2.4	226501.0
2020-05-21	AAIC.C-DELISTED	Stock	16.12	16.45	16.01	16.45	4133.0
2020-05-21	AAL	Stock	9.87	10.15	9.83	9.89	45785700.0
2020-05-21	AAM.A-DELISTED	Stock	26.15	26.2	26.06	26.2	7066.0
2020-05-21	AAM.B-DELISTED	Stock	26.037	26.23	25.95	26.15	21948.0
2020-05-21	AAMC-DELISTED	Stock	5.1103	5.1103	4.7765	4.9971	5875.0
2020-05-21	AAME	Stock	1.89	1.9	1.81	1.81	1800.0
2020-05-21	AAMI	Stock	8.32	8.505	8.31	8.36	170800.0
2020-05-21	AAOI	Stock	8.64	8.83	8.51	8.66	348000.0
2020-05-21	AAON	Stock	33.36	34.58	33.36	34.5267	242100.0
2020-05-21	AAP	Stock	135.57	136.02	130.07	134.79	1512800.0
2020-05-21	AAT	Stock	25.72	26.62	25.46	25.93	201900.0
2020-05-21	AAU-DELISTED	Stock	0.455	0.455	0.429	0.433	253665.0
2020-05-21	AAUAF-DELISTED	Stock	0.455	0.455	0.429	0.433	260723.0
2020-05-21	AAWW-DELISTED	Stock	40.05	40.29	38.85	39.59	328142.0
2020-05-21	AAXJ	Stock	64.85	64.99	64.18	64.35	793385.0
2020-05-21	AAXN-DELISTED	Stock	76.22	77.535	72.88	76.46	529366.0
2020-05-21	AB	Stock	23.75	24.59	23.62	23.92	432700.0
2020-05-21	ABB-DELISTED	Stock	18.65	18.8969	18.45	18.54	3106410.0
2020-05-21	ABBNY-DELISTED	Stock	18.65	18.8969	18.45	18.54	3251708.0
2020-05-21	ABBV	Stock	91.28	93.13	90.35	93.02	10393200.0
2020-05-21	ABC-DELISTED	Stock	92.17	93.27	91.19	92.25	786289.0
2020-05-21	ABCB	Stock	21.62	22.01	21.29	21.52	263000.0
2020-05-21	ABEO	Stock	82.25	82.25	76.25	80.75	32688.0
2020-05-21	ABEV	Stock	2.19	2.23	2.11	2.13	37050400.0
2020-05-21	ABG	Stock	70.58	74.78	69.26	72.97	236400.0
2020-05-21	ABM	Stock	32.6	33.45	32.57	32.57	270200.0
2020-05-21	ABMD-DELISTED	Stock	196.6	198.55	194.13	196.3	167055.0
2020-05-21	ABR	Stock	7.61	7.68	7.38	7.6	1516100.0
2020-05-21	ABR.A-DELISTED	Stock	24.2627	24.2627	23.8	24.25	2186.0
2020-05-21	ABR.B-DELISTED	Stock	22.81	23.59	22.6929	23.556	3236.0
2020-05-21	ABR.C-DELISTED	Stock	24.92	27.51	24.54	27.51	10116.0
2020-05-21	ABT	Stock	89.64	90.61	88.38	90.39	6148300.0
2020-05-21	ABTC	Stock	240600.0	245040.0	229800.0	240300.0	2.1333333333333333
2020-05-21	ABTS	Stock	9.42	10.65	8.4	9.705	1780.0
2020-05-21	ABTX-DELISTED	Stock	24.95	25.41	24.68	24.88	59871.0
2020-05-21	ABUS	Stock	2.35	2.42	2.3	2.34	733600.0

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

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