PREVIEW / stock_daily / 2019-10-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-03.parquet
  size:    220 KB
  rows:    6,564
  symbols: 2,478

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-10-03	AAPL	Stock	54.6075	55.24	53.7825	55.205	114426000.0
2019-10-03	MSFT	Stock	134.95	136.75	133.22	136.28	24132900.0
2019-10-03	NVDA	Stock	4.3305	4.539	4.3	4.5328	450588000.0
2019-10-03	AMZN	Stock	85.65	86.25	84.253	86.221	69364000.0
2019-10-03	GOOGL	Stock	59.167	59.55	58.157	59.4715	29388260.0
2019-10-03	META	Stock	175.57	179.84	173.63	179.38	16086300.0
2019-10-03	TSLA	Stock	15.4573	15.632	14.952	15.5353	226267500.0
2019-10-03	TLT	Stock	143.98	145.67	143.92	144.92	13526957.0
2019-10-03	ES	Stock	84.52	84.71	84.0	84.66	1829600.0
2019-10-03	CL	Stock	70.81	71.41	70.44	70.87	2269700.0
2019-10-03	A	Stock	73.38	73.88	72.47	73.87	1869400.0
2019-10-03	AA	Stock	19.13	19.34	18.68	19.05	3504800.0
2019-10-03	AAC-DELISTED	Stock	0.6684	0.6992	0.66	0.6603	22741.0
2019-10-03	AACG	Stock	1.65	1.66	1.63	1.63	10100.0
2019-10-03	AAIC-DELISTED	Stock	5.3	5.335	5.23	5.3	244487.0
2019-10-03	AAIC.C-DELISTED	Stock	21.1007	21.1767	21.0039	21.13	2390.0
2019-10-03	AAL	Stock	25.47	25.51	24.51	25.27	8586400.0
2019-10-03	AAM.A-DELISTED	Stock	26.55	26.55	26.47	26.51	8561.0
2019-10-03	AAM.B-DELISTED	Stock	26.7745	26.83	26.7055	26.79	7739.0
2019-10-03	AAMC-DELISTED	Stock	2.9912	3.2652	2.9912	3.1	14725.0
2019-10-03	AAME	Stock	2.52	2.52	2.52	2.52	300.0
2019-10-03	AAMI	Stock	9.3	9.49	9.17	9.35	1079100.0
2019-10-03	AAOI	Stock	10.25	10.445	9.79	10.22	379200.0
2019-10-03	AAON	Stock	28.9267	29.5867	28.38	29.36	211050.0
2019-10-03	AAP	Stock	162.6	162.79	158.26	159.86	918100.0
2019-10-03	AAT	Stock	45.98	46.41	45.65	46.04	310500.0
2019-10-03	AAU-DELISTED	Stock	0.6462	0.6615	0.6462	0.6599	86607.0
2019-10-03	AAUAF-DELISTED	Stock	0.6462	0.6615	0.6462	0.6599	88497.0
2019-10-03	AAWW-DELISTED	Stock	22.82	23.26	22.25	22.6	299481.0
2019-10-03	AAXJ	Stock	65.92	66.44	65.73	66.4	1667616.0
2019-10-03	AAXN-DELISTED	Stock	53.09	54.35	52.16	54.32	571885.0
2019-10-03	AB	Stock	28.22	28.67	28.1	28.6	161200.0
2019-10-03	ABB-DELISTED	Stock	18.08	18.3	18.035	18.3	3113441.0
2019-10-03	ABBNY-DELISTED	Stock	18.08	18.3	18.035	18.3	3263951.0
2019-10-03	ABBV	Stock	72.06	73.94	72.04	73.85	6228500.0
2019-10-03	ABC-DELISTED	Stock	80.81	81.57	79.75	81.39	572681.0
2019-10-03	ABCB	Stock	39.15	39.48	38.5	39.34	331500.0
2019-10-03	ABDC-DELISTED	Stock	8.9	8.9088	8.82	8.85	24268.0
2019-10-03	ABEO	Stock	55.5	57.5	54.25	56.5	11804.0
2019-10-03	ABEV	Stock	4.54	4.59	4.51	4.53	17942900.0
2019-10-03	ABG	Stock	98.65	98.93	95.87	96.28	118400.0
2019-10-03	ABIL-DELISTED	Stock	0.515	0.53	0.49	0.5	19224.0
2019-10-03	ABM	Stock	33.9	34.19	33.46	34.11	265400.0
2019-10-03	ABMD-DELISTED	Stock	162.9	167.04	159.4	166.99	570313.0
2019-10-03	ABR	Stock	12.95	13.02	12.86	12.92	1124400.0
2019-10-03	ABR.A-DELISTED	Stock	26.26	26.3	26.26	26.3	1000.0
2019-10-03	ABR.B-DELISTED	Stock	25.81	25.83	25.81	25.83	350.0
2019-10-03	ABR.C-DELISTED	Stock	26.18	26.4002	26.18	26.2039	1000.0
2019-10-03	ABT	Stock	79.25	81.13	78.77	81.07	3956000.0
2019-10-03	ABTC	Stock	181800.0	196110.0	172800.0	192000.0	1.5333333333333332

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

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