PREVIEW / stock_daily / 2018-07-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-30.parquet
  size:    219 KB
  rows:    6,522
  symbols: 2,779

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-30	AAPL	Stock	47.975	48.05	47.2675	47.4775	84118000.0
2018-07-30	MSFT	Stock	107.19	107.53	104.76	105.37	34668300.0
2018-07-30	NVDA	Stock	6.3148	6.3208	6.068	6.1032	340340000.0
2018-07-30	AMZN	Stock	91.3665	91.475	88.301	88.961	131246000.0
2018-07-30	GOOGL	Stock	62.2525	62.6445	61.2085	61.502	43896740.0
2018-07-30	META	Stock	175.3	175.3	166.56	171.06	65280800.0
2018-07-30	TSLA	Stock	19.7267	19.74	19.0753	19.3447	102211500.0
2018-07-30	TLT	Stock	118.99	119.405	118.97	119.05	7111165.0
2018-07-30	ES	Stock	59.98	60.12	59.47	59.76	1863400.0
2018-07-30	CL	Stock	65.43	66.65	65.36	66.46	4801200.0
2018-07-30	A	Stock	65.87	66.07	64.51	64.63	1601200.0
2018-07-30	AA	Stock	43.38	43.68	42.32	42.58	2704100.0
2018-07-30	AABA-DELISTED	Stock	74.51	74.58	71.32	72.4	9238343.0
2018-07-30	AAC-DELISTED	Stock	10.3	10.51	10.3	10.47	75572.0
2018-07-30	AACG	Stock	4.27	4.35	4.27	4.35	2200.0
2018-07-30	AAIC-DELISTED	Stock	10.4	10.48	10.39	10.42	687032.0
2018-07-30	AAL	Stock	39.88	40.29	38.93	38.97	5746200.0
2018-07-30	AAM.A-DELISTED	Stock	25.5	25.5	25.32	25.33	30876.0
2018-07-30	AAM.B-DELISTED	Stock	24.9993	25.08	24.97	25.03	26557.0
2018-07-30	AAMC-DELISTED	Stock	18.3088	18.3088	17.9559	18.3088	6307.0
2018-07-30	AAME	Stock	2.55	2.55	2.35	2.48	1500.0
2018-07-30	AAMI	Stock	14.05	14.19	13.99	14.14	1334800.0
2018-07-30	AAOI	Stock	38.31	38.31	37.24	37.91	439000.0
2018-07-30	AAON	Stock	24.4667	24.7333	24.3	24.4333	316650.0
2018-07-30	AAP	Stock	139.85	141.4	139.59	140.68	428100.0
2018-07-30	AAT	Stock	36.84	37.53	36.57	37.49	295700.0
2018-07-30	AAU-DELISTED	Stock	0.655	0.67	0.64	0.64	166907.0
2018-07-30	AAUAF-DELISTED	Stock	0.655	0.67	0.64	0.6533	168637.0
2018-07-30	AAV-DELISTED	Stock	3.55	3.65	3.4	3.45	211599.0
2018-07-30	AAWW-DELISTED	Stock	67.05	68.5	65.55	65.65	356494.0
2018-07-30	AAXJ	Stock	72.93	72.99	72.35	72.56	886850.0
2018-07-30	AAXN-DELISTED	Stock	69.0	69.34	65.49	66.38	722787.0
2018-07-30	AB	Stock	30.5	30.65	30.35	30.45	471600.0
2018-07-30	ABAC-DELISTED	Stock	2.19	2.21	2.14	2.21	11599.0
2018-07-30	ABAX-DELISTED	Stock	83.1	83.18	83.04	83.11	326492.0
2018-07-30	ABB-DELISTED	Stock	22.97	23.0	22.825	22.85	1303743.0
2018-07-30	ABBNY-DELISTED	Stock	22.97	23.0	22.825	22.84	1384585.0
2018-07-30	ABBV	Stock	90.67	91.54	89.38	91.45	6466000.0
2018-07-30	ABC-DELISTED	Stock	83.11	84.49	82.55	82.93	1461881.0
2018-07-30	ABCB	Stock	49.3	49.8	48.4	48.45	1019800.0
2018-07-30	ABCD-DELISTED	Stock	12.18	12.27	11.88	11.9	69585.0
2018-07-30	ABDC-DELISTED	Stock	6.07	6.1	5.75	5.96	339982.0
2018-07-30	ABEO	Stock	335.0	343.75	323.75	342.5	31956.0
2018-07-30	ABEOW-DELISTED	Stock	8.5	8.5	8.5	8.5	200.0
2018-07-30	ABEV	Stock	5.27	5.29	5.23	5.25	31614500.0
2018-07-30	ABG	Stock	68.15	70.65	68.15	70.6	194900.0
2018-07-30	ABIL-DELISTED	Stock	3.5901	3.599	2.85	3.05	47184.0
2018-07-30	ABM	Stock	30.83	31.08	30.79	30.86	477700.0
2018-07-30	ABMD-DELISTED	Stock	365.92	366.34	351.13	356.42	771002.0
2018-07-30	ABR	Stock	11.35	11.47	11.23	11.37	1795600.0

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

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