PREVIEW / stock_daily / 2018-09-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-04.parquet
  size:    218 KB
  rows:    6,525
  symbols: 2,757

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-04	AAPL	Stock	57.1025	57.295	56.6575	57.09	109560400.0
2018-09-04	MSFT	Stock	110.85	111.96	110.22	111.71	22634600.0
2018-09-04	NVDA	Stock	7.0038	7.1305	6.975	7.0925	391720000.0
2018-09-04	AMZN	Stock	101.325	102.525	100.65	101.9755	114422000.0
2018-09-04	GOOGL	Stock	61.126	61.3935	60.328	60.5655	41457380.0
2018-09-04	META	Stock	173.5	173.89	168.8	171.16	29809000.0
2018-09-04	TSLA	Stock	19.796	19.8793	19.2	19.2633	125257500.0
2018-09-04	TLT	Stock	119.96	120.095	119.75	120.03	18343553.0
2018-09-04	ES	Stock	62.48	62.96	62.3	62.42	1314100.0
2018-09-04	CL	Stock	65.74	65.99	65.01	65.23	4515900.0
2018-09-04	A	Stock	67.34	67.56	66.85	67.27	1728000.0
2018-09-04	AA	Stock	43.88	43.919	43.1	43.36	2045100.0
2018-09-04	AABA-DELISTED	Stock	69.12	69.14	67.66	67.9103	5369567.0
2018-09-04	AAC-DELISTED	Stock	8.75	8.75	8.43	8.5	164327.0
2018-09-04	AACG	Stock	2.2	2.57	2.15	2.22	926000.0
2018-09-04	AAIC-DELISTED	Stock	10.16	10.25	10.13	10.22	356579.0
2018-09-04	AAL	Stock	40.32	41.34	40.32	40.77	7123200.0
2018-09-04	AAM.A-DELISTED	Stock	25.69	25.75	25.5901	25.69	10718.0
2018-09-04	AAM.B-DELISTED	Stock	25.2	25.2	25.11	25.15	68540.0
2018-09-04	AAME	Stock	3.2	3.2	2.66	2.85	9200.0
2018-09-04	AAMI	Stock	12.65	12.75	12.59	12.72	463600.0
2018-09-04	AAOI	Stock	41.27	41.27	36.05	36.72	3086500.0
2018-09-04	AAON	Stock	26.8	26.9	26.1	26.5667	345750.0
2018-09-04	AAP	Stock	164.51	169.59	164.2	169.48	1371600.0
2018-09-04	AAT	Stock	39.34	39.5	38.62	38.83	164200.0
2018-09-04	AAU-DELISTED	Stock	0.645	0.645	0.6244	0.63	50306.0
2018-09-04	AAUAF-DELISTED	Stock	0.645	0.645	0.6244	0.63	59089.0
2018-09-04	AAV-DELISTED	Stock	2.9	2.9158	2.66	2.725	392325.0
2018-09-04	AAWW-DELISTED	Stock	61.15	62.5	60.25	61.25	177405.0
2018-09-04	AAXJ	Stock	70.71	70.71	70.35	70.6	814181.0
2018-09-04	AAXN-DELISTED	Stock	68.0	70.2363	67.15	69.84	477841.0
2018-09-04	AB	Stock	29.95	30.2	29.75	29.8	218300.0
2018-09-04	ABAC-DELISTED	Stock	1.724	1.759	1.51	1.5728	36652.0
2018-09-04	ABB-DELISTED	Stock	23.5	23.5	23.29	23.41	1930956.0
2018-09-04	ABBNY-DELISTED	Stock	23.5	23.5	23.29	23.42	3950078.0
2018-09-04	ABBV	Stock	95.97	95.97	94.08	94.56	4456100.0
2018-09-04	ABC-DELISTED	Stock	89.53	89.6	88.01	89.17	831931.0
2018-09-04	ABCB	Stock	49.7	50.25	49.55	49.85	319200.0
2018-09-04	ABCD-DELISTED	Stock	13.34	13.34	12.8116	13.14	108932.0
2018-09-04	ABDC-DELISTED	Stock	6.2	6.2	6.1	6.14	15210.0
2018-09-04	ABEO	Stock	385.0	388.75	376.25	377.5	15128.0
2018-09-04	ABEOW-DELISTED	Stock	10.4	10.4	10.4	10.4	100.0
2018-09-04	ABEV	Stock	4.45	4.45	4.32	4.33	41228600.0
2018-09-04	ABG	Stock	74.65	75.15	73.75	74.45	154600.0
2018-09-04	ABIL-DELISTED	Stock	3.84	3.99	3.6601	3.69	101043.0
2018-09-04	ABM	Stock	31.58	31.65	31.16	31.4	521500.0
2018-09-04	ABMD-DELISTED	Stock	402.06	413.79	400.011	411.36	320477.0
2018-09-04	ABR	Stock	12.26	12.35	11.91	11.96	2285800.0
2018-09-04	ABR.A-DELISTED	Stock	25.97	25.97	25.97	25.97	497.0
2018-09-04	ABR.B-DELISTED	Stock	25.42	25.42	25.42	25.42	150.0

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

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