PREVIEW / stock_daily / 2009-08-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-08-27.parquet
  size:    183 KB
  rows:    5,797
  symbols: 3,448

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
2009-08-27	AAPL	Stock	6.0268	6.0561	5.8868	6.0518	449181600.0
2009-08-27	MSFT	Stock	24.41	24.78	24.3	24.69	45495600.0
2009-08-27	NVDA	Stock	0.347	0.3518	0.3433	0.3502	551072000.0
2009-08-27	AMZN	Stock	4.2005	4.2425	4.157	4.2155	79954000.0
2009-08-27	TLT	Stock	96.18	96.62	95.73	96.07	2513928.0
2009-08-27	ES	Stock	24.27	24.41	24.08	24.31	1295200.0
2009-08-27	CL	Stock	36.705	36.74	36.4	36.615	3550200.0
2009-08-27	A	Stock	18.2403	18.2904	18.0472	18.269	9810745.0
2009-08-27	AABA-DELISTED	Stock	14.95	15.0	14.71	14.92	30060074.0
2009-08-27	AACC-DELISTED	Stock	8.14	8.3	7.95	8.23	15582.0
2009-08-27	AACG	Stock	7.45	7.65	7.21	7.25	5700.0
2009-08-27	AAI-DELISTED	Stock	6.85	6.85	6.55	6.76	1083710.0
2009-08-27	AAIC-DELISTED	Stock	9.2	10.84	9.2	10.84	2584642.0
2009-08-27	AAON	Stock	4.316	4.3279	4.1995	4.3062	304762.0
2009-08-27	AAP	Stock	42.89	43.15	42.09	43.09	1681900.0
2009-08-27	AATI-DELISTED	Stock	4.5	4.5	4.34	4.5	103153.0
2009-08-27	AAU-DELISTED	Stock	0.64	0.67	0.64	0.64	50061.0
2009-08-27	AAUAF-DELISTED	Stock	0.6401	0.67	0.64	0.64	50860.0
2009-08-27	AAV-DELISTED	Stock	5.7	5.83	5.64	5.81	817903.0
2009-08-27	AAWW-DELISTED	Stock	24.98	24.99	23.79	24.14	138121.0
2009-08-27	AAXJ	Stock	49.13	49.31	48.44	49.31	106618.0
2009-08-27	AAXN-DELISTED	Stock	4.94	4.94	4.75	4.78	252944.0
2009-08-27	AB	Stock	21.27	21.99	20.87	21.89	583400.0
2009-08-27	ABAX-DELISTED	Stock	27.94	27.94	27.0	27.6	106107.0
2009-08-27	ABB-DELISTED	Stock	19.17	19.43	18.87	19.3	3280782.0
2009-08-27	ABBC-DELISTED	Stock	8.29	8.46	8.17	8.43	32796.0
2009-08-27	ABBNY-DELISTED	Stock	19.17	19.43	18.87	19.33	3281782.0
2009-08-27	ABC-DELISTED	Stock	20.86	21.23	20.72	21.15	2289263.0
2009-08-27	ABCB	Stock	6.507	6.5459	6.2249	6.5459	20460.0
2009-08-27	ABCO-DELISTED	Stock	13.41	13.525	13.18	13.36	60878.0
2009-08-27	ABCW-DELISTED	Stock	1.27	1.36	1.25	1.31	30640.0
2009-08-27	ABD-DELISTED	Stock	5.865	6.0251	5.7049	5.865	273960.0
2009-08-27	ABE-DELISTED	Stock	16.51	16.51	16.27	16.33	10459.0
2009-08-27	ABEO	Stock	4075.0	4187.5	4075.0	4175.0	12.0
2009-08-27	ABFS-DELISTED	Stock	31.81	32.04	30.9	31.72	251858.0
2009-08-27	ABG	Stock	13.55	13.59	12.73	13.25	285400.0
2009-08-27	ABII-DELISTED	Stock	27.505	27.8899	27.41	27.58	15900.0
2009-08-27	ABK-DELISTED	Stock	1.27	1.85	1.21	1.8	113021773.0
2009-08-27	ABM	Stock	22.99	22.99	22.48	22.76	67400.0
2009-08-27	ABMD-DELISTED	Stock	8.71	8.87	8.63	8.75	108041.0
2009-08-27	ABR	Stock	1.95	2.03	1.9	1.98	188600.0
2009-08-27	ABT	Stock	22.1524	22.3875	22.0276	22.3635	16263235.0
2009-08-27	ABTL-DELISTED	Stock	2.9002	3.2503	2.8502	3.2498	9525.0
2009-08-27	ABV-DELISTED	Stock	75.8	75.86	74.24	75.54	339750.0
2009-08-27	ABVT-DELISTED	Stock	94.85	95.47	94.0	94.28	78292.0
2009-08-27	ABX-DELISTED	Stock	34.14	34.67	33.3	34.57	5400428.0
2009-08-27	ACAD	Stock	6.14	6.18	5.92	6.05	1201600.0
2009-08-27	ACAP-DELISTED	Stock	32.8	32.8	31.63	32.03	42031.0
2009-08-27	ACAS-DELISTED	Stock	2.47	2.5	2.4	2.45	3915825.0
2009-08-27	ACAT-DELISTED	Stock	7.92	7.92	7.775	7.92	20732.0

> showing 50 of 5,797 rows — these rows as CSV

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