PREVIEW / stock_daily / 2021-09-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-01.parquet
  size:    259 KB
  rows:    7,912
  symbols: 2,760

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-01	AAPL	Stock	152.83	154.98	152.34	152.51	80313700.0
2021-09-01	MSFT	Stock	302.87	305.19	301.49	301.83	18983800.0
2021-09-01	NVDA	Stock	22.485	22.697	22.357	22.441	201767000.0
2021-09-01	AMZN	Stock	174.82	176.35	173.762	173.95	72598000.0
2021-09-01	GOOGL	Stock	145.0	146.2538	144.8835	145.2155	21936100.0
2021-09-01	META	Stock	379.59	384.33	378.81	382.05	11567200.0
2021-09-01	TSLA	Stock	244.6933	247.33	243.7567	244.6967	39612900.0
2021-09-01	TLT	Stock	149.27	149.39	148.49	148.89	10807084.0
2021-09-01	ES	Stock	90.97	92.06	90.85	91.66	1542800.0
2021-09-01	CL	Stock	77.84	78.47	77.83	78.33	2658000.0
2021-09-01	A	Stock	175.04	175.74	174.38	175.45	1429000.0
2021-09-01	AA	Stock	43.71	46.22	42.45	45.6	11739100.0
2021-09-01	AAC-DELISTED	Stock	9.71	9.71	9.69	9.7	1114787.0
2021-09-01	AACG	Stock	2.87	2.87	2.71	2.8	33200.0
2021-09-01	AACIU	Stock	9.94	9.94	9.89	9.895	16943.0
2021-09-01	AAIC-DELISTED	Stock	3.75	3.77	3.72	3.75	182881.0
2021-09-01	AAIC.C-DELISTED	Stock	25.3799	25.39	25.25	25.39	3482.0
2021-09-01	AAL	Stock	20.01	20.1	19.53	19.64	20843200.0
2021-09-01	AAM.A-DELISTED	Stock	26.0299	26.19	26.0298	26.17	13529.0
2021-09-01	AAM.B-DELISTED	Stock	27.0152	27.04	26.87	26.93	52489.0
2021-09-01	AAMC-DELISTED	Stock	5.8824	7.7751	5.8824	7.2941	1104500.0
2021-09-01	AAME	Stock	4.02	4.35	3.96	4.35	115100.0
2021-09-01	AAMI	Stock	27.14	27.285	27.09	27.18	332000.0
2021-09-01	AAN-DELISTED	Stock	26.71	27.48	26.6	26.9	270100.0
2021-09-01	AAOI	Stock	7.36	7.7	7.265	7.63	605100.0
2021-09-01	AAON	Stock	45.5	45.66	44.3333	44.9933	173100.0
2021-09-01	AAP	Stock	203.8	204.59	199.99	201.88	615600.0
2021-09-01	AAQC-DELISTED	Stock	9.62	9.67	9.62	9.66	21771.0
2021-09-01	AAT	Stock	39.97	40.31	39.76	39.9	212700.0
2021-09-01	AATC	Stock	7.6	8.0499	7.6	7.87	38045.0
2021-09-01	AAU-DELISTED	Stock	0.4099	0.42	0.4088	0.414	223474.0
2021-09-01	AAUAF-DELISTED	Stock	0.4099	0.42	0.4088	0.414	227232.0
2021-09-01	AAWW-DELISTED	Stock	73.38	73.7	72.31	73.58	257899.0
2021-09-01	AAXJ	Stock	89.28	90.23	89.28	89.92	645963.0
2021-09-01	AB	Stock	52.37	52.37	52.0	52.24	155800.0
2021-09-01	ABB-DELISTED	Stock	37.01	37.24	36.93	37.175	871033.0
2021-09-01	ABBNY-DELISTED	Stock	37.01	37.24	36.93	37.18	987636.0
2021-09-01	ABBV	Stock	121.0	121.53	106.1	112.27	50943200.0
2021-09-01	ABC-DELISTED	Stock	122.15	122.79	119.84	122.68	427500.0
2021-09-01	ABCB	Stock	49.33	49.33	48.17	48.76	213200.0
2021-09-01	ABCL	Stock	16.78	17.41	16.545	16.93	1567600.0
2021-09-01	ABCM-DELISTED	Stock	21.22	21.44	21.14	21.255	20386.0
2021-09-01	ABEO	Stock	32.25	33.25	32.0	32.25	17988.0
2021-09-01	ABEV	Stock	3.27	3.33	3.24	3.28	25678400.0
2021-09-01	ABG	Stock	187.01	187.76	183.01	185.1	106600.0
2021-09-01	ABGI-DELISTED	Stock	9.62	9.68	9.62	9.68	400.0
2021-09-01	ABM	Stock	49.72	49.96	48.24	48.76	348500.0
2021-09-01	ABMD-DELISTED	Stock	365.39	367.62	361.93	362.84	90600.0
2021-09-01	ABNB	Stock	154.84	158.64	154.29	156.59	4324700.0
2021-09-01	ABOS	Stock	18.0	18.03	16.79	17.29	97400.0

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

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