PREVIEW / stock_daily / 2020-03-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-10.parquet
  size:    220 KB
  rows:    6,625
  symbols: 2,382

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-03-10	AAPL	Stock	69.285	71.61	67.3425	71.335	285290000.0
2020-03-10	MSFT	Stock	158.16	161.03	152.58	160.92	65354400.0
2020-03-10	NVDA	Stock	6.4135	6.527	6.1498	6.527	580648000.0
2020-03-10	AMZN	Stock	93.544	94.7135	90.9085	94.591	142666000.0
2020-03-10	GOOGL	Stock	62.7195	63.7925	60.7255	63.7585	54871320.0
2020-03-10	META	Stock	174.67	178.29	169.5	178.19	24517800.0
2020-03-10	TSLA	Stock	43.962	44.5333	40.5333	43.022	233916000.0
2020-03-10	TLT	Stock	169.635	172.93	162.03	162.51	37728253.0
2020-03-10	ES	Stock	93.34	94.34	87.45	91.14	3524400.0
2020-03-10	CL	Stock	71.62	72.01	68.09	71.81	7521500.0
2020-03-10	A	Stock	73.05	73.62	69.66	72.91	3537300.0
2020-03-10	AA	Stock	9.33	9.42	8.55	9.26	10358300.0
2020-03-10	AACG	Stock	0.98	1.02	0.96	0.98	9100.0
2020-03-10	AAIC-DELISTED	Stock	5.21	5.2216	4.85	4.94	349124.0
2020-03-10	AAIC.C-DELISTED	Stock	20.84	21.0	20.65	20.672	4670.0
2020-03-10	AAL	Stock	15.82	17.67	14.61	17.0	56972700.0
2020-03-10	AAM.A-DELISTED	Stock	25.52	25.7386	25.12	25.68	29871.0
2020-03-10	AAM.B-DELISTED	Stock	25.83	25.89	25.46	25.85	9694.0
2020-03-10	AAMC-DELISTED	Stock	6.4853	6.4853	5.8412	5.8649	4604.0
2020-03-10	AAME	Stock	2.6	2.6	2.34	2.6	1400.0
2020-03-10	AAMI	Stock	6.63	6.74	5.995	6.72	1136300.0
2020-03-10	AAOI	Stock	8.09	8.216	7.72	8.12	828800.0
2020-03-10	AAON	Stock	35.66	35.66	34.2267	34.64	580650.0
2020-03-10	AAP	Stock	133.74	137.35	129.94	135.2	1322500.0
2020-03-10	AAT	Stock	37.99	38.77	36.59	38.77	548400.0
2020-03-10	AAU-DELISTED	Stock	0.3346	0.34	0.29	0.2986	470872.0
2020-03-10	AAUAF-DELISTED	Stock	0.3346	0.34	0.29	0.2995	491132.0
2020-03-10	AAWW-DELISTED	Stock	21.33	21.79	20.0	21.27	634640.0
2020-03-10	AAXJ	Stock	66.87	67.375	65.78	67.29	5463479.0
2020-03-10	AAXN-DELISTED	Stock	69.02	69.02	63.6	67.09	558689.0
2020-03-10	AB	Stock	29.01	29.65	27.92	29.57	848500.0
2020-03-10	ABB-DELISTED	Stock	19.96	20.0	19.16	19.96	3424348.0
2020-03-10	ABBNY-DELISTED	Stock	19.96	20.0	19.16	19.96	3627656.0
2020-03-10	ABBV	Stock	88.19	88.22	83.76	87.53	12965800.0
2020-03-10	ABC-DELISTED	Stock	85.35	86.27	80.89	86.1	1688026.0
2020-03-10	ABCB	Stock	28.26	28.63	26.33	28.1	636400.0
2020-03-10	ABEO	Stock	61.75	65.25	57.5	59.0	53768.0
2020-03-10	ABEV	Stock	3.09	3.15	2.95	3.12	60029400.0
2020-03-10	ABG	Stock	83.12	83.12	75.18	81.35	277800.0
2020-03-10	ABM	Stock	32.5	32.5	30.55	31.92	365600.0
2020-03-10	ABMD-DELISTED	Stock	160.05	165.5	155.38	164.72	618130.0
2020-03-10	ABR	Stock	11.06	11.25	10.5	10.92	1877100.0
2020-03-10	ABR.A-DELISTED	Stock	25.2134	25.2134	24.8144	24.95	11773.0
2020-03-10	ABR.B-DELISTED	Stock	25.0	25.0	24.2545	24.34	2515.0
2020-03-10	ABR.C-DELISTED	Stock	25.35	25.8169	25.35	25.62	2902.0
2020-03-10	ABT	Stock	79.23	81.0	75.93	80.88	9417400.0
2020-03-10	ABTC	Stock	150000.0	159300.0	142500.0	147000.0	3.76
2020-03-10	ABTS	Stock	10.95	23.85	10.95	18.45	28267.0
2020-03-10	ABTX-DELISTED	Stock	27.48	28.47	26.19	28.31	122642.0
2020-03-10	ABUS	Stock	2.84	2.97	2.76	2.78	323000.0

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

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