PREVIEW / stock_daily / 2015-09-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-09.parquet
  size:    221 KB
  rows:    6,636
  symbols: 3,430

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
2015-09-09	AAPL	Stock	28.44	28.505	27.4425	27.5375	340043200.0
2015-09-09	MSFT	Stock	44.21	44.4	42.91	43.07	33469500.0
2015-09-09	NVDA	Stock	0.5688	0.5735	0.5545	0.5558	289392000.0
2015-09-09	AMZN	Stock	26.2	26.4975	25.753	25.8445	87414000.0
2015-09-09	GOOGL	Stock	32.594	32.868	32.045	32.1705	40978160.0
2015-09-09	META	Stock	90.78	91.98	90.17	90.44	32551100.0
2015-09-09	TSLA	Stock	16.8033	16.95	16.5533	16.594	50862000.0
2015-09-09	TLT	Stock	119.63	121.705	119.56	121.45	7441863.0
2015-09-09	ES	Stock	46.51	46.62	45.78	45.87	1724700.0
2015-09-09	CL	Stock	64.04	64.13	62.26	62.39	3645900.0
2015-09-09	A	Stock	36.5	36.8	35.44	35.54	1885300.0
2015-09-09	AA.B-DELISTED	Stock	36.07	37.14	35.5	35.8	46562.0
2015-09-09	AABA-DELISTED	Stock	30.39	31.8	30.35	31.51	45014052.0
2015-09-09	AAC-DELISTED	Stock	23.88	23.9295	22.22	22.32	282533.0
2015-09-09	AACG	Stock	2.37	2.45	2.3	2.34	22800.0
2015-09-09	AAIC-DELISTED	Stock	15.97	16.06	15.73	15.88	527997.0
2015-09-09	AAL	Stock	41.15	42.18	40.63	41.0	12481200.0
2015-09-09	AAMC-DELISTED	Stock	9.1059	9.1059	7.7647	8.0059	92619.0
2015-09-09	AAME	Stock	3.52	3.55	3.34	3.42	5500.0
2015-09-09	AAMI	Stock	16.83	16.84	16.31	16.43	166900.0
2015-09-09	AAOI	Stock	22.0	22.4	20.66	20.77	363900.0
2015-09-09	AAON	Stock	13.3333	13.5533	13.1267	13.3333	353550.0
2015-09-09	AAP	Stock	176.1	178.4	174.35	174.92	1024600.0
2015-09-09	AAT	Stock	38.4	38.59	37.85	37.92	159400.0
2015-09-09	AAU-DELISTED	Stock	0.5274	0.54	0.52	0.5374	33467.0
2015-09-09	AAUAF-DELISTED	Stock	0.5274	0.54	0.52	0.5374	33890.0
2015-09-09	AAV-DELISTED	Stock	5.5	5.56	5.25	5.27	119484.0
2015-09-09	AAVL-DELISTED	Stock	10.62	10.88	10.57	10.78	365938.0
2015-09-09	AAWW-DELISTED	Stock	39.32	39.58	38.87	38.92	295318.0
2015-09-09	AAXJ	Stock	54.0	54.2	53.12	53.17	1185526.0
2015-09-09	AAXN-DELISTED	Stock	24.45	24.5	23.71	23.77	928223.0
2015-09-09	AB	Stock	26.8	27.03	26.24	26.46	179700.0
2015-09-09	ABAX-DELISTED	Stock	49.06	49.06	47.95	48.49	109073.0
2015-09-09	ABB-DELISTED	Stock	19.12	19.14	18.7	18.72	1689677.0
2015-09-09	ABBNY-DELISTED	Stock	19.12	19.14	18.7	18.73	1745196.0
2015-09-09	ABBV	Stock	61.52	61.52	59.11	59.26	8436900.0
2015-09-09	ABC-DELISTED	Stock	101.14	103.46	100.55	100.74	1298137.0
2015-09-09	ABCB	Stock	27.7	27.9	27.45	27.67	244300.0
2015-09-09	ABCD-DELISTED	Stock	5.19	5.19	4.93	4.99	45567.0
2015-09-09	ABCO-DELISTED	Stock	48.93	49.36	48.05	48.13	209260.0
2015-09-09	ABCW-DELISTED	Stock	41.99	42.0	40.9159	41.6	22713.0
2015-09-09	ABDC-DELISTED	Stock	12.98	13.1	12.81	12.86	27414.0
2015-09-09	ABE-DELISTED	Stock	11.15	11.29	11.01	11.01	10003.0
2015-09-09	ABEO	Stock	120.5	127.75	118.5	125.5	5988.0
2015-09-09	ABEOW-DELISTED	Stock	1.95	2.0	1.73	2.0	9027.0
2015-09-09	ABEV	Stock	5.14	5.16	5.03	5.03	13177500.0
2015-09-09	ABG	Stock	83.76	84.17	81.89	81.99	325700.0
2015-09-09	ABGB-DELISTED	Stock	5.97	6.0297	5.7	5.71	33614.0
2015-09-09	ABM	Stock	29.81	30.02	29.68	29.72	617400.0
2015-09-09	ABMD-DELISTED	Stock	97.14	98.9	93.872	94.17	387647.0

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

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