PREVIEW / stock_daily / 2021-10-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-14.parquet
  size:    257 KB
  rows:    7,871
  symbols: 2,659

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-10-14	AAPL	Stock	142.11	143.88	141.51	143.76	69907100.0
2021-10-14	MSFT	Stock	299.21	303.27	297.83	302.75	27262900.0
2021-10-14	NVDA	Stock	21.288	21.755	21.122	21.746	243589000.0
2021-10-14	AMZN	Stock	165.1225	165.63	164.539	164.993	42190000.0
2021-10-14	GOOGL	Stock	139.4738	141.3372	138.825	141.151	31927940.0
2021-10-14	META	Stock	328.36	330.52	327.1	328.53	14302200.0
2021-10-14	TSLA	Stock	271.83	273.4167	271.1167	272.7733	36741600.0
2021-10-14	TLT	Stock	145.37	145.96	144.945	145.88	12950609.0
2021-10-14	ES	Stock	86.69	87.81	86.37	87.69	1203500.0
2021-10-14	CL	Stock	76.21	76.81	76.0	76.6	3739000.0
2021-10-14	A	Stock	151.62	153.48	151.62	152.59	1434100.0
2021-10-14	AA	Stock	49.29	50.04	48.06	48.6	9971300.0
2021-10-14	AAC-DELISTED	Stock	9.77	9.77	9.74	9.76	87114.0
2021-10-14	AACG	Stock	2.34	2.34	2.26	2.28	18000.0
2021-10-14	AAIC-DELISTED	Stock	3.9	4.0	3.895	3.99	469261.0
2021-10-14	AAIC.C-DELISTED	Stock	25.35	25.35	25.35	25.35	400.0
2021-10-14	AAL	Stock	19.77	19.94	19.59	19.64	21544600.0
2021-10-14	AAM.A-DELISTED	Stock	25.7	25.77	25.7	25.7	7873.0
2021-10-14	AAM.B-DELISTED	Stock	26.73	26.8	26.72	26.74	19992.0
2021-10-14	AAMC-DELISTED	Stock	6.9559	7.1781	6.9088	7.1618	12546.0
2021-10-14	AAME	Stock	4.29	4.4	4.25	4.4	9400.0
2021-10-14	AAMI	Stock	26.3	26.82	26.18	26.71	521700.0
2021-10-14	AAN-DELISTED	Stock	27.26	27.82	26.9	27.62	131900.0
2021-10-14	AAOI	Stock	7.25	7.58	7.25	7.34	362100.0
2021-10-14	AAON	Stock	45.36	46.4133	45.2	46.1933	103650.0
2021-10-14	AAP	Stock	211.2	216.18	210.32	214.86	385400.0
2021-10-14	AAQC-DELISTED	Stock	9.71	9.73	9.71	9.73	4417.0
2021-10-14	AAT	Stock	39.74	39.92	39.59	39.75	104400.0
2021-10-14	AATC	Stock	7.0	7.1	6.91	6.91	12235.0
2021-10-14	AAU-DELISTED	Stock	0.39	0.39	0.3884	0.39	557946.0
2021-10-14	AAUAF-DELISTED	Stock	0.39	0.39	0.3884	0.39	563927.0
2021-10-14	AAWW-DELISTED	Stock	80.5	81.94	79.03	79.36	476359.0
2021-10-14	AAXJ	Stock	86.49	86.64	86.055	86.44	718379.0
2021-10-14	AB	Stock	50.75	52.34	50.51	52.23	230000.0
2021-10-14	ABB-DELISTED	Stock	34.22	34.54	34.11	34.51	1183051.0
2021-10-14	ABBNY-DELISTED	Stock	34.22	34.54	34.11	34.51	1319353.0
2021-10-14	ABBV	Stock	107.96	108.99	107.8	108.91	7289500.0
2021-10-14	ABC-DELISTED	Stock	119.67	120.705	118.53	120.1	484532.0
2021-10-14	ABCB	Stock	52.88	52.88	52.03	52.78	234400.0
2021-10-14	ABCL	Stock	15.58	16.37	15.54	15.91	1303400.0
2021-10-14	ABCM-DELISTED	Stock	20.85	21.19	20.81	21.06	19956.0
2021-10-14	ABEO	Stock	22.0	22.75	22.0	22.25	19576.0
2021-10-14	ABEV	Stock	2.77	2.79	2.74	2.77	12761700.0
2021-10-14	ABG	Stock	214.84	214.84	209.17	210.92	120900.0
2021-10-14	ABGI-DELISTED	Stock	9.7	9.75	9.7	9.75	23900.0
2021-10-14	ABM	Stock	45.46	46.2	45.08	46.0	221000.0
2021-10-14	ABMD-DELISTED	Stock	339.03	346.22	339.03	345.06	113407.0
2021-10-14	ABNB	Stock	175.24	176.75	170.04	170.5	4139400.0
2021-10-14	ABOS	Stock	14.5	14.5	13.72	13.93	50300.0
2021-10-14	ABR	Stock	19.2	19.23	19.06	19.21	740300.0

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

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