PREVIEW / stock_daily / 2021-11-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-05.parquet
  size:    261 KB
  rows:    7,981
  symbols: 2,668

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-05	AAPL	Stock	151.89	152.2	150.06	151.28	65463900.0
2021-11-05	MSFT	Stock	338.51	338.79	334.42	336.06	22570100.0
2021-11-05	NVDA	Stock	30.187	31.4	29.41	29.752	851260000.0
2021-11-05	AMZN	Stock	173.85	178.3125	173.849	175.9495	99940000.0
2021-11-05	GOOGL	Stock	149.1695	150.3275	148.197	148.852	38354740.0
2021-11-05	META	Stock	340.31	346.79	339.64	341.13	26872800.0
2021-11-05	TSLA	Stock	409.3333	413.29	402.6667	407.3633	64886400.0
2021-11-05	TLT	Stock	148.52	149.58	148.13	149.3	21513029.0
2021-11-05	ES	Stock	84.01	85.06	83.86	84.41	1322700.0
2021-11-05	CL	Stock	77.55	77.95	77.08	77.84	3560300.0
2021-11-05	A	Stock	156.57	156.81	152.43	156.41	1775500.0
2021-11-05	AA	Stock	46.0	48.1	46.0	47.86	8317000.0
2021-11-05	AAC-DELISTED	Stock	9.83	9.83	9.79	9.8	58880.0
2021-11-05	AACG	Stock	2.36	2.38	2.3	2.36	20900.0
2021-11-05	AACIU	Stock	9.95	9.95	9.9	9.95	3200.0
2021-11-05	AAIC-DELISTED	Stock	3.85	3.87	3.83	3.83	82810.0
2021-11-05	AAL	Stock	21.91	22.06	21.26	21.82	58082500.0
2021-11-05	AAM.A-DELISTED	Stock	26.04	26.08	26.04	26.07	10920.0
2021-11-05	AAM.B-DELISTED	Stock	26.96	27.15	26.96	27.12	8116.0
2021-11-05	AAMC-DELISTED	Stock	7.2706	7.3059	7.2206	7.2912	17224.0
2021-11-05	AAME	Stock	4.3	4.53	4.3	4.51	8000.0
2021-11-05	AAMI	Stock	30.27	30.58	30.023	30.29	3311700.0
2021-11-05	AAN-DELISTED	Stock	25.55	26.19	25.35	25.6	214600.0
2021-11-05	AAOI	Stock	6.804	6.92	5.75	5.86	5693100.0
2021-11-05	AAON	Stock	48.34	50.24	47.3867	49.2667	258450.0
2021-11-05	AAP	Stock	231.22	232.12	228.09	229.73	491800.0
2021-11-05	AAQC-DELISTED	Stock	9.76	9.87	9.76	9.87	356890.0
2021-11-05	AAT	Stock	38.85	40.18	38.85	40.09	205100.0
2021-11-05	AATC	Stock	6.86	6.935	6.8	6.8	16234.0
2021-11-05	AAU-DELISTED	Stock	0.3713	0.3833	0.3713	0.381	552371.0
2021-11-05	AAUAF-DELISTED	Stock	0.3713	0.3833	0.3713	0.381	570406.0
2021-11-05	AAWW-DELISTED	Stock	90.69	91.77	85.8	85.93	591163.0
2021-11-05	AAXJ	Stock	86.46	86.56	85.73	85.97	505628.0
2021-11-05	AB	Stock	56.45	56.61	55.42	56.6	270900.0
2021-11-05	ABB-DELISTED	Stock	34.53	34.61	34.38	34.53	1154606.0
2021-11-05	ABBNY-DELISTED	Stock	34.53	34.61	34.38	34.53	1305319.0
2021-11-05	ABBV	Stock	116.73	117.32	115.5	117.18	4635800.0
2021-11-05	ABC-DELISTED	Stock	126.54	129.545	126.17	127.48	547146.0
2021-11-05	ABCB	Stock	54.33	55.98	54.27	55.09	302200.0
2021-11-05	ABCL	Stock	15.91	16.15	15.0	15.09	5201300.0
2021-11-05	ABCM-DELISTED	Stock	22.92	23.23	22.8097	23.04	14135.0
2021-11-05	ABEO	Stock	22.5	22.75	22.0	22.5	28976.0
2021-11-05	ABEV	Stock	3.19	3.22	3.16	3.22	28282800.0
2021-11-05	ABG	Stock	185.61	187.76	180.81	182.07	1039800.0
2021-11-05	ABM	Stock	46.84	48.61	46.64	48.0	466300.0
2021-11-05	ABMD-DELISTED	Stock	362.71	366.35	355.23	361.7	209490.0
2021-11-05	ABNB	Stock	186.15	203.295	185.944	201.62	27330500.0
2021-11-05	ABOS	Stock	14.96	14.96	14.59	14.88	31100.0
2021-11-05	ABR	Stock	19.75	19.84	19.58	19.63	1469700.0
2021-11-05	ABR.D	Stock	25.3	25.3	25.22	25.3	32922.0

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

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