PREVIEW / stock_daily / 2021-08-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-18.parquet
  size:    256 KB
  rows:    7,871
  symbols: 2,758

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-18	AAPL	Stock	149.8	150.72	146.15	146.36	86326000.0
2021-08-18	MSFT	Stock	292.04	294.82	290.27	290.73	21813000.0
2021-08-18	NVDA	Stock	19.5	19.634	19.0	19.04	285913000.0
2021-08-18	AMZN	Stock	162.0995	162.705	160.0	160.061	56086000.0
2021-08-18	GOOGL	Stock	136.5	137.1042	135.3215	135.449	19258940.0
2021-08-18	META	Stock	356.25	359.86	355.15	355.45	10042400.0
2021-08-18	TSLA	Stock	223.25	231.9233	223.1167	229.6633	61048200.0
2021-08-18	TLT	Stock	148.71	149.47	148.45	149.35	13143979.0
2021-08-18	ES	Stock	90.99	91.06	89.7	90.22	1151400.0
2021-08-18	CL	Stock	79.84	79.89	78.12	78.16	3654100.0
2021-08-18	A	Stock	163.2	165.36	162.09	163.02	2860900.0
2021-08-18	AA	Stock	41.03	42.35	40.8	41.49	6107400.0
2021-08-18	AAC-DELISTED	Stock	9.72	9.72	9.7	9.71	25887.0
2021-08-18	AACG	Stock	2.6	2.69	2.51	2.52	57400.0
2021-08-18	AACIU	Stock	9.81	9.84	9.79	9.82	99405.0
2021-08-18	AAIC-DELISTED	Stock	3.77	3.79	3.75	3.75	46479.0
2021-08-18	AAIC.C-DELISTED	Stock	25.11	25.11	25.09	25.09	3695.0
2021-08-18	AAL	Stock	19.34	19.66	19.04	19.14	24479500.0
2021-08-18	AAM.A-DELISTED	Stock	26.27	26.3	26.26	26.3	4141.0
2021-08-18	AAM.B-DELISTED	Stock	27.01	27.02	26.94	27.0	19200.0
2021-08-18	AAMC-DELISTED	Stock	4.1471	4.1768	3.8324	3.8324	119908.0
2021-08-18	AAME	Stock	3.58	3.72	3.55	3.65	42800.0
2021-08-18	AAMI	Stock	26.5	26.72	26.14	26.15	355300.0
2021-08-18	AAN-DELISTED	Stock	27.57	29.02	27.57	28.23	247300.0
2021-08-18	AAOI	Stock	6.54	6.82	6.445	6.69	504400.0
2021-08-18	AAON	Stock	45.38	45.68	44.6933	44.6933	80100.0
2021-08-18	AAP	Stock	207.68	209.97	207.08	207.62	409300.0
2021-08-18	AAQC-DELISTED	Stock	9.63	9.64	9.63	9.64	2790.0
2021-08-18	AAT	Stock	37.53	37.89	37.32	37.63	144500.0
2021-08-18	AATC	Stock	6.81	7.039	6.81	6.85	14728.0
2021-08-18	AAU-DELISTED	Stock	0.3988	0.4	0.395	0.3958	261149.0
2021-08-18	AAUAF-DELISTED	Stock	0.3988	0.4	0.395	0.3958	269451.0
2021-08-18	AAWW-DELISTED	Stock	77.49	77.95	74.82	75.35	397740.0
2021-08-18	AAXJ	Stock	85.77	86.2	85.39	85.44	1894748.0
2021-08-18	AB	Stock	48.77	50.24	48.7	49.88	228100.0
2021-08-18	ABB-DELISTED	Stock	37.71	37.945	37.51	37.53	903770.0
2021-08-18	ABBNY-DELISTED	Stock	37.71	37.945	37.51	37.52	988271.0
2021-08-18	ABBV	Stock	119.17	119.92	117.18	117.29	5586900.0
2021-08-18	ABC-DELISTED	Stock	120.93	121.07	118.55	118.56	414612.0
2021-08-18	ABCB	Stock	48.98	49.7	48.53	48.6	287000.0
2021-08-18	ABCL	Stock	16.98	17.26	16.36	16.75	2366100.0
2021-08-18	ABCM-DELISTED	Stock	20.7	20.75	20.49	20.61	95778.0
2021-08-18	ABEO	Stock	28.75	31.25	28.5	30.75	19988.0
2021-08-18	ABEV	Stock	3.04	3.11	3.01	3.02	25630000.0
2021-08-18	ABG	Stock	191.33	194.81	189.45	189.89	108000.0
2021-08-18	ABGI-DELISTED	Stock	9.64	9.7	9.61	9.62	1371.0
2021-08-18	ABM	Stock	47.45	48.01	46.83	46.85	273600.0
2021-08-18	ABMD-DELISTED	Stock	328.75	336.39	328.75	331.01	163693.0
2021-08-18	ABNB	Stock	144.02	148.68	141.7	146.74	5190100.0
2021-08-18	ABOS	Stock	15.34	16.32	15.26	16.04	201400.0

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

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