PREVIEW / stock_daily / 2018-09-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-24.parquet
  size:    219 KB
  rows:    6,541
  symbols: 2,747

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-09-24	AAPL	Stock	54.205	55.315	54.1575	55.1975	110773600.0
2018-09-24	MSFT	Stock	113.03	114.9	112.22	114.67	27334500.0
2018-09-24	NVDA	Stock	6.555	6.646	6.467	6.6425	293912000.0
2018-09-24	AMZN	Stock	95.1895	96.844	93.25	96.718	84274000.0
2018-09-24	GOOGL	Stock	57.9705	59.2595	57.575	58.978	31149580.0
2018-09-24	META	Stock	161.03	165.7	160.88	165.41	19222800.0
2018-09-24	TSLA	Stock	19.8987	20.2	19.572	19.9787	72645000.0
2018-09-24	TLT	Stock	116.74	117.27	116.72	116.8	5505769.0
2018-09-24	ES	Stock	61.99	62.27	61.43	61.48	1131300.0
2018-09-24	CL	Stock	68.98	69.17	67.85	67.94	2734100.0
2018-09-24	A	Stock	70.68	70.68	69.7	69.95	2333600.0
2018-09-24	AA	Stock	43.01	43.69	41.91	41.96	4054300.0
2018-09-24	AABA-DELISTED	Stock	67.12	67.64	66.52	67.59	4619593.0
2018-09-24	AAC-DELISTED	Stock	7.4	7.41	7.2	7.25	102734.0
2018-09-24	AACG	Stock	1.13	1.13	1.02	1.03	119300.0
2018-09-24	AAIC-DELISTED	Stock	10.15	10.19	10.11	10.12	486805.0
2018-09-24	AAL	Stock	43.27	43.3	41.85	41.98	7105100.0
2018-09-24	AAM.A-DELISTED	Stock	25.142	25.18	25.1	25.1	16613.0
2018-09-24	AAM.B-DELISTED	Stock	24.778	24.85	24.71	24.76	23896.0
2018-09-24	AAMC-DELISTED	Stock	17.5147	17.7132	17.3235	17.7132	4362.0
2018-09-24	AAME	Stock	2.4	2.65	2.4	2.65	3600.0
2018-09-24	AAMI	Stock	12.92	12.935	12.65	12.72	524300.0
2018-09-24	AAOI	Stock	32.64	33.47	32.54	33.21	743200.0
2018-09-24	AAON	Stock	26.6	26.6667	25.9	26.2	243150.0
2018-09-24	AAP	Stock	167.7	168.5	167.01	167.65	894900.0
2018-09-24	AAT	Stock	37.48	37.6	36.65	36.84	164300.0
2018-09-24	AAU-DELISTED	Stock	0.65	0.65	0.6113	0.6298	90906.0
2018-09-24	AAUAF-DELISTED	Stock	0.65	0.65	0.6113	0.6298	93112.0
2018-09-24	AAWW-DELISTED	Stock	63.25	64.2	61.0	62.35	283200.0
2018-09-24	AAXJ	Stock	70.3	70.48	70.05	70.44	714342.0
2018-09-24	AAXN-DELISTED	Stock	64.35	64.87	63.2	63.62	515681.0
2018-09-24	AB	Stock	30.5	30.55	30.2	30.35	168500.0
2018-09-24	ABAC-DELISTED	Stock	2.24	2.254	2.1	2.1	23452.0
2018-09-24	ABB-DELISTED	Stock	24.28	24.29	23.97	23.98	970993.0
2018-09-24	ABBNY-DELISTED	Stock	24.28	24.29	23.97	23.99	1091809.0
2018-09-24	ABBV	Stock	92.3	93.98	91.95	93.42	5910300.0
2018-09-24	ABC-DELISTED	Stock	89.63	90.19	88.44	89.57	822863.0
2018-09-24	ABCB	Stock	48.4	48.4	47.15	47.45	263100.0
2018-09-24	ABCD-DELISTED	Stock	12.03	12.14	11.81	11.87	90250.0
2018-09-24	ABDC-DELISTED	Stock	6.32	6.34	6.24	6.33	18462.0
2018-09-24	ABEO	Stock	317.5	348.25	316.0	343.25	25728.0
2018-09-24	ABEOW-DELISTED	Stock	8.53	8.53	8.53	8.53	1000.0
2018-09-24	ABEV	Stock	4.63	4.64	4.48	4.5	33766100.0
2018-09-24	ABG	Stock	72.2	72.8	70.45	71.2	223300.0
2018-09-24	ABIL-DELISTED	Stock	4.5	4.65	4.02	4.15	599458.0
2018-09-24	ABM	Stock	33.8	33.8	32.98	33.2	335400.0
2018-09-24	ABMD-DELISTED	Stock	381.03	422.91	378.0	419.54	746757.0
2018-09-24	ABR	Stock	11.65	11.67	11.45	11.45	905900.0
2018-09-24	ABR.A-DELISTED	Stock	25.6607	25.6607	25.6607	25.6607	220.0
2018-09-24	ABR.B-DELISTED	Stock	25.66	25.67	25.5331	25.5431	800.0

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

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