PREVIEW / stock_daily / 2017-03-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-17.parquet
  size:    217 KB
  rows:    6,474
  symbols: 3,059

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-03-17	AAPL	Stock	35.25	35.25	34.9725	34.9975	175540000.0
2017-03-17	MSFT	Stock	64.91	65.24	64.68	64.87	49219700.0
2017-03-17	NVDA	Stock	2.613	2.653	2.5952	2.6518	1119688000.0
2017-03-17	AMZN	Stock	42.6745	42.6915	42.532	42.6155	67688000.0
2017-03-17	GOOGL	Stock	43.684	43.721	43.4185	43.6185	37365040.0
2017-03-17	META	Stock	140.34	140.34	139.7	139.84	20592800.0
2017-03-17	TSLA	Stock	17.6	17.6887	17.4133	17.4333	97462500.0
2017-03-17	TLT	Stock	118.11	118.75	118.0301	118.64	7266766.0
2017-03-17	ES	Stock	58.78	59.41	58.69	58.93	3335900.0
2017-03-17	CL	Stock	74.02	74.27	73.71	73.96	5099000.0
2017-03-17	A	Stock	53.06	53.53	52.92	53.31	1936900.0
2017-03-17	AA	Stock	35.57	35.98	34.95	34.97	3824700.0
2017-03-17	AAAP-DELISTED	Stock	36.67	37.21	36.6175	37.02	57740.0
2017-03-17	AABA-DELISTED	Stock	46.73	46.9	46.5	46.59	5420816.0
2017-03-17	AAC-DELISTED	Stock	8.6	8.7	8.57	8.58	82772.0
2017-03-17	AACG	Stock	3.74	3.79	3.55	3.66	25000.0
2017-03-17	AAIC-DELISTED	Stock	14.19	14.4	14.1	14.38	1040207.0
2017-03-17	AAL	Stock	42.0	42.21	41.6	41.72	10185800.0
2017-03-17	AAM.A-DELISTED	Stock	24.89	25.04	24.85	24.98	299963.0
2017-03-17	AAMC-DELISTED	Stock	21.6029	21.625	17.6765	18.5588	105135.0
2017-03-17	AAME	Stock	3.95	4.0	3.9	4.0	2100.0
2017-03-17	AAMI	Stock	15.05	15.05	14.55	14.7	511300.0
2017-03-17	AAOI	Stock	48.0	50.99	47.701	50.77	1828500.0
2017-03-17	AAON	Stock	24.4	24.7	24.2	24.6667	584100.0
2017-03-17	AAP	Stock	152.42	153.25	150.9	152.4	1134600.0
2017-03-17	AAT	Stock	42.91	42.93	42.26	42.33	2040300.0
2017-03-17	AAU-DELISTED	Stock	1.06	1.06	1.01	1.03	97585.0
2017-03-17	AAUAF-DELISTED	Stock	1.06	1.06	1.01	1.03	98439.0
2017-03-17	AAV-DELISTED	Stock	6.05	6.075	5.9	6.0	44307.0
2017-03-17	AAWW-DELISTED	Stock	53.6	54.85	53.55	54.7	261628.0
2017-03-17	AAXJ	Stock	62.92	63.04	62.855	62.94	3716516.0
2017-03-17	AAXN-DELISTED	Stock	22.77	23.48	22.715	23.37	1304504.0
2017-03-17	AB	Stock	22.75	22.77	22.35	22.35	296900.0
2017-03-17	ABAC-DELISTED	Stock	2.3592	2.451	2.21	2.3	26658.0
2017-03-17	ABAX-DELISTED	Stock	48.83	49.515	48.81	49.375	183468.0
2017-03-17	ABB-DELISTED	Stock	23.31	23.38	23.18	23.27	2520425.0
2017-03-17	ABBNY-DELISTED	Stock	23.31	23.38	23.18	23.27	2682193.0
2017-03-17	ABBV	Stock	66.04	66.09	65.5	65.69	11288000.0
2017-03-17	ABC-DELISTED	Stock	87.91	88.325	86.88	87.52	1850703.0
2017-03-17	ABCB	Stock	47.5	47.75	46.35	47.65	1090400.0
2017-03-17	ABCD-DELISTED	Stock	4.92	5.1	4.9	5.06	55875.0
2017-03-17	ABCO-DELISTED	Stock	44.6	44.95	44.25	44.6	367725.0
2017-03-17	ABDC-DELISTED	Stock	13.34	13.61	13.11	13.4	148661.0
2017-03-17	ABE-DELISTED	Stock	12.47	12.51	12.4601	12.49	8086.0
2017-03-17	ABEO	Stock	127.5	130.0	126.25	126.25	6016.0
2017-03-17	ABEV	Stock	5.56	5.59	5.47	5.51	21487600.0
2017-03-17	ABG	Stock	63.45	63.45	61.55	61.9	342300.0
2017-03-17	ABIL-DELISTED	Stock	2.3	2.82	2.3	2.31	14394.0
2017-03-17	ABM	Stock	44.62	44.68	44.13	44.55	588000.0
2017-03-17	ABMD-DELISTED	Stock	123.17	124.68	122.7573	123.94	334242.0

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

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