PREVIEW / stock_daily / 2017-12-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-05.parquet
  size:    217 KB
  rows:    6,492
  symbols: 2,905

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
2017-12-05	AAPL	Stock	42.265	42.88	42.1	42.41	109400800.0
2017-12-05	MSFT	Stock	81.34	82.68	80.98	81.59	26152300.0
2017-12-05	NVDA	Stock	4.56	4.8175	4.5145	4.6935	981488000.0
2017-12-05	AMZN	Stock	56.413	57.9635	56.237	57.0785	81596000.0
2017-12-05	GOOGL	Stock	50.5495	51.834	50.1158	50.98	38997300.0
2017-12-05	META	Stock	170.45	175.38	169.01	172.83	20184900.0
2017-12-05	TSLA	Stock	20.1333	20.5333	20.0667	20.2467	69697500.0
2017-12-05	TLT	Stock	126.47	127.5	126.45	127.24	10958930.0
2017-12-05	ES	Stock	65.5	65.5	64.32	64.88	2019600.0
2017-12-05	CL	Stock	74.63	74.82	74.01	74.59	3463200.0
2017-12-05	A	Stock	66.2	67.0	65.73	65.83	2384000.0
2017-12-05	AA	Stock	41.37	41.86	40.95	41.18	2855500.0
2017-12-05	AAAP-DELISTED	Stock	81.26	81.5	81.24	81.35	250086.0
2017-12-05	AABA-DELISTED	Stock	67.1	69.38	66.62	68.14	10295545.0
2017-12-05	AAC-DELISTED	Stock	8.82	8.82	8.41	8.44	138705.0
2017-12-05	AACG	Stock	5.09	5.16	5.07	5.16	24500.0
2017-12-05	AAIC-DELISTED	Stock	11.96	12.0	11.8499	11.9	278563.0
2017-12-05	AAL	Stock	49.85	50.0	49.21	49.47	3594000.0
2017-12-05	AAM.A-DELISTED	Stock	26.1	26.19	26.04	26.18	22134.0
2017-12-05	AAMC-DELISTED	Stock	21.4706	21.4706	21.4706	21.4706	1163.0
2017-12-05	AAME	Stock	3.74	3.74	3.45	3.5	2200.0
2017-12-05	AAMI	Stock	16.34	16.42	15.95	15.98	602300.0
2017-12-05	AAOI	Stock	43.82	44.2	41.58	42.46	1133200.0
2017-12-05	AAON	Stock	25.0	25.4	24.8667	25.0333	380400.0
2017-12-05	AAP	Stock	107.1	107.79	100.02	101.15	2462400.0
2017-12-05	AAT	Stock	39.54	39.57	38.75	38.75	199300.0
2017-12-05	AAU-DELISTED	Stock	0.8766	0.8783	0.8365	0.848	257785.0
2017-12-05	AAUAF-DELISTED	Stock	0.8766	0.8783	0.8365	0.848	261909.0
2017-12-05	AAV-DELISTED	Stock	4.8	4.8	4.625	4.65	156285.0
2017-12-05	AAWW-DELISTED	Stock	58.05	58.55	56.75	56.9	156616.0
2017-12-05	AAXJ	Stock	74.96	75.405	74.899	75.02	859792.0
2017-12-05	AAXN-DELISTED	Stock	24.1	24.385	23.95	24.09	555618.0
2017-12-05	AB	Stock	25.4	25.6	25.15	25.4	290400.0
2017-12-05	ABAC-DELISTED	Stock	2.8846	2.97	2.77	2.89	46808.0
2017-12-05	ABAX-DELISTED	Stock	47.47	48.0	46.97	47.1	92147.0
2017-12-05	ABB-DELISTED	Stock	25.64	25.68	25.39	25.415	1165994.0
2017-12-05	ABBNY-DELISTED	Stock	25.64	25.68	25.39	25.42	1223003.0
2017-12-05	ABBV	Stock	96.28	96.72	95.0	95.41	5553000.0
2017-12-05	ABC-DELISTED	Stock	87.49	87.56	85.07	85.89	1645660.0
2017-12-05	ABCB	Stock	50.3	50.4	49.3	49.3	241400.0
2017-12-05	ABCD-DELISTED	Stock	5.55	5.78	5.44	5.7	71566.0
2017-12-05	ABDC-DELISTED	Stock	8.33	8.41	8.3	8.3	52659.0
2017-12-05	ABE-DELISTED	Stock	14.137	14.16	14.1214	14.16	2678.0
2017-12-05	ABEO	Stock	381.25	396.25	377.75	381.25	18700.0
2017-12-05	ABEOW-DELISTED	Stock	10.78	11.08	10.7491	10.804	1000.0
2017-12-05	ABEV	Stock	6.4	6.43	6.28	6.3	22461100.0
2017-12-05	ABG	Stock	68.7	68.7	66.7	67.0	167600.0
2017-12-05	ABIL-DELISTED	Stock	0.499	0.4995	0.47	0.48	68770.0
2017-12-05	ABLX-DELISTED	Stock	22.76	23.27	22.6695	22.97	122945.0
2017-12-05	ABM	Stock	43.98	44.05	42.98	42.99	240900.0

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

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