PREVIEW / stock_daily / 2021-10-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-01.parquet
  size:    259 KB
  rows:    7,910
  symbols: 2,719

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-10-01	AAPL	Stock	141.9	142.92	139.11	142.65	94639600.0
2021-10-01	MSFT	Stock	282.12	289.98	281.29	289.1	30086300.0
2021-10-01	NVDA	Stock	20.75	20.859	20.203	20.742	240978000.0
2021-10-01	AMZN	Stock	164.4505	165.4585	162.797	164.163	56712000.0
2021-10-01	GOOGL	Stock	134.4475	136.9105	134.073	136.543	35360180.0
2021-10-01	META	Stock	341.61	345.02	338.64	343.01	14905300.0
2021-10-01	TSLA	Stock	259.4667	260.26	254.53	258.4067	51094200.0
2021-10-01	TLT	Stock	144.85	145.4	144.2	145.35	26151798.0
2021-10-01	ES	Stock	82.26	82.7	81.6	81.84	1600600.0
2021-10-01	CL	Stock	75.85	76.02	75.07	75.58	3473400.0
2021-10-01	A	Stock	157.15	157.5	153.05	155.99	1881900.0
2021-10-01	AA	Stock	49.46	49.89	47.94	49.77	6561200.0
2021-10-01	AAC-DELISTED	Stock	9.74	9.77	9.74	9.75	13513.0
2021-10-01	AACG	Stock	2.33	2.4	2.33	2.4	13200.0
2021-10-01	AACIU	Stock	9.97	9.97	9.91	9.91	100400.0
2021-10-01	AAIC-DELISTED	Stock	3.71	3.77	3.71	3.71	53946.0
2021-10-01	AAIC.C-DELISTED	Stock	25.114	25.26	25.0218	25.0218	2749.0
2021-10-01	AAL	Stock	21.0	21.78	20.9	21.65	36430900.0
2021-10-01	AAM.A-DELISTED	Stock	25.6	25.7823	25.6	25.7823	7539.0
2021-10-01	AAM.B-DELISTED	Stock	27.13	27.13	26.97	27.04	4113.0
2021-10-01	AAMC-DELISTED	Stock	6.6059	7.3479	6.3956	7.0912	367707.0
2021-10-01	AAME	Stock	4.17	4.3	4.05	4.21	16000.0
2021-10-01	AAMI	Stock	26.15	26.47	25.84	26.12	699300.0
2021-10-01	AAN-DELISTED	Stock	27.6	28.56	27.58	28.1	160500.0
2021-10-01	AAOI	Stock	7.23	7.34	7.1	7.19	261800.0
2021-10-01	AAON	Stock	43.62	45.5	43.06	44.4067	259500.0
2021-10-01	AAP	Stock	209.53	209.88	205.26	208.0	642400.0
2021-10-01	AAQC-DELISTED	Stock	9.7	9.7	9.7	9.7	393.0
2021-10-01	AAT	Stock	37.53	38.46	37.23	38.15	322300.0
2021-10-01	AATC	Stock	7.45	7.5	7.25	7.3	24216.0
2021-10-01	AAU-DELISTED	Stock	0.4058	0.4085	0.38	0.3912	629400.0
2021-10-01	AAUAF-DELISTED	Stock	0.4058	0.4085	0.38	0.3912	637529.0
2021-10-01	AAWW-DELISTED	Stock	81.7	84.0	81.29	83.49	298908.0
2021-10-01	AAXJ	Stock	84.93	85.07	83.96	84.66	827808.0
2021-10-01	AB	Stock	49.53	51.1	49.32	50.79	167400.0
2021-10-01	ABB-DELISTED	Stock	33.17	33.38	32.91	33.25	1832957.0
2021-10-01	ABBNY-DELISTED	Stock	33.17	33.38	32.91	33.25	2094653.0
2021-10-01	ABBV	Stock	108.25	109.69	106.87	109.09	8611500.0
2021-10-01	ABC-DELISTED	Stock	119.86	120.87	118.59	119.82	623814.0
2021-10-01	ABCB	Stock	52.03	53.7	51.63	53.08	354600.0
2021-10-01	ABCL	Stock	19.06	19.41	16.765	17.2	8070500.0
2021-10-01	ABCM-DELISTED	Stock	20.18	20.56	19.89	20.16	84553.0
2021-10-01	ABEO	Stock	28.5	28.5	27.0	27.5	16328.0
2021-10-01	ABEV	Stock	2.8	2.82	2.74	2.78	35588800.0
2021-10-01	ABG	Stock	199.41	200.34	192.13	197.77	260600.0
2021-10-01	ABGI-DELISTED	Stock	9.75	9.75	9.72	9.725	89606.0
2021-10-01	ABM	Stock	45.44	47.09	44.92	46.95	459600.0
2021-10-01	ABMD-DELISTED	Stock	326.58	329.59	317.81	323.23	75459.0
2021-10-01	ABNB	Stock	170.31	173.2	168.55	173.01	4963000.0
2021-10-01	ABOS	Stock	14.8	15.42	14.12	15.27	91000.0

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

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