PREVIEW / stock_daily / 2021-09-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-02.parquet
  size:    258 KB
  rows:    7,861
  symbols: 2,715

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-09-02	AAPL	Stock	153.87	154.72	152.4	153.65	71115500.0
2021-09-02	MSFT	Stock	302.2	303.36	300.18	301.15	16285600.0
2021-09-02	NVDA	Stock	22.518	22.593	22.295	22.396	187834000.0
2021-09-02	AMZN	Stock	174.738	175.598	172.75	173.156	58474000.0
2021-09-02	GOOGL	Stock	145.216	145.5193	143.1848	143.287	32358140.0
2021-09-02	META	Stock	381.5	381.75	374.06	375.28	14832900.0
2021-09-02	TSLA	Stock	244.8333	246.99	243.5133	244.13	38331900.0
2021-09-02	TLT	Stock	149.24	149.55	148.75	149.54	9766003.0
2021-09-02	ES	Stock	91.77	92.65	91.7	92.62	943900.0
2021-09-02	CL	Stock	78.33	78.56	78.09	78.52	2549700.0
2021-09-02	A	Stock	176.45	178.34	175.7	178.02	1194000.0
2021-09-02	AA	Stock	46.03	48.24	45.9	46.91	8457000.0
2021-09-02	AAC-DELISTED	Stock	9.7	9.72	9.6999	9.71	78680.0
2021-09-02	AACG	Stock	2.82	2.85	2.76	2.77	40500.0
2021-09-02	AACIU	Stock	9.84	9.84	9.84	9.84	295.0
2021-09-02	AAIC-DELISTED	Stock	3.75	3.79	3.74	3.78	98103.0
2021-09-02	AAIC.C-DELISTED	Stock	25.38	25.38	25.3073	25.36	736.0
2021-09-02	AAL	Stock	19.73	19.98	19.48	19.76	20179400.0
2021-09-02	AAM.A-DELISTED	Stock	26.1	26.19	26.08	26.18	9618.0
2021-09-02	AAM.B-DELISTED	Stock	26.97	26.975	26.9	26.96	10108.0
2021-09-02	AAMC-DELISTED	Stock	7.0647	9.3794	7.0647	7.8882	1025787.0
2021-09-02	AAME	Stock	4.34	4.39	4.11	4.12	80000.0
2021-09-02	AAMI	Stock	27.24	27.56	27.12	27.34	309400.0
2021-09-02	AAN-DELISTED	Stock	27.24	27.24	26.31	26.55	182000.0
2021-09-02	AAOI	Stock	7.62	7.84	7.6	7.77	411500.0
2021-09-02	AAON	Stock	45.12	45.5733	45.0133	45.44	132450.0
2021-09-02	AAP	Stock	202.52	202.52	200.05	200.81	492000.0
2021-09-02	AAQC-DELISTED	Stock	9.68	9.68	9.63	9.655	2952.0
2021-09-02	AAT	Stock	40.2	40.2	39.62	39.84	178700.0
2021-09-02	AATC	Stock	7.87	8.315	7.8	7.95	95844.0
2021-09-02	AAU-DELISTED	Stock	0.42	0.4201	0.4057	0.4135	290241.0
2021-09-02	AAUAF-DELISTED	Stock	0.42	0.4201	0.4056	0.4135	295955.0
2021-09-02	AAWW-DELISTED	Stock	73.75	74.26	73.41	73.88	197966.0
2021-09-02	AAXJ	Stock	89.76	90.05	89.52	89.62	794266.0
2021-09-02	AB	Stock	52.45	52.49	51.73	51.8	144100.0
2021-09-02	ABB-DELISTED	Stock	37.46	37.6198	37.405	37.5	748953.0
2021-09-02	ABBNY-DELISTED	Stock	37.46	37.6198	37.405	37.51	848060.0
2021-09-02	ABBV	Stock	113.55	113.74	110.82	112.02	14719200.0
2021-09-02	ABC-DELISTED	Stock	122.98	125.0	122.98	124.98	437025.0
2021-09-02	ABCB	Stock	48.17	49.18	47.75	48.24	318200.0
2021-09-02	ABCL	Stock	17.14	17.68	16.78	17.55	1396100.0
2021-09-02	ABCM-DELISTED	Stock	21.4	21.65	21.22	21.54	24330.0
2021-09-02	ABEO	Stock	32.0	34.0	31.75	33.75	25504.0
2021-09-02	ABEV	Stock	3.2	3.22	3.13	3.15	27614400.0
2021-09-02	ABG	Stock	185.81	185.94	180.39	181.04	96800.0
2021-09-02	ABM	Stock	48.87	49.11	48.11	48.87	347000.0
2021-09-02	ABMD-DELISTED	Stock	366.17	374.2	365.595	369.87	96732.0
2021-09-02	ABNB	Stock	156.5	159.46	156.5	157.2	3301000.0
2021-09-02	ABOS	Stock	17.36	17.45	14.91	15.27	312800.0
2021-09-02	ABR	Stock	18.35	18.48	18.26	18.38	743500.0

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

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