PREVIEW / stock_daily / 2019-01-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-30.parquet
  size:    220 KB
  rows:    6,543
  symbols: 2,652

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
2019-01-30	AAPL	Stock	40.8125	41.5375	40.0575	41.3125	244439200.0
2019-01-30	MSFT	Stock	104.62	106.38	104.33	106.38	49471900.0
2019-01-30	NVDA	Stock	3.3668	3.4492	3.2865	3.4348	974228000.0
2019-01-30	AMZN	Stock	81.15	83.8475	80.984	83.5215	115676000.0
2019-01-30	GOOGL	Stock	53.868	54.976	53.832	54.8995	29452940.0
2019-01-30	META	Stock	146.22	150.95	145.7	150.42	44613200.0
2019-01-30	TSLA	Stock	20.03	20.6	19.8993	20.5847	168754500.0
2019-01-30	TLT	Stock	120.84	120.98	120.33	120.93	10571325.0
2019-01-30	ES	Stock	66.94	67.76	66.87	67.58	1515900.0
2019-01-30	CL	Stock	63.66	64.34	63.46	63.95	6663900.0
2019-01-30	A	Stock	73.74	75.59	73.48	75.44	1679500.0
2019-01-30	AA	Stock	29.1	29.82	28.67	29.59	6502400.0
2019-01-30	AABA-DELISTED	Stock	66.28	68.48	66.05	67.96	11051395.0
2019-01-30	AAC-DELISTED	Stock	2.3	2.41	2.22	2.3	142275.0
2019-01-30	AACG	Stock	1.05	1.05	1.0	1.01	16700.0
2019-01-30	AAIC-DELISTED	Stock	8.57	8.69	8.5276	8.65	264462.0
2019-01-30	AAL	Stock	36.43	36.68	36.17	36.34	7435600.0
2019-01-30	AAM.A-DELISTED	Stock	24.5062	24.6055	24.38	24.6055	24430.0
2019-01-30	AAM.B-DELISTED	Stock	24.45	24.5	24.25	24.4801	86813.0
2019-01-30	AAME	Stock	2.5	2.56	2.5	2.53	4500.0
2019-01-30	AAMI	Stock	12.56	12.57	12.29	12.38	577400.0
2019-01-30	AAOI	Stock	17.04	17.47	16.16	17.32	670500.0
2019-01-30	AAON	Stock	24.1	24.16	23.5867	24.14	127350.0
2019-01-30	AAP	Stock	156.19	160.2	155.6	159.04	1016500.0
2019-01-30	AAT	Stock	42.13	42.71	41.98	42.51	181400.0
2019-01-30	AAU-DELISTED	Stock	0.75	0.7628	0.7228	0.7463	148557.0
2019-01-30	AAUAF-DELISTED	Stock	0.75	0.7628	0.7228	0.7463	152273.0
2019-01-30	AAWW-DELISTED	Stock	51.49	52.91	50.3	52.9	292481.0
2019-01-30	AAXJ	Stock	67.59	68.5532	67.31	68.34	1637673.0
2019-01-30	AAXN-DELISTED	Stock	49.08	49.94	48.04	49.75	320481.0
2019-01-30	AB	Stock	30.15	30.4	29.9	30.03	349100.0
2019-01-30	ABB-DELISTED	Stock	19.12	19.39	19.055	19.35	2671598.0
2019-01-30	ABBNY-DELISTED	Stock	19.12	19.39	19.055	19.36	4632960.0
2019-01-30	ABBV	Stock	77.69	79.19	76.98	79.06	9277200.0
2019-01-30	ABC-DELISTED	Stock	79.73	80.14	78.33	78.53	1608129.0
2019-01-30	ABCB	Stock	38.29	38.29	37.29	37.86	374800.0
2019-01-30	ABDC-DELISTED	Stock	7.01	7.23	7.0	7.23	65978.0
2019-01-30	ABEO	Stock	162.25	165.5	159.5	164.75	13976.0
2019-01-30	ABEOW-DELISTED	Stock	2.47	2.47	2.47	2.47	100.0
2019-01-30	ABEV	Stock	4.78	4.84	4.68	4.82	22517500.0
2019-01-30	ABG	Stock	69.39	70.37	68.74	70.22	191600.0
2019-01-30	ABIL-DELISTED	Stock	2.08	2.09	2.0	2.02	195214.0
2019-01-30	ABM	Stock	33.54	33.54	32.74	33.51	621400.0
2019-01-30	ABMD-DELISTED	Stock	331.11	339.91	327.38	339.34	298010.0
2019-01-30	ABR	Stock	11.69	11.84	11.59	11.84	982800.0
2019-01-30	ABR.A-DELISTED	Stock	25.7126	25.7126	25.7126	25.7126	200.0
2019-01-30	ABR.B-DELISTED	Stock	25.66	25.7	25.4415	25.4415	2100.0
2019-01-30	ABR.C-DELISTED	Stock	25.52	25.83	25.52	25.57	6680.0
2019-01-30	ABT	Stock	69.91	71.8	69.69	71.68	8145000.0
2019-01-30	ABTC	Stock	305400.0	305400.0	302850.0	302850.0	1.04

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

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