PREVIEW / stock_daily / 2019-03-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-01.parquet
  size:    220 KB
  rows:    6,532
  symbols: 2,623

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
2019-03-01	AAPL	Stock	43.57	43.7875	43.2225	43.7425	103544800.0
2019-03-01	MSFT	Stock	112.89	113.02	111.67	112.53	23501200.0
2019-03-01	NVDA	Stock	3.9068	3.9538	3.848	3.9112	357188000.0
2019-03-01	AMZN	Stock	82.7565	83.713	82.55	83.5865	99498000.0
2019-03-01	GOOGL	Stock	56.55	57.5	56.55	57.426	34085160.0
2019-03-01	META	Stock	162.6	163.13	161.69	162.28	11097800.0
2019-03-01	TSLA	Stock	20.4627	20.4753	19.46	19.6527	343671000.0
2019-03-01	TLT	Stock	119.33	119.53	118.64	118.66	13541090.0
2019-03-01	ES	Stock	69.9	69.92	68.95	69.74	2684400.0
2019-03-01	CL	Stock	65.92	66.06	65.36	66.0	2712500.0
2019-03-01	A	Stock	80.0	81.44	80.0	81.24	1625900.0
2019-03-01	AA	Stock	29.68	30.2	29.35	29.66	2187700.0
2019-03-01	AABA-DELISTED	Stock	75.0	75.66	74.66	74.98	4296041.0
2019-03-01	AAC-DELISTED	Stock	2.6	2.87	2.5701	2.87	143043.0
2019-03-01	AACG	Stock	1.15	1.15	1.1	1.1	59000.0
2019-03-01	AAIC-DELISTED	Stock	8.35	8.37	8.23	8.23	864279.0
2019-03-01	AAL	Stock	35.58	35.96	34.37	34.64	8654000.0
2019-03-01	AAM.A-DELISTED	Stock	24.84	25.2	24.8	25.15	30075.0
2019-03-01	AAM.B-DELISTED	Stock	24.48	24.74	24.48	24.69	69784.0
2019-03-01	AAMC-DELISTED	Stock	10.9324	12.0588	10.9324	11.4706	221507.0
2019-03-01	AAME	Stock	2.85	2.87	2.81	2.86	5000.0
2019-03-01	AAMI	Stock	14.22	14.39	14.04	14.14	594500.0
2019-03-01	AAOI	Stock	13.63	13.789	13.23	13.24	3147800.0
2019-03-01	AAON	Stock	26.9667	27.68	26.5733	27.5067	294600.0
2019-03-01	AAP	Stock	162.25	163.25	158.05	160.62	1398300.0
2019-03-01	AAT	Stock	43.61	43.88	43.07	43.82	166100.0
2019-03-01	AAU-DELISTED	Stock	0.65	0.65	0.63	0.63	222048.0
2019-03-01	AAUAF-DELISTED	Stock	0.65	0.65	0.63	0.632	225342.0
2019-03-01	AAWW-DELISTED	Stock	54.19	54.54	53.26	54.0	251459.0
2019-03-01	AAXJ	Stock	69.9	69.9	69.31	69.48	502537.0
2019-03-01	AAXN-DELISTED	Stock	54.29	54.6	53.19	54.45	848339.0
2019-03-01	AB	Stock	29.29	29.64	28.95	29.55	300600.0
2019-03-01	ABB-DELISTED	Stock	19.71	19.74	19.52	19.57	3348360.0
2019-03-01	ABBNY-DELISTED	Stock	19.71	19.74	19.52	19.57	3474806.0
2019-03-01	ABBV	Stock	79.77	80.85	79.28	80.1	8567900.0
2019-03-01	ABC-DELISTED	Stock	83.71	84.27	82.2	82.97	731439.0
2019-03-01	ABCB	Stock	41.11	41.19	40.33	40.87	250500.0
2019-03-01	ABDC-DELISTED	Stock	7.06	7.35	7.0	7.35	17610.0
2019-03-01	ABEO	Stock	176.75	191.0	173.25	190.25	18916.0
2019-03-01	ABEV	Stock	4.45	4.5	4.35	4.39	60522900.0
2019-03-01	ABG	Stock	72.55	73.23	70.66	71.19	174100.0
2019-03-01	ABIL-DELISTED	Stock	1.83	1.88	1.79	1.88	81477.0
2019-03-01	ABM	Stock	36.02	36.31	35.3	36.01	483400.0
2019-03-01	ABMD-DELISTED	Stock	337.2	351.58	336.95	348.06	242137.0
2019-03-01	ABR	Stock	12.94	13.03	12.78	12.88	903400.0
2019-03-01	ABR.A-DELISTED	Stock	25.5196	25.5556	25.5001	25.5264	5540.0
2019-03-01	ABR.B-DELISTED	Stock	25.34	25.4496	25.34	25.38	1700.0
2019-03-01	ABR.C-DELISTED	Stock	25.481	25.6155	25.481	25.6155	1198.0
2019-03-01	ABT	Stock	77.99	78.74	77.68	78.59	5390100.0
2019-03-01	ABTC	Stock	303900.0	303900.0	301800.0	303060.0	0.30666666666666664

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

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