PREVIEW / stock_daily / 2010-01-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-20.parquet
  size:    189 KB
  rows:    5,891
  symbols: 3,478

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
2010-01-20	AAPL	Stock	7.6754	7.6982	7.4821	7.5618	612152800.0
2010-01-20	MSFT	Stock	30.81	30.94	30.31	30.59	54849500.0
2010-01-20	NVDA	Stock	0.4302	0.4358	0.4245	0.434	719728000.0
2010-01-20	AMZN	Stock	6.3565	6.46	6.254	6.289	181494000.0
2010-01-20	TLT	Stock	91.32	91.7701	91.27	91.74	2800568.0
2010-01-20	ES	Stock	26.22	26.36	26.06	26.28	1347500.0
2010-01-20	CL	Stock	40.06	40.06	39.2	39.605	7762000.0
2010-01-20	A	Stock	21.8383	21.9385	21.5951	21.9099	4589075.0
2010-01-20	AABA-DELISTED	Stock	16.65	16.68	16.25	16.39	14335750.0
2010-01-20	AACC-DELISTED	Stock	6.07	6.18	5.73	5.85	40669.0
2010-01-20	AACG	Stock	4.5	4.51	4.23	4.24	5600.0
2010-01-20	AAI-DELISTED	Stock	5.42	5.51	5.35	5.46	3682440.0
2010-01-20	AAIC-DELISTED	Stock	16.0	16.36	15.95	16.2	16878.0
2010-01-20	AAME	Stock	1.35	1.47	1.35	1.47	10100.0
2010-01-20	AAON	Stock	3.7768	3.7768	3.7314	3.761	314887.0
2010-01-20	AAP	Stock	38.75	39.38	38.38	39.16	1865000.0
2010-01-20	AATI-DELISTED	Stock	3.95	3.99	3.91	3.94	225476.0
2010-01-20	AAU-DELISTED	Stock	1.11	1.11	1.01	1.04	418331.0
2010-01-20	AAUAF-DELISTED	Stock	1.11	1.11	1.01	1.04	423048.0
2010-01-20	AAV-DELISTED	Stock	6.74	6.8	6.51	6.77	1046801.0
2010-01-20	AAWW-DELISTED	Stock	39.29	39.45	38.25	38.83	516606.0
2010-01-20	AAXJ	Stock	56.77	57.56	56.41	56.75	270446.0
2010-01-20	AAXN-DELISTED	Stock	6.29	6.36	6.1101	6.25	739107.0
2010-01-20	AB	Stock	29.58	29.7	29.0	29.66	287600.0
2010-01-20	ABAX-DELISTED	Stock	25.67	25.77	24.69	25.1	224436.0
2010-01-20	ABB-DELISTED	Stock	19.18	19.19	18.86	19.08	4320577.0
2010-01-20	ABBC-DELISTED	Stock	7.12	7.19	7.0	7.13	20873.0
2010-01-20	ABBNY-DELISTED	Stock	19.18	19.19	18.86	19.08	4321077.0
2010-01-20	ABC-DELISTED	Stock	27.33	27.35	26.74	27.1	2659173.0
2010-01-20	ABCB	Stock	8.4149	8.7902	8.4149	8.7606	68951.0
2010-01-20	ABCD-DELISTED	Stock	4.06	4.1	3.99	4.03	19244.0
2010-01-20	ABCO-DELISTED	Stock	16.105	16.405	15.875	16.375	179962.0
2010-01-20	ABCW-DELISTED	Stock	1.2398	1.4037	1.1475	1.25	584170.0
2010-01-20	ABD-DELISTED	Stock	8.37	8.41	8.06	8.2	462650.0
2010-01-20	ABE-DELISTED	Stock	17.05	17.05	16.63	16.8324	14374.0
2010-01-20	ABEO	Stock	3812.5	3875.0	3700.0	3750.0	70.0
2010-01-20	ABFS-DELISTED	Stock	27.28	27.3	26.26	26.95	461909.0
2010-01-20	ABG	Stock	13.01	13.14	12.75	12.94	367700.0
2010-01-20	ABII-DELISTED	Stock	40.85	42.41	40.85	41.75	60416.0
2010-01-20	ABK-DELISTED	Stock	0.735	0.76	0.7187	0.7599	6547190.0
2010-01-20	ABM	Stock	20.47	20.47	20.0	20.2	135800.0
2010-01-20	ABMD-DELISTED	Stock	8.27	8.51	8.22	8.49	181082.0
2010-01-20	ABR	Stock	2.38	2.45	2.36	2.44	84400.0
2010-01-20	ABT	Stock	26.9792	27.2478	26.6817	26.984	14080659.0
2010-01-20	ABTL-DELISTED	Stock	4.8	5.05	4.6085	5.05	17963.0
2010-01-20	ABV-DELISTED	Stock	103.19	103.37	100.68	101.95	505181.0
2010-01-20	ABVA-DELISTED	Stock	3.07	3.07	2.91	2.91	1376.0
2010-01-20	ABVT-DELISTED	Stock	63.15	63.15	61.3	62.53	67412.0
2010-01-20	ABX-DELISTED	Stock	38.46	38.64	37.23	37.87	16203546.0
2010-01-20	ACAD	Stock	1.38	1.42	1.35	1.37	295000.0

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

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