PREVIEW / stock_daily / 2021-08-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-25.parquet
  size:    257 KB
  rows:    7,864
  symbols: 2,742

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-25	AAPL	Stock	149.81	150.32	147.8	148.36	58991300.0
2021-08-25	MSFT	Stock	304.3	304.59	300.42	302.01	20006100.0
2021-08-25	NVDA	Stock	21.737	22.47	21.722	22.213	347701000.0
2021-08-25	AMZN	Stock	165.4935	166.05	164.3075	164.959	33606000.0
2021-08-25	GOOGL	Stock	141.625	142.1895	141.376	142.079	15851480.0
2021-08-25	META	Stock	365.6	370.86	365.4	368.39	9684500.0
2021-08-25	TSLA	Stock	235.6767	238.99	234.6667	237.0667	37936800.0
2021-08-25	TLT	Stock	149.21	149.37	147.58	148.04	16743814.0
2021-08-25	ES	Stock	90.63	90.77	90.11	90.35	1516800.0
2021-08-25	CL	Stock	77.5	77.83	76.99	77.65	3636600.0
2021-08-25	A	Stock	170.07	173.54	170.07	173.3	1411800.0
2021-08-25	AA	Stock	42.05	42.695	41.64	42.06	4728800.0
2021-08-25	AAC-DELISTED	Stock	9.67	9.69	9.65	9.68	145299.0
2021-08-25	AACG	Stock	2.61	2.7	2.56	2.63	98200.0
2021-08-25	AACIU	Stock	9.8566	9.96	9.845	9.92	281041.0
2021-08-25	AAIC-DELISTED	Stock	3.79	3.84	3.75	3.75	132496.0
2021-08-25	AAIC.C-DELISTED	Stock	25.12	25.19	25.12	25.1836	2145.0
2021-08-25	AAL	Stock	19.77	20.24	19.42	20.15	26913300.0
2021-08-25	AAM.A-DELISTED	Stock	26.19	26.2	26.18	26.2	7716.0
2021-08-25	AAM.B-DELISTED	Stock	27.2	27.22	27.1575	27.2	4820.0
2021-08-25	AAMC-DELISTED	Stock	4.1176	4.1176	4.0206	4.0206	4712.0
2021-08-25	AAME	Stock	3.8	3.8	3.7	3.7	22900.0
2021-08-25	AAMI	Stock	27.0	27.5	26.93	27.33	695400.0
2021-08-25	AAN-DELISTED	Stock	28.04	28.53	27.46	27.54	158900.0
2021-08-25	AAOI	Stock	6.88	7.02	6.845	6.92	323200.0
2021-08-25	AAON	Stock	45.84	46.3533	45.56	45.6533	120600.0
2021-08-25	AAP	Stock	209.47	212.6	207.93	212.24	1032100.0
2021-08-25	AAQC-DELISTED	Stock	9.61	9.63	9.6	9.61	17796.0
2021-08-25	AAT	Stock	38.06	38.65	37.89	38.28	179400.0
2021-08-25	AATC	Stock	6.96	7.85	6.96	7.34	264381.0
2021-08-25	AAU-DELISTED	Stock	0.385	0.4052	0.385	0.399	403506.0
2021-08-25	AAUAF-DELISTED	Stock	0.385	0.4052	0.385	0.3985	413732.0
2021-08-25	AAWW-DELISTED	Stock	74.28	74.93	73.5	74.37	166854.0
2021-08-25	AAXJ	Stock	87.1	87.27	86.85	87.15	894262.0
2021-08-25	AB	Stock	51.15	51.56	50.78	50.78	245300.0
2021-08-25	ABB-DELISTED	Stock	37.33	37.47	37.25	37.3	1477337.0
2021-08-25	ABBNY-DELISTED	Stock	37.33	37.47	37.25	37.3	1606017.0
2021-08-25	ABBV	Stock	119.86	121.4	118.87	120.4	5241100.0
2021-08-25	ABC-DELISTED	Stock	117.83	118.86	116.52	118.11	620634.0
2021-08-25	ABCB	Stock	49.28	50.12	49.28	49.33	208800.0
2021-08-25	ABCL	Stock	17.07	18.34	16.96	17.65	1856300.0
2021-08-25	ABCM-DELISTED	Stock	20.48	20.63	20.42	20.57	20520.0
2021-08-25	ABEO	Stock	32.75	33.25	31.5	31.5	21248.0
2021-08-25	ABEV	Stock	3.27	3.32	3.25	3.32	16271200.0
2021-08-25	ABG	Stock	191.06	193.89	190.19	190.53	60500.0
2021-08-25	ABGI-DELISTED	Stock	9.625	9.69	9.613	9.69	41063.0
2021-08-25	ABM	Stock	48.45	48.9	48.19	48.67	230000.0
2021-08-25	ABMD-DELISTED	Stock	357.62	361.07	355.955	358.02	71634.0
2021-08-25	ABNB	Stock	158.764	163.059	158.0	160.35	7267700.0
2021-08-25	ABOS	Stock	17.16	17.763	16.84	17.21	137400.0

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

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