PREVIEW / stock_daily / 2011-01-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-04.parquet
  size:    196 KB
  rows:    6,045
  symbols: 3,524

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-01-04	AAPL	Stock	11.8729	11.875	11.7196	11.8318	309080800.0
2011-01-04	MSFT	Stock	27.94	28.17	27.85	28.09	54405600.0
2011-01-04	NVDA	Stock	0.3962	0.398	0.3855	0.3942	651384000.0
2011-01-04	AMZN	Stock	9.3075	9.385	9.189	9.2505	100636000.0
2011-01-04	TSLA	Stock	1.7773	1.7967	1.7347	1.778	17811000.0
2011-01-04	TLT	Stock	93.41	93.765	92.91	93.52	10467657.0
2011-01-04	ES	Stock	32.04	32.04	31.64	31.9	2075900.0
2011-01-04	CL	Stock	39.765	40.13	39.665	39.84	5136000.0
2011-01-04	A	Stock	30.0358	30.1144	29.4564	29.6781	5017282.0
2011-01-04	AABA-DELISTED	Stock	16.72	16.8299	16.57	16.6	10887824.0
2011-01-04	AACC-DELISTED	Stock	6.15	6.15	6.06	6.11	13070.0
2011-01-04	AACG	Stock	3.66	3.74	3.65	3.74	1800.0
2011-01-04	AAI-DELISTED	Stock	7.47	7.48	7.43	7.47	2472858.0
2011-01-04	AAIC-DELISTED	Stock	24.61	24.61	23.8	24.06	21661.0
2011-01-04	AAME	Stock	2.06	2.07	2.06	2.07	3300.0
2011-01-04	AAON	Stock	5.7541	5.7541	5.5249	5.5506	99731.0
2011-01-04	AAP	Stock	65.46	65.5	61.86	62.24	1916600.0
2011-01-04	AATI-DELISTED	Stock	4.06	4.07	3.86	3.87	134849.0
2011-01-04	AAU-DELISTED	Stock	5.13	5.19	4.69	4.78	951246.0
2011-01-04	AAUAF-DELISTED	Stock	5.13	5.19	4.69	4.78	952300.0
2011-01-04	AAV-DELISTED	Stock	6.83	6.9	6.72	6.81	323114.0
2011-01-04	AAWW-DELISTED	Stock	56.0	56.0	53.44	53.98	217936.0
2011-01-04	AAXJ	Stock	65.19	65.19	64.3601	64.93	574243.0
2011-01-04	AAXN-DELISTED	Stock	4.98	5.09	4.77	4.77	899434.0
2011-01-04	AB	Stock	23.8	24.01	23.45	23.57	474900.0
2011-01-04	ABAC-DELISTED	Stock	6.2	6.2	5.83	5.9	67019.0
2011-01-04	ABAX-DELISTED	Stock	27.24	27.24	26.22	26.26	112643.0
2011-01-04	ABB-DELISTED	Stock	22.75	22.77	22.24	22.32	3614112.0
2011-01-04	ABBC-DELISTED	Stock	11.97	11.97	11.55	11.73	29462.0
2011-01-04	ABBNY-DELISTED	Stock	22.75	22.77	22.24	22.36	3618319.0
2011-01-04	ABC-DELISTED	Stock	34.43	34.48	33.91	33.95	2063084.0
2011-01-04	ABCB	Stock	10.9	10.92	10.45	10.58	39900.0
2011-01-04	ABCD-DELISTED	Stock	3.47	3.47	3.36	3.4	22288.0
2011-01-04	ABCO-DELISTED	Stock	24.08	24.39	23.85	24.15	124112.0
2011-01-04	ABCW-DELISTED	Stock	1.1812	1.269	1.1812	1.23	84280.0
2011-01-04	ABD-DELISTED	Stock	8.86	8.94	8.48	8.79	515070.0
2011-01-04	ABE-DELISTED	Stock	19.5	19.5	19.206	19.42	7801.0
2011-01-04	ABEO	Stock	3012.5	3062.5	3000.0	3062.5	10.0
2011-01-04	ABFS-DELISTED	Stock	28.13	28.13	26.91	27.34	185950.0
2011-01-04	ABG	Stock	18.88	19.0	18.29	18.51	204000.0
2011-01-04	ABH-DELISTED	Stock	23.85	23.85	22.94	23.25	157025.0
2011-01-04	ABM	Stock	26.62	26.62	25.68	26.08	227600.0
2011-01-04	ABMD-DELISTED	Stock	9.85	9.87	9.74	9.8	134322.0
2011-01-04	ABR	Stock	5.85	5.85	5.71	5.71	26200.0
2011-01-04	ABT	Stock	23.0496	23.1839	22.9344	23.1599	18826386.0
2011-01-04	ABTL-DELISTED	Stock	4.4	4.4	4.2785	4.3	6417.0
2011-01-04	ABUS	Stock	4.6	4.78	4.6	4.75	16100.0
2011-01-04	ABV-DELISTED	Stock	31.84	31.89	30.92	31.18	3122975.0
2011-01-04	ABVT-DELISTED	Stock	60.51	61.425	60.51	60.82	189037.0
2011-01-04	ABX-DELISTED	Stock	52.21	52.42	50.6	51.62	11179595.0

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

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