PREVIEW / stock_daily / 2018-09-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-19.parquet
  size:    218 KB
  rows:    6,516
  symbols: 2,734

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-19	AAPL	Stock	54.625	54.905	53.825	54.5925	108495200.0
2018-09-19	MSFT	Stock	113.05	113.32	111.04	111.7	21728400.0
2018-09-19	NVDA	Stock	6.7568	6.8175	6.7062	6.7995	224860000.0
2018-09-19	AMZN	Stock	97.025	97.0415	95.245	96.321	81136000.0
2018-09-19	GOOGL	Stock	58.448	58.8135	57.9308	58.7135	25961680.0
2018-09-19	META	Stock	160.08	163.44	159.48	163.06	19629000.0
2018-09-19	TSLA	Stock	18.7007	20.0	18.7	19.9347	124423500.0
2018-09-19	TLT	Stock	117.105	117.11	116.19	116.61	13379645.0
2018-09-19	ES	Stock	63.6	63.6	61.68	62.03	1391900.0
2018-09-19	CL	Stock	68.25	68.59	67.9	67.93	3017100.0
2018-09-19	A	Stock	69.04	69.64	68.88	69.56	1183400.0
2018-09-19	AA	Stock	43.05	43.12	42.13	42.63	3010300.0
2018-09-19	AABA-DELISTED	Stock	65.43	67.3	65.43	67.13	7611383.0
2018-09-19	AAC-DELISTED	Stock	7.24	7.36	6.72	6.75	302466.0
2018-09-19	AACG	Stock	1.26	1.29	1.2	1.23	63000.0
2018-09-19	AAIC-DELISTED	Stock	10.15	10.21	10.06	10.06	380902.0
2018-09-19	AAL	Stock	40.79	41.77	40.7	41.6	7413600.0
2018-09-19	AAM.A-DELISTED	Stock	25.32	25.32	25.1	25.101	24346.0
2018-09-19	AAM.B-DELISTED	Stock	24.88	24.88	24.67	24.69	41444.0
2018-09-19	AAMC-DELISTED	Stock	17.6471	18.3088	17.4265	18.1176	9731.0
2018-09-19	AAME	Stock	2.6	2.9	2.6	2.9	1200.0
2018-09-19	AAMI	Stock	12.7	12.95	12.7	12.85	323700.0
2018-09-19	AAOI	Stock	32.65	32.78	31.1	31.18	1404000.0
2018-09-19	AAON	Stock	26.6	26.7333	25.9333	26.0667	295050.0
2018-09-19	AAP	Stock	167.92	169.99	167.34	169.6	1110400.0
2018-09-19	AAT	Stock	38.3	38.3	37.06	37.14	308600.0
2018-09-19	AAU-DELISTED	Stock	0.675	0.675	0.58	0.617	299689.0
2018-09-19	AAUAF-DELISTED	Stock	0.675	0.675	0.58	0.617	303366.0
2018-09-19	AAV-DELISTED	Stock	2.55	2.6	2.5	2.575	101033.0
2018-09-19	AAWW-DELISTED	Stock	63.2	64.3	61.286	63.7	258802.0
2018-09-19	AAXJ	Stock	69.83	70.38	69.83	70.3	529105.0
2018-09-19	AAXN-DELISTED	Stock	68.89	69.3	66.225	67.38	602490.0
2018-09-19	AB	Stock	30.2	30.75	30.2	30.55	171200.0
2018-09-19	ABAC-DELISTED	Stock	2.4	2.4	2.02	2.1	28014.0
2018-09-19	ABB-DELISTED	Stock	24.1	24.19	24.07	24.095	1664763.0
2018-09-19	ABBNY-DELISTED	Stock	24.1	24.19	24.07	24.1	4452795.0
2018-09-19	ABBV	Stock	91.71	92.24	90.4	91.02	8451400.0
2018-09-19	ABC-DELISTED	Stock	87.45	89.89	87.13	89.39	1230157.0
2018-09-19	ABCB	Stock	47.0	47.9	47.0	47.3	391900.0
2018-09-19	ABCD-DELISTED	Stock	12.49	12.49	11.84	12.0	99372.0
2018-09-19	ABDC-DELISTED	Stock	6.22	6.3	6.15	6.15	33802.0
2018-09-19	ABEO	Stock	343.75	350.0	340.0	345.0	10444.0
2018-09-19	ABEV	Stock	4.53	4.61	4.49	4.57	37776300.0
2018-09-19	ABG	Stock	70.75	72.05	70.75	72.0	211700.0
2018-09-19	ABIL-DELISTED	Stock	3.44	3.56	3.33	3.42	82143.0
2018-09-19	ABM	Stock	34.86	35.01	33.62	33.73	942300.0
2018-09-19	ABMD-DELISTED	Stock	377.0	380.53	366.91	376.75	314050.0
2018-09-19	ABR	Stock	11.99	11.99	11.58	11.71	1915200.0
2018-09-19	ABR.A-DELISTED	Stock	25.86	25.86	25.58	25.6001	2110.0
2018-09-19	ABR.C-DELISTED	Stock	25.7	25.87	25.7	25.87	2050.0

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

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