PREVIEW / stock_daily / 2019-06-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-25.parquet
  size:    221 KB
  rows:    6,591
  symbols: 2,572

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-06-25	AAPL	Stock	49.6075	49.815	48.8225	48.8925	84281200.0
2019-06-25	MSFT	Stock	137.25	137.59	132.73	133.43	33327400.0
2019-06-25	NVDA	Stock	3.8215	3.897	3.7842	3.787	311868000.0
2019-06-25	AMZN	Stock	95.592	95.8195	93.621	93.9135	60246000.0
2019-06-25	GOOGL	Stock	55.754	55.785	54.23	54.379	31644340.0
2019-06-25	META	Stock	192.88	193.14	188.13	188.84	16750300.0
2019-06-25	TSLA	Stock	14.9593	15.0227	14.6327	14.6507	92731500.0
2019-06-25	TLT	Stock	132.79	133.09	132.72	132.82	9604623.0
2019-06-25	ES	Stock	77.48	77.71	76.72	76.98	1640700.0
2019-06-25	CL	Stock	73.87	74.25	73.31	73.91	3178100.0
2019-06-25	A	Stock	73.19	73.63	72.41	72.51	1340400.0
2019-06-25	AA	Stock	22.23	22.86	21.95	22.55	2568300.0
2019-06-25	AABA-DELISTED	Stock	68.9	68.95	68.27	68.61	3988097.0
2019-06-25	AAC-DELISTED	Stock	0.727	0.89	0.672	0.7999	766250.0
2019-06-25	AACG	Stock	2.54	2.71	2.54	2.64	93400.0
2019-06-25	AAIC-DELISTED	Stock	6.68	6.69	6.36	6.5	1112612.0
2019-06-25	AAIC.C-DELISTED	Stock	21.55	21.6379	21.28	21.5	6924.0
2019-06-25	AAL	Stock	31.83	32.11	31.24	31.26	6523600.0
2019-06-25	AAM.A-DELISTED	Stock	25.6	25.77	25.6	25.674	20042.0
2019-06-25	AAM.B-DELISTED	Stock	25.68	25.87	25.65	25.72	48819.0
2019-06-25	AAMC-DELISTED	Stock	4.4029	4.4029	4.138	4.2647	7701.0
2019-06-25	AAME	Stock	2.51	2.51	2.49	2.49	400.0
2019-06-25	AAMI	Stock	10.83	10.93	10.75	10.89	457200.0
2019-06-25	AAOI	Stock	9.11	9.25	8.93	9.1	424800.0
2019-06-25	AAON	Stock	32.2667	32.52	31.8133	31.8267	184500.0
2019-06-25	AAP	Stock	152.94	156.22	151.92	154.5	1346800.0
2019-06-25	AAT	Stock	47.27	47.59	46.41	46.49	649300.0
2019-06-25	AAU-DELISTED	Stock	0.68	0.68	0.6233	0.64	286688.0
2019-06-25	AAUAF-DELISTED	Stock	0.68	0.68	0.6233	0.64	322187.0
2019-06-25	AAWW-DELISTED	Stock	39.5	40.91	38.72	40.42	254796.0
2019-06-25	AAXJ	Stock	69.07	69.09	68.62	68.65	1067780.0
2019-06-25	AAXN-DELISTED	Stock	71.06	71.5	68.14	68.83	1612590.0
2019-06-25	AB	Stock	29.33	29.33	28.76	28.81	84100.0
2019-06-25	ABB-DELISTED	Stock	19.88	19.9	19.73	19.74	1334629.0
2019-06-25	ABBNY-DELISTED	Stock	19.88	19.9	19.73	19.74	1417822.0
2019-06-25	ABBV	Stock	70.47	70.67	65.06	65.7	90131800.0
2019-06-25	ABC-DELISTED	Stock	83.87	85.15	83.12	84.28	1417573.0
2019-06-25	ABCB	Stock	37.82	38.03	37.22	37.86	234200.0
2019-06-25	ABDC-DELISTED	Stock	8.69	8.69	8.65	8.68	17681.0
2019-06-25	ABEO	Stock	110.75	118.25	109.75	115.25	55084.0
2019-06-25	ABEOW-DELISTED	Stock	0.97	0.97	0.97	0.97	300.0
2019-06-25	ABEV	Stock	4.77	4.82	4.7	4.75	23980100.0
2019-06-25	ABG	Stock	80.42	81.57	80.24	81.1	165600.0
2019-06-25	ABIL-DELISTED	Stock	0.9	0.92	0.89	0.92	41063.0
2019-06-25	ABM	Stock	38.99	39.21	38.61	38.99	318200.0
2019-06-25	ABMD-DELISTED	Stock	254.0	260.59	253.17	257.15	397076.0
2019-06-25	ABR	Stock	12.19	12.21	12.03	12.03	1346800.0
2019-06-25	ABR.A-DELISTED	Stock	25.9337	26.1378	25.9337	26.1378	700.0
2019-06-25	ABR.B-DELISTED	Stock	25.9	26.075	25.9	25.9	3124.0
2019-06-25	ABR.C-DELISTED	Stock	26.0	26.1702	26.0	26.135	2548.0

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

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