PREVIEW / stock_daily / 2009-09-29

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-29.parquet
  size:    187 KB
  rows:    5,856
  symbols: 3,498

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-09-29	AAPL	Stock	6.6689	6.6929	6.5825	6.6207	345385600.0
2009-09-29	MSFT	Stock	25.91	25.96	25.69	25.75	39050300.0
2009-09-29	NVDA	Stock	0.373	0.3775	0.3632	0.364	470928000.0
2009-09-29	AMZN	Stock	4.598	4.6165	4.505	4.586	87878000.0
2009-09-29	TLT	Stock	98.32	99.17	98.15	98.75	3123132.0
2009-09-29	ES	Stock	23.97	24.07	23.8	24.0	1334100.0
2009-09-29	CL	Stock	38.25	38.46	37.9	38.275	5111800.0
2009-09-29	A	Stock	19.8856	20.1216	19.8212	19.9571	4369449.0
2009-09-29	AABA-DELISTED	Stock	17.51	17.66	17.21	17.45	31286741.0
2009-09-29	AACC-DELISTED	Stock	8.02	8.02	7.41	7.6	26629.0
2009-09-29	AACG	Stock	5.65	6.21	5.65	5.7	26900.0
2009-09-29	AAI-DELISTED	Stock	6.36	6.47	6.25	6.28	2791306.0
2009-09-29	AAIC-DELISTED	Stock	9.8	10.2	9.6	10.0	914923.0
2009-09-29	AAME	Stock	1.0	1.12	0.95	1.12	50100.0
2009-09-29	AAON	Stock	4.077	4.077	4.0	4.0158	754819.0
2009-09-29	AAP	Stock	39.42	39.88	39.04	39.19	1166400.0
2009-09-29	AATI-DELISTED	Stock	4.14	4.14	4.0	4.04	438019.0
2009-09-29	AAU-DELISTED	Stock	0.65	0.68	0.65	0.6699	106309.0
2009-09-29	AAUAF-DELISTED	Stock	0.65	0.68	0.65	0.6699	106809.0
2009-09-29	AAV-DELISTED	Stock	6.66	6.92	6.6	6.86	682989.0
2009-09-29	AAWW-DELISTED	Stock	32.34	32.72	31.79	32.33	158225.0
2009-09-29	AAXJ	Stock	52.33	52.47	51.92	52.28	82570.0
2009-09-29	AAXN-DELISTED	Stock	4.74	4.9	4.63	4.82	698349.0
2009-09-29	AB	Stock	26.58	27.25	26.43	27.02	480900.0
2009-09-29	ABAX-DELISTED	Stock	27.59	27.6	27.07	27.07	141414.0
2009-09-29	ABB-DELISTED	Stock	20.08	20.25	19.96	20.06	1980397.0
2009-09-29	ABBC-DELISTED	Stock	8.0	8.07	7.891	7.97	24673.0
2009-09-29	ABBNY-DELISTED	Stock	20.08	20.25	19.96	20.1	1982660.0
2009-09-29	ABC-DELISTED	Stock	21.8	22.1	21.72	21.97	2988736.0
2009-09-29	ABCB	Stock	6.9295	7.0569	6.8021	6.9099	6632.0
2009-09-29	ABCO-DELISTED	Stock	12.69	12.69	12.525	12.565	121086.0
2009-09-29	ABCW-DELISTED	Stock	1.28	1.32	1.25	1.25	40190.0
2009-09-29	ABD-DELISTED	Stock	7.36	7.37	7.14	7.18	292910.0
2009-09-29	ABE-DELISTED	Stock	17.56	17.5738	17.24	17.52	14818.0
2009-09-29	ABEO	Stock	3437.5	3625.0	3150.0	3562.5	47.0
2009-09-29	ABFS-DELISTED	Stock	30.49	30.77	29.96	30.16	231813.0
2009-09-29	ABG	Stock	13.09	13.34	13.06	13.17	128200.0
2009-09-29	ABII-DELISTED	Stock	35.21	36.23	34.5001	36.05	149730.0
2009-09-29	ABK-DELISTED	Stock	1.77	1.86	1.76	1.78	12267181.0
2009-09-29	ABM	Stock	21.11	21.56	20.9	21.33	167800.0
2009-09-29	ABMD-DELISTED	Stock	9.97	10.1	9.8	9.95	358102.0
2009-09-29	ABR	Stock	3.0	3.1	2.87	2.93	141900.0
2009-09-29	ABT	Stock	23.5006	23.7885	23.4142	23.5582	24744477.0
2009-09-29	ABTL-DELISTED	Stock	3.0	3.1	2.95	3.1	7412.0
2009-09-29	ABV-DELISTED	Stock	80.83	80.89	79.93	80.42	228880.0
2009-09-29	ABVA-DELISTED	Stock	2.321	2.7	2.32	2.32	1345.0
2009-09-29	ABVT-DELISTED	Stock	48.91	49.65	47.84	48.65	92174.0
2009-09-29	ABX-DELISTED	Stock	36.41	37.66	36.13	37.47	12594151.0
2009-09-29	ACAD	Stock	1.8	1.81	1.71	1.73	697200.0
2009-09-29	ACAP-DELISTED	Stock	29.52	29.69	29.18	29.18	40443.0

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

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