PREVIEW / stock_daily / 2021-08-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-02.parquet
  size:    258 KB
  rows:    7,897
  symbols: 2,801

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-02	AAPL	Stock	146.36	146.95	145.25	145.52	62880000.0
2021-08-02	MSFT	Stock	286.36	286.77	283.74	284.82	16267400.0
2021-08-02	NVDA	Stock	19.7	19.961	19.361	19.75	217444000.0
2021-08-02	AMZN	Stock	167.655	167.946	165.85	166.574	67078000.0
2021-08-02	GOOGL	Stock	135.117	135.3365	133.7941	134.8545	21634200.0
2021-08-02	META	Stock	358.1	359.4	350.74	351.95	13180400.0
2021-08-02	TSLA	Stock	233.3333	242.3133	232.8	236.5567	100847400.0
2021-08-02	TLT	Stock	149.454	151.23	149.18	150.67	21232706.0
2021-08-02	ES	Stock	86.28	87.35	85.94	87.3	1267400.0
2021-08-02	CL	Stock	79.49	79.82	78.65	79.54	5339300.0
2021-08-02	A	Stock	154.05	154.3	152.52	153.07	1438300.0
2021-08-02	AA	Stock	40.22	41.65	39.38	39.4	7601700.0
2021-08-02	AAC-DELISTED	Stock	9.78	9.78	9.75	9.77	7544.0
2021-08-02	AACG	Stock	3.12	3.22	3.01	3.07	227200.0
2021-08-02	AAIC-DELISTED	Stock	3.85	3.93	3.81	3.84	69049.0
2021-08-02	AAIC.C-DELISTED	Stock	25.1372	25.2	25.1372	25.185	2730.0
2021-08-02	AAL	Stock	20.49	20.85	19.99	20.06	27151300.0
2021-08-02	AAM.A-DELISTED	Stock	26.34	26.3401	26.25	26.2775	7886.0
2021-08-02	AAM.B-DELISTED	Stock	26.98	27.05	26.98	27.05	8686.0
2021-08-02	AAMC-DELISTED	Stock	4.5294	4.5353	4.5147	4.5147	4168.0
2021-08-02	AAME	Stock	4.11	4.22	4.1	4.21	8900.0
2021-08-02	AAMI	Stock	25.1	25.36	24.88	25.06	366500.0
2021-08-02	AAN-DELISTED	Stock	29.04	29.79	28.75	28.79	253900.0
2021-08-02	AAOI	Stock	7.76	7.92	7.625	7.64	421200.0
2021-08-02	AAON	Stock	41.5933	42.1867	41.0733	41.2267	152850.0
2021-08-02	AAP	Stock	213.19	213.92	210.4	212.71	515000.0
2021-08-02	AAQC-DELISTED	Stock	9.6701	9.6715	9.65	9.66	103579.0
2021-08-02	AAT	Stock	37.13	37.83	36.74	36.82	330200.0
2021-08-02	AATC	Stock	6.67	6.972	6.6	6.77	19388.0
2021-08-02	AAU-DELISTED	Stock	0.444	0.444	0.416	0.43	382076.0
2021-08-02	AAUAF-DELISTED	Stock	0.444	0.444	0.416	0.4348	389963.0
2021-08-02	AAWW-DELISTED	Stock	67.42	68.24	65.75	66.21	206275.0
2021-08-02	AAXJ	Stock	88.32	88.74	88.22	88.25	769550.0
2021-08-02	AB	Stock	49.39	49.55	49.0	49.2	314900.0
2021-08-02	ABB-DELISTED	Stock	36.53	36.65	36.395	36.42	1284842.0
2021-08-02	ABBNY-DELISTED	Stock	36.53	36.65	36.395	36.43	1387573.0
2021-08-02	ABBV	Stock	116.89	117.24	115.41	115.45	9245500.0
2021-08-02	ABC-DELISTED	Stock	122.28	123.31	121.23	122.76	509621.0
2021-08-02	ABCB	Stock	48.7	50.54	48.22	48.31	470100.0
2021-08-02	ABCL	Stock	15.35	16.31	15.263	15.82	1000600.0
2021-08-02	ABCM-DELISTED	Stock	19.25	19.9	19.25	19.73	58773.0
2021-08-02	ABEO	Stock	29.5	32.5	28.75	32.25	48724.0
2021-08-02	ABEV	Stock	3.24	3.31	3.23	3.23	21100900.0
2021-08-02	ABG	Stock	206.0	211.46	203.79	204.3	326300.0
2021-08-02	ABGI-DELISTED	Stock	9.66	9.7	9.63	9.7	6263.0
2021-08-02	ABM	Stock	46.67	47.55	45.22	45.31	592700.0
2021-08-02	ABMD-DELISTED	Stock	329.81	331.17	325.25	328.36	96118.0
2021-08-02	ABNB	Stock	143.85	146.27	143.4	145.49	4522400.0
2021-08-02	ABOS	Stock	15.41	16.24	14.5	15.27	1018300.0
2021-08-02	ABR	Stock	18.35	18.59	18.09	18.13	1389900.0

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

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