PREVIEW / stock_daily / 2021-12-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-08.parquet
  size:    261 KB
  rows:    8,000
  symbols: 2,647

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-12-08	AAPL	Stock	172.13	175.96	170.7	175.08	116998900.0
2021-12-08	MSFT	Stock	335.31	335.5	330.8	334.97	24761000.0
2021-12-08	NVDA	Stock	31.999	32.29	31.421	31.826	475551000.0
2021-12-08	AMZN	Stock	176.1505	177.18	174.7505	176.158	45254000.0
2021-12-08	GOOGL	Stock	147.5965	148.393	146.406	148.1865	24270320.0
2021-12-08	META	Stock	325.0	332.75	323.07	330.56	19937700.0
2021-12-08	TSLA	Stock	350.9033	357.46	344.3333	356.32	41906400.0
2021-12-08	TLT	Stock	150.472	150.48	148.36	148.39	33633891.0
2021-12-08	ES	Stock	87.41	87.82	86.65	87.35	1416200.0
2021-12-08	CL	Stock	77.39	77.97	76.77	77.76	4311200.0
2021-12-08	A	Stock	154.76	156.39	153.95	156.31	1491500.0
2021-12-08	AA	Stock	47.07	48.735	46.98	48.56	5594700.0
2021-12-08	AAC-DELISTED	Stock	9.79	9.81	9.79	9.81	31310.0
2021-12-08	AACG	Stock	1.5	1.58	1.4	1.42	79800.0
2021-12-08	AACIW-DELISTED	Stock	0.5172	0.5174	0.49	0.5002	16400.0
2021-12-08	AAIC-DELISTED	Stock	3.6	3.7	3.59	3.65	122393.0
2021-12-08	AAIC.C-DELISTED	Stock	25.46	25.5038	25.46	25.5038	800.0
2021-12-08	AAL	Stock	17.96	18.87	17.88	18.23	46340600.0
2021-12-08	AAM.A-DELISTED	Stock	25.3	25.3799	25.25	25.32	7949.0
2021-12-08	AAM.B-DELISTED	Stock	26.13	26.1697	26.05	26.09	7617.0
2021-12-08	AAME	Stock	3.78	3.9	3.77	3.79	6400.0
2021-12-08	AAMI	Stock	28.98	30.0	28.63	29.78	1391500.0
2021-12-08	AAN-DELISTED	Stock	23.98	24.65	23.73	24.6	181600.0
2021-12-08	AAOI	Stock	5.65	6.02	5.59	5.91	362100.0
2021-12-08	AAON	Stock	54.32	55.86	54.2333	55.4667	417600.0
2021-12-08	AAP	Stock	234.68	235.59	229.99	234.03	665600.0
2021-12-08	AAQC-DELISTED	Stock	9.72	9.73	9.72	9.73	8241.0
2021-12-08	AAT	Stock	35.95	36.66	35.81	36.51	151400.0
2021-12-08	AATC	Stock	6.4	6.51	6.4	6.45	7307.0
2021-12-08	AAU-DELISTED	Stock	0.3179	0.32	0.315	0.32	259530.0
2021-12-08	AAUAF-DELISTED	Stock	0.3179	0.32	0.315	0.32	273271.0
2021-12-08	AAWW-DELISTED	Stock	88.59	88.755	86.54	87.27	311355.0
2021-12-08	AAXJ	Stock	85.2	85.85	85.0101	85.67	1500666.0
2021-12-08	AB	Stock	52.5	52.8	51.51	51.78	187500.0
2021-12-08	ABB-DELISTED	Stock	36.69	36.88	36.58	36.79	1191185.0
2021-12-08	ABBNY-DELISTED	Stock	36.69	36.88	36.58	36.8	1324107.0
2021-12-08	ABBV	Stock	121.96	122.44	120.75	121.87	5278100.0
2021-12-08	ABC-DELISTED	Stock	120.41	121.49	119.44	120.87	607105.0
2021-12-08	ABCB	Stock	49.54	50.0	49.14	49.45	200600.0
2021-12-08	ABCL	Stock	14.66	15.37	14.459	15.12	1923600.0
2021-12-08	ABCM-DELISTED	Stock	22.6	23.29	22.39	23.14	128602.0
2021-12-08	ABEO	Stock	16.0	16.5	15.5	16.25	22364.0
2021-12-08	ABEV	Stock	2.89	2.92	2.84	2.87	26024700.0
2021-12-08	ABG	Stock	174.37	175.13	168.74	168.96	164800.0
2021-12-08	ABGI-DELISTED	Stock	9.74	9.74	9.74	9.74	700.0
2021-12-08	ABM	Stock	45.74	46.17	45.65	45.93	392200.0
2021-12-08	ABMD-DELISTED	Stock	321.5	326.41	316.87	324.36	109197.0
2021-12-08	ABNB	Stock	186.0	187.5	182.14	186.49	4218700.0
2021-12-08	ABOS	Stock	7.54	7.83	7.25	7.61	107500.0
2021-12-08	ABR	Stock	18.26	18.47	18.17	18.36	1207800.0

> showing 50 of 8,000 rows — these rows as CSV

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