PREVIEW / stock_daily / 2011-03-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-24.parquet
  size:    196 KB
  rows:    6,060
  symbols: 3,530

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
2011-03-24	AAPL	Stock	12.2089	12.3571	12.1021	12.3204	404712000.0
2011-03-24	MSFT	Stock	25.6	25.87	25.5	25.81	38696700.0
2011-03-24	NVDA	Stock	0.4548	0.4862	0.4538	0.4808	1780592000.0
2011-03-24	AMZN	Stock	8.4105	8.6	8.368	8.555	125664000.0
2011-03-24	TSLA	Stock	1.476	1.492	1.4653	1.4887	6933000.0
2011-03-24	TLT	Stock	92.76	92.88	92.39	92.4	9478934.0
2011-03-24	ES	Stock	34.34	34.37	34.0	34.15	1181700.0
2011-03-24	CL	Stock	39.345	40.17	39.195	40.15	7165400.0
2011-03-24	A	Stock	31.4735	31.5522	31.0801	31.4092	3846597.0
2011-03-24	AABA-DELISTED	Stock	16.23	16.91	16.17	16.82	19681414.0
2011-03-24	AACC-DELISTED	Stock	5.4	5.43	5.39	5.4	18475.0
2011-03-24	AACG	Stock	7.99	8.0	7.94	7.94	4700.0
2011-03-24	AAI-DELISTED	Stock	7.37	7.4	7.35	7.36	2799035.0
2011-03-24	AAIC-DELISTED	Stock	28.75	29.85	28.63	29.7	34619.0
2011-03-24	AAME	Stock	2.17	2.24	2.02	2.14	8500.0
2011-03-24	AAON	Stock	6.1472	6.157	6.0642	6.0978	96694.0
2011-03-24	AAP	Stock	65.72	66.86	65.47	66.52	1010400.0
2011-03-24	AAT	Stock	21.45	21.48	21.11	21.39	191300.0
2011-03-24	AATI-DELISTED	Stock	3.7	3.73	3.65	3.71	65170.0
2011-03-24	AAU-DELISTED	Stock	4.1	4.15	3.9	3.93	273193.0
2011-03-24	AAUAF-DELISTED	Stock	4.1	4.15	3.9	3.93	275593.0
2011-03-24	AAV-DELISTED	Stock	8.44	8.7	8.44	8.62	670968.0
2011-03-24	AAWW-DELISTED	Stock	67.6	68.38	66.9012	67.92	184111.0
2011-03-24	AAXJ	Stock	61.37	61.74	60.95	61.68	148994.0
2011-03-24	AAXN-DELISTED	Stock	3.8	4.05	3.8	4.05	1066863.0
2011-03-24	AB	Stock	21.68	21.7	21.23	21.41	335300.0
2011-03-24	ABAC-DELISTED	Stock	4.3	4.3	4.08	4.11	127780.0
2011-03-24	ABAX-DELISTED	Stock	28.81	29.18	28.48	29.0	221240.0
2011-03-24	ABB-DELISTED	Stock	23.85	24.01	23.72	23.9	1840015.0
2011-03-24	ABBC-DELISTED	Stock	11.64	11.67	11.431	11.61	30626.0
2011-03-24	ABBNY-DELISTED	Stock	23.85	24.01	23.72	23.91	1842520.0
2011-03-24	ABC-DELISTED	Stock	38.3	39.195	38.22	39.08	2487137.0
2011-03-24	ABCB	Stock	10.19	10.19	10.01	10.06	23700.0
2011-03-24	ABCD-DELISTED	Stock	3.38	3.38	3.32	3.33	39765.0
2011-03-24	ABCO-DELISTED	Stock	25.07	25.07	24.76	24.81	51532.0
2011-03-24	ABCW-DELISTED	Stock	0.97	1.0	0.9699	0.99	41170.0
2011-03-24	ABD-DELISTED	Stock	9.14	9.31	8.88	9.19	316790.0
2011-03-24	ABE-DELISTED	Stock	18.14	18.27	18.13	18.25	6743.0
2011-03-24	ABEO	Stock	2500.0	2612.5	2437.5	2612.5	19.0
2011-03-24	ABFS-DELISTED	Stock	25.33	25.74	25.25	25.27	282729.0
2011-03-24	ABG	Stock	17.69	18.31	17.66	18.15	413500.0
2011-03-24	ABH-DELISTED	Stock	27.1	27.1	26.745	26.96	246236.0
2011-03-24	ABM	Stock	25.36	25.4	25.15	25.22	192100.0
2011-03-24	ABMD-DELISTED	Stock	14.4	14.53	14.22	14.46	107657.0
2011-03-24	ABR	Stock	5.79	5.79	5.68	5.75	23100.0
2011-03-24	ABT	Stock	23.0976	23.0976	22.9009	23.0832	14031888.0
2011-03-24	ABTL-DELISTED	Stock	6.0	7.0	5.95	6.5	329916.0
2011-03-24	ABUS	Stock	3.57	3.59	3.34	3.4	21600.0
2011-03-24	ABV-DELISTED	Stock	27.7	27.77	27.25	27.37	2050614.0
2011-03-24	ABVA-DELISTED	Stock	4.98	5.0	4.98	5.0	1100.0

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

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