PREVIEW / stock_daily / 2021-11-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-10.parquet
  size:    261 KB
  rows:    8,002
  symbols: 2,689

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-11-10	AAPL	Stock	150.02	150.13	147.85	147.92	65187100.0
2021-11-10	MSFT	Stock	334.57	334.63	329.92	330.8	25500900.0
2021-11-10	NVDA	Stock	29.356	30.85	28.778	29.459	636206000.0
2021-11-10	AMZN	Stock	178.1935	180.2725	173.1545	174.1025	80548000.0
2021-11-10	GOOGL	Stock	147.5	148.07	144.5375	145.8935	29969800.0
2021-11-10	META	Stock	332.49	333.19	325.51	327.64	21872600.0
2021-11-10	TSLA	Stock	336.8033	359.3667	329.1033	355.9833	128408100.0
2021-11-10	TLT	Stock	150.83	150.93	147.03	148.2	28170644.0
2021-11-10	ES	Stock	83.73	84.45	83.19	83.74	1063700.0
2021-11-10	CL	Stock	77.94	78.53	77.59	78.48	3263500.0
2021-11-10	A	Stock	159.21	159.98	156.06	159.28	1093200.0
2021-11-10	AA	Stock	47.01	47.69	45.6	46.17	5964800.0
2021-11-10	AAC-DELISTED	Stock	9.81	9.86	9.78	9.85	417083.0
2021-11-10	AACG	Stock	2.29	2.31	2.2	2.2	24200.0
2021-11-10	AACIU	Stock	9.99	10.01	9.91	9.99	417782.0
2021-11-10	AAIC-DELISTED	Stock	3.82	3.88	3.7401	3.8	619192.0
2021-11-10	AAIC.C-DELISTED	Stock	25.56	25.56	25.56	25.56	100.0
2021-11-10	AAL	Stock	21.83	22.03	21.45	21.57	22330900.0
2021-11-10	AAM.A-DELISTED	Stock	25.96	25.96	25.73	25.84	6619.0
2021-11-10	AAM.B-DELISTED	Stock	26.95	26.95	26.76	26.866	5503.0
2021-11-10	AAMC-DELISTED	Stock	7.2059	7.2147	6.7176	6.7176	30348.0
2021-11-10	AAME	Stock	4.27	4.4	4.18	4.18	16800.0
2021-11-10	AAMI	Stock	30.25	30.48	30.16	30.29	1263300.0
2021-11-10	AAN-DELISTED	Stock	26.3	27.0	25.96	26.13	183600.0
2021-11-10	AAOI	Stock	5.73	5.915	5.55	5.75	922700.0
2021-11-10	AAON	Stock	50.9733	51.3	50.5	51.16	141150.0
2021-11-10	AAP	Stock	233.33	236.05	232.47	234.77	457700.0
2021-11-10	AAQC-DELISTED	Stock	9.76	9.82	9.76	9.82	500.0
2021-11-10	AAT	Stock	39.75	40.24	39.29	39.32	193600.0
2021-11-10	AATC	Stock	6.85	6.9542	6.8097	6.95	13950.0
2021-11-10	AAU-DELISTED	Stock	0.411	0.4201	0.405	0.405	1014599.0
2021-11-10	AAUAF-DELISTED	Stock	0.411	0.4201	0.405	0.4155	1181895.0
2021-11-10	AAWW-DELISTED	Stock	83.66	84.89	83.35	83.71	275714.0
2021-11-10	AAXJ	Stock	86.42	86.81	85.765	86.06	4416932.0
2021-11-10	AB	Stock	56.17	56.27	54.52	55.1	221300.0
2021-11-10	ABB-DELISTED	Stock	34.85	35.01	34.581	34.64	835432.0
2021-11-10	ABBNY-DELISTED	Stock	34.85	35.01	34.581	34.63	933841.0
2021-11-10	ABBV	Stock	115.4	117.1	115.39	116.75	4981100.0
2021-11-10	ABC-DELISTED	Stock	125.03	126.14	124.93	125.69	448175.0
2021-11-10	ABCB	Stock	55.14	55.72	54.85	54.89	368400.0
2021-11-10	ABCL	Stock	13.54	15.13	13.18	14.14	3332100.0
2021-11-10	ABCM-DELISTED	Stock	22.78	22.96	22.55	22.68	48775.0
2021-11-10	ABEO	Stock	23.25	25.5	23.25	23.5	22744.0
2021-11-10	ABEV	Stock	3.23	3.26	3.17	3.18	33996900.0
2021-11-10	ABG	Stock	184.01	184.82	178.17	183.17	313800.0
2021-11-10	ABGI-DELISTED	Stock	9.75	9.75	9.75	9.75	200.0
2021-11-10	ABM	Stock	47.62	48.27	47.52	48.11	168300.0
2021-11-10	ABMD-DELISTED	Stock	369.0	379.295	354.7954	355.8	229762.0
2021-11-10	ABNB	Stock	190.23	195.0	189.28	192.22	6704100.0
2021-11-10	ABOS	Stock	14.69	14.95	13.96	14.13	31000.0

> showing 50 of 8,002 rows — these rows as CSV

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