PREVIEW / stock_daily / 2013-03-05

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-05.parquet
  size:    208 KB
  rows:    6,296
  symbols: 3,502

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-05	AAPL	Stock	15.0529	15.5425	15.0268	15.3979	638433600.0
2013-03-05	MSFT	Stock	28.29	28.54	28.16	28.35	41432200.0
2013-03-05	NVDA	Stock	0.3183	0.3205	0.3168	0.32	366168000.0
2013-03-05	AMZN	Stock	13.7	13.834	13.4995	13.7795	73724000.0
2013-03-05	META	Stock	27.88	28.18	27.21	27.52	40622200.0
2013-03-05	TSLA	Stock	2.4	2.4613	2.386	2.4433	31305000.0
2013-03-05	TLT	Stock	118.07	118.2	117.68	117.93	6539510.0
2013-03-05	ES	Stock	42.54	42.72	42.39	42.58	1074900.0
2013-03-05	CL	Stock	57.615	58.085	57.55	57.855	2893000.0
2013-03-05	A	Stock	30.2933	30.8941	30.2861	30.515	4598022.0
2013-03-05	AABA-DELISTED	Stock	22.91	23.08	22.61	22.95	29989618.0
2013-03-05	AACC-DELISTED	Stock	5.76	5.76	5.57	5.75	8048.0
2013-03-05	AACG	Stock	3.9	4.19	3.9	4.02	13100.0
2013-03-05	AAIC-DELISTED	Stock	26.21	26.7	26.15	26.31	197754.0
2013-03-05	AAMC-DELISTED	Stock	38.8235	39.7059	38.5294	38.5294	68105.0
2013-03-05	AAME	Stock	3.4	3.4	3.35	3.4	2600.0
2013-03-05	AAMRQ-DELISTED	Stock	2.675	2.77	2.67	2.74	8096647.0
2013-03-05	AAON	Stock	7.2207	7.3689	7.1941	7.3007	177863.0
2013-03-05	AAP	Stock	77.07	77.49	76.72	76.95	1288600.0
2013-03-05	AAT	Stock	31.42	31.57	31.17	31.53	113800.0
2013-03-05	AAU-DELISTED	Stock	1.86	1.97	1.845	1.86	133360.0
2013-03-05	AAUAF-DELISTED	Stock	1.86	1.98	1.85	1.85	133484.0
2013-03-05	AAV-DELISTED	Stock	3.01	3.03	2.97	3.01	309566.0
2013-03-05	AAWW-DELISTED	Stock	45.84	46.86	45.84	46.11	233855.0
2013-03-05	AAXJ	Stock	60.06	60.2499	59.97	60.16	1210151.0
2013-03-05	AAXN-DELISTED	Stock	7.91	7.96	7.76	7.92	867424.0
2013-03-05	AB	Stock	22.88	23.1	22.78	22.98	473400.0
2013-03-05	ABAC-DELISTED	Stock	0.87	0.87	0.81	0.84	10752.0
2013-03-05	ABAX-DELISTED	Stock	43.35	44.06	43.11	43.61	118890.0
2013-03-05	ABB-DELISTED	Stock	22.94	23.0	22.86	22.88	1455467.0
2013-03-05	ABBNY-DELISTED	Stock	22.94	23.0	22.86	22.88	1480037.0
2013-03-05	ABBV	Stock	38.45	38.57	37.29	37.51	6650400.0
2013-03-05	ABC-DELISTED	Stock	47.91	48.4	47.91	48.28	1533504.0
2013-03-05	ABCB	Stock	14.05	14.4	14.05	14.23	60200.0
2013-03-05	ABCD-DELISTED	Stock	1.15	1.24	1.12	1.12	12041.0
2013-03-05	ABCO-DELISTED	Stock	53.28	53.31	51.82	52.98	243152.0
2013-03-05	ABCW-DELISTED	Stock	0.58	0.63	0.53	0.5601	51942.0
2013-03-05	ABE-DELISTED	Stock	21.39	21.4	21.31	21.39	23484.0
2013-03-05	ABEO	Stock	587.5	612.5	587.5	612.5	5.0
2013-03-05	ABFS-DELISTED	Stock	10.99	11.93	10.93	11.8	419420.0
2013-03-05	ABG	Stock	33.57	34.24	33.42	34.23	390900.0
2013-03-05	ABM	Stock	23.23	23.38	21.33	22.04	1019800.0
2013-03-05	ABMD-DELISTED	Stock	16.0	16.46	15.87	16.38	514838.0
2013-03-05	ABR	Stock	8.15	8.41	8.15	8.35	355000.0
2013-03-05	ABR.A-DELISTED	Stock	25.43	25.45	25.4	25.4	5388.0
2013-03-05	ABT	Stock	34.38	34.7	34.37	34.67	7653800.0
2013-03-05	ABTL-DELISTED	Stock	4.4495	4.4495	4.16	4.38	28733.0
2013-03-05	ABUS	Stock	4.45	4.5	4.42	4.42	18200.0
2013-03-05	ABV-DELISTED	Stock	45.04	45.5937	45.04	45.36	1677766.0
2013-03-05	ABX-DELISTED	Stock	28.91	29.09	28.5	28.53	8800076.0

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

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