PREVIEW / stock_daily / 2013-03-21

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-21.parquet
  size:    206 KB
  rows:    6,248
  symbols: 3,472

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
2013-03-21	AAPL	Stock	16.0793	16.3564	16.075	16.1689	383255600.0
2013-03-21	MSFT	Stock	28.11	28.36	28.05	28.11	34233200.0
2013-03-21	NVDA	Stock	0.3138	0.3143	0.31	0.3105	339032000.0
2013-03-21	AMZN	Stock	12.8055	12.85	12.634	12.6695	56128000.0
2013-03-21	META	Stock	25.66	26.11	25.56	25.74	24336100.0
2013-03-21	TSLA	Stock	2.3967	2.4707	2.3827	2.4007	17194500.0
2013-03-21	TLT	Stock	116.86	117.25	116.53	117.24	6119489.0
2013-03-21	ES	Stock	42.57	42.85	42.49	42.59	1152200.0
2013-03-21	CL	Stock	57.055	57.29	56.85	56.855	2341800.0
2013-03-21	A	Stock	30.3648	30.5866	29.7783	29.7926	6163922.0
2013-03-21	AABA-DELISTED	Stock	22.4	22.95	22.36	22.85	24652294.0
2013-03-21	AACC-DELISTED	Stock	6.49	6.505	6.46	6.48	598192.0
2013-03-21	AAIC-DELISTED	Stock	25.75	25.8761	25.46	25.46	380663.0
2013-03-21	AAMC-DELISTED	Stock	41.9118	42.5	39.4118	40.0	49524.0
2013-03-21	AAME	Stock	3.3	3.33	3.3	3.3	1100.0
2013-03-21	AAMRQ-DELISTED	Stock	4.29	4.47	4.28	4.38	12506849.0
2013-03-21	AAON	Stock	8.0207	8.1511	7.9822	8.0415	347288.0
2013-03-21	AAP	Stock	79.91	80.72	79.85	80.03	616300.0
2013-03-21	AAT	Stock	31.84	32.23	31.84	31.91	98400.0
2013-03-21	AAU-DELISTED	Stock	2.18	2.3502	2.15	2.32	145996.0
2013-03-21	AAUAF-DELISTED	Stock	2.16	2.3299	2.13	2.32	147769.0
2013-03-21	AAV-DELISTED	Stock	3.3	3.36	3.29	3.3	107560.0
2013-03-21	AAWW-DELISTED	Stock	42.37	42.56	41.59	42.1	353303.0
2013-03-21	AAXJ	Stock	58.05	58.17	57.77	57.83	891240.0
2013-03-21	AAXN-DELISTED	Stock	7.98	8.17	7.92	8.03	359706.0
2013-03-21	AB	Stock	21.71	21.72	21.1	21.2	187700.0
2013-03-21	ABAC-DELISTED	Stock	0.7	0.77	0.7	0.7	11497.0
2013-03-21	ABAX-DELISTED	Stock	46.4	47.15	45.87	46.99	90836.0
2013-03-21	ABB-DELISTED	Stock	22.44	22.63	22.37	22.42	1337398.0
2013-03-21	ABBNY-DELISTED	Stock	22.44	22.63	22.37	22.41	1354573.0
2013-03-21	ABBV	Stock	38.82	38.97	38.48	38.49	4736100.0
2013-03-21	ABC-DELISTED	Stock	50.11	50.54	49.56	49.78	2193794.0
2013-03-21	ABCB	Stock	14.1	14.33	14.04	14.29	51100.0
2013-03-21	ABCD-DELISTED	Stock	0.99	1.02	0.99	1.01	24988.0
2013-03-21	ABCO-DELISTED	Stock	49.62	50.11	48.89	50.01	110522.0
2013-03-21	ABCW-DELISTED	Stock	0.62	0.65	0.6	0.65	15631.0
2013-03-21	ABE-DELISTED	Stock	20.72	20.78	20.69	20.78	3624.0
2013-03-21	ABEO	Stock	787.5	787.5	687.5	687.5	17.0
2013-03-21	ABFS-DELISTED	Stock	12.42	12.556	11.63	11.81	469022.0
2013-03-21	ABG	Stock	37.44	37.63	36.69	37.01	143400.0
2013-03-21	ABM	Stock	22.12	22.27	21.94	22.08	159100.0
2013-03-21	ABMD-DELISTED	Stock	17.39	17.515	17.16	17.4	163367.0
2013-03-21	ABR	Stock	8.16	8.35	8.16	8.23	153500.0
2013-03-21	ABR.A-DELISTED	Stock	25.7	25.73	25.55	25.67	8105.0
2013-03-21	ABT	Stock	33.78	33.82	33.32	33.48	5889800.0
2013-03-21	ABTL-DELISTED	Stock	4.09	4.19	3.98	4.11	41172.0
2013-03-21	ABUS	Stock	4.7	4.86	4.53	4.68	638300.0
2013-03-21	ABV-DELISTED	Stock	42.97	43.23	42.5	42.72	1511106.0
2013-03-21	ABX-DELISTED	Stock	29.05	29.83	28.93	29.62	10153365.0
2013-03-21	ACAD	Stock	7.13	8.81	7.04	8.24	22321100.0

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

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