PREVIEW / stock_daily / 2021-09-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-28.parquet
  size:    257 KB
  rows:    7,840
  symbols: 2,654

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-28	AAPL	Stock	143.25	144.75	141.69	141.91	108972300.0
2021-09-28	MSFT	Stock	289.8	290.78	282.75	283.52	43186200.0
2021-09-28	NVDA	Stock	21.214	21.419	20.651	20.699	343069000.0
2021-09-28	AMZN	Stock	167.8855	168.4595	164.505	165.798	88616000.0
2021-09-28	GOOGL	Stock	138.655	139.0965	135.36	135.83	45772200.0
2021-09-28	META	Stock	347.97	349.6	338.92	340.65	21710300.0
2021-09-28	TSLA	Stock	262.4	265.2133	255.3933	259.1867	76144200.0
2021-09-28	TLT	Stock	144.33	145.07	143.64	144.09	26613486.0
2021-09-28	ES	Stock	81.02	81.47	80.35	81.07	1466800.0
2021-09-28	CL	Stock	75.62	76.16	75.41	75.82	4949500.0
2021-09-28	A	Stock	164.19	164.33	158.79	159.9	2541000.0
2021-09-28	AA	Stock	51.6	52.45	50.16	50.98	7122300.0
2021-09-28	AAC-DELISTED	Stock	9.75	9.76	9.71	9.75	637085.0
2021-09-28	AACG	Stock	2.4	2.49	2.37	2.47	40800.0
2021-09-28	AAIC-DELISTED	Stock	3.73	3.79	3.73	3.76	109163.0
2021-09-28	AAIC.C-DELISTED	Stock	25.15	25.24	25.15	25.19	2340.0
2021-09-28	AAL	Stock	21.35	21.81	21.29	21.43	26170200.0
2021-09-28	AAM.A-DELISTED	Stock	25.68	25.68	25.35	25.62	16748.0
2021-09-28	AAM.B-DELISTED	Stock	26.75	26.76	26.52	26.72	29409.0
2021-09-28	AAMC-DELISTED	Stock	6.7824	7.0059	6.3824	6.8471	345528.0
2021-09-28	AAME	Stock	3.98	4.04	3.92	3.96	10100.0
2021-09-28	AAMI	Stock	26.77	26.9	26.15	26.16	398200.0
2021-09-28	AAN-DELISTED	Stock	28.85	29.135	28.1	28.11	141500.0
2021-09-28	AAOI	Stock	7.18	7.29	7.05	7.05	248700.0
2021-09-28	AAON	Stock	44.8467	44.8467	43.94	44.1133	196500.0
2021-09-28	AAP	Stock	218.25	219.43	214.27	214.78	686800.0
2021-09-28	AAQC-DELISTED	Stock	9.7	9.73	9.7	9.72	757.0
2021-09-28	AAT	Stock	38.32	38.44	37.71	37.92	276400.0
2021-09-28	AATC	Stock	7.75	7.8	7.53	7.6	28185.0
2021-09-28	AAU-DELISTED	Stock	0.39	0.4015	0.39	0.3976	397130.0
2021-09-28	AAUAF-DELISTED	Stock	0.39	0.4015	0.39	0.3976	402322.0
2021-09-28	AAWW-DELISTED	Stock	82.01	84.76	81.93	83.58	475107.0
2021-09-28	AAXJ	Stock	85.64	85.77	84.8701	85.14	886418.0
2021-09-28	AB	Stock	51.12	51.27	49.6	49.73	377200.0
2021-09-28	ABB-DELISTED	Stock	33.85	33.92	33.51	33.63	1391079.0
2021-09-28	ABBNY-DELISTED	Stock	33.85	33.92	33.51	33.63	1546610.0
2021-09-28	ABBV	Stock	107.62	108.62	107.04	107.34	6445600.0
2021-09-28	ABC-DELISTED	Stock	122.89	122.955	121.15	121.35	541389.0
2021-09-28	ABCB	Stock	53.47	53.61	52.05	52.33	329800.0
2021-09-28	ABCL	Stock	20.57	20.68	19.328	19.61	3738100.0
2021-09-28	ABCM-DELISTED	Stock	20.1	20.4	19.91	20.33	35342.0
2021-09-28	ABEO	Stock	29.25	29.5	28.5	28.5	14808.0
2021-09-28	ABEV	Stock	2.89	2.89	2.77	2.79	26022700.0
2021-09-28	ABG	Stock	203.0	205.18	198.24	198.82	129800.0
2021-09-28	ABGI-DELISTED	Stock	9.7	9.7	9.7	9.7	26929.0
2021-09-28	ABM	Stock	45.24	45.49	44.81	44.93	173800.0
2021-09-28	ABMD-DELISTED	Stock	334.08	334.08	327.36	331.46	96873.0
2021-09-28	ABNB	Stock	172.516	173.56	166.9	168.58	4362800.0
2021-09-28	ABOS	Stock	15.66	16.005	14.6	14.7	210400.0
2021-09-28	ABR	Stock	18.57	18.6	18.32	18.34	771000.0

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

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