PREVIEW / stock_daily / 2021-08-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-11.parquet
  size:    258 KB
  rows:    7,901
  symbols: 2,791

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-11	AAPL	Stock	146.05	146.72	145.53	145.86	48493500.0
2021-08-11	MSFT	Stock	287.21	288.66	285.86	286.95	13955900.0
2021-08-11	NVDA	Stock	20.043	20.049	19.43	19.699	185925000.0
2021-08-11	AMZN	Stock	166.5725	166.885	163.8895	164.6055	58944000.0
2021-08-11	GOOGL	Stock	137.1815	137.6822	136.2715	136.279	15352000.0
2021-08-11	META	Stock	362.1	362.36	357.81	359.96	8400300.0
2021-08-11	TSLA	Stock	237.57	238.3933	234.7367	235.94	29401800.0
2021-08-11	TLT	Stock	146.412	147.23	145.71	146.48	17227605.0
2021-08-11	ES	Stock	89.25	89.98	88.97	89.92	1061700.0
2021-08-11	CL	Stock	78.58	79.34	78.58	79.1	4239100.0
2021-08-11	A	Stock	156.69	156.99	155.85	156.52	1402500.0
2021-08-11	AA	Stock	43.48	44.74	43.15	44.66	7674500.0
2021-08-11	AAC-DELISTED	Stock	9.68	9.72	9.68	9.71	27329.0
2021-08-11	AACG	Stock	2.97	2.99	2.9	2.94	38400.0
2021-08-11	AAIC-DELISTED	Stock	3.83	3.87	3.81	3.86	67356.0
2021-08-11	AAIC.C-DELISTED	Stock	25.0201	25.094	25.0	25.0	16159.0
2021-08-11	AAL	Stock	20.63	21.49	20.48	21.23	39902300.0
2021-08-11	AAM.A-DELISTED	Stock	26.331	26.331	26.2468	26.32	4934.0
2021-08-11	AAM.B-DELISTED	Stock	27.0565	27.0565	26.975	27.0	4969.0
2021-08-11	AAMC-DELISTED	Stock	4.1853	4.2618	4.1577	4.1577	26683.0
2021-08-11	AAME	Stock	4.43	4.52	4.03	4.07	89300.0
2021-08-11	AAMI	Stock	26.65	26.84	26.42	26.66	392900.0
2021-08-11	AAN-DELISTED	Stock	27.86	28.71	27.79	28.67	276000.0
2021-08-11	AAOI	Stock	7.15	7.2	6.93	6.97	696200.0
2021-08-11	AAON	Stock	46.9933	47.0	45.96	46.2133	207900.0
2021-08-11	AAP	Stock	209.21	211.98	208.37	211.21	438300.0
2021-08-11	AAQC-DELISTED	Stock	9.65	9.66	9.64	9.66	7430.0
2021-08-11	AAT	Stock	37.79	38.21	37.6	38.15	189000.0
2021-08-11	AATC	Stock	6.65	6.6601	6.4212	6.54	28426.0
2021-08-11	AAU-DELISTED	Stock	0.4293	0.435	0.4222	0.4226	358790.0
2021-08-11	AAUAF-DELISTED	Stock	0.4293	0.435	0.4222	0.4226	364371.0
2021-08-11	AAWW-DELISTED	Stock	72.57	73.46	71.2101	73.37	263876.0
2021-08-11	AAXJ	Stock	88.98	89.045	88.42	88.75	630954.0
2021-08-11	AB	Stock	49.75	50.07	49.56	49.89	209200.0
2021-08-11	ABB-DELISTED	Stock	37.47	37.47	37.34	37.42	833496.0
2021-08-11	ABBNY-DELISTED	Stock	37.47	37.47	37.34	37.42	1064944.0
2021-08-11	ABBV	Stock	115.16	115.34	113.55	113.72	6840400.0
2021-08-11	ABC-DELISTED	Stock	119.41	120.03	118.08	119.24	751577.0
2021-08-11	ABCB	Stock	50.76	51.44	49.93	51.31	386400.0
2021-08-11	ABCL	Stock	15.63	15.735	14.93	15.28	1471100.0
2021-08-11	ABCM-DELISTED	Stock	20.6	20.65	20.42	20.47	34498.0
2021-08-11	ABEO	Stock	31.5	31.75	30.5	31.0	19476.0
2021-08-11	ABEV	Stock	3.17	3.2	3.12	3.15	13237000.0
2021-08-11	ABG	Stock	197.01	199.8	195.84	199.4	102100.0
2021-08-11	ABGI-DELISTED	Stock	9.7574	9.7574	9.72	9.72	400.0
2021-08-11	ABM	Stock	47.29	47.93	47.0	47.92	199600.0
2021-08-11	ABMD-DELISTED	Stock	331.78	334.665	315.72	319.88	201234.0
2021-08-11	ABNB	Stock	147.54	149.28	145.158	148.16	6717700.0
2021-08-11	ABOS	Stock	15.13	15.15	14.66	14.82	58700.0
2021-08-11	ABR	Stock	18.58	18.75	18.37	18.7	2903100.0

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

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