PREVIEW / stock_daily / 2021-10-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-25.parquet
  size:    260 KB
  rows:    7,957
  symbols: 2,700

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-25	AAPL	Stock	148.68	149.37	147.62	148.64	50720600.0
2021-10-25	MSFT	Stock	309.36	309.4	306.46	308.13	17554500.0
2021-10-25	NVDA	Stock	22.973	23.355	22.77	23.166	230235000.0
2021-10-25	AMZN	Stock	166.75	167.39	164.885	166.0185	44520000.0
2021-10-25	GOOGL	Stock	137.55	138.0	135.424	137.447	34412260.0
2021-10-25	META	Stock	320.3	329.56	319.72	328.69	38409000.0
2021-10-25	TSLA	Stock	316.8433	348.34	314.7333	341.62	188556300.0
2021-10-25	TLT	Stock	143.67	144.3	143.63	143.91	8138047.0
2021-10-25	ES	Stock	86.5	86.52	85.72	86.01	862200.0
2021-10-25	CL	Stock	75.02	75.35	74.2	75.14	6205900.0
2021-10-25	A	Stock	157.9	158.52	156.75	158.34	1088100.0
2021-10-25	AA	Stock	50.11	52.125	49.35	51.17	11070100.0
2021-10-25	AAC-DELISTED	Stock	9.84	9.85	9.82	9.84	860064.0
2021-10-25	AACG	Stock	2.32	2.42	2.24	2.39	56200.0
2021-10-25	AACIU	Stock	9.92	9.94	9.92	9.94	11543.0
2021-10-25	AAIC-DELISTED	Stock	3.81	3.87	3.81	3.85	121058.0
2021-10-25	AAIC.C-DELISTED	Stock	25.25	25.25	25.25	25.25	200.0
2021-10-25	AAL	Stock	19.16	19.3	18.9	19.23	27977600.0
2021-10-25	AAM.A-DELISTED	Stock	26.01	26.04	25.96	25.98	15753.0
2021-10-25	AAM.B-DELISTED	Stock	27.08	27.1861	27.06	27.08	8915.0
2021-10-25	AAMC-DELISTED	Stock	7.5147	7.8971	7.5147	7.7235	36407.0
2021-10-25	AAME	Stock	4.15	4.24	3.95	4.16	34400.0
2021-10-25	AAMI	Stock	26.95	27.375	26.95	27.08	431300.0
2021-10-25	AAN-DELISTED	Stock	30.52	31.69	29.84	31.04	312900.0
2021-10-25	AAOI	Stock	7.5	7.671	7.471	7.59	252400.0
2021-10-25	AAON	Stock	46.9667	47.7667	46.7333	46.8067	171600.0
2021-10-25	AAP	Stock	232.31	233.36	228.63	230.13	589400.0
2021-10-25	AAQC-DELISTED	Stock	9.735	9.75	9.73	9.74	4018.0
2021-10-25	AAT	Stock	39.2	39.58	38.83	39.32	198000.0
2021-10-25	AATC	Stock	7.0	7.0	6.8	6.9	32952.0
2021-10-25	AAU-DELISTED	Stock	0.37	0.385	0.37	0.3806	516814.0
2021-10-25	AAUAF-DELISTED	Stock	0.37	0.385	0.37	0.3806	523898.0
2021-10-25	AAWW-DELISTED	Stock	81.08	83.13	80.83	82.28	225016.0
2021-10-25	AAXJ	Stock	88.45	88.55	87.99	88.39	399586.0
2021-10-25	AB	Stock	54.78	56.22	54.2	55.6	434000.0
2021-10-25	ABB-DELISTED	Stock	32.55	32.78	32.42	32.55	2419406.0
2021-10-25	ABBNY-DELISTED	Stock	32.55	32.78	32.42	32.55	2626485.0
2021-10-25	ABBV	Stock	109.08	109.14	107.75	108.5	5697400.0
2021-10-25	ABC-DELISTED	Stock	123.35	123.96	122.41	122.61	288423.0
2021-10-25	ABCB	Stock	54.86	55.1	54.35	54.96	251600.0
2021-10-25	ABCL	Stock	15.92	16.51	15.92	16.47	997500.0
2021-10-25	ABCM-DELISTED	Stock	22.7	22.89	22.55	22.69	8477.0
2021-10-25	ABEO	Stock	21.25	22.0	21.0	21.0	27080.0
2021-10-25	ABEV	Stock	2.65	2.73	2.65	2.72	25542100.0
2021-10-25	ABG	Stock	227.81	230.09	221.77	223.46	297300.0
2021-10-25	ABGI-DELISTED	Stock	9.73	9.75	9.73	9.75	1900.0
2021-10-25	ABM	Stock	44.6	45.92	44.34	45.37	397400.0
2021-10-25	ABMD-DELISTED	Stock	353.14	359.99	348.77	354.53	66241.0
2021-10-25	ABNB	Stock	166.69	170.329	166.65	169.24	2620800.0
2021-10-25	ABOS	Stock	14.4	14.535	13.84	14.41	25900.0

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

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