PREVIEW / stock_daily / 2021-05-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-05.parquet
  size:    257 KB
  rows:    7,831
  symbols: 2,959

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-05-05	AAPL	Stock	129.2	130.45	127.97	128.1	84000900.0
2021-05-05	MSFT	Stock	249.06	249.5	245.82	246.47	21901300.0
2021-05-05	NVDA	Stock	14.709	14.8135	14.3875	14.4585	292024000.0
2021-05-05	AMZN	Stock	166.943	167.735	163.218	163.527	74226000.0
2021-05-05	GOOGL	Stock	116.4315	116.75	115.414	115.7385	26636180.0
2021-05-05	META	Stock	318.19	321.06	314.49	315.02	15577600.0
2021-05-05	TSLA	Stock	227.02	228.4333	222.4467	223.6467	65705700.0
2021-05-05	TLT	Stock	139.03	139.85	138.92	139.69	11128146.0
2021-05-05	ES	Stock	85.86	85.93	83.28	83.59	1242000.0
2021-05-05	CL	Stock	80.95	81.55	80.53	81.32	3093300.0
2021-05-05	A	Stock	132.09	134.09	131.25	133.37	1430600.0
2021-05-05	AA	Stock	39.37	40.88	38.64	40.6	7658800.0
2021-05-05	AAC-DELISTED	Stock	9.83	9.85	9.82	9.83	60296.0
2021-05-05	AACG	Stock	2.83	3.07	2.83	3.03	72900.0
2021-05-05	AACQ-DELISTED	Stock	10.12	10.13	10.05	10.05	1324288.0
2021-05-05	AACQU-DELISTED	Stock	10.72	10.8	10.72	10.72	5633.0
2021-05-05	AACQW-DELISTED	Stock	1.9	2.0	1.89	1.92	153333.0
2021-05-05	AAIC-DELISTED	Stock	4.1	4.14	4.02	4.13	257737.0
2021-05-05	AAIC.C-DELISTED	Stock	24.4256	24.4256	24.4	24.4	975.0
2021-05-05	AAL	Stock	21.35	21.87	21.19	21.57	27984800.0
2021-05-05	AAM.A-DELISTED	Stock	26.14	26.23	26.1	26.1	12698.0
2021-05-05	AAM.B-DELISTED	Stock	27.23	27.23	27.08	27.09	5660.0
2021-05-05	AAMC-DELISTED	Stock	5.0676	5.1938	5.0588	5.0992	37992.0
2021-05-05	AAME	Stock	4.1	4.32	4.05	4.08	122300.0
2021-05-05	AAMI	Stock	22.74	22.875	22.44	22.62	573600.0
2021-05-05	AAN-DELISTED	Stock	30.91	31.59	30.58	30.98	330300.0
2021-05-05	AAOI	Stock	7.36	7.4	7.0	7.05	640500.0
2021-05-05	AAON	Stock	42.8467	43.7733	41.86	42.48	161700.0
2021-05-05	AAP	Stock	204.11	204.82	200.65	202.81	832400.0
2021-05-05	AAT	Stock	34.79	35.07	33.63	33.76	262400.0
2021-05-05	AAU-DELISTED	Stock	0.5512	0.5627	0.5466	0.556	515326.0
2021-05-05	AAUAF-DELISTED	Stock	0.5512	0.5627	0.5466	0.5617	538911.0
2021-05-05	AAWW-DELISTED	Stock	70.17	71.895	67.23	71.52	641179.0
2021-05-05	AAXJ	Stock	92.83	92.97	92.42	92.61	1509003.0
2021-05-05	AB	Stock	44.79	45.45	44.48	45.15	553300.0
2021-05-05	ABB-DELISTED	Stock	33.46	33.6879	33.2789	33.51	1818209.0
2021-05-05	ABBNY-DELISTED	Stock	33.46	33.6879	33.2789	33.51	2613023.0
2021-05-05	ABBV	Stock	114.31	116.28	113.95	115.78	7021400.0
2021-05-05	ABC-DELISTED	Stock	120.61	121.55	115.91	118.84	3251747.0
2021-05-05	ABCB	Stock	56.76	56.76	55.08	56.23	294800.0
2021-05-05	ABCL	Stock	28.72	30.35	28.53	29.42	1360600.0
2021-05-05	ABCM-DELISTED	Stock	20.82	21.34	20.8	21.04	74598.0
2021-05-05	ABEO	Stock	43.75	44.25	41.0	41.25	71788.0
2021-05-05	ABEV	Stock	2.75	2.81	2.73	2.79	14896300.0
2021-05-05	ABG	Stock	207.61	208.45	202.09	205.59	89800.0
2021-05-05	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	200.0
2021-05-05	ABM	Stock	53.07	53.07	51.89	52.43	384300.0
2021-05-05	ABMD-DELISTED	Stock	305.49	306.52	299.76	300.82	118460.0
2021-05-05	ABNB	Stock	169.3	170.18	162.12	162.33	3590100.0
2021-05-05	ABR	Stock	17.7	17.86	17.47	17.84	1122100.0

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

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