PREVIEW / stock_daily / 2020-02-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-13.parquet
  size:    222 KB
  rows:    6,572
  symbols: 2,370

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-02-13	AAPL	Stock	81.0475	81.555	80.8375	81.2175	94747600.0
2020-02-13	MSFT	Stock	183.08	186.23	182.87	183.71	35295800.0
2020-02-13	NVDA	Stock	6.7552	6.837	6.7278	6.7695	528016000.0
2020-02-13	AMZN	Stock	107.2495	108.514	107.1	107.4935	60636000.0
2020-02-13	GOOGL	Stock	75.5	76.2973	75.2	75.6695	22913160.0
2020-02-13	META	Stock	209.52	214.33	209.18	213.14	15396600.0
2020-02-13	TSLA	Stock	49.456	54.5333	49.0	53.6	394339500.0
2020-02-13	TLT	Stock	143.44	144.2	143.27	143.92	7883440.0
2020-02-13	ES	Stock	91.36	92.55	91.0	92.48	1426400.0
2020-02-13	CL	Stock	75.72	76.61	75.63	76.37	2907800.0
2020-02-13	A	Stock	85.1	85.68	84.66	85.47	1596300.0
2020-02-13	AA	Stock	15.56	15.775	15.45	15.75	2810300.0
2020-02-13	AACG	Stock	1.04	1.11	1.04	1.1	7600.0
2020-02-13	AAIC-DELISTED	Stock	5.83	5.9	5.83	5.9	196548.0
2020-02-13	AAIC.C-DELISTED	Stock	22.465	22.545	22.465	22.545	2136.0
2020-02-13	AAL	Stock	30.03	30.4	29.73	30.09	9119400.0
2020-02-13	AAM.A-DELISTED	Stock	26.94	27.0721	26.94	26.96	8206.0
2020-02-13	AAM.B-DELISTED	Stock	27.61	27.8367	27.61	27.71	9458.0
2020-02-13	AAMC-DELISTED	Stock	3.8461	3.8471	3.8461	3.8471	1669.0
2020-02-13	AAME	Stock	2.01	2.29	2.01	2.29	6500.0
2020-02-13	AAMI	Stock	10.18	10.43	10.02	10.3	270900.0
2020-02-13	AAOI	Stock	12.2	12.89	12.06	12.75	1002300.0
2020-02-13	AAON	Stock	36.8467	37.6867	36.8333	37.5733	123000.0
2020-02-13	AAP	Stock	133.78	136.17	133.17	134.67	949700.0
2020-02-13	AAT	Stock	46.1	46.71	45.82	46.0	333000.0
2020-02-13	AAU-DELISTED	Stock	0.45	0.45	0.436	0.4405	299379.0
2020-02-13	AAUAF-DELISTED	Stock	0.45	0.45	0.436	0.4413	321207.0
2020-02-13	AAWW-DELISTED	Stock	27.22	27.6	26.22	26.4	301820.0
2020-02-13	AAXJ	Stock	73.18	73.46	72.97	73.08	1576071.0
2020-02-13	AAXN-DELISTED	Stock	87.53	89.16	87.23	87.74	441159.0
2020-02-13	AB	Stock	35.25	35.25	34.45	34.55	460900.0
2020-02-13	ABB-DELISTED	Stock	24.51	24.54	24.305	24.32	1576325.0
2020-02-13	ABBNY-DELISTED	Stock	24.51	24.54	24.305	24.32	1652334.0
2020-02-13	ABBV	Stock	96.85	97.36	95.23	95.35	10613000.0
2020-02-13	ABC-DELISTED	Stock	94.92	95.48	94.42	94.53	960796.0
2020-02-13	ABCB	Stock	41.0	41.47	40.84	41.44	164600.0
2020-02-13	ABEO	Stock	79.25	79.25	74.0	77.25	44028.0
2020-02-13	ABEV	Stock	3.78	3.81	3.71	3.71	15930500.0
2020-02-13	ABG	Stock	96.26	97.95	95.39	96.89	187300.0
2020-02-13	ABM	Stock	38.97	39.3	38.51	39.12	171700.0
2020-02-13	ABMD-DELISTED	Stock	167.8	167.8593	162.55	164.61	987312.0
2020-02-13	ABR	Stock	14.93	15.1	14.91	15.09	999300.0
2020-02-13	ABR.A-DELISTED	Stock	26.1467	26.2459	26.1467	26.2459	1781.0
2020-02-13	ABR.B-DELISTED	Stock	26.0319	26.0319	25.935	25.935	2145.0
2020-02-13	ABR.C-DELISTED	Stock	26.53	26.64	26.36	26.36	1848.0
2020-02-13	ABT	Stock	88.5	89.04	87.7	88.68	4448800.0
2020-02-13	ABTC	Stock	210000.0	222900.0	189000.0	211800.0	8.333333333333334
2020-02-13	ABTS	Stock	27.3	31.5	27.3	27.675	3340.0
2020-02-13	ABTX-DELISTED	Stock	37.8	38.6	37.675	38.49	95897.0
2020-02-13	ABUS	Stock	3.15	3.48	3.12	3.28	2668600.0

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

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