PREVIEW / stock_daily / 2021-03-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-10.parquet
  size:    252 KB
  rows:    7,618
  symbols: 2,860

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-03-10	AAPL	Stock	121.69	122.17	119.45	119.98	111943300.0
2021-03-10	MSFT	Stock	237.0	237.0	232.04	232.42	29746800.0
2021-03-10	NVDA	Stock	12.8405	12.98	12.4575	12.4683	384376000.0
2021-03-10	AMZN	Stock	154.9225	155.823	151.5025	152.882	60250000.0
2021-03-10	GOOGL	Stock	103.07	103.07	100.9665	101.8095	27100080.0
2021-03-10	META	Stock	268.64	268.97	262.87	264.9	14210300.0
2021-03-10	TSLA	Stock	233.4333	239.2833	218.3533	222.6867	181817100.0
2021-03-10	TLT	Stock	139.8	140.15	139.28	140.02	12387639.0
2021-03-10	ES	Stock	81.53	82.48	81.03	81.69	1163100.0
2021-03-10	CL	Stock	75.29	76.33	74.14	75.8	7028500.0
2021-03-10	A	Stock	120.59	122.21	119.69	119.99	1934600.0
2021-03-10	AA	Stock	30.34	32.42	30.34	31.98	7927700.0
2021-03-10	AACG	Stock	4.81	5.12	4.4	4.5	911100.0
2021-03-10	AACQ-DELISTED	Stock	10.68	11.0	10.4401	10.49	2454560.0
2021-03-10	AACQU-DELISTED	Stock	11.39	11.75	11.19	11.19	5711.0
2021-03-10	AACQW-DELISTED	Stock	2.18	2.38	2.05	2.16	291103.0
2021-03-10	AAIC-DELISTED	Stock	4.28	4.41	4.28	4.3	128522.0
2021-03-10	AAIC.C-DELISTED	Stock	22.01	22.2394	22.0	22.1302	3899.0
2021-03-10	AAL	Stock	21.67	22.48	21.37	21.75	44224900.0
2021-03-10	AAM.A-DELISTED	Stock	25.88	25.88	25.82	25.88	19808.0
2021-03-10	AAM.B-DELISTED	Stock	26.55	26.6	26.5	26.58	10663.0
2021-03-10	AAMC-DELISTED	Stock	6.0412	6.2724	5.85	5.85	160086.0
2021-03-10	AAME	Stock	4.22	4.29	3.82	3.95	138200.0
2021-03-10	AAMI	Stock	19.5	20.58	19.34	20.25	517100.0
2021-03-10	AAN-DELISTED	Stock	24.21	24.36	23.21	24.04	309000.0
2021-03-10	AAOI	Stock	8.62	8.87	8.35	8.47	821900.0
2021-03-10	AAON	Stock	49.3067	50.0	48.6667	49.44	197700.0
2021-03-10	AAP	Stock	173.99	177.25	170.91	176.34	1014600.0
2021-03-10	AAT	Stock	35.3	35.34	34.57	34.84	324700.0
2021-03-10	AAU-DELISTED	Stock	0.66	0.6657	0.632	0.6548	1789927.0
2021-03-10	AAUAF-DELISTED	Stock	0.66	0.6657	0.632	0.6548	1846124.0
2021-03-10	AAWW-DELISTED	Stock	58.6	60.91	58.41	60.41	427241.0
2021-03-10	AAXJ	Stock	94.22	94.22	92.79	93.18	1386951.0
2021-03-10	AB	Stock	37.87	38.8	37.87	38.8	432800.0
2021-03-10	ABB-DELISTED	Stock	30.55	30.765	30.38	30.72	1708735.0
2021-03-10	ABBNY-DELISTED	Stock	30.55	30.765	30.38	30.72	1832354.0
2021-03-10	ABBV	Stock	107.39	108.36	107.05	108.0	5762600.0
2021-03-10	ABC-DELISTED	Stock	110.0	113.565	109.72	111.88	1519087.0
2021-03-10	ABCB	Stock	51.53	53.71	51.53	52.73	528700.0
2021-03-10	ABCL	Stock	31.03	32.89	30.21	32.22	941400.0
2021-03-10	ABCM-DELISTED	Stock	20.82	20.895	20.38	20.75	33679.0
2021-03-10	ABEO	Stock	55.0	56.75	53.25	55.0	65556.0
2021-03-10	ABEV	Stock	2.69	2.74	2.63	2.71	30944900.0
2021-03-10	ABG	Stock	177.73	189.17	176.94	186.47	197000.0
2021-03-10	ABGI-DELISTED	Stock	10.0	10.19	9.99	10.04	121426.0
2021-03-10	ABM	Stock	51.2	55.48	49.97	50.73	1410900.0
2021-03-10	ABMD-DELISTED	Stock	297.56	305.5114	295.57	296.4	156481.0
2021-03-10	ABNB	Stock	184.57	191.0	181.55	183.79	6145600.0
2021-03-10	ABR	Stock	16.24	16.55	16.18	16.32	917400.0
2021-03-10	ABR.A-DELISTED	Stock	25.73	25.73	25.6	25.64	1030.0

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

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