PREVIEW / stock_daily / 2019-03-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-28.parquet
  size:    219 KB
  rows:    6,526
  symbols: 2,601

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-28	AAPL	Stock	47.2375	47.39	46.8825	47.18	83121600.0
2019-03-28	MSFT	Stock	117.44	117.58	116.13	116.93	18334800.0
2019-03-28	NVDA	Stock	4.4388	4.4975	4.3778	4.4312	480264000.0
2019-03-28	AMZN	Stock	88.5	88.8965	87.6735	88.671	60860000.0
2019-03-28	GOOGL	Stock	58.775	58.8625	58.1715	58.6135	22402440.0
2019-03-28	META	Stock	164.57	166.72	163.33	165.55	10443000.0
2019-03-28	TSLA	Stock	18.4773	18.6887	18.34	18.5747	101611500.0
2019-03-28	TLT	Stock	126.25	126.69	126.01	126.56	9143238.0
2019-03-28	ES	Stock	71.37	71.53	70.04	70.34	1642600.0
2019-03-28	CL	Stock	67.12	67.56	67.12	67.37	2958900.0
2019-03-28	A	Stock	79.39	79.79	78.71	79.7	1615600.0
2019-03-28	AA	Stock	28.05	28.05	27.385	27.99	2553100.0
2019-03-28	AABA-DELISTED	Stock	72.37	72.81	71.8	72.49	4798580.0
2019-03-28	AAC-DELISTED	Stock	1.83	1.85	1.75	1.755	120950.0
2019-03-28	AACG	Stock	1.03	1.03	0.98	1.0	55900.0
2019-03-28	AAIC-DELISTED	Stock	7.9	7.985	7.8459	7.94	504478.0
2019-03-28	AAIC.C-DELISTED	Stock	23.1188	23.1899	23.02	23.07	14904.0
2019-03-28	AAL	Stock	31.01	31.37	30.44	30.9	6687200.0
2019-03-28	AAM.A-DELISTED	Stock	25.01	25.0274	24.84	24.84	33239.0
2019-03-28	AAM.B-DELISTED	Stock	24.6	24.6895	24.49	24.52	46913.0
2019-03-28	AAMC-DELISTED	Stock	9.4147	9.5147	8.6551	9.2647	22222.0
2019-03-28	AAME	Stock	2.52	2.52	2.52	2.52	400.0
2019-03-28	AAMI	Stock	12.99	13.31	12.99	13.3	608700.0
2019-03-28	AAOI	Stock	12.21	12.46	12.08	12.19	376000.0
2019-03-28	AAON	Stock	30.0	30.6	29.64	30.5467	255450.0
2019-03-28	AAP	Stock	167.32	168.92	166.66	168.75	643400.0
2019-03-28	AAT	Stock	45.68	46.32	45.68	46.28	189100.0
2019-03-28	AAU-DELISTED	Stock	0.633	0.633	0.5963	0.5973	134056.0
2019-03-28	AAUAF-DELISTED	Stock	0.633	0.633	0.5963	0.6004	137649.0
2019-03-28	AAWW-DELISTED	Stock	47.82	49.2	47.15	48.19	243143.0
2019-03-28	AAXJ	Stock	69.82	69.95	69.56	69.95	861875.0
2019-03-28	AAXN-DELISTED	Stock	52.66	53.98	52.6018	53.86	243911.0
2019-03-28	AB	Stock	28.54	28.93	28.5	28.92	199000.0
2019-03-28	ABB-DELISTED	Stock	18.67	18.7	18.5601	18.68	2095400.0
2019-03-28	ABBNY-DELISTED	Stock	18.67	18.7	18.5601	18.67	2176020.0
2019-03-28	ABBV	Stock	80.33	80.49	79.5	79.96	3071000.0
2019-03-28	ABC-DELISTED	Stock	77.05	77.93	76.69	77.88	940441.0
2019-03-28	ABCB	Stock	34.33	34.75	33.92	34.67	247400.0
2019-03-28	ABDC-DELISTED	Stock	7.48	7.58	7.45	7.5	41073.0
2019-03-28	ABEO	Stock	179.5	184.25	175.25	181.75	8972.0
2019-03-28	ABEV	Stock	4.18	4.34	4.17	4.29	37755700.0
2019-03-28	ABG	Stock	69.91	70.91	68.1	68.58	240400.0
2019-03-28	ABIL-DELISTED	Stock	1.68	1.95	1.665	1.74	251649.0
2019-03-28	ABM	Stock	35.45	36.06	35.3	35.93	490800.0
2019-03-28	ABMD-DELISTED	Stock	277.75	286.9	275.0	283.98	637385.0
2019-03-28	ABR	Stock	12.98	12.99	12.9	12.98	502400.0
2019-03-28	ABR.A-DELISTED	Stock	25.7308	25.75	25.7308	25.75	1000.0
2019-03-28	ABR.B-DELISTED	Stock	25.69	25.74	25.69	25.74	650.0
2019-03-28	ABR.C-DELISTED	Stock	25.899	26.09	25.899	26.09	2463.0
2019-03-28	ABT	Stock	79.16	79.66	78.72	79.44	5675900.0

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

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