PREVIEW / stock_daily / 2021-08-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-05.parquet
  size:    258 KB
  rows:    7,890
  symbols: 2,795

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-05	AAPL	Stock	146.98	147.84	146.17	147.06	46397700.0
2021-08-05	MSFT	Stock	286.88	289.63	286.1	289.52	13900200.0
2021-08-05	NVDA	Stock	20.5	20.733	20.342	20.637	211435000.0
2021-08-05	AMZN	Stock	167.811	169.45	167.046	168.7995	48670000.0
2021-08-05	GOOGL	Stock	135.6805	136.35	134.846	136.2515	17869000.0
2021-08-05	META	Stock	359.64	363.9	356.9	362.97	10247200.0
2021-08-05	TSLA	Stock	238.6667	240.3167	237.1367	238.21	38758800.0
2021-08-05	TLT	Stock	150.76	150.92	150.0	150.29	15345359.0
2021-08-05	ES	Stock	88.48	89.15	87.89	89.03	1045200.0
2021-08-05	CL	Stock	78.77	79.38	78.4	78.9	4135100.0
2021-08-05	A	Stock	154.46	155.16	153.34	155.04	1667600.0
2021-08-05	AA	Stock	38.49	39.35	38.29	38.75	4021700.0
2021-08-05	AAC-DELISTED	Stock	9.74	9.75	9.69	9.71	41353.0
2021-08-05	AACG	Stock	2.86	2.92	2.85	2.87	44100.0
2021-08-05	AAIC-DELISTED	Stock	3.8	3.87	3.78	3.81	66180.0
2021-08-05	AAIC.C-DELISTED	Stock	25.1801	25.273	25.17	25.233	7114.0
2021-08-05	AAL	Stock	19.47	20.97	19.45	20.91	42900900.0
2021-08-05	AAM.A-DELISTED	Stock	26.29	26.45	26.29	26.38	10245.0
2021-08-05	AAM.B-DELISTED	Stock	27.21	27.25	27.145	27.19	10269.0
2021-08-05	AAMC-DELISTED	Stock	4.3853	4.6265	4.2971	4.4235	30372.0
2021-08-05	AAME	Stock	4.16	4.26	4.05	4.24	14100.0
2021-08-05	AAMI	Stock	25.88	26.19	25.72	26.18	357200.0
2021-08-05	AAN-DELISTED	Stock	28.07	28.45	27.73	27.96	226600.0
2021-08-05	AAOI	Stock	7.71	7.875	7.62	7.7	485300.0
2021-08-05	AAON	Stock	41.6533	42.4067	41.5267	42.1533	166200.0
2021-08-05	AAP	Stock	210.68	211.94	205.13	206.34	826000.0
2021-08-05	AAQC-DELISTED	Stock	9.65	9.67	9.65	9.66	9319.0
2021-08-05	AAT	Stock	36.74	37.6	36.71	37.6	188600.0
2021-08-05	AATC	Stock	6.7	7.02	6.65	6.96	62127.0
2021-08-05	AAU-DELISTED	Stock	0.4416	0.4416	0.4225	0.438	328334.0
2021-08-05	AAUAF-DELISTED	Stock	0.4416	0.4416	0.4225	0.4415	335115.0
2021-08-05	AAWW-DELISTED	Stock	68.625	71.02	67.6405	70.34	406552.0
2021-08-05	AAXJ	Stock	88.82	89.18	88.77	88.97	1709602.0
2021-08-05	AB	Stock	50.48	51.19	50.04	50.74	452000.0
2021-08-05	ABB-DELISTED	Stock	37.13	37.36	37.1	37.3	1056226.0
2021-08-05	ABBNY-DELISTED	Stock	37.13	37.36	37.1	37.29	1153814.0
2021-08-05	ABBV	Stock	115.13	115.56	114.45	115.12	5132400.0
2021-08-05	ABC-DELISTED	Stock	125.7	126.09	119.5	121.9	1613200.0
2021-08-05	ABCB	Stock	48.16	49.21	48.16	49.16	218600.0
2021-08-05	ABCL	Stock	15.472	15.83	15.1	15.61	1228300.0
2021-08-05	ABCM-DELISTED	Stock	19.31	19.56	19.11	19.5	80029.0
2021-08-05	ABEO	Stock	30.75	32.5	30.0	32.0	21528.0
2021-08-05	ABEV	Stock	3.25	3.27	3.14	3.17	24263300.0
2021-08-05	ABG	Stock	195.83	198.54	192.97	195.06	123300.0
2021-08-05	ABGI-DELISTED	Stock	9.71	9.78	9.71	9.74	9154.0
2021-08-05	ABM	Stock	46.99	47.0	46.44	46.7	409300.0
2021-08-05	ABMD-DELISTED	Stock	336.0	349.27	334.735	349.06	222722.0
2021-08-05	ABNB	Stock	146.67	150.41	146.399	150.32	4737500.0
2021-08-05	ABOS	Stock	14.85	15.36	14.75	14.99	88300.0
2021-08-05	ABR	Stock	18.09	18.38	18.09	18.33	1365100.0

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

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