PREVIEW / stock_daily / 2021-10-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-08.parquet
  size:    255 KB
  rows:    7,848
  symbols: 2,663

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-10-08	AAPL	Stock	144.03	144.18	142.56	142.9	58773200.0
2021-10-08	MSFT	Stock	296.22	296.64	293.76	294.85	17685700.0
2021-10-08	NVDA	Stock	21.101	21.206	20.775	20.831	151258000.0
2021-10-08	AMZN	Stock	165.85	166.0715	164.41	164.431	39964000.0
2021-10-08	GOOGL	Stock	139.577	140.331	139.2175	139.7855	26525840.0
2021-10-08	META	Stock	331.51	333.4	328.71	330.05	15946100.0
2021-10-08	TSLA	Stock	265.4033	265.46	260.3033	261.83	50215800.0
2021-10-08	TLT	Stock	142.255	142.35	141.525	141.88	17257754.0
2021-10-08	ES	Stock	86.09	86.66	85.29	85.41	824800.0
2021-10-08	CL	Stock	75.54	75.89	75.31	75.59	3327900.0
2021-10-08	A	Stock	156.18	156.92	152.1	152.47	904100.0
2021-10-08	AA	Stock	47.07	47.33	45.63	46.03	5548600.0
2021-10-08	AAC-DELISTED	Stock	9.76	9.78	9.75	9.77	175798.0
2021-10-08	AACG	Stock	2.28	2.33	2.28	2.3	6500.0
2021-10-08	AAIC-DELISTED	Stock	3.75	3.81	3.73	3.78	205900.0
2021-10-08	AAL	Stock	20.24	20.29	19.88	20.07	21691000.0
2021-10-08	AAM.A-DELISTED	Stock	25.65	25.66	25.61	25.62	8952.0
2021-10-08	AAM.B-DELISTED	Stock	26.75	26.89	26.68	26.72	46475.0
2021-10-08	AAMC-DELISTED	Stock	6.8559	6.9289	6.7971	6.903	25313.0
2021-10-08	AAME	Stock	4.39	4.49	4.33	4.49	19100.0
2021-10-08	AAMI	Stock	26.43	26.699	26.29	26.61	309200.0
2021-10-08	AAN-DELISTED	Stock	28.27	28.3	27.86	27.95	92200.0
2021-10-08	AAOI	Stock	6.94	7.065	6.77	6.79	357600.0
2021-10-08	AAON	Stock	46.4467	46.7	45.92	45.9933	126600.0
2021-10-08	AAP	Stock	213.76	215.3	213.08	214.15	351500.0
2021-10-08	AAQC-DELISTED	Stock	9.72	9.8	9.72	9.8	119791.0
2021-10-08	AAT	Stock	38.12	38.71	38.12	38.22	128600.0
2021-10-08	AATC	Stock	7.1001	7.2314	6.89	6.9	36231.0
2021-10-08	AAU-DELISTED	Stock	0.4019	0.4019	0.383	0.385	282661.0
2021-10-08	AAUAF-DELISTED	Stock	0.4019	0.4019	0.383	0.3875	296425.0
2021-10-08	AAWW-DELISTED	Stock	83.62	83.8961	81.45	81.68	248128.0
2021-10-08	AAXJ	Stock	85.54	85.75	85.32	85.64	514033.0
2021-10-08	AB	Stock	50.59	51.36	50.22	50.7	223600.0
2021-10-08	ABB-DELISTED	Stock	33.23	33.25	33.005	33.05	987513.0
2021-10-08	ABBNY-DELISTED	Stock	33.23	33.25	33.005	33.05	1119200.0
2021-10-08	ABBV	Stock	111.05	111.75	110.64	111.18	5019800.0
2021-10-08	ABC-DELISTED	Stock	118.53	119.88	118.14	119.39	521020.0
2021-10-08	ABCB	Stock	53.21	53.64	52.67	52.82	182100.0
2021-10-08	ABCL	Stock	15.79	15.9	15.24	15.37	1797000.0
2021-10-08	ABCM-DELISTED	Stock	20.8	20.86	20.5	20.57	63763.0
2021-10-08	ABEO	Stock	24.25	24.5	23.5	23.75	13324.0
2021-10-08	ABEV	Stock	2.73	2.78	2.7	2.74	18457000.0
2021-10-08	ABG	Stock	204.66	209.0	204.58	208.75	124200.0
2021-10-08	ABM	Stock	46.32	46.55	46.17	46.31	116400.0
2021-10-08	ABMD-DELISTED	Stock	340.3	343.5791	333.35	337.19	68898.0
2021-10-08	ABNB	Stock	170.1	174.1	169.48	169.97	2265100.0
2021-10-08	ABOS	Stock	14.7	14.82	13.41	13.45	71600.0
2021-10-08	ABR	Stock	19.04	19.29	19.02	19.15	904100.0
2021-10-08	ABR.D	Stock	25.42	25.43	25.41	25.42	17550.0
2021-10-08	ABR.E	Stock	25.29	25.29	25.1572	25.16	16633.0

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

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