PREVIEW / stock_daily / 2018-06-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-20.parquet
  size:    219 KB
  rows:    6,508
  symbols: 2,793

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-06-20	AAPL	Stock	46.5875	46.8	46.4325	46.625	82514800.0
2018-06-20	MSFT	Stock	101.37	102.52	101.12	101.87	26180800.0
2018-06-20	NVDA	Stock	6.5458	6.6112	6.507	6.5578	369780000.0
2018-06-20	AMZN	Stock	87.125	88.1465	87.068	87.504	86652000.0
2018-06-20	GOOGL	Stock	59.165	60.0745	59.1015	59.2035	51685200.0
2018-06-20	META	Stock	199.1	203.55	198.81	202.0	28230900.0
2018-06-20	TSLA	Stock	23.8693	24.292	23.4667	24.148	125755500.0
2018-06-20	TLT	Stock	120.77	120.788	119.9	119.91	6879114.0
2018-06-20	ES	Stock	55.87	55.9	55.44	55.81	1152700.0
2018-06-20	CL	Stock	63.82	64.05	63.45	63.9	4898800.0
2018-06-20	A	Stock	63.54	63.57	62.63	62.79	4942100.0
2018-06-20	AA	Stock	44.88	45.43	44.33	45.27	2160500.0
2018-06-20	AABA-DELISTED	Stock	80.5	81.39	80.2	81.11	12199051.0
2018-06-20	AAC-DELISTED	Stock	9.96	10.39	9.9	10.24	157317.0
2018-06-20	AAIC-DELISTED	Stock	10.74	10.905	10.62	10.88	657499.0
2018-06-20	AAL	Stock	41.65	42.34	41.35	42.03	4930600.0
2018-06-20	AAM.A-DELISTED	Stock	25.23	25.3	25.23	25.3	25913.0
2018-06-20	AAM.B-DELISTED	Stock	24.8	24.809	24.66	24.66	87668.0
2018-06-20	AAMC-DELISTED	Stock	20.265	20.5882	19.2223	20.5882	25017.0
2018-06-20	AAME	Stock	2.35	2.54	2.35	2.45	2100.0
2018-06-20	AAMI	Stock	15.79	15.79	15.46	15.49	359200.0
2018-06-20	AAOI	Stock	42.11	42.97	41.65	42.15	772000.0
2018-06-20	AAON	Stock	22.5	22.52	22.2333	22.4333	248850.0
2018-06-20	AAP	Stock	139.2	140.22	137.47	139.16	849600.0
2018-06-20	AAT	Stock	37.06	37.84	36.97	37.7	185000.0
2018-06-20	AAU-DELISTED	Stock	0.7402	0.7402	0.73	0.7301	50077.0
2018-06-20	AAUAF-DELISTED	Stock	0.7402	0.7402	0.73	0.7301	51660.0
2018-06-20	AAV-DELISTED	Stock	3.05	3.145	3.05	3.075	53214.0
2018-06-20	AAWW-DELISTED	Stock	73.0	74.35	72.5	74.0	175906.0
2018-06-20	AAXJ	Stock	73.92	74.04	73.65	73.71	1010822.0
2018-06-20	AAXN-DELISTED	Stock	66.33	68.855	66.2	68.45	914324.0
2018-06-20	AB	Stock	29.35	29.5	29.1	29.2	268100.0
2018-06-20	ABAC-DELISTED	Stock	2.28	2.5396	2.2201	2.3	95864.0
2018-06-20	ABAX-DELISTED	Stock	83.11	83.37	82.98	82.99	248412.0
2018-06-20	ABB-DELISTED	Stock	22.48	22.575	22.41	22.48	1945941.0
2018-06-20	ABBNY-DELISTED	Stock	22.48	22.575	22.41	22.47	2064449.0
2018-06-20	ABBV	Stock	98.22	99.55	97.84	98.25	5842700.0
2018-06-20	ABC-DELISTED	Stock	92.03	93.58	91.69	93.24	531740.0
2018-06-20	ABCB	Stock	57.65	58.1	57.5	57.6	304100.0
2018-06-20	ABCD-DELISTED	Stock	10.8	10.92	10.7498	10.89	117024.0
2018-06-20	ABDC-DELISTED	Stock	6.74	6.989	6.74	6.88	37955.0
2018-06-20	ABEO	Stock	402.5	415.0	397.5	413.75	42032.0
2018-06-20	ABEV	Stock	5.05	5.05	4.89	4.89	25977700.0
2018-06-20	ABG	Stock	75.5	76.5	74.6	75.8	165000.0
2018-06-20	ABIL-DELISTED	Stock	2.3	2.35	2.14	2.16	26463.0
2018-06-20	ABM	Stock	31.04	31.04	30.29	30.38	538000.0
2018-06-20	ABMD-DELISTED	Stock	441.1	450.93	441.1	446.21	421226.0
2018-06-20	ABR	Stock	10.1	10.18	10.08	10.13	1090500.0
2018-06-20	ABR.A-DELISTED	Stock	25.9387	25.9387	25.6716	25.8	3814.0
2018-06-20	ABR.B-DELISTED	Stock	25.2982	25.2982	25.2982	25.2982	400.0

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

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