PREVIEW / stock_daily / 2021-12-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-13.parquet
  size:    261 KB
  rows:    8,010
  symbols: 2,625

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-13	AAPL	Stock	181.12	182.13	175.53	175.74	153237000.0
2021-12-13	MSFT	Stock	340.68	343.79	339.08	339.4	28899400.0
2021-12-13	NVDA	Stock	30.249	30.294	28.116	28.161	598344000.0
2021-12-13	AMZN	Stock	172.0	172.1	169.13	169.5675	62170000.0
2021-12-13	GOOGL	Stock	147.7815	147.97	145.5175	145.8265	27069400.0
2021-12-13	META	Stock	330.95	341.09	329.59	334.49	22948700.0
2021-12-13	TSLA	Stock	333.6967	335.0	317.14	322.1367	78595500.0
2021-12-13	TLT	Stock	150.39	151.305	150.31	151.06	17860465.0
2021-12-13	ES	Stock	87.7	89.8	87.43	89.26	1901600.0
2021-12-13	CL	Stock	79.28	81.25	79.28	81.14	5950900.0
2021-12-13	A	Stock	157.34	157.9	155.14	156.29	1413800.0
2021-12-13	AA	Stock	49.22	50.05	47.2	47.78	4950900.0
2021-12-13	AAC-DELISTED	Stock	9.79	9.8001	9.78	9.8	796000.0
2021-12-13	AACG	Stock	1.57	1.57	1.4	1.42	23000.0
2021-12-13	AACIW-DELISTED	Stock	0.49	0.49	0.4601	0.4601	27900.0
2021-12-13	AAIC-DELISTED	Stock	3.67	3.6889	3.65	3.65	105053.0
2021-12-13	AAIC.C-DELISTED	Stock	25.5664	25.65	25.5664	25.65	950.0
2021-12-13	AAL	Stock	17.55	17.65	16.85	17.12	40783900.0
2021-12-13	AAM.A-DELISTED	Stock	25.34	25.4	25.3112	25.4	20700.0
2021-12-13	AAM.B-DELISTED	Stock	26.17	26.17	26.06	26.1	1723.0
2021-12-13	AAME	Stock	3.63	3.8	3.63	3.69	3800.0
2021-12-13	AAMI	Stock	29.07	29.175	28.35	28.55	1144800.0
2021-12-13	AAN-DELISTED	Stock	24.2	24.293	23.46	23.62	249500.0
2021-12-13	AAOI	Stock	5.73	5.78	5.595	5.69	321000.0
2021-12-13	AAON	Stock	53.9333	54.3467	53.34	53.84	227850.0
2021-12-13	AAP	Stock	239.75	240.0	232.98	234.12	913400.0
2021-12-13	AAQC-DELISTED	Stock	9.72	9.75	9.72	9.75	120357.0
2021-12-13	AAT	Stock	35.58	35.95	34.86	35.59	253200.0
2021-12-13	AATC	Stock	6.65	6.72	6.5289	6.56	20596.0
2021-12-13	AAU-DELISTED	Stock	0.3003	0.3051	0.286	0.2965	560063.0
2021-12-13	AAUAF-DELISTED	Stock	0.3003	0.3051	0.286	0.2966	566787.0
2021-12-13	AAWW-DELISTED	Stock	86.6	86.83	84.77	86.16	218790.0
2021-12-13	AAXJ	Stock	83.32	83.32	82.3201	82.58	1539158.0
2021-12-13	AB	Stock	50.7	50.81	49.61	49.64	405800.0
2021-12-13	ABB-DELISTED	Stock	36.78	36.86	36.67	36.69	898058.0
2021-12-13	ABBNY-DELISTED	Stock	36.78	36.86	36.67	36.69	1017759.0
2021-12-13	ABBV	Stock	125.2	127.74	125.2	126.51	7834200.0
2021-12-13	ABC-DELISTED	Stock	123.13	123.51	121.0	122.53	391088.0
2021-12-13	ABCB	Stock	48.89	49.39	48.0	48.87	496600.0
2021-12-13	ABCL	Stock	14.11	14.45	13.43	13.78	1864400.0
2021-12-13	ABCM-DELISTED	Stock	22.54	22.59	21.36	21.45	127804.0
2021-12-13	ABEO	Stock	15.25	15.25	14.25	14.75	18200.0
2021-12-13	ABEV	Stock	2.82	2.83	2.78	2.8	22887600.0
2021-12-13	ABG	Stock	171.21	171.81	163.4	165.99	258200.0
2021-12-13	ABGI-DELISTED	Stock	9.73	9.75	9.73	9.75	35494.0
2021-12-13	ABM	Stock	45.73	46.06	45.31	45.76	337200.0
2021-12-13	ABMD-DELISTED	Stock	306.1	313.26	300.11	312.37	222901.0
2021-12-13	ABNB	Stock	178.25	180.0	168.89	171.04	7263700.0
2021-12-13	ABOS	Stock	7.12	7.255	6.39	6.76	151200.0
2021-12-13	ABR	Stock	18.11	18.14	17.82	17.89	1503600.0

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

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