PREVIEW / stock_daily / 2018-08-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-08.parquet
  size:    218 KB
  rows:    6,470
  symbols: 2,731

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-08	AAPL	Stock	51.5125	51.9525	51.13	51.8125	90102000.0
2018-08-08	MSFT	Stock	109.33	109.75	108.76	109.49	15487500.0
2018-08-08	NVDA	Stock	6.425	6.506	6.3898	6.4605	262100000.0
2018-08-08	AMZN	Stock	93.05	94.5755	92.725	94.326	79260000.0
2018-08-08	GOOGL	Stock	62.836	63.586	62.606	63.0665	34373280.0
2018-08-08	META	Stock	184.75	186.85	183.76	185.18	22205200.0
2018-08-08	TSLA	Stock	24.606	25.5093	24.4747	24.6893	368568000.0
2018-08-08	TLT	Stock	118.66	119.025	118.61	118.79	5641629.0
2018-08-08	ES	Stock	60.74	61.15	60.49	60.95	942700.0
2018-08-08	CL	Stock	67.07	67.16	66.57	66.59	1910500.0
2018-08-08	A	Stock	67.74	68.15	67.34	67.38	1681900.0
2018-08-08	AA	Stock	42.0	44.32	41.945	43.7	6483900.0
2018-08-08	AABA-DELISTED	Stock	71.75	71.75	70.46	70.88	16215580.0
2018-08-08	AAC-DELISTED	Stock	8.83	9.59	8.65	8.75	179984.0
2018-08-08	AACG	Stock	5.7	6.15	5.66	5.8	266100.0
2018-08-08	AAIC-DELISTED	Stock	10.22	10.28	10.121	10.23	350833.0
2018-08-08	AAL	Stock	38.41	38.86	38.22	38.38	3886500.0
2018-08-08	AAM.A-DELISTED	Stock	25.42	25.49	25.42	25.43	9318.0
2018-08-08	AAM.B-DELISTED	Stock	25.04	25.06	25.0	25.06	29537.0
2018-08-08	AAME	Stock	2.5	2.5	2.5	2.5	500.0
2018-08-08	AAMI	Stock	12.58	12.67	12.42	12.43	806800.0
2018-08-08	AAOI	Stock	46.0	46.0	40.28	40.92	5947100.0
2018-08-08	AAON	Stock	25.8667	26.1333	25.6333	25.9	222750.0
2018-08-08	AAP	Stock	145.32	146.76	145.1	146.41	530900.0
2018-08-08	AAT	Stock	38.66	38.75	38.29	38.62	159400.0
2018-08-08	AAU-DELISTED	Stock	0.6588	0.6621	0.65	0.6507	80162.0
2018-08-08	AAUAF-DELISTED	Stock	0.6588	0.6621	0.65	0.6507	81358.0
2018-08-08	AAV-DELISTED	Stock	3.1	3.15	3.05	3.125	401030.0
2018-08-08	AAWW-DELISTED	Stock	62.5	63.1	61.45	61.8	216857.0
2018-08-08	AAXJ	Stock	72.18	72.28	71.83	72.22	393612.0
2018-08-08	AAXN-DELISTED	Stock	62.84	63.19	56.09	59.78	3788396.0
2018-08-08	AB	Stock	29.0	29.6	28.95	29.4	207200.0
2018-08-08	ABAC-DELISTED	Stock	2.15	2.25	2.15	2.25	2572.0
2018-08-08	ABB-DELISTED	Stock	23.28	23.28	23.13	23.15	1544966.0
2018-08-08	ABBNY-DELISTED	Stock	23.28	23.28	23.13	23.16	1934352.0
2018-08-08	ABBV	Stock	93.52	94.08	92.87	93.73	4535100.0
2018-08-08	ABC-DELISTED	Stock	83.24	83.56	81.478	82.67	1184556.0
2018-08-08	ABCB	Stock	48.7	49.65	48.55	49.4	449600.0
2018-08-08	ABCD-DELISTED	Stock	11.72	11.8	11.56	11.66	100129.0
2018-08-08	ABDC-DELISTED	Stock	6.24	6.24	6.06	6.18	19687.0
2018-08-08	ABEO	Stock	367.5	373.75	362.5	367.5	9544.0
2018-08-08	ABEV	Stock	5.05	5.16	5.04	5.1	41509700.0
2018-08-08	ABG	Stock	74.4	75.6	74.15	75.45	153900.0
2018-08-08	ABIL-DELISTED	Stock	4.8	8.57	4.73	6.505	21494106.0
2018-08-08	ABM	Stock	31.5	31.51	31.26	31.38	369100.0
2018-08-08	ABMD-DELISTED	Stock	376.42	380.31	371.21	376.03	322894.0
2018-08-08	ABR	Stock	11.51	11.51	11.27	11.32	1653000.0
2018-08-08	ABR.A-DELISTED	Stock	25.982	26.05	25.982	26.032	736.0
2018-08-08	ABR.C-DELISTED	Stock	26.3	26.33	26.2976	26.2976	1508.0
2018-08-08	ABT	Stock	64.74	65.31	64.56	64.84	4103100.0

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

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