PREVIEW / stock_daily / 2021-08-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-04.parquet
  size:    258 KB
  rows:    7,898
  symbols: 2,804

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-04	AAPL	Stock	147.27	147.79	146.28	146.95	56368300.0
2021-08-04	MSFT	Stock	286.22	287.59	284.65	286.51	16191300.0
2021-08-04	NVDA	Stock	19.99	20.318	19.828	20.274	231309000.0
2021-08-04	AMZN	Stock	168.9675	169.444	167.278	167.736	43678000.0
2021-08-04	GOOGL	Stock	135.3495	135.6495	134.487	135.1255	19676020.0
2021-08-04	META	Stock	352.42	360.48	351.51	358.92	14180600.0
2021-08-04	TSLA	Stock	237.0	241.6333	236.31	236.9733	51007800.0
2021-08-04	TLT	Stock	151.5	151.82	149.72	151.06	18267907.0
2021-08-04	ES	Stock	87.31	88.22	86.71	88.17	1209600.0
2021-08-04	CL	Stock	79.26	79.47	77.82	78.25	4194400.0
2021-08-04	A	Stock	153.96	154.71	153.49	154.27	1786700.0
2021-08-04	AA	Stock	39.97	40.019	38.53	38.75	5087600.0
2021-08-04	AAC-DELISTED	Stock	9.74	9.76	9.7	9.71	98492.0
2021-08-04	AACG	Stock	2.92	3.0	2.89	2.9	25900.0
2021-08-04	AAIC-DELISTED	Stock	3.92	3.92	3.78	3.79	152935.0
2021-08-04	AAIC.C-DELISTED	Stock	25.215	25.25	25.215	25.25	2353.0
2021-08-04	AAL	Stock	19.52	19.95	19.35	19.45	30815400.0
2021-08-04	AAM.A-DELISTED	Stock	26.4	26.45	26.3	26.33	21635.0
2021-08-04	AAM.B-DELISTED	Stock	27.11	27.201	27.11	27.13	11282.0
2021-08-04	AAMC-DELISTED	Stock	4.4883	4.5029	4.3235	4.3235	41749.0
2021-08-04	AAME	Stock	4.25	4.31	4.12	4.2	22000.0
2021-08-04	AAMI	Stock	25.17	25.79	25.1	25.73	598500.0
2021-08-04	AAN-DELISTED	Stock	28.64	29.34	27.47	27.61	168500.0
2021-08-04	AAOI	Stock	7.51	7.72	7.38	7.71	563300.0
2021-08-04	AAON	Stock	41.72	42.2133	41.0733	41.3867	141150.0
2021-08-04	AAP	Stock	214.13	215.14	209.45	209.67	495200.0
2021-08-04	AAQC-DELISTED	Stock	9.65	9.65	9.62	9.62	102511.0
2021-08-04	AAT	Stock	36.54	37.01	36.18	36.26	212000.0
2021-08-04	AATC	Stock	6.79	7.08	6.6129	6.68	116272.0
2021-08-04	AAU-DELISTED	Stock	0.4325	0.445	0.4223	0.4299	241078.0
2021-08-04	AAUAF-DELISTED	Stock	0.4325	0.445	0.4223	0.4287	248820.0
2021-08-04	AAWW-DELISTED	Stock	67.11	68.23	66.33	67.34	307809.0
2021-08-04	AAXJ	Stock	89.26	89.75	89.13	89.32	1507826.0
2021-08-04	AB	Stock	50.23	51.21	49.71	50.19	322000.0
2021-08-04	ABB-DELISTED	Stock	37.2	37.4701	37.14	37.16	2075628.0
2021-08-04	ABBNY-DELISTED	Stock	37.2	37.4701	37.14	37.16	2210245.0
2021-08-04	ABBV	Stock	115.78	116.52	114.91	115.08	4602000.0
2021-08-04	ABC-DELISTED	Stock	123.76	128.87	123.575	125.56	1292812.0
2021-08-04	ABCB	Stock	47.93	49.02	47.83	47.89	297100.0
2021-08-04	ABCL	Stock	15.77	15.77	15.06	15.23	1159500.0
2021-08-04	ABCM-DELISTED	Stock	19.7	19.93	19.24	19.27	205555.0
2021-08-04	ABEO	Stock	31.0	31.25	30.0	30.25	20788.0
2021-08-04	ABEV	Stock	3.25	3.27	3.13	3.16	20620300.0
2021-08-04	ABG	Stock	195.51	198.99	191.22	193.21	154100.0
2021-08-04	ABGI-DELISTED	Stock	9.7	9.72	9.7	9.72	13864.0
2021-08-04	ABM	Stock	46.7	47.28	46.52	46.68	483300.0
2021-08-04	ABMD-DELISTED	Stock	325.69	335.0	325.24	331.02	197782.0
2021-08-04	ABNB	Stock	145.1	147.46	145.01	147.4	4631400.0
2021-08-04	ABOS	Stock	15.08	16.01	14.61	14.65	81500.0
2021-08-04	ABR	Stock	17.83	18.12	17.68	18.04	1204200.0

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

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