PREVIEW / stock_daily / 2020-04-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-28.parquet
  size:    216 KB
  rows:    6,593
  symbols: 2,348

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-28	AAPL	Stock	71.27	71.4575	69.55	69.645	112004800.0
2020-04-28	MSFT	Stock	175.59	175.67	169.39	169.81	34392700.0
2020-04-28	NVDA	Stock	7.575	7.605	7.2785	7.284	442904000.0
2020-04-28	AMZN	Stock	118.605	118.675	115.3	115.704	105388000.0
2020-04-28	GOOGL	Stock	64.16	64.238	61.519	61.6295	80700140.0
2020-04-28	META	Stock	188.66	189.2	182.56	182.91	21731000.0
2020-04-28	TSLA	Stock	53.0427	53.6667	50.446	51.2747	228330000.0
2020-04-28	TLT	Stock	168.55	169.85	168.45	169.59	9905415.0
2020-04-28	ES	Stock	86.31	87.67	85.72	86.22	1427600.0
2020-04-28	CL	Stock	71.94	71.94	70.44	71.11	2995700.0
2020-04-28	A	Stock	77.0	77.0	75.34	75.45	1855900.0
2020-04-28	AA	Stock	7.55	8.11	7.38	7.84	12227900.0
2020-04-28	AACG	Stock	0.69	0.75	0.69	0.75	20200.0
2020-04-28	AAIC-DELISTED	Stock	2.74	2.915	2.72	2.87	353949.0
2020-04-28	AAIC.C-DELISTED	Stock	16.94	17.1	16.91	16.99	5535.0
2020-04-28	AAL	Stock	10.29	11.63	10.21	11.26	114643000.0
2020-04-28	AAM.A-DELISTED	Stock	25.5785	25.68	25.4	25.4	9319.0
2020-04-28	AAM.B-DELISTED	Stock	25.41	25.67	25.23	25.2805	25012.0
2020-04-28	AAMC-DELISTED	Stock	4.1147	4.1618	4.1147	4.1263	19795.0
2020-04-28	AAME	Stock	1.58	1.79	1.58	1.61	7400.0
2020-04-28	AAMI	Stock	7.36	7.63	7.23	7.45	655700.0
2020-04-28	AAOI	Stock	9.92	10.177	9.66	9.76	393300.0
2020-04-28	AAON	Stock	32.5733	33.12	31.9333	32.2133	269850.0
2020-04-28	AAP	Stock	121.51	123.24	119.94	120.97	776000.0
2020-04-28	AAT	Stock	28.73	29.58	27.99	29.02	346300.0
2020-04-28	AAU-DELISTED	Stock	0.44	0.4751	0.42	0.4651	569218.0
2020-04-28	AAUAF-DELISTED	Stock	0.44	0.4751	0.42	0.471	582798.0
2020-04-28	AAWW-DELISTED	Stock	32.15	33.0	30.72	31.97	589970.0
2020-04-28	AAXJ	Stock	64.66	64.67	63.71	63.71	1952747.0
2020-04-28	AAXN-DELISTED	Stock	73.63	76.0	71.12	75.37	511572.0
2020-04-28	AB	Stock	22.0	22.84	21.62	22.22	929500.0
2020-04-28	ABB-DELISTED	Stock	18.72	18.785	18.5	18.63	2291874.0
2020-04-28	ABBNY-DELISTED	Stock	18.72	18.785	18.5	18.63	2859158.0
2020-04-28	ABBV	Stock	85.7	85.97	82.37	82.76	8341000.0
2020-04-28	ABC-DELISTED	Stock	91.93	92.0782	89.24	89.56	862415.0
2020-04-28	ABCB	Stock	25.62	26.27	24.72	24.92	422400.0
2020-04-28	ABEO	Stock	65.0	65.0	59.25	63.0	46196.0
2020-04-28	ABEV	Stock	2.16	2.19	2.11	2.13	56467000.0
2020-04-28	ABG	Stock	63.01	65.38	62.39	63.54	324600.0
2020-04-28	ABM	Stock	33.8	34.48	33.35	34.09	421600.0
2020-04-28	ABMD-DELISTED	Stock	166.0	167.85	161.0	164.11	399313.0
2020-04-28	ABR	Stock	6.45	6.74	6.28	6.51	2575600.0
2020-04-28	ABR.A-DELISTED	Stock	21.6373	21.9	20.83	21.55	5633.0
2020-04-28	ABR.B-DELISTED	Stock	19.83	21.0524	19.5975	20.25	12518.0
2020-04-28	ABR.C-DELISTED	Stock	22.12	22.4	21.75	22.0	3595.0
2020-04-28	ABT	Stock	94.88	95.15	91.34	91.46	7805500.0
2020-04-28	ABTC	Stock	276000.0	282630.0	265500.0	271500.0	3.1199999999999997
2020-04-28	ABTS	Stock	12.33	12.33	10.23	10.95	3013.0
2020-04-28	ABTX-DELISTED	Stock	25.0	25.71	24.5582	25.44	67683.0
2020-04-28	ABUS	Stock	1.17	1.26	1.17	1.2	304700.0

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

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