PREVIEW / stock_daily / 2017-02-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-28.parquet
  size:    216 KB
  rows:    6,499
  symbols: 3,081

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
2017-02-28	AAPL	Stock	34.27	34.36	34.175	34.2475	93931600.0
2017-02-28	MSFT	Stock	64.08	64.2	63.76	63.98	23239800.0
2017-02-28	NVDA	Stock	2.62	2.63	2.5195	2.537	625360000.0
2017-02-28	AMZN	Stock	42.5725	42.7045	42.1025	42.252	55874000.0
2017-02-28	GOOGL	Stock	42.3675	42.4415	42.0721	42.2465	27662380.0
2017-02-28	META	Stock	136.79	136.81	134.75	135.54	16112100.0
2017-02-28	TSLA	Stock	16.2793	16.7333	16.26	16.666	91171500.0
2017-02-28	TLT	Stock	121.5	122.075	121.32	121.74	8410508.0
2017-02-28	ES	Stock	58.35	58.75	58.17	58.66	1927600.0
2017-02-28	CL	Stock	72.67	73.57	72.41	72.98	4497900.0
2017-02-28	A	Stock	51.52	51.65	51.23	51.3	1417800.0
2017-02-28	AA	Stock	34.73	35.33	34.4	34.59	4034100.0
2017-02-28	AAAP-DELISTED	Stock	37.25	38.87	37.05	37.93	145717.0
2017-02-28	AABA-DELISTED	Stock	45.57	45.75	45.25	45.69	6600135.0
2017-02-28	AAC-DELISTED	Stock	7.55	9.53	7.05	9.18	398468.0
2017-02-28	AACG	Stock	3.82	3.83	3.71	3.77	14900.0
2017-02-28	AAIC-DELISTED	Stock	14.8	14.82	14.63	14.74	269684.0
2017-02-28	AAL	Stock	46.32	46.72	46.03	46.36	4935600.0
2017-02-28	AAMC-DELISTED	Stock	20.4706	20.6765	19.5946	20.6765	33752.0
2017-02-28	AAME	Stock	3.85	3.85	3.85	3.85	400.0
2017-02-28	AAMI	Stock	14.9	15.04	14.67	14.91	444100.0
2017-02-28	AAOI	Stock	47.56	48.75	45.6	45.92	1405700.0
2017-02-28	AAON	Stock	22.6667	22.7	22.1667	22.4333	328050.0
2017-02-28	AAP	Stock	155.64	158.69	155.18	156.61	1087300.0
2017-02-28	AAT	Stock	44.34	44.48	43.91	44.0	234600.0
2017-02-28	AAU-DELISTED	Stock	1.11	1.1399	1.09	1.09	216679.0
2017-02-28	AAUAF-DELISTED	Stock	1.11	1.1399	1.09	1.09	217610.0
2017-02-28	AAV-DELISTED	Stock	6.05	6.1	6.0	6.05	70335.0
2017-02-28	AAWW-DELISTED	Stock	57.2	57.95	56.45	56.9	205441.0
2017-02-28	AAXJ	Stock	60.86	60.87	60.56	60.62	330853.0
2017-02-28	AAXN-DELISTED	Stock	26.13	26.24	25.44	25.66	1291479.0
2017-02-28	AB	Stock	23.7	23.75	23.5	23.7	240500.0
2017-02-28	ABAC-DELISTED	Stock	2.94	2.95	2.75	2.8	7520.0
2017-02-28	ABAX-DELISTED	Stock	51.08	51.2	49.51	49.85	121404.0
2017-02-28	ABB-DELISTED	Stock	22.58	22.69	22.53	22.56	2053168.0
2017-02-28	ABBNY-DELISTED	Stock	22.58	22.69	22.53	22.55	2198142.0
2017-02-28	ABBV	Stock	62.11	62.4	61.69	61.84	6756100.0
2017-02-28	ABC-DELISTED	Stock	91.9	91.93	90.98	91.5	1714027.0
2017-02-28	ABCB	Stock	48.8	48.8	47.9	48.3	193600.0
2017-02-28	ABCD-DELISTED	Stock	4.88	4.98	4.77	4.95	25409.0
2017-02-28	ABCO-DELISTED	Stock	46.55	46.55	44.85	44.95	656094.0
2017-02-28	ABDC-DELISTED	Stock	12.51	12.5697	12.1472	12.49	56250.0
2017-02-28	ABE-DELISTED	Stock	12.08	12.1348	12.0	12.03	52088.0
2017-02-28	ABEO	Stock	137.5	140.0	131.25	135.0	6628.0
2017-02-28	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	997.0
2017-02-28	ABEV	Stock	5.72	5.72	5.66	5.69	5467100.0
2017-02-28	ABG	Stock	66.45	66.85	64.9	65.15	223700.0
2017-02-28	ABIL-DELISTED	Stock	2.65	2.75	2.65	2.65	18056.0
2017-02-28	ABM	Stock	41.47	41.59	40.74	40.79	345400.0
2017-02-28	ABMD-DELISTED	Stock	117.92	118.71	116.83	117.99	264837.0

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

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