PREVIEW / stock_daily / 2020-01-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-16.parquet
  size:    222 KB
  rows:    6,588
  symbols: 2,409

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-01-16	AAPL	Stock	78.3975	78.925	78.0225	78.81	108829200.0
2020-01-16	MSFT	Stock	164.35	166.24	164.03	166.17	23865400.0
2020-01-16	NVDA	Stock	6.193	6.2293	6.1695	6.2232	284192000.0
2020-01-16	AMZN	Stock	94.1495	94.2795	93.301	93.897	53190000.0
2020-01-16	GOOGL	Stock	72.2725	72.535	72.0	72.508	26080800.0
2020-01-16	META	Stock	222.57	222.63	220.39	221.77	10015300.0
2020-01-16	TSLA	Stock	32.9167	34.2973	32.8113	34.2327	326050500.0
2020-01-16	TLT	Stock	139.26	139.53	138.74	139.21	6798593.0
2020-01-16	ES	Stock	87.19	87.81	87.19	87.76	1908700.0
2020-01-16	CL	Stock	70.96	71.18	70.67	70.75	2720300.0
2020-01-16	A	Stock	89.12	89.49	88.86	89.46	1595900.0
2020-01-16	AA	Stock	19.42	19.61	17.73	17.78	21993400.0
2020-01-16	AACG	Stock	1.69	1.72	1.63	1.63	17100.0
2020-01-16	AAIC-DELISTED	Stock	5.78	5.8	5.7	5.74	348814.0
2020-01-16	AAIC.C-DELISTED	Stock	22.0	22.0499	21.8617	22.0	15268.0
2020-01-16	AAL	Stock	27.79	28.26	27.76	28.23	6442800.0
2020-01-16	AAM.A-DELISTED	Stock	26.7276	26.92	26.7276	26.8962	19584.0
2020-01-16	AAM.B-DELISTED	Stock	27.35	27.4396	27.32	27.35	19335.0
2020-01-16	AAMC-DELISTED	Stock	3.8382	3.9559	3.8147	3.9559	11924.0
2020-01-16	AAME	Stock	1.93	1.93	1.9	1.9	500.0
2020-01-16	AAMI	Stock	10.16	10.25	10.12	10.22	323400.0
2020-01-16	AAOI	Stock	15.91	15.98	14.03	14.345	2333200.0
2020-01-16	AAON	Stock	35.1733	35.4867	34.9667	35.1333	177150.0
2020-01-16	AAP	Stock	150.74	152.0	150.1	151.94	677000.0
2020-01-16	AAT	Stock	46.32	46.58	46.29	46.4	190200.0
2020-01-16	AAU-DELISTED	Stock	0.515	0.52	0.5004	0.515	172798.0
2020-01-16	AAUAF-DELISTED	Stock	0.515	0.52	0.5004	0.515	176954.0
2020-01-16	AAWW-DELISTED	Stock	27.86	28.7	27.7525	27.88	313275.0
2020-01-16	AAXJ	Stock	75.88	75.98	75.72	75.85	296992.0
2020-01-16	AAXN-DELISTED	Stock	73.12	75.31	73.12	75.22	386446.0
2020-01-16	AB	Stock	32.8	33.07	32.67	33.06	274500.0
2020-01-16	ABB-DELISTED	Stock	23.84	23.99	23.72	23.98	1455980.0
2020-01-16	ABBNY-DELISTED	Stock	23.84	23.99	23.72	23.98	1528439.0
2020-01-16	ABBV	Stock	89.31	89.8	88.92	89.26	7073200.0
2020-01-16	ABC-DELISTED	Stock	91.9	91.9	90.54	91.47	952053.0
2020-01-16	ABCB	Stock	42.6	43.33	42.6	43.1	205600.0
2020-01-16	ABDC-DELISTED	Stock	9.308	9.33	9.25	9.26	15913.0
2020-01-16	ABEO	Stock	66.75	69.25	63.5	63.5	36012.0
2020-01-16	ABEV	Stock	4.5	4.51	4.43	4.44	16671000.0
2020-01-16	ABG	Stock	101.73	103.01	101.73	102.5	179600.0
2020-01-16	ABM	Stock	39.52	40.5	39.51	40.41	341900.0
2020-01-16	ABMD-DELISTED	Stock	178.8	184.16	178.3	181.43	654694.0
2020-01-16	ABR	Stock	14.48	14.52	14.45	14.52	1069200.0
2020-01-16	ABR.A-DELISTED	Stock	26.34	26.4	26.34	26.4	1224.0
2020-01-16	ABR.B-DELISTED	Stock	26.21	26.24	26.21	26.2255	2583.0
2020-01-16	ABT	Stock	87.94	88.31	87.42	88.28	5023300.0
2020-01-16	ABTC	Stock	277500.0	289260.0	255600.0	258300.0	8.266666666666666
2020-01-16	ABTS	Stock	30.3	30.39	30.3	30.39	73.3
2020-01-16	ABTX-DELISTED	Stock	37.04	37.72	36.96	37.6	65553.0
2020-01-16	ABUS	Stock	3.06	3.09	2.95	3.05	222100.0

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

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