PREVIEW / stock_daily / 2020-10-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-12.parquet
  size:    228 KB
  rows:    6,935
  symbols: 2,467

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
2020-10-12	AAPL	Stock	120.06	125.18	119.28	124.4	240226800.0
2020-10-12	MSFT	Stock	218.79	223.86	216.81	221.4	40461400.0
2020-10-12	NVDA	Stock	13.9895	14.347	13.9125	14.226	434744000.0
2020-10-12	AMZN	Stock	167.497	174.812	166.9775	172.1465	167284000.0
2020-10-12	GOOGL	Stock	76.9	79.421	76.465	78.2295	55343280.0
2020-10-12	META	Stock	270.2	280.18	267.87	275.75	31019300.0
2020-10-12	TSLA	Stock	147.3333	149.58	146.1933	147.4333	116373300.0
2020-10-12	TLT	Stock	160.43	160.68	160.11	160.6	3962045.0
2020-10-12	ES	Stock	92.17	93.8	92.17	93.06	906300.0
2020-10-12	CL	Stock	79.69	80.96	79.62	80.63	2691100.0
2020-10-12	A	Stock	106.45	107.0	105.32	105.43	1003700.0
2020-10-12	AA	Stock	12.59	12.65	12.349	12.59	5099500.0
2020-10-12	AACG	Stock	1.07	1.43	1.06	1.19	994400.0
2020-10-12	AACQ-DELISTED	Stock	9.8	9.9899	9.79	9.8	175820.0
2020-10-12	AACQU-DELISTED	Stock	10.19	10.29	10.16	10.24	4002.0
2020-10-12	AACQW-DELISTED	Stock	1.4	1.44	1.34	1.35	107807.0
2020-10-12	AAIC-DELISTED	Stock	2.81	2.9	2.81	2.86	156069.0
2020-10-12	AAIC.C-DELISTED	Stock	18.931	18.931	18.75	18.75	3197.0
2020-10-12	AAL	Stock	13.14	13.17	12.9	12.92	39852500.0
2020-10-12	AAM.A-DELISTED	Stock	26.4	26.4216	26.35	26.4	6598.0
2020-10-12	AAM.B-DELISTED	Stock	27.44	27.46	27.34	27.35	8204.0
2020-10-12	AAMC-DELISTED	Stock	5.8824	6.4118	5.8824	6.1265	9925.0
2020-10-12	AAME	Stock	2.05	2.05	1.97	2.0	5300.0
2020-10-12	AAMI	Stock	15.1	15.28	14.88	15.26	560100.0
2020-10-12	AAOI	Stock	11.79	11.84	11.36	11.4	360100.0
2020-10-12	AAON	Stock	42.38	43.7933	42.3667	43.5267	218700.0
2020-10-12	AAP	Stock	155.51	156.39	153.63	156.25	720400.0
2020-10-12	AAT	Stock	25.95	26.41	25.72	26.16	156600.0
2020-10-12	AAU-DELISTED	Stock	0.8873	0.899	0.79	0.829	319339.0
2020-10-12	AAUAF-DELISTED	Stock	0.8873	0.899	0.79	0.8299	343174.0
2020-10-12	AAWW-DELISTED	Stock	68.23	69.08	66.9	67.27	186647.0
2020-10-12	AAXJ	Stock	80.57	81.06	80.43	80.93	521484.0
2020-10-12	AAXN-DELISTED	Stock	99.72	100.12	98.13	99.19	397089.0
2020-10-12	AB	Stock	32.98	33.5	31.07	31.95	1658000.0
2020-10-12	ABB-DELISTED	Stock	26.9	27.04	26.865	27.015	867461.0
2020-10-12	ABBNY-DELISTED	Stock	26.9	27.04	26.865	27.02	921720.0
2020-10-12	ABBV	Stock	88.17	88.6	87.32	88.32	7314900.0
2020-10-12	ABC-DELISTED	Stock	97.38	97.6	96.45	96.84	649480.0
2020-10-12	ABCB	Stock	25.88	26.45	25.7	26.42	164700.0
2020-10-12	ABEO	Stock	35.0	36.0	32.0	32.5	97972.0
2020-10-12	ABEV	Stock	2.48	2.53	2.45	2.52	9881600.0
2020-10-12	ABG	Stock	114.84	115.35	112.51	113.52	101700.0
2020-10-12	ABM	Stock	36.91	37.31	36.78	37.15	313600.0
2020-10-12	ABMD-DELISTED	Stock	274.8	279.38	272.65	277.85	161662.0
2020-10-12	ABR	Stock	11.8	11.95	11.73	11.87	1152700.0
2020-10-12	ABR.A-DELISTED	Stock	25.32	25.356	25.23	25.27	10722.0
2020-10-12	ABR.B-DELISTED	Stock	25.1595	25.1595	25.1	25.1	2588.0
2020-10-12	ABR.C-DELISTED	Stock	25.71	25.8149	25.3663	25.63	3897.0
2020-10-12	ABT	Stock	110.25	111.57	109.76	111.05	4201800.0
2020-10-12	ABTC	Stock	135900.0	141000.0	126000.0	140100.0	14.4

> showing 50 of 6,935 rows — these rows as CSV

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