PREVIEW / stock_daily / 2014-12-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-18.parquet
  size:    224 KB
  rows:    6,694
  symbols: 3,579

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
2014-12-18	AAPL	Stock	27.9675	28.1625	27.665	28.1625	236024800.0
2014-12-18	MSFT	Stock	46.58	47.52	46.34	47.52	40105600.0
2014-12-18	NVDA	Stock	0.5098	0.5158	0.5008	0.5055	226156000.0
2014-12-18	AMZN	Stock	15.2005	15.225	14.6625	14.8865	154762000.0
2014-12-18	GOOGL	Stock	25.7995	25.8125	25.328	25.731	77427700.0
2014-12-18	META	Stock	76.89	78.4	76.51	78.4	34222100.0
2014-12-18	TSLA	Stock	14.1587	14.5627	14.12	14.5507	112249500.0
2014-12-18	TLT	Stock	124.93	125.1	124.2	124.2	12758214.0
2014-12-18	ES	Stock	52.13	52.89	51.76	52.87	2076300.0
2014-12-18	CL	Stock	69.4	69.48	68.61	69.48	4104900.0
2014-12-18	A	Stock	40.48	40.8	40.11	40.7	3104100.0
2014-12-18	AA.B-DELISTED	Stock	49.3	50.13	49.098	50.13	41340.0
2014-12-18	AABA-DELISTED	Stock	50.93	51.15	50.435	50.9	14498321.0
2014-12-18	AAC-DELISTED	Stock	29.98	30.52	28.6901	29.78	93300.0
2014-12-18	AACG	Stock	3.48	3.5	3.14	3.14	6200.0
2014-12-18	AAIC-DELISTED	Stock	27.21	27.4943	27.21	27.38	322197.0
2014-12-18	AAL	Stock	48.56	50.93	47.5	50.14	16945300.0
2014-12-18	AAMC-DELISTED	Stock	132.8206	136.9824	129.4441	136.9824	52302.0
2014-12-18	AAME	Stock	3.83	3.88	3.83	3.87	6600.0
2014-12-18	AAMI	Stock	16.2	16.63	16.06	16.4	302000.0
2014-12-18	AAOI	Stock	10.27	10.81	10.07	10.71	249700.0
2014-12-18	AAON	Stock	14.5667	14.78	14.4267	14.64	257100.0
2014-12-18	AAP	Stock	161.05	161.56	159.29	160.74	505300.0
2014-12-18	AAT	Stock	39.4	39.45	38.96	39.29	124700.0
2014-12-18	AAU-DELISTED	Stock	0.96	1.0	0.929	0.96	75540.0
2014-12-18	AAUAF-DELISTED	Stock	0.94	0.98	0.913	0.9596	77436.0
2014-12-18	AAV-DELISTED	Stock	5.22	5.36	4.825	4.89	336853.0
2014-12-18	AAVL-DELISTED	Stock	51.39	52.3999	48.4401	50.5	140616.0
2014-12-18	AAWW-DELISTED	Stock	45.6	46.35	44.93	46.25	165879.0
2014-12-18	AAXJ	Stock	59.72	59.9	59.46	59.83	1263951.0
2014-12-18	AAXN-DELISTED	Stock	25.04	25.14	23.64	24.18	3072438.0
2014-12-18	AB	Stock	25.05	25.55	24.6	24.98	351300.0
2014-12-18	ABAC-DELISTED	Stock	1.9	1.9	1.85	1.85	10500.0
2014-12-18	ABAX-DELISTED	Stock	59.5	59.7599	57.63	59.74	196658.0
2014-12-18	ABB-DELISTED	Stock	21.07	21.22	21.0	21.22	3815138.0
2014-12-18	ABBNY-DELISTED	Stock	21.07	21.22	21.0	21.22	5047113.0
2014-12-18	ABBV	Stock	67.86	68.01	67.2	67.92	7184700.0
2014-12-18	ABC-DELISTED	Stock	91.12	91.39	90.43	91.28	1923471.0
2014-12-18	ABCB	Stock	26.6	26.6	25.93	25.96	131100.0
2014-12-18	ABCD-DELISTED	Stock	1.6	1.6	1.52	1.53	10848.0
2014-12-18	ABCO-DELISTED	Stock	51.59	51.59	48.88	49.07	673021.0
2014-12-18	ABCW-DELISTED	Stock	33.45	34.25	31.5	33.84	37990.0
2014-12-18	ABDC-DELISTED	Stock	11.65	12.15	11.65	11.89	68022.0
2014-12-18	ABE-DELISTED	Stock	13.089	13.1424	13.07	13.12	4130.0
2014-12-18	ABEO	Stock	135.25	145.75	135.0	145.75	296.0
2014-12-18	ABEV	Stock	5.96	6.05	5.92	6.0	18580700.0
2014-12-18	ABG	Stock	76.07	76.18	74.16	75.0	466300.0
2014-12-18	ABGB-DELISTED	Stock	12.64	12.64	12.21	12.29	20174.0
2014-12-18	ABIL-DELISTED	Stock	9.88	9.88	9.83	9.83	400.0
2014-12-18	ABM	Stock	28.31	28.6	28.09	28.1	462600.0

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

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