PREVIEW / stock_daily / 2021-12-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-17.parquet
  size:    263 KB
  rows:    8,018
  symbols: 2,632

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-12-17	AAPL	Stock	169.93	173.47	169.69	171.14	195432700.0
2021-12-17	MSFT	Stock	320.88	324.92	317.25	323.8	47750300.0
2021-12-17	NVDA	Stock	27.985	28.922	27.76	27.801	713758000.0
2021-12-17	AMZN	Stock	167.7105	170.8985	165.6135	170.0175	85542000.0
2021-12-17	GOOGL	Stock	142.5	143.8345	141.3	141.725	51017880.0
2021-12-17	META	Stock	332.8	337.11	330.75	333.79	40012600.0
2021-12-17	TSLA	Stock	304.9233	320.22	303.0133	310.8567	100437300.0
2021-12-17	TLT	Stock	150.34	150.98	150.16	150.83	18094619.0
2021-12-17	ES	Stock	90.76	91.41	89.06	89.4	2971200.0
2021-12-17	CL	Stock	83.58	84.27	82.24	82.48	10299800.0
2021-12-17	A	Stock	150.35	152.59	148.04	151.42	2628700.0
2021-12-17	AA	Stock	52.26	53.78	50.881	53.73	31780900.0
2021-12-17	AAC-DELISTED	Stock	9.76	9.78	9.76	9.78	50753.0
2021-12-17	AACG	Stock	1.28	1.3	1.25	1.27	26300.0
2021-12-17	AACIU	Stock	10.06	10.155	10.01	10.01	16748.0
2021-12-17	AACIW-DELISTED	Stock	0.571	0.6697	0.48	0.54	300725.0
2021-12-17	AAIC-DELISTED	Stock	3.5	3.55	3.4875	3.49	178437.0
2021-12-17	AAIC.C-DELISTED	Stock	25.8791	25.91	25.86	25.9	1900.0
2021-12-17	AAL	Stock	16.66	17.3	16.4	16.95	41330600.0
2021-12-17	AAM.A-DELISTED	Stock	25.43	25.45	25.29	25.29	32290.0
2021-12-17	AAM.B-DELISTED	Stock	26.46	26.7	26.25	26.25	17353.0
2021-12-17	AAME	Stock	3.38	3.64	3.36	3.56	6000.0
2021-12-17	AAMI	Stock	26.28	26.49	25.79	26.31	1848400.0
2021-12-17	AAN-DELISTED	Stock	23.55	24.18	23.13	24.05	856000.0
2021-12-17	AAOI	Stock	5.39	5.68	5.29	5.67	596500.0
2021-12-17	AAON	Stock	51.5067	52.7733	50.5933	51.9267	1423650.0
2021-12-17	AAP	Stock	237.92	237.92	231.76	232.82	1544500.0
2021-12-17	AAQC-DELISTED	Stock	9.7	9.72	9.7	9.71	10042.0
2021-12-17	AAT	Stock	35.27	35.88	34.99	35.65	1290500.0
2021-12-17	AATC	Stock	6.47	6.61	6.4	6.4	12265.0
2021-12-17	AAU-DELISTED	Stock	0.31	0.3199	0.3036	0.3104	415766.0
2021-12-17	AAUAF-DELISTED	Stock	0.31	0.3199	0.3036	0.3175	421771.0
2021-12-17	AAWW-DELISTED	Stock	87.76	90.64	86.36	87.3	1166490.0
2021-12-17	AAXJ	Stock	81.22	81.72	80.96	81.35	1268750.0
2021-12-17	AB	Stock	46.66	47.66	46.01	47.06	466700.0
2021-12-17	ABB-DELISTED	Stock	37.0	37.12	36.745	36.76	1543002.0
2021-12-17	ABBNY-DELISTED	Stock	37.0	37.12	36.745	36.76	1733547.0
2021-12-17	ABBV	Stock	130.84	131.02	129.37	129.53	12631100.0
2021-12-17	ABC-DELISTED	Stock	124.66	126.3599	123.61	125.24	991669.0
2021-12-17	ABCB	Stock	48.79	49.26	47.01	48.59	2401500.0
2021-12-17	ABCL	Stock	13.93	15.55	13.27	14.98	5273600.0
2021-12-17	ABCM-DELISTED	Stock	21.67	22.65	21.64	22.11	1796189.0
2021-12-17	ABEO	Stock	7.25	7.75	6.75	7.25	2112244.0
2021-12-17	ABEV	Stock	2.8	2.82	2.77	2.81	16177700.0
2021-12-17	ABG	Stock	165.45	167.52	163.65	164.1	627900.0
2021-12-17	ABGI-DELISTED	Stock	9.74	9.8	9.74	9.8	586.0
2021-12-17	ABM	Stock	40.95	41.15	40.05	40.26	1185100.0
2021-12-17	ABMD-DELISTED	Stock	309.64	319.89	305.12	315.28	554945.0
2021-12-17	ABNB	Stock	154.62	158.31	149.44	157.91	24062400.0
2021-12-17	ABOS	Stock	6.87	7.14	6.201	6.88	535500.0

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

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