PREVIEW / stock_daily / 2018-07-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-24.parquet
  size:    219 KB
  rows:    6,536
  symbols: 2,792

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-07-24	AAPL	Stock	48.1125	48.415	48.0125	48.25	74791600.0
2018-07-24	MSFT	Stock	108.57	108.82	107.26	107.66	26316600.0
2018-07-24	NVDA	Stock	6.2838	6.3712	6.2	6.2178	354620000.0
2018-07-24	AMZN	Stock	91.4505	92.0	90.469	91.462	85574000.0
2018-07-24	GOOGL	Stock	63.55	63.75	62.207	62.9075	107600640.0
2018-07-24	META	Stock	215.11	216.2	212.6	214.67	28468700.0
2018-07-24	TSLA	Stock	20.2947	20.5147	19.5033	19.8287	143862000.0
2018-07-24	TLT	Stock	119.28	119.815	119.14	119.68	9053492.0
2018-07-24	ES	Stock	58.29	58.99	57.49	58.82	2083200.0
2018-07-24	CL	Stock	65.52	65.71	64.93	65.27	5407100.0
2018-07-24	A	Stock	63.94	65.35	63.69	64.79	2454400.0
2018-07-24	AA	Stock	42.35	43.1	42.0	42.49	8243900.0
2018-07-24	AABA-DELISTED	Stock	74.16	75.66	73.9108	74.15	7879223.0
2018-07-24	AAC-DELISTED	Stock	9.79	10.07	9.63	9.66	138461.0
2018-07-24	AACG	Stock	4.25	4.45	4.24	4.24	4000.0
2018-07-24	AAIC-DELISTED	Stock	10.0	10.14	10.0	10.09	383772.0
2018-07-24	AAL	Stock	38.19	38.39	37.04	37.45	6415100.0
2018-07-24	AAM.A-DELISTED	Stock	25.39	25.448	25.3065	25.31	24249.0
2018-07-24	AAM.B-DELISTED	Stock	24.9	25.04	24.9	24.95	75521.0
2018-07-24	AAME	Stock	2.6	2.6	2.5	2.6	5700.0
2018-07-24	AAMI	Stock	14.07	14.27	14.055	14.11	499400.0
2018-07-24	AAOI	Stock	42.31	42.38	37.91	38.26	1866200.0
2018-07-24	AAON	Stock	24.4667	24.7667	23.9667	24.2333	349200.0
2018-07-24	AAP	Stock	145.1	145.15	139.44	139.99	800400.0
2018-07-24	AAT	Stock	37.5	37.56	37.25	37.39	354500.0
2018-07-24	AAU-DELISTED	Stock	0.69	0.7	0.6858	0.697	47703.0
2018-07-24	AAUAF-DELISTED	Stock	0.69	0.7	0.6858	0.697	58673.0
2018-07-24	AAV-DELISTED	Stock	3.2	3.5	3.16	3.475	224226.0
2018-07-24	AAWW-DELISTED	Stock	69.15	69.25	67.0	67.85	210250.0
2018-07-24	AAXJ	Stock	72.58	72.87	72.34	72.5	869717.0
2018-07-24	AAXN-DELISTED	Stock	75.25	76.4544	70.78	72.24	1027816.0
2018-07-24	AB	Stock	30.45	30.7	30.2	30.3	287400.0
2018-07-24	ABAC-DELISTED	Stock	2.17	2.27	2.17	2.18	15135.0
2018-07-24	ABAX-DELISTED	Stock	83.17	83.19	83.08	83.101	73572.0
2018-07-24	ABB-DELISTED	Stock	22.54	22.6	22.43	22.47	1960894.0
2018-07-24	ABBNY-DELISTED	Stock	22.54	22.6	22.43	22.47	2080372.0
2018-07-24	ABBV	Stock	90.51	91.61	89.75	91.54	7965000.0
2018-07-24	ABC-DELISTED	Stock	84.85	85.58	83.79	83.93	789343.0
2018-07-24	ABCB	Stock	52.2	52.2	50.55	50.85	232500.0
2018-07-24	ABCD-DELISTED	Stock	12.2	12.75	12.1793	12.38	286447.0
2018-07-24	ABDC-DELISTED	Stock	6.51	6.51	6.29	6.43	16931.0
2018-07-24	ABEO	Stock	350.0	353.75	327.5	327.5	23768.0
2018-07-24	ABEV	Stock	4.99	5.06	4.93	4.99	29389000.0
2018-07-24	ABG	Stock	70.65	73.35	69.4	69.95	327800.0
2018-07-24	ABIL-DELISTED	Stock	5.0	5.06	4.35	4.4	114695.0
2018-07-24	ABM	Stock	29.94	30.21	29.65	29.87	376800.0
2018-07-24	ABMD-DELISTED	Stock	434.0	436.42	419.4073	423.39	357599.0
2018-07-24	ABR	Stock	11.12	11.18	11.04	11.08	1458900.0
2018-07-24	ABR.A-DELISTED	Stock	26.0379	26.07	25.89	26.0025	1441.0
2018-07-24	ABR.B-DELISTED	Stock	25.5	25.5384	25.5	25.5384	262.0

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

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