PREVIEW / stock_daily / 2021-06-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-21.parquet
  size:    257 KB
  rows:    7,853
  symbols: 2,892

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-06-21	AAPL	Stock	130.3	132.41	129.21	132.3	79663300.0
2021-06-21	MSFT	Stock	259.82	263.52	257.92	262.63	26696100.0
2021-06-21	NVDA	Stock	18.4352	18.5365	17.8228	18.4272	672384000.0
2021-06-21	AMZN	Stock	173.821	174.1	171.7	172.698	65542000.0
2021-06-21	GOOGL	Stock	120.5005	122.0	119.8985	121.8125	27413660.0
2021-06-21	META	Stock	331.09	332.92	327.65	332.29	11337500.0
2021-06-21	TSLA	Stock	208.16	210.4633	202.96	206.9433	74438100.0
2021-06-21	TLT	Stock	144.39	144.49	143.02	143.29	16485035.0
2021-06-21	ES	Stock	79.96	80.94	79.24	80.69	1968400.0
2021-06-21	CL	Stock	81.27	81.59	81.13	81.44	4226700.0
2021-06-21	A	Stock	145.42	146.69	143.73	146.41	1266100.0
2021-06-21	AA	Stock	32.44	33.33	32.35	33.09	6758600.0
2021-06-21	AAC-DELISTED	Stock	9.79	9.79	9.76	9.77	10149.0
2021-06-21	AACG	Stock	3.07	3.09	2.91	3.02	69700.0
2021-06-21	AACQ-DELISTED	Stock	9.8	9.82	9.42	9.52	2409771.0
2021-06-21	AACQU-DELISTED	Stock	10.56	10.56	10.28	10.29	5624.0
2021-06-21	AACQW-DELISTED	Stock	2.29	2.3103	2.02	2.16	494542.0
2021-06-21	AAIC-DELISTED	Stock	4.0	4.0	3.94	3.95	289430.0
2021-06-21	AAIC.C-DELISTED	Stock	24.92	24.92	24.8467	24.86	906.0
2021-06-21	AAL	Stock	22.32	22.55	21.91	22.45	26666200.0
2021-06-21	AAM.A-DELISTED	Stock	26.41	26.41	26.229	26.26	49035.0
2021-06-21	AAM.B-DELISTED	Stock	27.07	27.2	27.07	27.2	12785.0
2021-06-21	AAMC-DELISTED	Stock	5.6029	5.7294	5.5618	5.5618	10424.0
2021-06-21	AAME	Stock	4.11	4.15	4.01	4.07	39900.0
2021-06-21	AAMI	Stock	22.83	24.25	22.76	23.88	646000.0
2021-06-21	AAN-DELISTED	Stock	35.09	35.44	34.58	34.98	233000.0
2021-06-21	AAOI	Stock	8.3	8.47	8.16	8.34	497400.0
2021-06-21	AAON	Stock	40.98	42.1267	40.98	41.7067	287250.0
2021-06-21	AAP	Stock	195.5	199.24	194.76	198.47	591600.0
2021-06-21	AAQC-DELISTED	Stock	9.8	9.8	9.72	9.72	13742.0
2021-06-21	AAT	Stock	37.47	38.09	37.0	37.88	355500.0
2021-06-21	AAU-DELISTED	Stock	0.5	0.5005	0.482	0.4923	1088007.0
2021-06-21	AAUAF-DELISTED	Stock	0.5	0.5005	0.482	0.4927	1256636.0
2021-06-21	AAWW-DELISTED	Stock	67.74	68.422	67.41	67.98	321403.0
2021-06-21	AAXJ	Stock	92.7	93.11	92.27	93.09	859267.0
2021-06-21	AB	Stock	43.19	44.6	42.82	44.26	255600.0
2021-06-21	ABB-DELISTED	Stock	33.36	33.78	33.3	33.74	1003792.0
2021-06-21	ABBNY-DELISTED	Stock	33.36	33.78	33.3	33.74	1111415.0
2021-06-21	ABBV	Stock	113.69	115.25	112.77	114.73	4666100.0
2021-06-21	ABC-DELISTED	Stock	114.7	116.74	114.38	116.64	409564.0
2021-06-21	ABCB	Stock	50.5	52.8	50.38	52.19	496900.0
2021-06-21	ABCL	Stock	23.2	23.23	21.83	22.72	2506800.0
2021-06-21	ABCM-DELISTED	Stock	18.77	19.04	18.68	19.01	112023.0
2021-06-21	ABEO	Stock	42.25	42.75	40.5	42.0	46144.0
2021-06-21	ABEV	Stock	3.7	3.75	3.67	3.72	26369800.0
2021-06-21	ABG	Stock	159.13	163.57	158.64	161.31	224500.0
2021-06-21	ABGI-DELISTED	Stock	9.85	9.95	9.85	9.905	23060.0
2021-06-21	ABM	Stock	45.15	45.98	45.15	45.57	663300.0
2021-06-21	ABMD-DELISTED	Stock	318.18	326.35	313.73	325.26	196161.0
2021-06-21	ABNB	Stock	152.52	152.61	145.83	149.7	8040200.0

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

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