PREVIEW / stock_daily / 2018-08-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-03.parquet
  size:    218 KB
  rows:    6,493
  symbols: 2,742

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-08-03	AAPL	Stock	51.7575	52.185	51.37	51.9975	133789600.0
2018-08-03	MSFT	Stock	107.8	108.05	106.82	108.04	18659600.0
2018-08-03	NVDA	Stock	6.2902	6.3265	6.2733	6.3025	214288000.0
2018-08-03	AMZN	Stock	91.887	92.05	91.075	91.1645	69210000.0
2018-08-03	GOOGL	Stock	62.259	62.326	61.471	61.908	21264880.0
2018-08-03	META	Stock	177.69	178.85	176.15	177.78	24763400.0
2018-08-03	TSLA	Stock	23.1873	23.6667	22.8353	23.2113	204847500.0
2018-08-03	TLT	Stock	118.83	119.29	118.81	119.22	6162443.0
2018-08-03	ES	Stock	60.15	61.0	59.73	60.93	1328100.0
2018-08-03	CL	Stock	67.37	68.43	66.83	67.5	4324100.0
2018-08-03	A	Stock	65.5	65.79	64.96	65.73	1857300.0
2018-08-03	AA	Stock	42.54	43.3	42.31	42.72	2101600.0
2018-08-03	AABA-DELISTED	Stock	72.74	72.75	71.31	71.57	17352208.0
2018-08-03	AAC-DELISTED	Stock	8.72	9.38	8.6818	9.38	296818.0
2018-08-03	AACG	Stock	4.49	4.55	4.49	4.55	1200.0
2018-08-03	AAIC-DELISTED	Stock	10.43	10.485	10.36	10.39	296753.0
2018-08-03	AAL	Stock	38.06	38.62	38.05	38.42	3975100.0
2018-08-03	AAM.A-DELISTED	Stock	25.4094	25.4502	25.35	25.356	7003.0
2018-08-03	AAM.B-DELISTED	Stock	25.02	25.04	24.89	24.97	87418.0
2018-08-03	AAMC-DELISTED	Stock	18.2353	19.2353	18.2279	18.3088	5307.0
2018-08-03	AAMI	Stock	12.39	12.56	12.22	12.27	678000.0
2018-08-03	AAOI	Stock	38.34	39.68	38.205	39.42	1219100.0
2018-08-03	AAON	Stock	24.9333	25.6	24.7333	25.5333	423300.0
2018-08-03	AAP	Stock	144.25	145.66	143.03	144.68	535000.0
2018-08-03	AAT	Stock	38.42	38.9	38.31	38.87	192200.0
2018-08-03	AAU-DELISTED	Stock	0.65	0.67	0.64	0.6521	135108.0
2018-08-03	AAUAF-DELISTED	Stock	0.65	0.67	0.64	0.6521	142210.0
2018-08-03	AAV-DELISTED	Stock	3.35	3.425	3.25	3.3	197803.0
2018-08-03	AAWW-DELISTED	Stock	64.85	65.75	62.9	63.1	283857.0
2018-08-03	AAXJ	Stock	71.43	71.72	71.38	71.55	1292871.0
2018-08-03	AAXN-DELISTED	Stock	70.64	71.0	67.93	69.09	333274.0
2018-08-03	AB	Stock	27.7	28.35	27.41	28.1	541400.0
2018-08-03	ABAC-DELISTED	Stock	2.1316	2.22	2.12	2.16	3271.0
2018-08-03	ABB-DELISTED	Stock	22.64	22.71	22.59	22.71	696005.0
2018-08-03	ABBNY-DELISTED	Stock	22.64	22.71	22.59	22.71	748287.0
2018-08-03	ABBV	Stock	94.89	96.85	94.82	96.53	4876100.0
2018-08-03	ABC-DELISTED	Stock	78.98	81.34	78.22	80.97	1686701.0
2018-08-03	ABCB	Stock	49.7	49.9	48.38	48.9	585800.0
2018-08-03	ABCD-DELISTED	Stock	12.62	12.8	11.84	11.87	204441.0
2018-08-03	ABDC-DELISTED	Stock	6.2	6.27	6.15	6.27	59003.0
2018-08-03	ABEO	Stock	355.0	357.5	348.25	352.5	10536.0
2018-08-03	ABEV	Stock	5.14	5.26	5.12	5.19	26870100.0
2018-08-03	ABG	Stock	71.65	72.85	71.65	72.85	261800.0
2018-08-03	ABIL-DELISTED	Stock	2.91	3.0946	2.77	2.9445	19315.0
2018-08-03	ABM	Stock	31.11	31.32	30.98	31.12	406700.0
2018-08-03	ABMD-DELISTED	Stock	393.72	396.97	371.385	376.77	738473.0
2018-08-03	ABR	Stock	11.49	11.75	11.42	11.74	1865200.0
2018-08-03	ABR.A-DELISTED	Stock	25.9	25.9	25.87	25.87	2360.0
2018-08-03	ABR.B-DELISTED	Stock	25.65	25.65	25.573	25.573	1890.0
2018-08-03	ABR.C-DELISTED	Stock	26.4906	26.4906	26.4653	26.4653	690.0

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

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