PREVIEW / stock_daily / 2018-03-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-02.parquet
  size:    216 KB
  rows:    6,456
  symbols: 2,833

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-03-02	AAPL	Stock	43.2	44.075	43.1125	44.0525	153816000.0
2018-03-02	MSFT	Stock	91.58	93.15	90.86	93.05	32830400.0
2018-03-02	NVDA	Stock	5.6965	5.92	5.5463	5.9135	913428000.0
2018-03-02	AMZN	Stock	73.455	75.0525	72.7505	75.0125	131752000.0
2018-03-02	GOOGL	Stock	52.899	54.3445	52.5055	54.207	50162900.0
2018-03-02	META	Stock	173.29	177.11	172.99	176.62	20025900.0
2018-03-02	TSLA	Stock	21.7987	22.348	21.5313	22.3413	76392000.0
2018-03-02	TLT	Stock	118.85	118.93	118.121	118.35	10064302.0
2018-03-02	ES	Stock	56.58	57.41	56.53	57.1	2678400.0
2018-03-02	CL	Stock	68.5	69.39	68.5	69.27	3189300.0
2018-03-02	A	Stock	66.82	67.68	66.65	67.51	2057300.0
2018-03-02	AA	Stock	44.72	46.18	44.14	45.54	3707700.0
2018-03-02	AABA-DELISTED	Stock	72.35	72.99	71.4352	72.77	6811884.0
2018-03-02	AAC-DELISTED	Stock	9.58	9.87	9.37	9.79	142759.0
2018-03-02	AACG	Stock	5.22	5.22	5.22	5.22	200.0
2018-03-02	AAIC-DELISTED	Stock	10.8	11.075	10.71	11.06	425811.0
2018-03-02	AAL	Stock	52.9	53.42	51.87	53.18	4918200.0
2018-03-02	AAM.A-DELISTED	Stock	25.4651	25.49	25.38	25.44	7506.0
2018-03-02	AAMC-DELISTED	Stock	19.1176	19.9853	19.1176	19.6176	2625.0
2018-03-02	AAMI	Stock	14.84	15.05	14.52	15.02	533200.0
2018-03-02	AAOI	Stock	27.5	28.105	27.01	27.95	1041900.0
2018-03-02	AAON	Stock	23.4333	23.7	23.1667	23.6	234900.0
2018-03-02	AAP	Stock	116.67	116.79	113.12	116.07	1462100.0
2018-03-02	AAT	Stock	31.4	31.85	31.22	31.76	592000.0
2018-03-02	AAU-DELISTED	Stock	0.898	0.898	0.8757	0.89	88913.0
2018-03-02	AAUAF-DELISTED	Stock	0.898	0.898	0.8757	0.89	95454.0
2018-03-02	AAV-DELISTED	Stock	2.75	2.85	2.7	2.8	263102.0
2018-03-02	AAWW-DELISTED	Stock	59.45	60.65	59.0	60.25	170594.0
2018-03-02	AAXJ	Stock	75.85	77.03	75.43	76.9	806773.0
2018-03-02	AAXN-DELISTED	Stock	36.37	38.87	35.95	38.76	3060017.0
2018-03-02	AB	Stock	26.05	26.45	25.75	26.25	283100.0
2018-03-02	ABAC-DELISTED	Stock	2.5	2.5	2.49	2.49	470.0
2018-03-02	ABAX-DELISTED	Stock	65.61	68.9	65.61	68.62	137078.0
2018-03-02	ABB-DELISTED	Stock	23.93	24.04	23.685	24.005	2409028.0
2018-03-02	ABBNY-DELISTED	Stock	23.93	24.04	23.685	24.01	3172913.0
2018-03-02	ABBV	Stock	112.94	115.47	111.89	115.04	5439700.0
2018-03-02	ABC-DELISTED	Stock	92.7	94.58	92.56	93.92	1298829.0
2018-03-02	ABCB	Stock	52.65	54.23	52.35	54.05	246700.0
2018-03-02	ABCD-DELISTED	Stock	7.25	7.51	7.1744	7.29	56353.0
2018-03-02	ABDC-DELISTED	Stock	7.51	7.6	7.35	7.44	46356.0
2018-03-02	ABE-DELISTED	Stock	14.94	15.0596	14.88	15.0596	10520.0
2018-03-02	ABEO	Stock	345.0	391.25	340.0	387.5	55060.0
2018-03-02	ABEOW-DELISTED	Stock	9.62	10.5	9.62	10.4746	7780.0
2018-03-02	ABEV	Stock	6.73	6.9	6.68	6.88	16315000.0
2018-03-02	ABG	Stock	64.5	66.45	64.0	66.15	139500.0
2018-03-02	ABIL-DELISTED	Stock	0.37	0.3779	0.37	0.3778	67336.0
2018-03-02	ABLX-DELISTED	Stock	53.95	54.14	53.67	54.08	91560.0
2018-03-02	ABM	Stock	33.81	34.1	33.33	33.85	801800.0
2018-03-02	ABMD-DELISTED	Stock	263.13	276.21	260.0	275.041	346095.0
2018-03-02	ABR	Stock	8.62	8.68	8.54	8.56	1155200.0

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

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