PREVIEW / stock_daily / 2021-09-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-07.parquet
  size:    257 KB
  rows:    7,852
  symbols: 2,707

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-07	AAPL	Stock	154.97	157.26	154.39	156.69	82278300.0
2021-09-07	MSFT	Stock	301.01	301.09	298.2	300.18	17180400.0
2021-09-07	NVDA	Stock	22.833	22.899	22.522	22.662	198107000.0
2021-09-07	AMZN	Stock	173.9	176.4045	173.847	175.4645	54758000.0
2021-09-07	GOOGL	Stock	143.8345	144.565	143.619	144.2805	20131900.0
2021-09-07	META	Stock	375.88	382.96	373.15	382.18	10793800.0
2021-09-07	TSLA	Stock	246.6667	253.4	246.42	250.9733	60119400.0
2021-09-07	TLT	Stock	147.262	147.52	146.655	146.93	15548172.0
2021-09-07	ES	Stock	91.88	91.88	89.72	89.73	1463000.0
2021-09-07	CL	Stock	77.9	77.95	76.83	76.9	3246400.0
2021-09-07	A	Stock	179.28	179.37	176.79	177.72	1252000.0
2021-09-07	AA	Stock	47.61	48.39	46.48	46.77	6167000.0
2021-09-07	AAC-DELISTED	Stock	9.72	9.73	9.71	9.71	992366.0
2021-09-07	AACG	Stock	2.77	2.85	2.77	2.82	19700.0
2021-09-07	AACIU	Stock	9.85	9.85	9.85	9.85	4438.0
2021-09-07	AAIC-DELISTED	Stock	3.85	3.86	3.75	3.78	121380.0
2021-09-07	AAIC.C-DELISTED	Stock	25.39	25.39	25.365	25.39	1008.0
2021-09-07	AAL	Stock	19.36	19.65	19.21	19.53	18291000.0
2021-09-07	AAM.A-DELISTED	Stock	26.14	26.14	25.98	26.06	5226.0
2021-09-07	AAM.B-DELISTED	Stock	26.85	26.85	26.78	26.85	8011.0
2021-09-07	AAMC-DELISTED	Stock	7.9382	8.1588	7.2059	7.5647	129683.0
2021-09-07	AAME	Stock	4.0	4.13	3.9	3.9	16900.0
2021-09-07	AAMI	Stock	27.39	27.4	27.125	27.15	311100.0
2021-09-07	AAN-DELISTED	Stock	26.6	26.97	26.35	26.42	187500.0
2021-09-07	AAOI	Stock	7.7	8.0	7.7	7.81	415900.0
2021-09-07	AAON	Stock	44.64	44.64	42.9533	43.14	274200.0
2021-09-07	AAP	Stock	198.6	201.37	197.86	199.81	574700.0
2021-09-07	AAQC-DELISTED	Stock	9.65	9.69	9.64	9.65	9329.0
2021-09-07	AAT	Stock	40.14	40.56	39.81	40.41	326500.0
2021-09-07	AATC	Stock	8.19	8.38	7.87	8.1	72909.0
2021-09-07	AAU-DELISTED	Stock	0.38	0.419	0.38	0.419	803699.0
2021-09-07	AAUAF-DELISTED	Stock	0.38	0.419	0.38	0.4146	1028566.0
2021-09-07	AAWW-DELISTED	Stock	74.07	74.37	72.9	73.87	334918.0
2021-09-07	AAXJ	Stock	90.26	90.99	90.26	90.7	1353122.0
2021-09-07	AB	Stock	51.25	51.52	50.84	51.0	179400.0
2021-09-07	ABB-DELISTED	Stock	37.24	37.29	36.92	36.965	958248.0
2021-09-07	ABBNY-DELISTED	Stock	37.24	37.29	36.92	36.96	1079451.0
2021-09-07	ABBV	Stock	110.45	111.57	108.32	109.03	12694200.0
2021-09-07	ABC-DELISTED	Stock	125.14	125.445	123.2512	124.2	314394.0
2021-09-07	ABCB	Stock	48.36	48.38	47.35	47.44	329100.0
2021-09-07	ABCL	Stock	19.46	19.52	18.7	18.95	2864700.0
2021-09-07	ABCM-DELISTED	Stock	21.2	21.23	20.87	20.99	54837.0
2021-09-07	ABEO	Stock	33.25	34.0	32.25	32.25	26444.0
2021-09-07	ABEV	Stock	3.18	3.25	3.14	3.2	28667800.0
2021-09-07	ABG	Stock	179.44	180.53	173.39	173.41	174300.0
2021-09-07	ABGI-DELISTED	Stock	9.63	9.63	9.63	9.63	100.0
2021-09-07	ABM	Stock	48.8	48.83	47.18	47.22	384700.0
2021-09-07	ABMD-DELISTED	Stock	371.92	376.99	369.66	376.205	129545.0
2021-09-07	ABNB	Stock	159.72	165.735	159.55	165.0	11008800.0
2021-09-07	ABOS	Stock	15.83	19.0	15.83	18.31	583600.0

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

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