PREVIEW / stock_daily / 2010-03-12

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-12.parquet
  size:    190 KB
  rows:    5,921
  symbols: 3,497

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-03-12	AAPL	Stock	8.1204	8.1332	8.0625	8.0929	416323600.0
2010-03-12	MSFT	Stock	29.32	29.38	29.04	29.27	31700200.0
2010-03-12	NVDA	Stock	0.4345	0.4358	0.429	0.4312	520352000.0
2010-03-12	AMZN	Stock	6.71	6.71	6.559	6.591	123016000.0
2010-03-12	TLT	Stock	89.77	90.65	89.7301	90.48	3099362.0
2010-03-12	ES	Stock	26.92	26.96	26.66	26.81	976300.0
2010-03-12	CL	Stock	41.875	42.15	41.855	42.075	4126400.0
2010-03-12	A	Stock	24.0486	24.1559	23.8412	23.9056	4015755.0
2010-03-12	AABA-DELISTED	Stock	16.5	16.59	16.26	16.32	21844243.0
2010-03-12	AACC-DELISTED	Stock	5.8	6.09	5.8	6.03	35817.0
2010-03-12	AACG	Stock	3.99	4.59	3.75	4.53	466400.0
2010-03-12	AAI-DELISTED	Stock	5.38	5.5	5.27	5.5	3000122.0
2010-03-12	AAIC-DELISTED	Stock	18.94	18.97	18.49	18.6	59216.0
2010-03-12	AAME	Stock	1.57	1.57	1.56	1.56	1500.0
2010-03-12	AAON	Stock	4.3121	4.3121	4.2588	4.2864	253125.0
2010-03-12	AAP	Stock	42.44	42.55	42.04	42.18	1155000.0
2010-03-12	AATI-DELISTED	Stock	3.42	3.4801	3.38	3.43	546836.0
2010-03-12	AAU-DELISTED	Stock	0.92	0.935	0.9102	0.9102	45714.0
2010-03-12	AAUAF-DELISTED	Stock	0.92	0.935	0.9102	0.9102	45914.0
2010-03-12	AAV-DELISTED	Stock	7.93	8.07	7.63	7.85	590239.0
2010-03-12	AAWW-DELISTED	Stock	48.06	48.29	46.91	48.11	237157.0
2010-03-12	AAXJ	Stock	55.71	55.8901	55.55	55.73	106000.0
2010-03-12	AAXN-DELISTED	Stock	7.1	7.1	6.91	6.94	1166645.0
2010-03-12	AB	Stock	29.5	29.69	29.25	29.4	420500.0
2010-03-12	ABAX-DELISTED	Stock	26.95	27.44	26.88	27.44	162853.0
2010-03-12	ABB-DELISTED	Stock	21.2	21.2	21.04	21.16	1695556.0
2010-03-12	ABBC-DELISTED	Stock	8.0495	8.08	8.03	8.03	20443.0
2010-03-12	ABBNY-DELISTED	Stock	21.2	21.2	21.04	21.15	1718178.0
2010-03-12	ABC-DELISTED	Stock	28.17	28.25	27.8	27.94	2323903.0
2010-03-12	ABCB	Stock	9.9063	9.9063	9.6297	9.6791	17212.0
2010-03-12	ABCD-DELISTED	Stock	3.7499	3.78	3.67	3.67	131281.0
2010-03-12	ABCO-DELISTED	Stock	16.415	16.48	16.195	16.345	144785.0
2010-03-12	ABCW-DELISTED	Stock	1.22	1.25	1.19	1.25	272160.0
2010-03-12	ABD-DELISTED	Stock	8.1	8.16	7.65	7.76	229540.0
2010-03-12	ABE-DELISTED	Stock	16.81	16.81	16.6	16.65	9198.0
2010-03-12	ABEO	Stock	3187.5	3250.0	3125.0	3187.5	17.0
2010-03-12	ABFS-DELISTED	Stock	29.16	29.74	28.38	28.78	455249.0
2010-03-12	ABG	Stock	13.46	13.6	13.16	13.29	258700.0
2010-03-12	ABII-DELISTED	Stock	38.65	42.94	37.55	39.66	124523.0
2010-03-12	ABK-DELISTED	Stock	0.81	0.81	0.7756	0.79	4977056.0
2010-03-12	ABM	Stock	20.0	20.0	19.74	19.98	229600.0
2010-03-12	ABMD-DELISTED	Stock	10.8	10.8	10.26	10.39	307376.0
2010-03-12	ABR	Stock	2.9	2.98	2.87	2.97	162000.0
2010-03-12	ABT	Stock	26.4082	26.413	25.7749	26.1587	33828679.0
2010-03-12	ABTL-DELISTED	Stock	5.35	5.35	5.105	5.35	8291.0
2010-03-12	ABV-DELISTED	Stock	97.02	97.22	96.2	96.56	408995.0
2010-03-12	ABVA-DELISTED	Stock	2.6	2.605	2.58	2.605	11300.0
2010-03-12	ABVT-DELISTED	Stock	55.17	55.17	53.21	54.69	295055.0
2010-03-12	ABX-DELISTED	Stock	39.27	39.52	38.63	39.08	8467933.0
2010-03-12	ACAD	Stock	1.41	1.55	1.39	1.55	2392600.0

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

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