PREVIEW / stock_daily / 2021-07-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-27.parquet
  size:    257 KB
  rows:    7,891
  symbols: 2,819

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-07-27	AAPL	Stock	149.12	149.21	145.55	146.77	104818600.0
2021-07-27	MSFT	Stock	289.43	289.58	282.95	286.54	33604100.0
2021-07-27	NVDA	Stock	19.265	19.622	18.741	19.208	248863000.0
2021-07-27	AMZN	Stock	184.925	184.925	179.3075	181.3195	82638000.0
2021-07-27	GOOGL	Stock	134.2505	134.399	130.104	131.9	54709480.0
2021-07-27	META	Stock	371.91	373.15	364.55	367.81	15705400.0
2021-07-27	TSLA	Stock	221.1333	222.1667	209.08	214.9267	98439900.0
2021-07-27	TLT	Stock	149.33	149.69	148.99	149.64	13036604.0
2021-07-27	ES	Stock	86.03	87.81	85.35	87.6	1339400.0
2021-07-27	CL	Stock	83.78	84.57	83.44	83.95	4136700.0
2021-07-27	A	Stock	149.29	150.0	148.86	149.95	2085700.0
2021-07-27	AA	Stock	38.04	38.5	37.37	38.27	5782400.0
2021-07-27	AAC-DELISTED	Stock	9.7401	9.76	9.7392	9.76	17852.0
2021-07-27	AACG	Stock	3.25	3.35	2.98	3.08	209500.0
2021-07-27	AAIC-DELISTED	Stock	3.9	3.985	3.83	3.92	533024.0
2021-07-27	AAIC.C-DELISTED	Stock	25.23	25.23	25.0	25.115	1355.0
2021-07-27	AAL	Stock	21.96	22.16	21.11	21.46	30301300.0
2021-07-27	AAM.A-DELISTED	Stock	26.48	26.5	26.3584	26.5	9715.0
2021-07-27	AAM.B-DELISTED	Stock	27.0056	27.05	26.9	27.05	4821.0
2021-07-27	AAMC-DELISTED	Stock	4.7	4.7324	4.5587	4.5598	54060.0
2021-07-27	AAME	Stock	3.88	4.1	3.75	4.08	41400.0
2021-07-27	AAMI	Stock	24.05	24.31	23.89	24.27	296700.0
2021-07-27	AAN-DELISTED	Stock	30.6	30.75	28.335	30.13	653100.0
2021-07-27	AAOI	Stock	7.36	7.46	7.11	7.21	453100.0
2021-07-27	AAON	Stock	39.7933	40.44	39.48	39.9133	315750.0
2021-07-27	AAP	Stock	217.69	217.69	212.42	215.37	703100.0
2021-07-27	AAQC-DELISTED	Stock	9.665	9.6894	9.665	9.68	79138.0
2021-07-27	AAT	Stock	36.46	37.11	36.46	36.85	310900.0
2021-07-27	AATC	Stock	6.4	6.4999	6.23	6.3214	43355.0
2021-07-27	AAU-DELISTED	Stock	0.41	0.414	0.4	0.4039	633532.0
2021-07-27	AAUAF-DELISTED	Stock	0.41	0.414	0.4	0.41	683444.0
2021-07-27	AAWW-DELISTED	Stock	65.48	66.035	64.63	65.955	121450.0
2021-07-27	AAXJ	Stock	85.52	85.82	84.38	85.53	4398273.0
2021-07-27	AB	Stock	47.27	47.3	46.25	46.59	165200.0
2021-07-27	ABB-DELISTED	Stock	36.74	36.955	36.63	36.83	979980.0
2021-07-27	ABBNY-DELISTED	Stock	36.74	36.955	36.63	36.83	1073577.0
2021-07-27	ABBV	Stock	117.79	118.3	116.76	117.96	3773100.0
2021-07-27	ABC-DELISTED	Stock	120.42	121.76	119.725	121.4	384449.0
2021-07-27	ABCB	Stock	46.66	47.59	46.25	47.33	468000.0
2021-07-27	ABCL	Stock	15.35	15.45	14.51	14.85	1993600.0
2021-07-27	ABCM-DELISTED	Stock	18.05	18.07	17.8	17.99	23992.0
2021-07-27	ABEO	Stock	32.25	32.5	30.5	31.25	62976.0
2021-07-27	ABEV	Stock	3.25	3.25	3.2	3.24	11312100.0
2021-07-27	ABG	Stock	200.0	202.45	190.86	196.92	198400.0
2021-07-27	ABGI-DELISTED	Stock	9.75	9.78	9.66	9.67	8420.0
2021-07-27	ABM	Stock	45.68	46.14	45.41	45.74	293600.0
2021-07-27	ABMD-DELISTED	Stock	326.02	326.02	316.75	321.95	78122.0
2021-07-27	ABNB	Stock	141.255	142.52	138.31	141.58	5113100.0
2021-07-27	ABOS	Stock	16.93	17.52	14.41	14.5	314400.0
2021-07-27	ABR	Stock	17.85	17.96	17.63	17.94	836000.0

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

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