PREVIEW / stock_daily / 2021-09-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-23.parquet
  size:    258 KB
  rows:    7,890
  symbols: 2,705

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-09-23	AAPL	Stock	146.65	147.08	145.64	146.83	64838200.0
2021-09-23	MSFT	Stock	298.85	300.9	297.53	299.56	18604600.0
2021-09-23	NVDA	Stock	22.14	22.535	21.89	22.482	248555000.0
2021-09-23	AMZN	Stock	169.0025	171.448	169.0025	170.8	47588000.0
2021-09-23	GOOGL	Stock	140.9875	141.6965	140.4015	141.216	20951000.0
2021-09-23	META	Stock	345.36	349.67	343.0	345.96	21806300.0
2021-09-23	TSLA	Stock	251.6667	252.7333	249.3067	251.2133	35842500.0
2021-09-23	TLT	Stock	150.42	150.45	148.3401	148.36	23853343.0
2021-09-23	ES	Stock	83.08	83.43	82.36	82.49	1147000.0
2021-09-23	CL	Stock	76.73	76.91	76.31	76.67	2393100.0
2021-09-23	A	Stock	173.5	174.35	172.49	172.77	1654600.0
2021-09-23	AA	Stock	48.11	49.46	47.8	48.56	5723400.0
2021-09-23	AAC-DELISTED	Stock	9.77	9.77	9.7389	9.74	3619.0
2021-09-23	AACG	Stock	2.44	2.47	2.36	2.36	34500.0
2021-09-23	AACIU	Stock	9.87	9.97	9.87	9.9	98137.0
2021-09-23	AAIC-DELISTED	Stock	3.79	3.79	3.76	3.77	87141.0
2021-09-23	AAIC.C-DELISTED	Stock	25.175	25.233	25.1003	25.14	3952.0
2021-09-23	AAL	Stock	20.76	21.3	20.65	20.9	51636300.0
2021-09-23	AAM.A-DELISTED	Stock	25.92	25.98	25.71	25.8196	14069.0
2021-09-23	AAM.B-DELISTED	Stock	26.95	26.95	26.76	26.83	12705.0
2021-09-23	AAMC-DELISTED	Stock	7.3559	7.6235	7.2147	7.3882	372943.0
2021-09-23	AAME	Stock	3.79	3.91	3.76	3.91	10700.0
2021-09-23	AAMI	Stock	26.79	27.13	26.76	27.0	288400.0
2021-09-23	AAN-DELISTED	Stock	27.72	28.715	27.65	27.8	175600.0
2021-09-23	AAOI	Stock	7.05	7.24	7.015	7.16	228400.0
2021-09-23	AAON	Stock	44.1533	45.4333	44.0333	45.3867	337650.0
2021-09-23	AAP	Stock	211.87	215.7	211.87	214.09	496400.0
2021-09-23	AAQC-DELISTED	Stock	9.7	9.7	9.7	9.7	100.0
2021-09-23	AAT	Stock	38.71	39.28	38.71	38.89	153600.0
2021-09-23	AATC	Stock	7.66	7.76	7.54	7.7	21977.0
2021-09-23	AAU-DELISTED	Stock	0.4	0.4065	0.3949	0.3962	238882.0
2021-09-23	AAUAF-DELISTED	Stock	0.4	0.4065	0.3949	0.3962	246169.0
2021-09-23	AAWW-DELISTED	Stock	74.16	78.19	74.16	77.56	432299.0
2021-09-23	AAXJ	Stock	86.58	86.7859	86.28	86.7	1169230.0
2021-09-23	AB	Stock	51.01	52.19	51.01	51.98	227900.0
2021-09-23	ABB-DELISTED	Stock	35.64	35.88	35.64	35.68	1109907.0
2021-09-23	ABBNY-DELISTED	Stock	35.64	35.88	35.64	35.68	1214243.0
2021-09-23	ABBV	Stock	106.99	108.27	106.65	107.36	5847800.0
2021-09-23	ABC-DELISTED	Stock	122.45	123.65	122.1	122.53	538277.0
2021-09-23	ABCB	Stock	47.87	49.96	47.61	49.54	297500.0
2021-09-23	ABCL	Stock	21.41	22.088	20.68	21.15	3962800.0
2021-09-23	ABCM-DELISTED	Stock	20.99	21.23	20.89	21.05	31278.0
2021-09-23	ABEO	Stock	30.0	30.5	30.0	30.5	7604.0
2021-09-23	ABEV	Stock	2.92	2.98	2.92	2.95	41938700.0
2021-09-23	ABG	Stock	186.85	194.25	186.71	191.0	185300.0
2021-09-23	ABGI-DELISTED	Stock	9.6701	9.74	9.67	9.74	1300.0
2021-09-23	ABM	Stock	44.6	45.5	44.45	44.91	169400.0
2021-09-23	ABMD-DELISTED	Stock	351.55	353.79	350.32	350.9	78914.0
2021-09-23	ABNB	Stock	171.55	176.0	170.5	175.13	5370800.0
2021-09-23	ABOS	Stock	15.68	16.5	14.89	16.12	244800.0

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

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