PREVIEW / stock_daily / 2016-03-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-02.parquet
  size:    219 KB
  rows:    6,572
  symbols: 3,336

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
2016-03-02	AAPL	Stock	25.1275	25.2225	24.91	25.1875	132678400.0
2016-03-02	MSFT	Stock	52.41	52.96	52.16	52.95	29289900.0
2016-03-02	NVDA	Stock	0.8142	0.8265	0.8128	0.8235	233812000.0
2016-03-02	AMZN	Stock	29.0875	29.25	28.685	29.0105	91644000.0
2016-03-02	GOOGL	Stock	37.1435	37.156	36.6625	36.974	36292860.0
2016-03-02	META	Stock	109.68	110.55	108.77	109.95	25670200.0
2016-03-02	TSLA	Stock	12.2487	12.568	12.1	12.556	72936000.0
2016-03-02	TLT	Stock	128.32	128.97	128.21	128.96	7047705.0
2016-03-02	ES	Stock	53.96	54.38	52.62	54.34	1800700.0
2016-03-02	CL	Stock	67.06	67.42	66.39	67.08	2546900.0
2016-03-02	A	Stock	38.49	39.27	38.41	39.04	3612300.0
2016-03-02	AA.B-DELISTED	Stock	31.24	32.7	31.24	32.53	25118.0
2016-03-02	AAAP-DELISTED	Stock	31.755	33.0	31.285	32.64	23664.0
2016-03-02	AABA-DELISTED	Stock	32.88	33.24	32.77	32.92	9636998.0
2016-03-02	AAC-DELISTED	Stock	20.16	20.32	19.79	19.93	124750.0
2016-03-02	AACG	Stock	4.87	5.19	4.52	4.57	9000.0
2016-03-02	AAIC-DELISTED	Stock	12.41	12.65	12.29	12.55	268862.0
2016-03-02	AAL	Stock	41.47	41.8	41.29	41.59	7913700.0
2016-03-02	AAMC-DELISTED	Stock	5.0	5.0765	4.9412	5.0412	19162.0
2016-03-02	AAME	Stock	4.3	4.3	4.15	4.28	4600.0
2016-03-02	AAMI	Stock	11.81	11.81	11.5	11.73	98000.0
2016-03-02	AAOI	Stock	18.32	18.5	18.12	18.29	252800.0
2016-03-02	AAON	Stock	16.8867	17.0133	16.6867	16.84	249300.0
2016-03-02	AAP	Stock	152.44	153.82	151.32	152.17	659200.0
2016-03-02	AAT	Stock	37.43	37.99	37.32	37.83	115300.0
2016-03-02	AAU-DELISTED	Stock	0.68	0.7089	0.67	0.6907	87925.0
2016-03-02	AAUAF-DELISTED	Stock	0.68	0.7089	0.67	0.6907	91409.0
2016-03-02	AAV-DELISTED	Stock	5.08	5.27	5.05	5.24	136455.0
2016-03-02	AAVL-DELISTED	Stock	5.44	5.85	5.16	5.71	400632.0
2016-03-02	AAWW-DELISTED	Stock	37.22	37.8675	36.3	36.61	414388.0
2016-03-02	AAXJ	Stock	50.96	51.54	50.93	51.5	736093.0
2016-03-02	AAXN-DELISTED	Stock	19.39	19.78	19.25	19.53	1419702.0
2016-03-02	AB	Stock	20.1	20.73	20.1	20.61	262900.0
2016-03-02	ABAC-DELISTED	Stock	0.6146	0.624	0.6146	0.6147	1360.0
2016-03-02	ABAX-DELISTED	Stock	38.98	41.3	38.98	40.61	279914.0
2016-03-02	ABB-DELISTED	Stock	18.02	18.24	17.97	18.24	1803205.0
2016-03-02	ABBNY-DELISTED	Stock	18.02	18.24	17.97	18.22	1934168.0
2016-03-02	ABBV	Stock	56.17	56.43	55.4	55.7	7054800.0
2016-03-02	ABC-DELISTED	Stock	87.43	87.96	87.04	87.63	1427071.0
2016-03-02	ABCB	Stock	27.62	28.25	27.13	27.55	155500.0
2016-03-02	ABCD-DELISTED	Stock	4.39	4.67	4.35	4.53	43449.0
2016-03-02	ABCO-DELISTED	Stock	29.82	30.054	28.17	28.2	814349.0
2016-03-02	ABCW-DELISTED	Stock	42.33	42.7	42.25	42.64	45052.0
2016-03-02	ABDC-DELISTED	Stock	10.32	10.56	10.13	10.14	17600.0
2016-03-02	ABE-DELISTED	Stock	10.73	10.86	10.73	10.86	1100.0
2016-03-02	ABEO	Stock	53.75	56.75	53.75	56.25	2196.0
2016-03-02	ABEV	Stock	4.6	4.67	4.55	4.65	17186500.0
2016-03-02	ABG	Stock	59.14	59.97	57.94	59.25	453800.0
2016-03-02	ABGB-DELISTED	Stock	0.721	0.75	0.7201	0.75	17180.0
2016-03-02	ABIL-DELISTED	Stock	7.13	7.25	7.12	7.19	21795.0

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

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