PREVIEW / stock_daily / 2019-02-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-12.parquet
  size:    220 KB
  rows:    6,521
  symbols: 2,623

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-02-12	AAPL	Stock	42.525	42.75	42.425	42.7225	89134000.0
2019-02-12	MSFT	Stock	106.14	107.14	105.48	106.89	25056600.0
2019-02-12	NVDA	Stock	3.7	3.795	3.6855	3.7792	591060000.0
2019-02-12	AMZN	Stock	80.2	81.97	79.944	81.9005	97172000.0
2019-02-12	GOOGL	Stock	55.5505	56.643	55.5505	56.379	35035420.0
2019-02-12	META	Stock	166.86	168.34	164.5	165.04	16292300.0
2019-02-12	TSLA	Stock	21.08	21.2127	20.6413	20.7873	82764000.0
2019-02-12	TLT	Stock	121.66	121.75	121.2	121.555	7939591.0
2019-02-12	ES	Stock	70.39	70.62	69.71	70.28	1252300.0
2019-02-12	CL	Stock	66.11	66.48	65.48	66.02	4450400.0
2019-02-12	A	Stock	76.8	77.25	76.43	77.07	2045500.0
2019-02-12	AA	Stock	28.33	28.69	27.95	28.4	3021400.0
2019-02-12	AABA-DELISTED	Stock	69.04	69.57	68.79	68.84	4455687.0
2019-02-12	AAC-DELISTED	Stock	2.68	2.8	2.62	2.77	197335.0
2019-02-12	AACG	Stock	1.03	1.09	1.03	1.08	39000.0
2019-02-12	AAIC-DELISTED	Stock	8.82	8.855	8.78	8.83	311819.0
2019-02-12	AAL	Stock	36.76	37.17	35.67	35.75	6883200.0
2019-02-12	AAM.A-DELISTED	Stock	24.6462	24.8	24.6462	24.8	32453.0
2019-02-12	AAM.B-DELISTED	Stock	24.47	24.55	24.42	24.5265	57609.0
2019-02-12	AAMC-DELISTED	Stock	8.5735	10.8235	8.3824	10.2471	55094.0
2019-02-12	AAME	Stock	2.58	2.58	2.58	2.58	100.0
2019-02-12	AAMI	Stock	13.63	14.11	13.63	14.07	729000.0
2019-02-12	AAOI	Stock	15.45	15.45	14.42	14.66	2233100.0
2019-02-12	AAON	Stock	25.4133	25.9133	25.3667	25.4667	151050.0
2019-02-12	AAP	Stock	165.87	168.54	165.48	167.89	1264300.0
2019-02-12	AAT	Stock	44.18	44.22	43.43	43.58	158200.0
2019-02-12	AAU-DELISTED	Stock	0.72	0.7498	0.72	0.745	60473.0
2019-02-12	AAUAF-DELISTED	Stock	0.72	0.7498	0.72	0.745	62825.0
2019-02-12	AAWW-DELISTED	Stock	53.6	54.7043	53.54	54.29	187577.0
2019-02-12	AAXJ	Stock	68.65	68.83	68.55	68.7	1184769.0
2019-02-12	AAXN-DELISTED	Stock	53.8	54.04	52.72	53.28	323535.0
2019-02-12	AB	Stock	31.22	31.42	30.88	31.17	422300.0
2019-02-12	ABB-DELISTED	Stock	18.99	19.23	18.97	19.21	4862516.0
2019-02-12	ABBNY-DELISTED	Stock	18.99	19.23	18.97	19.2	4934040.0
2019-02-12	ABBV	Stock	79.99	80.12	78.57	79.93	6620100.0
2019-02-12	ABC-DELISTED	Stock	84.14	85.83	84.0673	85.78	835467.0
2019-02-12	ABCB	Stock	38.54	39.02	38.35	39.02	361600.0
2019-02-12	ABDC-DELISTED	Stock	7.4	7.553	7.4	7.42	6011.0
2019-02-12	ABEO	Stock	168.75	174.75	165.0	167.0	15008.0
2019-02-12	ABEV	Stock	5.0	5.03	4.93	4.98	28864800.0
2019-02-12	ABG	Stock	69.4	70.0	68.9	69.98	160400.0
2019-02-12	ABIL-DELISTED	Stock	1.82	1.93	1.8103	1.927	125661.0
2019-02-12	ABM	Stock	35.37	36.45	35.35	36.15	402000.0
2019-02-12	ABMD-DELISTED	Stock	359.48	361.76	353.845	358.07	272188.0
2019-02-12	ABR	Stock	11.94	12.0	11.88	12.0	601900.0
2019-02-12	ABR.A-DELISTED	Stock	25.58	25.58	25.5552	25.5648	2754.0
2019-02-12	ABR.B-DELISTED	Stock	25.79	25.9	25.7521	25.9	6442.0
2019-02-12	ABR.C-DELISTED	Stock	25.76	25.85	25.68	25.74	5343.0
2019-02-12	ABT	Stock	73.99	75.23	73.72	75.06	7039700.0
2019-02-12	ABTC	Stock	304500.0	304500.0	303900.0	304200.0	0.5733333333333333

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

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