PREVIEW / stock_daily / 2019-05-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-10.parquet
  size:    220 KB
  rows:    6,539
  symbols: 2,567

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
2019-05-10	AAPL	Stock	49.355	49.7125	48.1925	49.295	164834800.0
2019-05-10	MSFT	Stock	124.91	127.93	123.82	127.13	30915100.0
2019-05-10	NVDA	Stock	4.2238	4.2898	4.1	4.2205	569500000.0
2019-05-10	AMZN	Stock	94.9	95.1895	92.8	94.499	114360000.0
2019-05-10	GOOGL	Stock	58.442	58.814	57.3185	58.382	31649200.0
2019-05-10	META	Stock	188.25	190.0	184.59	188.34	12578500.0
2019-05-10	TSLA	Stock	15.9833	16.1327	15.7347	15.968	105124500.0
2019-05-10	TLT	Stock	124.89	125.45	124.59	124.75	6037925.0
2019-05-10	ES	Stock	70.46	71.77	70.32	71.76	874600.0
2019-05-10	CL	Stock	70.56	71.58	70.28	71.5	2341200.0
2019-05-10	A	Stock	76.64	77.14	74.09	77.1	2849800.0
2019-05-10	AA	Stock	24.73	25.31	24.27	25.04	3551000.0
2019-05-10	AABA-DELISTED	Stock	72.34	72.97	70.28	71.87	4721917.0
2019-05-10	AAC-DELISTED	Stock	1.89	1.9797	1.7	1.725	188912.0
2019-05-10	AACG	Stock	2.0	2.41	1.92	2.35	1054600.0
2019-05-10	AAIC-DELISTED	Stock	7.59	7.64	7.52	7.63	290790.0
2019-05-10	AAIC.C-DELISTED	Stock	23.5166	23.5166	23.29	23.35	4426.0
2019-05-10	AAL	Stock	33.72	34.19	32.94	33.99	4949800.0
2019-05-10	AAM.A-DELISTED	Stock	25.5399	25.61	25.5399	25.61	7654.0
2019-05-10	AAM.B-DELISTED	Stock	25.57	25.57	25.53	25.566	17687.0
2019-05-10	AAMC-DELISTED	Stock	6.7735	6.9118	6.2485	6.3735	15830.0
2019-05-10	AAME	Stock	2.51	2.51	2.48	2.49	1100.0
2019-05-10	AAMI	Stock	13.54	13.65	13.42	13.6	499300.0
2019-05-10	AAOI	Stock	10.81	11.06	10.305	10.71	965200.0
2019-05-10	AAON	Stock	31.4533	32.34	31.22	32.2667	193800.0
2019-05-10	AAP	Stock	159.24	159.24	154.49	158.12	813300.0
2019-05-10	AAT	Stock	45.29	45.8	44.87	45.8	113900.0
2019-05-10	AAU-DELISTED	Stock	0.465	0.47	0.46	0.47	117520.0
2019-05-10	AAUAF-DELISTED	Stock	0.465	0.47	0.46	0.47	128053.0
2019-05-10	AAWW-DELISTED	Stock	41.91	42.65	40.85	41.73	173861.0
2019-05-10	AAXJ	Stock	68.57	69.025	67.79	68.77	1390119.0
2019-05-10	AAXN-DELISTED	Stock	67.0	68.8	61.71	63.72	1529724.0
2019-05-10	AB	Stock	28.99	29.4	28.58	29.35	221300.0
2019-05-10	ABB-DELISTED	Stock	19.19	19.24	18.98	19.215	2444590.0
2019-05-10	ABBNY-DELISTED	Stock	19.19	19.24	18.98	19.21	2529997.0
2019-05-10	ABBV	Stock	77.45	77.73	75.62	77.45	4731800.0
2019-05-10	ABC-DELISTED	Stock	78.9	79.51	76.13	77.47	856995.0
2019-05-10	ABCB	Stock	36.33	36.75	35.85	36.66	216800.0
2019-05-10	ABDC-DELISTED	Stock	8.43	8.44	8.36	8.44	16693.0
2019-05-10	ABEO	Stock	191.5	193.75	185.25	192.0	15208.0
2019-05-10	ABEV	Stock	4.42	4.45	4.32	4.38	19658400.0
2019-05-10	ABG	Stock	79.76	80.45	78.55	80.25	98200.0
2019-05-10	ABIL-DELISTED	Stock	1.35	1.3621	1.3067	1.32	56860.0
2019-05-10	ABM	Stock	38.04	38.36	37.39	38.32	218800.0
2019-05-10	ABMD-DELISTED	Stock	260.74	260.74	251.09	258.79	402821.0
2019-05-10	ABR	Stock	13.01	13.11	12.74	13.04	2409400.0
2019-05-10	ABR.B-DELISTED	Stock	25.8338	25.8338	25.8001	25.8001	1332.0
2019-05-10	ABR.C-DELISTED	Stock	26.5	26.79	26.49	26.758	6710.0
2019-05-10	ABT	Stock	76.21	76.66	74.54	76.45	3993500.0
2019-05-10	ABTC	Stock	305100.0	305700.0	305100.0	305550.0	0.28

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

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