PREVIEW / stock_daily / 2018-03-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-09.parquet
  size:    217 KB
  rows:    6,472
  symbols: 2,840

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-09	AAPL	Stock	44.49	45.0	44.3475	44.995	128740800.0
2018-03-09	MSFT	Stock	95.29	96.54	95.0	96.54	36937300.0
2018-03-09	NVDA	Stock	6.0775	6.1462	6.0612	6.1332	505524000.0
2018-03-09	AMZN	Stock	78.175	78.947	77.954	78.9445	90686000.0
2018-03-09	GOOGL	Stock	56.975	58.05	56.7145	58.042	42661740.0
2018-03-09	META	Stock	183.91	185.51	183.21	185.23	18526300.0
2018-03-09	TSLA	Stock	21.6067	21.8993	21.4913	21.8113	82602000.0
2018-03-09	TLT	Stock	117.99	118.269	117.59	117.91	6570366.0
2018-03-09	ES	Stock	56.88	57.25	56.64	57.24	1634000.0
2018-03-09	CL	Stock	71.15	71.57	70.76	71.24	2928200.0
2018-03-09	A	Stock	70.27	71.5	70.0	71.13	2061200.0
2018-03-09	AA	Stock	48.05	48.59	47.23	47.86	2768900.0
2018-03-09	AABA-DELISTED	Stock	76.35	76.88	75.76	76.61	5508094.0
2018-03-09	AAC-DELISTED	Stock	12.01	12.07	11.34	11.94	259619.0
2018-03-09	AACG	Stock	5.27	5.27	5.05	5.14	10700.0
2018-03-09	AAIC-DELISTED	Stock	11.69	11.78	11.52	11.61	588009.0
2018-03-09	AAL	Stock	55.05	56.08	54.65	56.07	3468900.0
2018-03-09	AAM.A-DELISTED	Stock	25.6	25.73	25.52	25.65	24959.0
2018-03-09	AAMC-DELISTED	Stock	19.1029	19.2794	19.1029	19.2794	1275.0
2018-03-09	AAME	Stock	3.36	3.45	3.35	3.35	1500.0
2018-03-09	AAMI	Stock	15.5	15.985	15.48	15.95	682000.0
2018-03-09	AAOI	Stock	28.05	29.38	28.05	28.7	1307000.0
2018-03-09	AAON	Stock	24.3667	25.3	24.1333	25.2333	326700.0
2018-03-09	AAP	Stock	116.44	118.94	114.4	118.86	1088300.0
2018-03-09	AAT	Stock	32.34	32.45	31.82	32.14	279500.0
2018-03-09	AAU-DELISTED	Stock	0.87	0.889	0.8536	0.8543	144508.0
2018-03-09	AAUAF-DELISTED	Stock	0.87	0.889	0.8536	0.8543	147796.0
2018-03-09	AAV-DELISTED	Stock	2.9	2.95	2.8	2.875	304382.0
2018-03-09	AAWW-DELISTED	Stock	60.9	62.05	60.55	61.55	154014.0
2018-03-09	AAXJ	Stock	78.42	79.54	78.42	79.54	880701.0
2018-03-09	AAXN-DELISTED	Stock	40.01	40.16	39.11	39.86	1047369.0
2018-03-09	AB	Stock	27.35	27.35	27.0	27.25	366900.0
2018-03-09	ABAC-DELISTED	Stock	2.47	2.4751	2.4489	2.45	12600.0
2018-03-09	ABAX-DELISTED	Stock	71.55	72.04	70.04	71.71	78897.0
2018-03-09	ABB-DELISTED	Stock	24.42	24.63	24.39	24.615	1554509.0
2018-03-09	ABBNY-DELISTED	Stock	24.42	24.63	24.39	24.61	1732473.0
2018-03-09	ABBV	Stock	117.85	119.66	117.67	119.29	5835600.0
2018-03-09	ABC-DELISTED	Stock	96.89	99.05	96.76	98.98	904578.0
2018-03-09	ABCB	Stock	56.8	58.15	56.75	58.1	249900.0
2018-03-09	ABCD-DELISTED	Stock	8.74	9.64	8.71	9.16	428411.0
2018-03-09	ABDC-DELISTED	Stock	7.67	7.7545	7.65	7.73	22370.0
2018-03-09	ABE-DELISTED	Stock	15.18	15.26	15.18	15.2553	2025.0
2018-03-09	ABEO	Stock	382.5	395.0	379.5	382.5	30760.0
2018-03-09	ABEOW-DELISTED	Stock	10.25	10.5	10.19	10.5	3656.0
2018-03-09	ABEV	Stock	7.16	7.22	7.12	7.14	15375800.0
2018-03-09	ABG	Stock	68.2	69.8	67.55	69.65	84500.0
2018-03-09	ABIL-DELISTED	Stock	0.3829	0.4299	0.3829	0.4038	310624.0
2018-03-09	ABLX-DELISTED	Stock	54.0	54.16	53.97	54.15	111912.0
2018-03-09	ABM	Stock	37.2	37.78	36.82	37.65	440000.0
2018-03-09	ABMD-DELISTED	Stock	292.62	297.45	291.085	294.25	327153.0

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

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