PREVIEW / stock_daily / 2021-12-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-15.parquet
  size:    262 KB
  rows:    8,024
  symbols: 2,649

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-15	AAPL	Stock	175.11	179.5	172.31	179.3	131063300.0
2021-12-15	MSFT	Stock	328.61	335.19	324.5	334.65	35381100.0
2021-12-15	NVDA	Stock	28.4	30.5	27.838	30.459	698297000.0
2021-12-15	AMZN	Stock	168.598	173.6	165.195	173.315	75794000.0
2021-12-15	GOOGL	Stock	143.409	146.721	141.6779	146.441	36370460.0
2021-12-15	META	Stock	332.49	342.11	323.98	341.66	24681300.0
2021-12-15	TSLA	Stock	317.7367	326.25	309.4167	325.33	75169200.0
2021-12-15	TLT	Stock	149.6139	150.79	149.13	149.25	25383933.0
2021-12-15	ES	Stock	89.52	90.98	89.38	90.87	1620100.0
2021-12-15	CL	Stock	81.93	83.22	81.82	82.76	6124500.0
2021-12-15	A	Stock	152.76	154.59	150.62	154.31	2054900.0
2021-12-15	AA	Stock	49.51	51.01	48.045	50.97	9047600.0
2021-12-15	AAC-DELISTED	Stock	9.79	9.79	9.77	9.79	55017.0
2021-12-15	AACG	Stock	1.31	1.4	1.1	1.34	53100.0
2021-12-15	AACIW-DELISTED	Stock	0.4613	0.49995	0.4502	0.49995	7910.0
2021-12-15	AAIC-DELISTED	Stock	3.55	3.57	3.485	3.5	349997.0
2021-12-15	AAIC.C-DELISTED	Stock	25.8499	25.99	25.52	25.52	1759.0
2021-12-15	AAL	Stock	16.95	17.09	16.27	16.99	39939400.0
2021-12-15	AAM.A-DELISTED	Stock	25.52	25.52	25.37	25.429	45976.0
2021-12-15	AAM.B-DELISTED	Stock	26.33	26.481	26.2	26.42	15195.0
2021-12-15	AAME	Stock	3.65	3.65	3.51	3.54	9200.0
2021-12-15	AAMI	Stock	27.41	27.41	26.52	27.12	1638400.0
2021-12-15	AAN-DELISTED	Stock	23.32	23.76	22.69	23.72	367000.0
2021-12-15	AAOI	Stock	5.6	5.74	5.43	5.74	280200.0
2021-12-15	AAON	Stock	52.62	52.8067	51.6	52.54	321900.0
2021-12-15	AAP	Stock	235.39	239.65	234.56	239.14	535700.0
2021-12-15	AAQC-DELISTED	Stock	9.71	9.73	9.71	9.72	35949.0
2021-12-15	AAT	Stock	34.99	35.57	34.65	35.5	346100.0
2021-12-15	AATC	Stock	6.53	6.61	6.5001	6.53	6792.0
2021-12-15	AAU-DELISTED	Stock	0.3	0.3007	0.27	0.2896	939337.0
2021-12-15	AAUAF-DELISTED	Stock	0.3	0.3007	0.27	0.285	948311.0
2021-12-15	AAWW-DELISTED	Stock	87.5	88.38	85.74	87.8	353893.0
2021-12-15	AAXJ	Stock	81.94	82.04	80.88	81.95	1061698.0
2021-12-15	AB	Stock	48.23	48.4	46.72	47.86	633700.0
2021-12-15	ABB-DELISTED	Stock	36.35	36.795	36.115	36.79	1488015.0
2021-12-15	ABBNY-DELISTED	Stock	36.35	36.795	36.115	36.79	1641087.0
2021-12-15	ABBV	Stock	128.25	130.78	127.6	130.23	9585600.0
2021-12-15	ABC-DELISTED	Stock	123.17	124.05	122.47	123.76	514403.0
2021-12-15	ABCB	Stock	49.71	49.71	47.85	48.3	821000.0
2021-12-15	ABCL	Stock	13.12	13.228	12.2	12.99	3512400.0
2021-12-15	ABCM-DELISTED	Stock	21.66	22.58	21.53	22.46	139925.0
2021-12-15	ABEO	Stock	13.0	13.75	12.0	13.0	51192.0
2021-12-15	ABEV	Stock	2.81	2.81	2.74	2.8	19439800.0
2021-12-15	ABG	Stock	166.98	174.11	164.25	173.08	360300.0
2021-12-15	ABGI-DELISTED	Stock	9.77	9.85	9.77	9.8	57604.0
2021-12-15	ABM	Stock	45.97	46.86	39.29	40.88	1539200.0
2021-12-15	ABMD-DELISTED	Stock	313.01	315.685	309.27	315.45	122928.0
2021-12-15	ABNB	Stock	167.64	168.96	160.18	168.14	6678500.0
2021-12-15	ABOS	Stock	6.6	7.06	6.23	6.9	285200.0
2021-12-15	ABR	Stock	17.5	17.71	17.31	17.61	1663100.0

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

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