PREVIEW / stock_daily / 2021-08-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-06.parquet
  size:    256 KB
  rows:    7,869
  symbols: 2,775

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-08-06	AAPL	Stock	146.35	147.11	145.63	146.14	54126800.0
2021-08-06	MSFT	Stock	288.51	289.5	287.62	289.46	16589300.0
2021-08-06	NVDA	Stock	20.524	20.57	20.21	20.366	178497000.0
2021-08-06	AMZN	Stock	168.75	168.75	166.452	167.247	52752000.0
2021-08-06	GOOGL	Stock	136.042	136.4725	135.21	135.7385	20488120.0
2021-08-06	META	Stock	361.4	365.15	361.4	363.51	8925000.0
2021-08-06	TSLA	Stock	237.3	238.7767	232.5433	233.0333	46869000.0
2021-08-06	TLT	Stock	148.322	148.76	147.6909	147.78	21144286.0
2021-08-06	ES	Stock	88.97	89.86	88.52	88.96	1072200.0
2021-08-06	CL	Stock	78.97	79.25	78.3	78.63	2877400.0
2021-08-06	A	Stock	154.76	155.89	154.47	155.7	1209300.0
2021-08-06	AA	Stock	39.62	40.95	39.23	40.71	6146700.0
2021-08-06	AAC-DELISTED	Stock	9.7	9.78	9.68	9.77	94010.0
2021-08-06	AACG	Stock	2.89	2.9	2.83	2.86	31300.0
2021-08-06	AAIC-DELISTED	Stock	3.85	3.89	3.8	3.87	169750.0
2021-08-06	AAIC.C-DELISTED	Stock	25.12	25.14	25.0	25.0	1800.0
2021-08-06	AAL	Stock	21.13	21.22	20.52	21.02	28281000.0
2021-08-06	AAM.A-DELISTED	Stock	26.4214	26.45	26.39	26.45	13823.0
2021-08-06	AAM.B-DELISTED	Stock	27.25	27.33	27.24	27.29	13153.0
2021-08-06	AAMC-DELISTED	Stock	4.2941	4.6054	4.1176	4.6	31685.0
2021-08-06	AAME	Stock	4.23	4.58	4.23	4.53	28500.0
2021-08-06	AAMI	Stock	26.18	26.54	26.135	26.4	424300.0
2021-08-06	AAN-DELISTED	Stock	28.18	28.48	27.6	27.65	135700.0
2021-08-06	AAOI	Stock	7.27	7.27	6.85	7.15	1627300.0
2021-08-06	AAON	Stock	43.3333	45.3467	43.32	44.8333	322200.0
2021-08-06	AAP	Stock	207.4	207.94	204.99	205.72	521400.0
2021-08-06	AAQC-DELISTED	Stock	9.64	9.66	9.64	9.66	9455.0
2021-08-06	AAT	Stock	37.81	38.14	37.54	37.93	218500.0
2021-08-06	AATC	Stock	6.88	6.9799	6.73	6.79	38428.0
2021-08-06	AAU-DELISTED	Stock	0.4238	0.4415	0.4209	0.4264	262157.0
2021-08-06	AAUAF-DELISTED	Stock	0.4238	0.4415	0.4209	0.4264	267484.0
2021-08-06	AAWW-DELISTED	Stock	71.52	74.18	71.065	72.86	292180.0
2021-08-06	AAXJ	Stock	88.73	88.73	87.95	88.17	1312354.0
2021-08-06	AB	Stock	50.02	50.26	49.65	49.98	200400.0
2021-08-06	ABB-DELISTED	Stock	37.16	37.24	36.9	36.98	1040038.0
2021-08-06	ABBNY-DELISTED	Stock	37.16	37.24	36.9	36.98	1126254.0
2021-08-06	ABBV	Stock	115.26	115.55	114.43	114.45	5340400.0
2021-08-06	ABC-DELISTED	Stock	121.95	122.045	119.63	120.63	843275.0
2021-08-06	ABCB	Stock	50.06	50.58	49.56	50.16	405500.0
2021-08-06	ABCL	Stock	15.85	15.85	14.775	14.97	1636600.0
2021-08-06	ABCM-DELISTED	Stock	20.1	20.65	19.99	20.33	137103.0
2021-08-06	ABEO	Stock	32.5	32.75	30.75	32.25	25280.0
2021-08-06	ABEV	Stock	3.18	3.24	3.15	3.22	19417800.0
2021-08-06	ABG	Stock	200.02	201.22	193.0	194.96	175700.0
2021-08-06	ABGI-DELISTED	Stock	9.77	9.78	9.75	9.75	1700.0
2021-08-06	ABM	Stock	47.09	47.49	46.82	47.0	214300.0
2021-08-06	ABMD-DELISTED	Stock	347.0	350.0	341.6701	346.2	152549.0
2021-08-06	ABNB	Stock	148.99	150.19	147.55	149.99	4043500.0
2021-08-06	ABOS	Stock	14.89	15.183	14.8	15.01	76900.0
2021-08-06	ABR	Stock	18.47	18.53	18.23	18.36	979900.0

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

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