PREVIEW / stock_daily / 2011-03-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-25.parquet
  size:    197 KB
  rows:    6,060
  symbols: 3,528

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-25	AAPL	Stock	12.4311	12.5736	12.3936	12.555	448910000.0
2011-03-25	MSFT	Stock	25.93	25.95	25.59	25.62	57029800.0
2011-03-25	NVDA	Stock	0.485	0.4862	0.465	0.4658	1196392000.0
2011-03-25	AMZN	Stock	8.582	8.6745	8.515	8.549	85876000.0
2011-03-25	TSLA	Stock	1.4953	1.5333	1.4933	1.5167	8520000.0
2011-03-25	TLT	Stock	92.86	92.96	92.02	92.17	6447169.0
2011-03-25	ES	Stock	34.25	34.41	34.11	34.15	1058700.0
2011-03-25	CL	Stock	39.725	40.25	39.675	40.075	4327000.0
2011-03-25	A	Stock	31.4807	31.8312	31.2804	31.5021	2914411.0
2011-03-25	AABA-DELISTED	Stock	16.92	17.05	16.7	16.95	20465770.0
2011-03-25	AACC-DELISTED	Stock	5.4	5.41	5.33	5.33	11814.0
2011-03-25	AACG	Stock	8.0	8.0	7.93	7.93	8000.0
2011-03-25	AAI-DELISTED	Stock	7.36	7.445	7.36	7.44	1514703.0
2011-03-25	AAIC-DELISTED	Stock	29.99	31.15	29.84	30.33	78810.0
2011-03-25	AAME	Stock	2.1	2.17	1.99	2.1	2700.0
2011-03-25	AAON	Stock	6.1353	6.2459	6.1037	6.1412	151369.0
2011-03-25	AAP	Stock	66.71	66.83	66.02	66.26	743900.0
2011-03-25	AAT	Stock	21.32	21.57	21.32	21.49	167500.0
2011-03-25	AATI-DELISTED	Stock	3.71	3.78	3.7	3.75	118982.0
2011-03-25	AAU-DELISTED	Stock	3.93	4.05	3.82	3.94	183547.0
2011-03-25	AAUAF-DELISTED	Stock	3.93	4.05	3.82	3.94	183947.0
2011-03-25	AAV-DELISTED	Stock	8.64	8.97	8.56	8.92	1064199.0
2011-03-25	AAWW-DELISTED	Stock	68.42	69.52	67.59	69.02	211172.0
2011-03-25	AAXJ	Stock	61.66	62.04	61.56	61.82	196095.0
2011-03-25	AAXN-DELISTED	Stock	4.07	4.17	4.0	4.1	605671.0
2011-03-25	AB	Stock	21.61	21.62	21.36	21.57	625500.0
2011-03-25	ABAC-DELISTED	Stock	4.12	4.29	4.1	4.22	46495.0
2011-03-25	ABAX-DELISTED	Stock	29.09	29.56	28.92	29.3	237977.0
2011-03-25	ABB-DELISTED	Stock	23.67	23.8	23.58	23.6	1366085.0
2011-03-25	ABBC-DELISTED	Stock	11.64	12.06	11.64	11.71	33076.0
2011-03-25	ABBNY-DELISTED	Stock	23.67	23.8	23.58	23.62	1388411.0
2011-03-25	ABC-DELISTED	Stock	39.07	39.48	39.07	39.3	2376704.0
2011-03-25	ABCB	Stock	10.13	10.2	10.01	10.1	29900.0
2011-03-25	ABCD-DELISTED	Stock	3.33	3.33	3.3	3.32	15064.0
2011-03-25	ABCO-DELISTED	Stock	24.97	25.32	24.38	25.21	192304.0
2011-03-25	ABCW-DELISTED	Stock	0.98	1.02	0.96	0.99	54700.0
2011-03-25	ABD-DELISTED	Stock	9.27	9.53	9.09	9.11	217300.0
2011-03-25	ABE-DELISTED	Stock	18.24	18.47	18.24	18.2601	15844.0
2011-03-25	ABEO	Stock	2500.0	2600.0	2437.5	2512.5	16.0
2011-03-25	ABFS-DELISTED	Stock	25.43	25.59	24.8	24.84	422051.0
2011-03-25	ABG	Stock	18.32	19.19	18.19	18.82	709200.0
2011-03-25	ABH-DELISTED	Stock	27.08	27.19	26.8502	27.02	175803.0
2011-03-25	ABM	Stock	25.36	25.72	25.11	25.39	170400.0
2011-03-25	ABMD-DELISTED	Stock	14.56	14.58	14.37	14.47	121275.0
2011-03-25	ABR	Stock	5.75	5.75	5.6	5.65	40300.0
2011-03-25	ABT	Stock	23.1408	23.1408	22.8481	23.0448	17943518.0
2011-03-25	ABTL-DELISTED	Stock	6.5242	7.227	6.223	6.9758	156956.0
2011-03-25	ABUS	Stock	3.3	3.34	3.22	3.24	21000.0
2011-03-25	ABV-DELISTED	Stock	27.43	27.59	27.2	27.285	1436057.0
2011-03-25	ABVA-DELISTED	Stock	5.09	5.34	5.09	5.32	3207.0

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

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