PREVIEW / stock_daily / 2019-01-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-15.parquet
  size:    219 KB
  rows:    6,547
  symbols: 2,657

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-01-15	AAPL	Stock	37.5675	38.3475	37.5125	38.2675	114843600.0
2019-01-15	MSFT	Stock	102.51	105.05	101.88	105.01	31587600.0
2019-01-15	NVDA	Stock	3.794	3.8338	3.7282	3.7468	617012000.0
2019-01-15	AMZN	Stock	81.6	83.758	81.3005	83.728	119970000.0
2019-01-15	GOOGL	Stock	52.9005	54.4135	52.722	54.3255	37517040.0
2019-01-15	META	Stock	146.01	150.68	145.99	148.95	24069000.0
2019-01-15	TSLA	Stock	22.3333	23.2533	22.3	22.962	90849000.0
2019-01-15	TLT	Stock	120.56	120.57	119.95	120.04	8997352.0
2019-01-15	ES	Stock	65.3	66.91	65.3	66.41	1484400.0
2019-01-15	CL	Stock	61.65	62.51	61.6	62.22	2580300.0
2019-01-15	A	Stock	69.95	70.75	69.62	70.6	1793100.0
2019-01-15	AA	Stock	28.94	29.47	28.587	28.9	3770900.0
2019-01-15	AABA-DELISTED	Stock	62.59	63.82	62.44	62.84	11311522.0
2019-01-15	AAC-DELISTED	Stock	2.94	3.3199	2.6101	2.79	642671.0
2019-01-15	AACG	Stock	1.03	1.05	0.98	1.04	96800.0
2019-01-15	AAIC-DELISTED	Stock	8.02	8.07	7.94	8.04	174571.0
2019-01-15	AAL	Stock	31.88	32.86	31.63	32.1	7643100.0
2019-01-15	AAM.A-DELISTED	Stock	24.16	24.3486	24.0001	24.175	48064.0
2019-01-15	AAM.B-DELISTED	Stock	24.14	24.4	24.0154	24.2	79739.0
2019-01-15	AAMC-DELISTED	Stock	8.9765	9.0291	8.6838	8.8	16694.0
2019-01-15	AAME	Stock	2.55	2.67	2.46	2.67	8800.0
2019-01-15	AAMI	Stock	11.2	11.37	11.12	11.36	598000.0
2019-01-15	AAOI	Stock	16.0	16.36	15.68	16.16	324300.0
2019-01-15	AAON	Stock	23.6533	23.8667	23.2533	23.62	122400.0
2019-01-15	AAP	Stock	158.62	162.32	158.03	160.28	1023700.0
2019-01-15	AAT	Stock	40.54	40.87	40.44	40.57	204900.0
2019-01-15	AAU-DELISTED	Stock	0.81	0.822	0.8	0.8025	115513.0
2019-01-15	AAUAF-DELISTED	Stock	0.81	0.822	0.8	0.8025	122236.0
2019-01-15	AAWW-DELISTED	Stock	47.8	48.22	47.0	47.745	203203.0
2019-01-15	AAXJ	Stock	65.28	65.7	65.21	65.34	1552568.0
2019-01-15	AAXN-DELISTED	Stock	50.13	50.4	49.02	49.34	310762.0
2019-01-15	AB	Stock	28.14	28.85	28.14	28.84	225000.0
2019-01-15	ABAC-DELISTED	Stock	1.5001	1.7125	1.5001	1.59	22229.0
2019-01-15	ABB-DELISTED	Stock	19.33	19.4	19.205	19.27	1780495.0
2019-01-15	ABBNY-DELISTED	Stock	19.33	19.4	19.205	19.26	1838165.0
2019-01-15	ABBV	Stock	84.93	85.68	84.45	85.5	7295500.0
2019-01-15	ABC-DELISTED	Stock	76.99	77.74	76.39	77.25	1429492.0
2019-01-15	ABCB	Stock	34.38	34.77	33.68	34.41	208700.0
2019-01-15	ABDC-DELISTED	Stock	6.85	6.85	6.8263	6.84	122405.0
2019-01-15	ABEO	Stock	175.0	182.25	174.0	180.25	10612.0
2019-01-15	ABEOW-DELISTED	Stock	2.72	2.72	2.72	2.72	1000.0
2019-01-15	ABEV	Stock	4.7	4.75	4.69	4.73	41402300.0
2019-01-15	ABG	Stock	69.17	70.08	67.82	69.39	217500.0
2019-01-15	ABIL-DELISTED	Stock	2.38	2.51	2.02	2.06	5612250.0
2019-01-15	ABM	Stock	34.01	34.72	33.6	34.55	486600.0
2019-01-15	ABMD-DELISTED	Stock	316.62	327.57	316.62	325.61	216757.0
2019-01-15	ABR	Stock	11.41	11.43	11.26	11.35	672100.0
2019-01-15	ABR.A-DELISTED	Stock	25.5302	25.58	25.4334	25.45	5250.0
2019-01-15	ABR.B-DELISTED	Stock	25.21	25.21	25.167	25.167	560.0
2019-01-15	ABT	Stock	68.41	70.52	68.36	70.47	6306900.0

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

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