PREVIEW / stock_daily / 2018-07-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-27.parquet
  size:    218 KB
  rows:    6,487
  symbols: 2,739

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-27	AAPL	Stock	48.7475	48.7975	47.525	47.745	96096000.0
2018-07-27	MSFT	Stock	110.18	110.18	106.14	107.68	37005300.0
2018-07-27	NVDA	Stock	6.408	6.415	6.246	6.3005	295420000.0
2018-07-27	AMZN	Stock	93.8025	94.0025	90.3265	90.8635	193620000.0
2018-07-27	GOOGL	Stock	64.456	64.572	62.2248	62.6445	48361800.0
2018-07-27	META	Stock	179.87	179.93	173.0	174.89	60073700.0
2018-07-27	TSLA	Stock	20.4833	20.5127	19.6893	19.812	85549500.0
2018-07-27	TLT	Stock	119.85	119.87	119.4	119.46	4542059.0
2018-07-27	ES	Stock	60.18	60.59	59.88	60.08	1167800.0
2018-07-27	CL	Stock	65.92	67.38	64.92	66.66	5497100.0
2018-07-27	A	Stock	66.65	66.77	65.36	65.75	2638900.0
2018-07-27	AA	Stock	42.86	43.48	42.363	43.22	3977500.0
2018-07-27	AABA-DELISTED	Stock	76.89	77.0	73.21	74.09	8533179.0
2018-07-27	AAC-DELISTED	Stock	10.35	10.42	10.23	10.3	106311.0
2018-07-27	AACG	Stock	4.38	4.52	4.38	4.52	1500.0
2018-07-27	AAIC-DELISTED	Stock	10.39	10.42	10.32	10.4	840287.0
2018-07-27	AAL	Stock	39.93	40.86	39.51	39.69	8445100.0
2018-07-27	AAM.A-DELISTED	Stock	25.48	25.48	25.351	25.4	5027.0
2018-07-27	AAM.B-DELISTED	Stock	25.0509	25.055	24.91	25.019	54511.0
2018-07-27	AAMC-DELISTED	Stock	19.1912	19.1912	18.7206	18.7206	694.0
2018-07-27	AAME	Stock	2.6	2.6	2.55	2.55	1400.0
2018-07-27	AAMI	Stock	14.05	14.17	14.0	14.06	875100.0
2018-07-27	AAOI	Stock	39.75	40.21	37.55	38.23	985900.0
2018-07-27	AAON	Stock	24.3333	24.5	24.2	24.4333	269100.0
2018-07-27	AAP	Stock	142.41	143.13	139.43	139.85	370300.0
2018-07-27	AAT	Stock	37.65	37.65	36.66	36.77	187400.0
2018-07-27	AAU-DELISTED	Stock	0.6635	0.67	0.64	0.665	182400.0
2018-07-27	AAUAF-DELISTED	Stock	0.6635	0.67	0.64	0.665	186077.0
2018-07-27	AAV-DELISTED	Stock	3.6	3.69	3.5	3.55	194484.0
2018-07-27	AAWW-DELISTED	Stock	68.05	68.45	66.75	67.25	146843.0
2018-07-27	AAXJ	Stock	73.36	73.36	72.58	72.9	365916.0
2018-07-27	AAXN-DELISTED	Stock	72.87	73.11	67.51	68.76	728132.0
2018-07-27	AB	Stock	30.5	30.55	30.25	30.3	265800.0
2018-07-27	ABAC-DELISTED	Stock	2.2	2.22	2.1723	2.18	14660.0
2018-07-27	ABAX-DELISTED	Stock	83.17	83.2	83.04	83.09	86692.0
2018-07-27	ABB-DELISTED	Stock	22.91	22.94	22.8	22.9	1245376.0
2018-07-27	ABBNY-DELISTED	Stock	22.89	22.94	22.8	22.9	1300553.0
2018-07-27	ABBV	Stock	91.34	92.27	88.77	90.56	12905800.0
2018-07-27	ABC-DELISTED	Stock	83.21	84.37	82.14	82.92	1110167.0
2018-07-27	ABCB	Stock	49.1	49.85	45.6	49.58	337300.0
2018-07-27	ABCD-DELISTED	Stock	12.8	12.8	11.95	12.2	148343.0
2018-07-27	ABDC-DELISTED	Stock	6.19	6.2066	6.09	6.1	62363.0
2018-07-27	ABEO	Stock	325.0	336.25	315.75	335.0	26704.0
2018-07-27	ABEV	Stock	5.37	5.44	5.27	5.28	39341000.0
2018-07-27	ABG	Stock	68.3	69.3	67.95	68.15	255000.0
2018-07-27	ABIL-DELISTED	Stock	3.9	3.9	3.5	3.5801	36071.0
2018-07-27	ABM	Stock	30.85	31.13	30.73	30.82	526600.0
2018-07-27	ABMD-DELISTED	Stock	390.53	392.0	366.11	368.84	701900.0
2018-07-27	ABR	Stock	11.19	11.19	11.08	11.16	1023500.0
2018-07-27	ABR.A-DELISTED	Stock	26.0603	26.099	26.0603	26.0847	3454.0

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

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