PREVIEW / stock_daily / 2021-08-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-19.parquet
  size:    257 KB
  rows:    7,896
  symbols: 2,774

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
2021-08-19	AAPL	Stock	145.03	148.0	144.5	146.7	86960300.0
2021-08-19	MSFT	Stock	288.69	297.47	288.64	296.77	29850500.0
2021-08-19	NVDA	Stock	19.494	20.495	18.762	19.798	766555000.0
2021-08-19	AMZN	Stock	159.701	161.65	159.123	159.3875	75658000.0
2021-08-19	GOOGL	Stock	134.4355	136.3525	134.25	135.68	21782540.0
2021-08-19	META	Stock	351.35	357.57	351.0	355.12	12004500.0
2021-08-19	TSLA	Stock	226.07	228.85	222.53	224.49	42940500.0
2021-08-19	TLT	Stock	150.31	150.46	149.81	150.45	15474585.0
2021-08-19	ES	Stock	90.29	91.83	90.12	91.18	1567300.0
2021-08-19	CL	Stock	78.19	79.28	78.19	78.97	3527800.0
2021-08-19	A	Stock	161.74	169.08	161.61	167.67	2179600.0
2021-08-19	AA	Stock	39.9	40.09	36.609	36.92	16177800.0
2021-08-19	AAC-DELISTED	Stock	9.67	9.71	9.66	9.67	64351.0
2021-08-19	AACG	Stock	2.51	2.57	2.5	2.52	29800.0
2021-08-19	AACIU	Stock	9.85	9.85	9.8	9.83	4440.0
2021-08-19	AAIC-DELISTED	Stock	3.7	3.72	3.66	3.68	107809.0
2021-08-19	AAIC.C-DELISTED	Stock	24.99	25.0904	24.99	25.0899	3460.0
2021-08-19	AAL	Stock	19.0	19.2	18.38	18.73	37097100.0
2021-08-19	AAM.A-DELISTED	Stock	26.27	26.3	26.21	26.3	6122.0
2021-08-19	AAM.B-DELISTED	Stock	26.91	27.03	26.91	26.99	4404.0
2021-08-19	AAMC-DELISTED	Stock	3.8971	3.8971	3.6885	3.7706	87132.0
2021-08-19	AAME	Stock	3.6	3.8	3.56	3.65	78000.0
2021-08-19	AAMI	Stock	25.76	26.19	25.65	26.16	492500.0
2021-08-19	AAN-DELISTED	Stock	27.85	28.73	27.7	28.3	349100.0
2021-08-19	AAOI	Stock	6.62	6.71	6.51	6.52	405000.0
2021-08-19	AAON	Stock	44.4	45.7933	44.3867	45.6133	208950.0
2021-08-19	AAP	Stock	205.86	209.72	205.53	208.37	380700.0
2021-08-19	AAQC-DELISTED	Stock	9.64	9.66	9.61	9.62	14741.0
2021-08-19	AAT	Stock	37.34	37.8	37.15	37.57	159600.0
2021-08-19	AATC	Stock	6.94	7.03	6.75	6.84	54229.0
2021-08-19	AAU-DELISTED	Stock	0.395	0.3959	0.365	0.3661	928254.0
2021-08-19	AAUAF-DELISTED	Stock	0.395	0.3959	0.365	0.3658	943645.0
2021-08-19	AAWW-DELISTED	Stock	74.41	74.61	72.79	74.06	417410.0
2021-08-19	AAXJ	Stock	83.84	84.45	83.73	84.05	924965.0
2021-08-19	AB	Stock	49.7	50.77	49.5	50.31	349800.0
2021-08-19	ABB-DELISTED	Stock	37.26	37.59	37.252	37.48	980043.0
2021-08-19	ABBNY-DELISTED	Stock	37.26	37.59	37.252	37.47	1112126.0
2021-08-19	ABBV	Stock	116.21	118.96	116.21	117.93	6145200.0
2021-08-19	ABC-DELISTED	Stock	117.94	120.65	117.7557	119.26	530631.0
2021-08-19	ABCB	Stock	47.97	48.4	47.13	47.45	335100.0
2021-08-19	ABCL	Stock	16.5	16.5	15.45	15.79	3199900.0
2021-08-19	ABCM-DELISTED	Stock	20.25	20.37	20.04	20.1	42573.0
2021-08-19	ABEO	Stock	30.0	30.5	29.0	29.0	12580.0
2021-08-19	ABEV	Stock	3.01	3.14	3.0	3.11	44972300.0
2021-08-19	ABG	Stock	187.57	188.96	183.52	186.12	101400.0
2021-08-19	ABGI-DELISTED	Stock	9.6303	9.66	9.6303	9.66	2699.0
2021-08-19	ABM	Stock	46.49	47.7	46.49	47.6	391200.0
2021-08-19	ABMD-DELISTED	Stock	330.17	339.0	330.17	333.35	95428.0
2021-08-19	ABNB	Stock	143.791	145.28	141.92	142.65	4732400.0
2021-08-19	ABOS	Stock	15.65	16.79	15.65	16.69	113500.0

> showing 50 of 7,896 rows — these rows as CSV

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