PREVIEW / stock_daily / 2021-08-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-10.parquet
  size:    257 KB
  rows:    7,882
  symbols: 2,776

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-08-10	AAPL	Stock	146.44	147.71	145.3	145.6	69023100.0
2021-08-10	MSFT	Stock	288.8	289.25	285.2	286.44	18616600.0
2021-08-10	NVDA	Stock	20.322	20.43	19.835	19.936	179238000.0
2021-08-10	AMZN	Stock	167.2505	167.9	165.75	166.034	48252000.0
2021-08-10	GOOGL	Stock	137.342	137.7723	136.3645	136.807	19414080.0
2021-08-10	META	Stock	361.83	364.1	359.04	361.13	7469900.0
2021-08-10	TSLA	Stock	237.9967	238.8633	233.96	236.6633	40296900.0
2021-08-10	TLT	Stock	147.49	147.57	146.56	146.57	13716901.0
2021-08-10	ES	Stock	89.06	89.26	88.39	88.92	863200.0
2021-08-10	CL	Stock	78.55	78.77	77.99	78.73	2740600.0
2021-08-10	A	Stock	156.92	157.6	155.9	156.52	1575900.0
2021-08-10	AA	Stock	40.69	44.15	40.65	43.87	11404000.0
2021-08-10	AAC-DELISTED	Stock	9.79	9.79	9.69	9.7	24055.0
2021-08-10	AACG	Stock	2.86	2.94	2.86	2.88	41200.0
2021-08-10	AAIC-DELISTED	Stock	3.84	3.88	3.8	3.86	102171.0
2021-08-10	AAIC.C-DELISTED	Stock	25.1501	25.153	25.06	25.06	3007.0
2021-08-10	AAL	Stock	20.5	21.4	20.38	20.94	31320900.0
2021-08-10	AAM.A-DELISTED	Stock	26.306	26.37	26.04	26.37	14158.0
2021-08-10	AAM.B-DELISTED	Stock	27.07	27.09	26.87	27.01	9631.0
2021-08-10	AAMC-DELISTED	Stock	4.4856	4.4856	4.1	4.3029	60095.0
2021-08-10	AAME	Stock	4.5	5.7	4.4	4.48	1100600.0
2021-08-10	AAMI	Stock	26.71	26.98	26.563	26.62	435100.0
2021-08-10	AAN-DELISTED	Stock	26.88	28.1	26.84	27.86	218400.0
2021-08-10	AAOI	Stock	7.54	7.6	7.06	7.12	585900.0
2021-08-10	AAON	Stock	45.9133	47.0467	45.56	46.7667	276600.0
2021-08-10	AAP	Stock	204.21	209.39	204.21	208.74	408200.0
2021-08-10	AAQC-DELISTED	Stock	9.65	9.66	9.65	9.66	7998.0
2021-08-10	AAT	Stock	37.51	37.89	37.22	37.67	167500.0
2021-08-10	AATC	Stock	6.85	6.93	6.52	6.57	38130.0
2021-08-10	AAU-DELISTED	Stock	0.42	0.4335	0.415	0.4334	586004.0
2021-08-10	AAUAF-DELISTED	Stock	0.42	0.4335	0.415	0.4334	593529.0
2021-08-10	AAWW-DELISTED	Stock	72.61	72.98	71.01	72.15	218019.0
2021-08-10	AAXJ	Stock	88.91	88.94	88.48	88.65	689621.0
2021-08-10	AB	Stock	48.75	49.73	48.75	49.73	246600.0
2021-08-10	ABB-DELISTED	Stock	36.97	37.18	36.92	37.15	894121.0
2021-08-10	ABBNY-DELISTED	Stock	36.97	37.18	36.92	37.16	976320.0
2021-08-10	ABBV	Stock	114.2	115.03	112.92	114.82	5120800.0
2021-08-10	ABC-DELISTED	Stock	119.87	120.02	117.32	119.01	611626.0
2021-08-10	ABCB	Stock	49.91	50.82	49.66	50.52	1362000.0
2021-08-10	ABCL	Stock	16.5	16.58	15.16	15.59	1756900.0
2021-08-10	ABCM-DELISTED	Stock	20.43	20.69	20.3	20.5	44158.0
2021-08-10	ABEO	Stock	31.75	32.5	31.25	31.5	13396.0
2021-08-10	ABEV	Stock	3.19	3.22	3.16	3.2	26983200.0
2021-08-10	ABG	Stock	194.3	199.17	191.94	196.82	151800.0
2021-08-10	ABM	Stock	46.55	47.22	46.3	47.13	183800.0
2021-08-10	ABMD-DELISTED	Stock	347.9	348.0	332.41	332.7	126543.0
2021-08-10	ABNB	Stock	149.365	150.76	147.85	147.95	5149800.0
2021-08-10	ABOS	Stock	15.01	15.108	14.7	14.75	90000.0
2021-08-10	ABR	Stock	18.33	18.53	18.14	18.52	2636800.0
2021-08-10	ABR.D	Stock	25.68	25.68	25.6	25.65	17006.0

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

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