PREVIEW / stock_daily / 2021-08-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-09.parquet
  size:    257 KB
  rows:    7,882
  symbols: 2,771

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-09	AAPL	Stock	146.2	146.7	145.52	146.09	48908700.0
2021-08-09	MSFT	Stock	289.75	291.55	287.81	288.33	16117600.0
2021-08-09	NVDA	Stock	20.446	20.508	20.143	20.295	146443000.0
2021-08-09	AMZN	Stock	167.1805	167.744	166.426	167.0935	42964000.0
2021-08-09	GOOGL	Stock	135.9425	137.184	135.3392	136.913	17766000.0
2021-08-09	META	Stock	363.76	365.78	360.75	361.61	7798900.0
2021-08-09	TSLA	Stock	236.7233	239.6767	235.0433	237.92	44145900.0
2021-08-09	TLT	Stock	148.152	148.56	147.23	147.25	12942623.0
2021-08-09	ES	Stock	89.27	89.41	88.33	88.95	872900.0
2021-08-09	CL	Stock	78.77	78.93	78.03	78.34	2563700.0
2021-08-09	A	Stock	156.08	156.8	155.01	156.54	982900.0
2021-08-09	AA	Stock	40.45	41.49	39.9	40.53	5634400.0
2021-08-09	AAC-DELISTED	Stock	9.74	9.77	9.7	9.72	28816.0
2021-08-09	AACG	Stock	2.89	2.91	2.86	2.86	47700.0
2021-08-09	AAIC-DELISTED	Stock	3.81	3.89	3.81	3.84	64607.0
2021-08-09	AAIC.C-DELISTED	Stock	25.05	25.2299	25.05	25.09	1985.0
2021-08-09	AAL	Stock	20.77	20.79	20.06	20.56	32047600.0
2021-08-09	AAM.A-DELISTED	Stock	26.43	26.51	26.3562	26.3562	10292.0
2021-08-09	AAM.B-DELISTED	Stock	27.29	27.32	27.1401	27.181	11968.0
2021-08-09	AAMC-DELISTED	Stock	4.5559	4.5559	4.2	4.3706	37648.0
2021-08-09	AAME	Stock	4.55	4.59	4.45	4.49	48300.0
2021-08-09	AAMI	Stock	26.41	26.78	26.14	26.72	383500.0
2021-08-09	AAN-DELISTED	Stock	27.46	27.61	26.9	26.98	240900.0
2021-08-09	AAOI	Stock	7.2	7.61	7.15	7.52	740200.0
2021-08-09	AAON	Stock	44.9533	46.1933	44.8733	45.7	312450.0
2021-08-09	AAP	Stock	205.08	205.65	204.19	204.52	512700.0
2021-08-09	AAQC-DELISTED	Stock	9.63	9.66	9.63	9.6568	3866.0
2021-08-09	AAT	Stock	38.11	38.11	37.35	37.57	220400.0
2021-08-09	AATC	Stock	6.93	6.93	6.76	6.8393	15660.0
2021-08-09	AAU-DELISTED	Stock	0.4278	0.4278	0.4152	0.4153	365064.0
2021-08-09	AAUAF-DELISTED	Stock	0.4278	0.4278	0.4152	0.416	375258.0
2021-08-09	AAWW-DELISTED	Stock	71.85	72.7	69.5	72.33	226580.0
2021-08-09	AAXJ	Stock	88.48	88.95	88.13	88.56	1080013.0
2021-08-09	AB	Stock	49.75	49.92	48.75	48.75	322900.0
2021-08-09	ABB-DELISTED	Stock	36.86	36.8937	36.67	36.71	1069640.0
2021-08-09	ABBNY-DELISTED	Stock	36.86	36.8937	36.67	36.71	1159903.0
2021-08-09	ABBV	Stock	114.58	115.19	113.74	114.06	5277900.0
2021-08-09	ABC-DELISTED	Stock	120.64	121.885	119.2	120.22	391849.0
2021-08-09	ABCB	Stock	49.95	50.44	48.46	49.97	512400.0
2021-08-09	ABCL	Stock	15.03	16.49	14.98	16.2	1848500.0
2021-08-09	ABCM-DELISTED	Stock	20.39	20.42	20.1	20.39	57423.0
2021-08-09	ABEO	Stock	31.75	33.25	31.0	32.0	26492.0
2021-08-09	ABEV	Stock	3.25	3.28	3.2	3.21	36384000.0
2021-08-09	ABG	Stock	193.0	195.79	188.37	193.31	142800.0
2021-08-09	ABGI-DELISTED	Stock	9.72	9.72	9.72	9.72	667.0
2021-08-09	ABM	Stock	46.81	46.91	46.31	46.76	186300.0
2021-08-09	ABMD-DELISTED	Stock	345.0	350.0	342.95	346.72	148146.0
2021-08-09	ABNB	Stock	148.74	151.0	148.7	149.44	5541900.0
2021-08-09	ABOS	Stock	15.11	15.2	14.8	15.04	70000.0
2021-08-09	ABR	Stock	18.28	18.4	18.11	18.22	1158700.0

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

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