PREVIEW / stock_daily / 2020-02-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-10.parquet
  size:    222 KB
  rows:    6,592
  symbols: 2,389

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-10	AAPL	Stock	78.545	80.3875	78.4625	80.3875	109348800.0
2020-02-10	MSFT	Stock	183.58	188.84	183.25	188.7	35844300.0
2020-02-10	NVDA	Stock	6.3125	6.575	6.3075	6.5743	529608000.0
2020-02-10	AMZN	Stock	104.2505	106.78	104.248	106.6955	101124000.0
2020-02-10	GOOGL	Stock	73.8615	75.444	73.76	75.433	38301440.0
2020-02-10	META	Stock	211.52	213.8	210.66	213.06	11856400.0
2020-02-10	TSLA	Stock	53.3333	54.666	50.16	51.4187	370338000.0
2020-02-10	TLT	Stock	145.1	145.25	144.68	144.83	6699265.0
2020-02-10	ES	Stock	90.7	91.37	90.6	91.37	1246200.0
2020-02-10	CL	Stock	75.96	77.41	75.96	77.35	4418400.0
2020-02-10	A	Stock	83.04	84.64	82.93	84.43	2066900.0
2020-02-10	AA	Stock	15.31	15.59	15.15	15.42	4009100.0
2020-02-10	AACG	Stock	1.04	1.12	1.04	1.1	19400.0
2020-02-10	AAIC-DELISTED	Stock	5.75	5.76	5.7	5.72	271246.0
2020-02-10	AAIC.C-DELISTED	Stock	22.6684	22.6684	22.528	22.6	13400.0
2020-02-10	AAL	Stock	28.19	28.81	27.98	28.79	15134300.0
2020-02-10	AAM.A-DELISTED	Stock	27.02	27.08	26.99	27.0432	14202.0
2020-02-10	AAM.B-DELISTED	Stock	27.89	27.93	27.75	27.86	18431.0
2020-02-10	AAMC-DELISTED	Stock	3.8235	3.8235	3.8235	3.8235	1234.0
2020-02-10	AAME	Stock	2.05	2.05	2.05	2.05	5800.0
2020-02-10	AAMI	Stock	9.85	10.15	9.85	10.08	392600.0
2020-02-10	AAOI	Stock	11.21	11.52	11.01	11.3	566600.0
2020-02-10	AAON	Stock	36.0133	36.6333	35.84	36.58	196500.0
2020-02-10	AAP	Stock	132.17	132.29	129.94	130.68	780800.0
2020-02-10	AAT	Stock	46.2	46.43	46.05	46.15	552700.0
2020-02-10	AAU-DELISTED	Stock	0.44	0.4599	0.4	0.4275	719518.0
2020-02-10	AAUAF-DELISTED	Stock	0.44	0.4599	0.4	0.4275	731883.0
2020-02-10	AAWW-DELISTED	Stock	27.3	27.4754	26.63	26.93	399436.0
2020-02-10	AAXJ	Stock	71.62	72.17	71.62	72.17	2484135.0
2020-02-10	AAXN-DELISTED	Stock	82.88	85.73	82.78	85.43	484678.0
2020-02-10	AB	Stock	34.26	34.86	34.18	34.73	187200.0
2020-02-10	ABB-DELISTED	Stock	24.23	24.41	24.19	24.39	1576107.0
2020-02-10	ABBNY-DELISTED	Stock	24.23	24.41	24.19	24.4	1674885.0
2020-02-10	ABBV	Stock	92.36	95.5	92.11	94.75	13998300.0
2020-02-10	ABC-DELISTED	Stock	91.7	94.18	91.355	93.58	1049946.0
2020-02-10	ABCB	Stock	41.08	41.5	40.92	41.43	173000.0
2020-02-10	ABEO	Stock	65.0	73.5	65.0	73.25	123792.0
2020-02-10	ABEV	Stock	3.89	3.9	3.8	3.81	30190500.0
2020-02-10	ABG	Stock	93.5	94.86	92.71	94.86	194100.0
2020-02-10	ABM	Stock	38.31	38.57	38.03	38.54	241600.0
2020-02-10	ABMD-DELISTED	Stock	187.19	187.74	172.5	174.14	1062632.0
2020-02-10	ABR	Stock	15.25	15.27	15.0	15.0	795100.0
2020-02-10	ABR.A-DELISTED	Stock	26.47	26.49	26.4211	26.4539	1570.0
2020-02-10	ABR.B-DELISTED	Stock	26.2561	26.26	26.2561	26.26	200.0
2020-02-10	ABR.C-DELISTED	Stock	26.755	27.2	26.56	27.15	4377.0
2020-02-10	ABT	Stock	87.21	88.3	87.21	88.3	4219400.0
2020-02-10	ABTC	Stock	234000.0	244500.0	232500.0	235500.0	2.0933333333333333
2020-02-10	ABTS	Stock	29.85	30.0	29.4	29.925	100.0
2020-02-10	ABTX-DELISTED	Stock	38.3	38.3	37.9	38.19	74889.0
2020-02-10	ABUS	Stock	2.75	3.25	2.7	3.2	1355700.0

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

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