PREVIEW / stock_daily / 2021-11-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-30.parquet
  size:    263 KB
  rows:    8,065
  symbols: 2,704

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-30	AAPL	Stock	159.99	165.52	159.92	165.3	174048100.0
2021-11-30	MSFT	Stock	335.32	337.78	328.99	330.59	42885600.0
2021-11-30	NVDA	Stock	33.169	33.353	31.864	32.676	622066000.0
2021-11-30	AMZN	Stock	178.175	179.2885	174.6005	175.3535	80022000.0
2021-11-30	GOOGL	Stock	145.0085	146.0	141.6015	141.8975	42067220.0
2021-11-30	META	Stock	335.0	335.81	323.43	324.46	25390000.0
2021-11-30	TSLA	Stock	381.4567	389.3333	372.6667	381.5867	81276000.0
2021-11-30	TLT	Stock	150.83	152.07	150.25	151.59	31481117.0
2021-11-30	ES	Stock	84.78	85.07	82.25	82.27	3065200.0
2021-11-30	CL	Stock	77.14	77.4	75.01	75.02	8702400.0
2021-11-30	A	Stock	153.35	155.71	149.7	150.9	3900500.0
2021-11-30	AA	Stock	48.78	49.38	45.56	46.53	9644900.0
2021-11-30	AAC-DELISTED	Stock	9.78	9.8	9.78	9.79	97363.0
2021-11-30	AACG	Stock	1.73	1.73	1.64	1.64	33400.0
2021-11-30	AACIW-DELISTED	Stock	0.51	0.51	0.495	0.4999	22491.0
2021-11-30	AAIC-DELISTED	Stock	3.65	3.675	3.5801	3.61	249539.0
2021-11-30	AAIC.C-DELISTED	Stock	25.9565	25.9565	25.67	25.6701	400.0
2021-11-30	AAL	Stock	17.44	17.74	16.92	17.69	49870100.0
2021-11-30	AAM.A-DELISTED	Stock	25.42	25.42	25.03	25.15	41501.0
2021-11-30	AAM.B-DELISTED	Stock	26.15	26.27	25.8	26.03	41577.0
2021-11-30	AAMC-DELISTED	Stock	5.7353	5.7353	5.0794	5.2647	45920.0
2021-11-30	AAME	Stock	3.85	3.93	3.8	3.9	7800.0
2021-11-30	AAMI	Stock	30.2	30.58	30.01	30.03	2945000.0
2021-11-30	AAN-DELISTED	Stock	23.5	23.555	22.14	22.2	414400.0
2021-11-30	AAOI	Stock	5.93	5.97	5.755	5.91	484300.0
2021-11-30	AAON	Stock	51.5933	52.2867	51.1933	52.0	933600.0
2021-11-30	AAP	Stock	225.6	228.17	220.0	220.72	918000.0
2021-11-30	AAQC-DELISTED	Stock	9.72	9.73	9.72	9.72	3986.0
2021-11-30	AAT	Stock	34.88	34.92	34.28	34.4	361300.0
2021-11-30	AATC	Stock	7.04	7.0447	6.7	6.76	11086.0
2021-11-30	AAU-DELISTED	Stock	0.3363	0.344	0.325	0.3435	540911.0
2021-11-30	AAUAF-DELISTED	Stock	0.3363	0.344	0.325	0.3435	550772.0
2021-11-30	AAWW-DELISTED	Stock	89.63	89.99	85.81	87.73	403552.0
2021-11-30	AAXJ	Stock	83.18	83.77	82.445	83.29	1216944.0
2021-11-30	AB	Stock	52.98	53.16	50.11	50.12	626500.0
2021-11-30	ABB-DELISTED	Stock	34.75	35.03	34.34	34.54	1690694.0
2021-11-30	ABBNY-DELISTED	Stock	34.75	35.03	34.34	34.55	1971338.0
2021-11-30	ABBV	Stock	116.68	116.79	115.1	115.28	8172100.0
2021-11-30	ABC-DELISTED	Stock	119.65	120.015	115.41	115.755	2438026.0
2021-11-30	ABCB	Stock	49.02	49.76	48.11	48.67	413700.0
2021-11-30	ABCL	Stock	14.0	15.351	13.96	14.96	2263800.0
2021-11-30	ABCM-DELISTED	Stock	22.93	23.11	22.59	22.67	58799.0
2021-11-30	ABEO	Stock	16.5	17.25	16.25	17.25	43460.0
2021-11-30	ABEV	Stock	2.87	2.9	2.8	2.82	35143300.0
2021-11-30	ABG	Stock	161.78	165.77	159.16	163.64	498400.0
2021-11-30	ABGI-DELISTED	Stock	9.82	9.82	9.76	9.82	21017.0
2021-11-30	ABM	Stock	46.0	46.24	44.66	45.0	391900.0
2021-11-30	ABMD-DELISTED	Stock	319.11	321.408	312.43	315.02	416026.0
2021-11-30	ABNB	Stock	176.405	180.64	170.921	172.54	10682700.0
2021-11-30	ABOS	Stock	8.08	8.09	7.65	7.9	150400.0

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

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