PREVIEW / stock_daily / 2020-03-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-30.parquet
  size:    214 KB
  rows:    6,605
  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-03-30	AAPL	Stock	62.685	63.88	62.35	63.7025	167976400.0
2020-03-30	MSFT	Stock	152.44	160.6	150.01	160.23	63420300.0
2020-03-30	NVDA	Stock	6.384	6.649	6.3398	6.6398	602252000.0
2020-03-30	AMZN	Stock	96.1415	98.6815	95.617	98.1975	122522000.0
2020-03-30	GOOGL	Stock	56.632	57.55	54.9245	57.3155	58736540.0
2020-03-30	META	Stock	159.18	166.75	158.06	165.95	22515200.0
2020-03-30	TSLA	Stock	34.0173	34.4433	32.7487	33.4753	179971500.0
2020-03-30	TLT	Stock	168.3	170.11	165.94	166.32	13473205.0
2020-03-30	ES	Stock	82.64	84.0	79.66	83.65	2672600.0
2020-03-30	CL	Stock	65.99	66.93	64.97	66.58	4950500.0
2020-03-30	A	Stock	71.06	73.18	71.06	72.67	1486200.0
2020-03-30	AA	Stock	6.55	6.6	6.0	6.07	9615600.0
2020-03-30	AACG	Stock	0.88	1.0	0.88	0.95	6500.0
2020-03-30	AAIC-DELISTED	Stock	2.63	2.65	2.16	2.2	691416.0
2020-03-30	AAIC.C-DELISTED	Stock	14.93	15.01	13.9	14.26	13810.0
2020-03-30	AAL	Stock	13.2	13.22	11.81	12.25	50516800.0
2020-03-30	AAM.A-DELISTED	Stock	23.4	23.6704	22.7	23.2	38325.0
2020-03-30	AAM.B-DELISTED	Stock	22.9	23.31	22.4	22.83	29266.0
2020-03-30	AAMC-DELISTED	Stock	3.9018	3.9018	3.4941	3.6132	8932.0
2020-03-30	AAME	Stock	2.25	2.25	2.13	2.13	400.0
2020-03-30	AAMI	Stock	6.11	6.64	5.92	6.37	616700.0
2020-03-30	AAOI	Stock	7.5	7.62	7.03	7.6	707100.0
2020-03-30	AAON	Stock	31.1933	32.4067	30.7	32.1733	391650.0
2020-03-30	AAP	Stock	94.41	97.87	89.86	96.5	1046400.0
2020-03-30	AAT	Stock	24.98	24.98	23.5	24.67	536900.0
2020-03-30	AAU-DELISTED	Stock	0.311	0.3233	0.2784	0.28	443368.0
2020-03-30	AAUAF-DELISTED	Stock	0.311	0.3233	0.2784	0.28	466152.0
2020-03-30	AAWW-DELISTED	Stock	22.59	23.28	21.42	22.19	431516.0
2020-03-30	AAXJ	Stock	58.56	59.43	58.13	59.43	1109826.0
2020-03-30	AAXN-DELISTED	Stock	74.29	76.36	69.1	69.11	827018.0
2020-03-30	AB	Stock	18.55	18.87	17.52	18.8	607800.0
2020-03-30	ABB-DELISTED	Stock	17.22	17.3998	17.04	17.35	2494869.0
2020-03-30	ABBNY-DELISTED	Stock	17.22	17.3998	17.04	17.35	2708284.0
2020-03-30	ABBV	Stock	73.52	76.24	73.47	75.24	10671600.0
2020-03-30	ABC-DELISTED	Stock	83.53	88.55	82.44	88.07	1440245.0
2020-03-30	ABCB	Stock	22.54	23.47	21.45	23.35	462300.0
2020-03-30	ABEO	Stock	52.5	52.5	48.25	51.0	32828.0
2020-03-30	ABEV	Stock	2.5	2.54	2.45	2.48	19568000.0
2020-03-30	ABG	Stock	55.49	57.04	53.74	55.28	361700.0
2020-03-30	ABM	Stock	22.21	24.22	21.6	24.17	602300.0
2020-03-30	ABMD-DELISTED	Stock	146.03	149.89	143.6851	148.99	318860.0
2020-03-30	ABR	Stock	6.82	6.82	5.45	5.54	4415200.0
2020-03-30	ABR.A-DELISTED	Stock	18.96	19.41	17.02	17.02	17915.0
2020-03-30	ABR.B-DELISTED	Stock	17.4	17.4969	13.62	14.9275	13771.0
2020-03-30	ABR.C-DELISTED	Stock	17.85	18.7	14.7097	15.5	5909.0
2020-03-30	ABT	Stock	82.83	84.4	78.47	79.34	47540200.0
2020-03-30	ABTC	Stock	153900.0	159600.0	147000.0	150600.0	2.2266666666666666
2020-03-30	ABTS	Stock	11.25	12.0	11.25	12.0	180.0
2020-03-30	ABTX-DELISTED	Stock	23.94	24.46	23.44	24.11	45170.0
2020-03-30	ABUS	Stock	1.29	1.29	1.1	1.12	2102400.0

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

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