PREVIEW / stock_daily / 2012-12-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-24.parquet
  size:    197 KB
  rows:    6,160
  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
2012-12-24	AAPL	Stock	18.5839	18.7232	18.5254	18.5775	175753200.0
2012-12-24	MSFT	Stock	27.2	27.25	27.0	27.06	20842400.0
2012-12-24	NVDA	Stock	0.3085	0.3095	0.3052	0.3062	127376000.0
2012-12-24	AMZN	Stock	12.865	12.975	12.848	12.931	19688000.0
2012-12-24	META	Stock	26.5	26.96	26.2	26.93	28230100.0
2012-12-24	TSLA	Stock	2.2427	2.29	2.2367	2.2853	5637000.0
2012-12-24	TLT	Stock	122.0	122.08	121.87	122.03	1071090.0
2012-12-24	ES	Stock	39.16	39.18	38.72	39.15	740600.0
2012-12-24	CL	Stock	52.315	52.68	52.3	52.525	1251000.0
2012-12-24	A	Stock	29.2489	29.4492	29.1702	29.3777	1560028.0
2012-12-24	AABA-DELISTED	Stock	19.45	19.66	19.38	19.65	11256781.0
2012-12-24	AACC-DELISTED	Stock	4.48	4.6	4.3901	4.5499	7486.0
2012-12-24	AACG	Stock	5.58	5.58	5.5	5.51	5400.0
2012-12-24	AAIC-DELISTED	Stock	20.79	21.35	20.7875	21.05	141318.0
2012-12-24	AAMC-DELISTED	Stock	23.8235	27.5	23.5294	23.5294	12342.0
2012-12-24	AAME	Stock	2.76	2.84	2.76	2.8	2100.0
2012-12-24	AAMRQ-DELISTED	Stock	0.8065	0.815	0.69	0.77	4547811.0
2012-12-24	AAON	Stock	5.9911	5.9911	5.8637	5.9496	253125.0
2012-12-24	AAP	Stock	70.5	71.09	70.2	70.78	178600.0
2012-12-24	AAT	Stock	27.47	27.67	26.88	27.48	30700.0
2012-12-24	AAU-DELISTED	Stock	3.02	3.05	2.951	3.05	71079.0
2012-12-24	AAUAF-DELISTED	Stock	3.03	3.06	2.961	3.04	71952.0
2012-12-24	AAV-DELISTED	Stock	3.27	3.3	3.26	3.3	94720.0
2012-12-24	AAWW-DELISTED	Stock	44.41	44.56	43.73	44.33	75780.0
2012-12-24	AAXJ	Stock	59.1	59.1	58.7801	58.99	283595.0
2012-12-24	AAXN-DELISTED	Stock	8.77	8.91	8.67	8.7501	345751.0
2012-12-24	AB	Stock	16.68	17.34	16.51	17.02	356000.0
2012-12-24	ABAC-DELISTED	Stock	1.09	1.09	0.9101	1.0	11507.0
2012-12-24	ABAX-DELISTED	Stock	37.34	37.51	36.84	37.28	22622.0
2012-12-24	ABB-DELISTED	Stock	20.68	20.74	20.52	20.58	632316.0
2012-12-24	ABBNY-DELISTED	Stock	20.68	20.74	20.52	20.57	648245.0
2012-12-24	ABC-DELISTED	Stock	43.52	43.68	43.21	43.45	629416.0
2012-12-24	ABCB	Stock	12.46	12.54	12.25	12.35	9500.0
2012-12-24	ABCD-DELISTED	Stock	1.4	1.5	1.27	1.27	44510.0
2012-12-24	ABCO-DELISTED	Stock	49.0	49.08	48.45	48.98	40858.0
2012-12-24	ABCW-DELISTED	Stock	0.34	0.3599	0.31	0.3599	32200.0
2012-12-24	ABE-DELISTED	Stock	21.03	21.05	20.91	21.0	8650.0
2012-12-24	ABEO	Stock	312.5	312.5	262.5	275.0	74.0
2012-12-24	ABFS-DELISTED	Stock	9.51	9.57	9.26	9.41	122609.0
2012-12-24	ABG	Stock	31.2	31.31	31.0	31.04	47400.0
2012-12-24	ABM	Stock	20.12	20.16	19.97	20.1	75600.0
2012-12-24	ABMD-DELISTED	Stock	13.7	13.8	13.44	13.56	738094.0
2012-12-24	ABR	Stock	5.93	6.0	5.92	5.97	37200.0
2012-12-24	ABT	Stock	31.6908	31.6908	31.3693	31.4125	4894331.0
2012-12-24	ABTL-DELISTED	Stock	3.99	4.06	3.91	4.0	10719.0
2012-12-24	ABUS	Stock	4.99	5.0	4.96	5.0	6800.0
2012-12-24	ABV-DELISTED	Stock	41.73	42.09	41.63	41.96	267757.0
2012-12-24	ABX-DELISTED	Stock	33.38	33.8	33.25	33.75	3596669.0
2012-12-24	ACAD	Stock	4.5	4.61	4.45	4.55	698000.0
2012-12-24	ACAS-DELISTED	Stock	12.34	12.34	12.09	12.29	970306.0

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

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