PREVIEW / stock_daily / 2021-08-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-27.parquet
  size:    257 KB
  rows:    7,854
  symbols: 2,714

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-27	AAPL	Stock	147.48	148.75	146.83	148.6	55802400.0
2021-08-27	MSFT	Stock	298.99	300.87	296.83	299.72	22605700.0
2021-08-27	NVDA	Stock	22.184	22.722	22.167	22.636	304722000.0
2021-08-27	AMZN	Stock	166.6615	167.616	165.6875	167.4815	48048000.0
2021-08-27	GOOGL	Stock	141.6525	144.5125	141.497	144.004	28780200.0
2021-08-27	META	Stock	365.1	373.74	364.08	372.63	11219100.0
2021-08-27	TSLA	Stock	235.0	238.3333	234.0333	237.3067	41501400.0
2021-08-27	TLT	Stock	148.57	149.485	148.33	149.46	15384740.0
2021-08-27	ES	Stock	90.45	90.51	89.9	90.18	1119200.0
2021-08-27	CL	Stock	77.31	77.81	77.21	77.44	2294200.0
2021-08-27	A	Stock	174.03	175.1	172.99	173.81	1185800.0
2021-08-27	AA	Stock	42.19	44.3	42.08	44.13	7106700.0
2021-08-27	AAC-DELISTED	Stock	9.7	9.7	9.66	9.69	224214.0
2021-08-27	AACG	Stock	2.62	2.69	2.61	2.66	35300.0
2021-08-27	AACIU	Stock	9.92	9.92	9.92	9.92	202.0
2021-08-27	AAIC-DELISTED	Stock	3.77	3.82	3.75	3.75	108933.0
2021-08-27	AAIC.C-DELISTED	Stock	25.2	25.32	25.2	25.32	2502.0
2021-08-27	AAL	Stock	19.99	20.43	19.88	20.22	21615100.0
2021-08-27	AAM.A-DELISTED	Stock	26.19	26.2	26.172	26.19	14311.0
2021-08-27	AAM.B-DELISTED	Stock	27.13	27.3	27.13	27.25	6105.0
2021-08-27	AAMC-DELISTED	Stock	4.0441	4.2015	3.9737	4.1618	29305.0
2021-08-27	AAME	Stock	3.7	3.95	3.7	3.8	97800.0
2021-08-27	AAMI	Stock	27.28	27.67	27.19	27.61	441900.0
2021-08-27	AAN-DELISTED	Stock	26.95	27.81	26.88	27.59	341900.0
2021-08-27	AAOI	Stock	7.1	7.3	7.085	7.3	378100.0
2021-08-27	AAON	Stock	45.02	45.9133	44.84	45.8133	270150.0
2021-08-27	AAP	Stock	203.79	206.62	203.01	203.82	675100.0
2021-08-27	AAQC-DELISTED	Stock	9.61	9.63	9.599	9.62	313377.0
2021-08-27	AAT	Stock	38.44	39.57	38.44	39.39	246300.0
2021-08-27	AATC	Stock	7.62	7.81	7.5	7.67	44877.0
2021-08-27	AAU-DELISTED	Stock	0.3927	0.43	0.3927	0.4185	617496.0
2021-08-27	AAUAF-DELISTED	Stock	0.3927	0.43	0.3927	0.4185	626702.0
2021-08-27	AAWW-DELISTED	Stock	73.25	74.41	73.0	73.83	195795.0
2021-08-27	AAXJ	Stock	86.65	87.29	86.65	87.25	470831.0
2021-08-27	AB	Stock	51.13	52.1	50.84	52.04	313800.0
2021-08-27	ABB-DELISTED	Stock	37.41	37.72	37.4	37.65	1061384.0
2021-08-27	ABBNY-DELISTED	Stock	37.41	37.72	37.4	37.65	1158839.0
2021-08-27	ABBV	Stock	120.34	120.64	119.42	119.58	4279900.0
2021-08-27	ABC-DELISTED	Stock	117.69	120.29	117.19	119.89	569924.0
2021-08-27	ABCB	Stock	48.7	50.16	48.7	50.07	299600.0
2021-08-27	ABCL	Stock	17.35	18.16	17.04	17.58	1682400.0
2021-08-27	ABCM-DELISTED	Stock	20.74	20.89	20.5	20.67	67043.0
2021-08-27	ABEO	Stock	32.75	33.25	31.75	32.75	19580.0
2021-08-27	ABEV	Stock	3.23	3.24	3.19	3.23	28839300.0
2021-08-27	ABG	Stock	185.0	192.0	185.0	190.86	124000.0
2021-08-27	ABGI-DELISTED	Stock	9.655	9.69	9.62	9.63	12406.0
2021-08-27	ABM	Stock	49.2	50.0	49.03	49.74	506300.0
2021-08-27	ABMD-DELISTED	Stock	359.07	365.635	357.18	358.72	69008.0
2021-08-27	ABNB	Stock	152.251	156.44	151.45	154.18	4818800.0
2021-08-27	ABOS	Stock	17.48	19.27	17.212	18.68	172700.0

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

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