PREVIEW / stock_daily / 2018-02-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-28.parquet
  size:    216 KB
  rows:    6,493
  symbols: 2,855

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
2018-02-28	AAPL	Stock	44.815	45.155	44.5125	44.53	151128400.0
2018-02-28	MSFT	Stock	94.84	95.71	93.63	93.77	31167300.0
2018-02-28	NVDA	Stock	6.1625	6.2025	6.0383	6.05	523116000.0
2018-02-28	AMZN	Stock	75.9755	76.435	75.6	75.6225	90300000.0
2018-02-28	GOOGL	Stock	56.1	56.3825	55.15	55.196	49292380.0
2018-02-28	META	Stock	182.3	182.88	178.14	178.32	18783000.0
2018-02-28	TSLA	Stock	23.5047	23.6827	22.8147	22.8707	91045500.0
2018-02-28	TLT	Stock	118.47	118.8301	118.25	118.75	9311606.0
2018-02-28	ES	Stock	57.67	57.88	57.0	57.0	1912500.0
2018-02-28	CL	Stock	70.3	70.36	68.97	68.97	3796000.0
2018-02-28	A	Stock	69.42	70.0	68.57	68.59	3289200.0
2018-02-28	AA	Stock	46.25	46.84	44.94	44.97	2837400.0
2018-02-28	AABA-DELISTED	Stock	75.91	76.08	74.51	74.86	7725652.0
2018-02-28	AAC-DELISTED	Stock	9.56	9.71	9.29	9.46	127948.0
2018-02-28	AACG	Stock	5.34	5.37	5.32	5.34	14100.0
2018-02-28	AAIC-DELISTED	Stock	10.98	11.049	10.8	10.82	541864.0
2018-02-28	AAL	Stock	54.41	54.6	53.64	54.25	4343800.0
2018-02-28	AAM.A-DELISTED	Stock	25.28	25.34	25.23	25.34	34185.0
2018-02-28	AAME	Stock	3.5	3.5	3.3	3.45	5300.0
2018-02-28	AAMI	Stock	15.76	15.85	15.32	15.33	576300.0
2018-02-28	AAOI	Stock	27.57	28.04	26.35	27.93	1139800.0
2018-02-28	AAON	Stock	25.7667	26.1333	24.4333	24.5	598050.0
2018-02-28	AAP	Stock	110.71	116.11	109.68	114.25	1901700.0
2018-02-28	AAT	Stock	31.87	32.27	31.69	31.72	247600.0
2018-02-28	AAU-DELISTED	Stock	0.8685	0.8732	0.8231	0.8495	201864.0
2018-02-28	AAUAF-DELISTED	Stock	0.8685	0.8732	0.8231	0.8495	206888.0
2018-02-28	AAV-DELISTED	Stock	3.0	3.05	2.8	2.8	376159.0
2018-02-28	AAWW-DELISTED	Stock	61.5	62.35	60.75	60.95	278899.0
2018-02-28	AAXJ	Stock	77.85	77.92	76.74	76.74	520195.0
2018-02-28	AAXN-DELISTED	Stock	32.01	36.3	31.06	34.81	7552730.0
2018-02-28	AB	Stock	26.55	26.7	26.15	26.6	285400.0
2018-02-28	ABAC-DELISTED	Stock	2.47	2.5	2.3	2.49	15918.0
2018-02-28	ABAX-DELISTED	Stock	68.54	68.91	66.56	66.65	91500.0
2018-02-28	ABB-DELISTED	Stock	24.68	24.735	24.28	24.28	2684257.0
2018-02-28	ABBNY-DELISTED	Stock	24.7	24.735	24.28	24.29	3357899.0
2018-02-28	ABBV	Stock	119.0	120.0	115.78	115.83	6660000.0
2018-02-28	ABC-DELISTED	Stock	97.85	99.75	95.15	95.16	1245165.0
2018-02-28	ABCB	Stock	54.0	54.4	53.05	53.15	235700.0
2018-02-28	ABCD-DELISTED	Stock	7.64	7.8	7.37	7.38	68185.0
2018-02-28	ABDC-DELISTED	Stock	7.32	7.73	7.15	7.52	163783.0
2018-02-28	ABE-DELISTED	Stock	15.08	15.1596	15.08	15.09	5550.0
2018-02-28	ABEO	Stock	346.25	361.25	337.5	346.25	27620.0
2018-02-28	ABEOW-DELISTED	Stock	8.99	8.99	8.95	8.9501	1800.0
2018-02-28	ABEV	Stock	6.78	6.87	6.75	6.75	22336800.0
2018-02-28	ABG	Stock	68.2	68.9	65.8	65.85	213700.0
2018-02-28	ABIL-DELISTED	Stock	0.4	0.4073	0.3805	0.382	133880.0
2018-02-28	ABLX-DELISTED	Stock	53.46	53.55	53.09	53.1	125013.0
2018-02-28	ABM	Stock	35.98	36.0	35.12	35.16	477100.0
2018-02-28	ABMD-DELISTED	Stock	272.63	274.4	267.98	268.15	135049.0
2018-02-28	ABR	Stock	8.6	8.65	8.56	8.56	854000.0

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

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