PREVIEW / stock_daily / 2021-09-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-10.parquet
  size:    257 KB
  rows:    7,836
  symbols: 2,679

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-10	AAPL	Stock	155.0	155.48	148.7	148.97	140893200.0
2021-09-10	MSFT	Stock	298.42	299.92	295.38	295.71	19633400.0
2021-09-10	NVDA	Stock	22.348	22.626	22.27	22.478	248376000.0
2021-09-10	AMZN	Stock	175.0915	175.4225	173.1455	173.4575	47946000.0
2021-09-10	GOOGL	Stock	144.2125	144.7185	140.7378	140.876	36839340.0
2021-09-10	META	Stock	381.36	383.79	378.26	378.69	11549600.0
2021-09-10	TSLA	Stock	253.2	254.2033	244.84	245.4233	45552600.0
2021-09-10	TLT	Stock	148.9	149.17	148.16	148.4	14894629.0
2021-09-10	ES	Stock	89.75	90.01	88.21	88.33	1534700.0
2021-09-10	CL	Stock	77.47	77.47	76.79	77.04	3360100.0
2021-09-10	A	Stock	177.72	179.31	177.17	177.23	1086300.0
2021-09-10	AA	Stock	48.25	50.345	48.25	49.5	10397400.0
2021-09-10	AAC-DELISTED	Stock	9.73	9.79	9.72	9.7591	1955146.0
2021-09-10	AACG	Stock	2.78	2.91	2.71	2.85	138000.0
2021-09-10	AACIU	Stock	9.86	9.88	9.85	9.88	277270.0
2021-09-10	AAIC-DELISTED	Stock	3.78	3.79	3.74	3.75	98754.0
2021-09-10	AAIC.C-DELISTED	Stock	25.38	25.51	25.38	25.51	870.0
2021-09-10	AAL	Stock	20.28	20.29	18.93	18.95	54951400.0
2021-09-10	AAM.A-DELISTED	Stock	25.96	26.0	25.88	25.92	7400.0
2021-09-10	AAM.B-DELISTED	Stock	26.93	26.971	26.9	26.97	22763.0
2021-09-10	AAMC-DELISTED	Stock	8.5294	8.95	8.05	8.2618	174746.0
2021-09-10	AAME	Stock	4.04	4.06	3.92	3.92	20800.0
2021-09-10	AAMI	Stock	27.04	27.095	26.55	26.65	246300.0
2021-09-10	AAN-DELISTED	Stock	27.07	27.16	26.14	26.23	180500.0
2021-09-10	AAOI	Stock	7.77	7.8	7.4	7.43	259800.0
2021-09-10	AAON	Stock	43.2067	43.5933	42.8733	43.38	377700.0
2021-09-10	AAP	Stock	202.19	203.0	199.91	200.03	359800.0
2021-09-10	AAQC-DELISTED	Stock	9.67	9.7	9.66	9.66	7746.0
2021-09-10	AAT	Stock	39.46	39.46	38.18	38.19	179300.0
2021-09-10	AATC	Stock	8.26	8.28	8.07	8.23	21186.0
2021-09-10	AAU-DELISTED	Stock	0.396	0.4144	0.393	0.4095	1093605.0
2021-09-10	AAUAF-DELISTED	Stock	0.396	0.4144	0.393	0.4095	1103596.0
2021-09-10	AAWW-DELISTED	Stock	73.69	75.4	73.05	73.94	269016.0
2021-09-10	AAXJ	Stock	89.92	90.04	89.17	89.17	1596940.0
2021-09-10	AB	Stock	51.82	52.49	51.67	51.79	287100.0
2021-09-10	ABB-DELISTED	Stock	36.96	36.99	36.6	36.6	974101.0
2021-09-10	ABBNY-DELISTED	Stock	36.96	36.99	36.6	36.61	1075462.0
2021-09-10	ABBV	Stock	107.48	108.32	106.36	106.68	7620100.0
2021-09-10	ABC-DELISTED	Stock	123.5	123.99	121.89	122.8	487873.0
2021-09-10	ABCB	Stock	46.99	47.43	46.39	46.54	447600.0
2021-09-10	ABCL	Stock	19.72	19.72	18.51	18.99	1588600.0
2021-09-10	ABCM-DELISTED	Stock	21.17	21.17	20.88	20.88	112679.0
2021-09-10	ABEO	Stock	32.75	33.0	31.75	32.25	8732.0
2021-09-10	ABEV	Stock	3.13	3.14	3.01	3.01	29187600.0
2021-09-10	ABG	Stock	176.85	176.85	170.96	171.08	194800.0
2021-09-10	ABGI-DELISTED	Stock	9.6945	9.6945	9.6945	9.6945	187.0
2021-09-10	ABM	Stock	46.17	47.37	45.84	46.2	504200.0
2021-09-10	ABMD-DELISTED	Stock	368.37	368.37	360.7	361.14	79420.0
2021-09-10	ABNB	Stock	166.95	168.236	165.01	165.2	3985300.0
2021-09-10	ABOS	Stock	17.75	18.699	17.0	17.0	128700.0

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

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