PREVIEW / stock_1hour / 2011-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-25.parquet
  size:    959 KB
  rows:    46,189
  symbols: 3,538

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-02-25 04:00:00	AAPL	Stock	12.3196	12.3525	12.3196	12.3525	11200.0
2011-02-25 05:00:00	AAPL	Stock	12.3429	12.3536	12.3393	12.3479	58156.0
2011-02-25 06:00:00	AAPL	Stock	12.3564	12.3568	12.3393	12.3568	93156.0
2011-02-25 07:00:00	AAPL	Stock	12.35	12.3554	12.3136	12.33	555772.0
2011-02-25 08:00:00	AAPL	Stock	12.3293	12.3368	12.2457	12.3232	1623552.0
2011-02-25 09:00:00	AAPL	Stock	12.3168	12.3696	12.3143	12.3432	68415256.0
2011-02-25 10:00:00	AAPL	Stock	12.3446	12.4296	12.3382	12.4175	78121400.0
2011-02-25 11:00:00	AAPL	Stock	12.4175	12.4386	12.3668	12.3846	62866160.0
2011-02-25 12:00:00	AAPL	Stock	12.3836	12.4264	12.3789	12.4205	27978412.0
2011-02-25 13:00:00	AAPL	Stock	12.4228	12.4286	12.3821	12.4143	38969168.0
2011-02-25 14:00:00	AAPL	Stock	12.4139	12.4213	12.3929	12.4146	29825320.0
2011-02-25 15:00:00	AAPL	Stock	12.4154	12.4439	12.4043	12.4389	53739028.0
2011-02-25 16:00:00	AAPL	Stock	12.4343	12.4429	12.3266	12.4332	13586104.0
2011-02-25 17:00:00	AAPL	Stock	12.435	12.4382	12.3701	12.4321	1888208.0
2011-02-25 18:00:00	AAPL	Stock	12.4321	12.4457	12.4311	12.4457	523376.0
2011-02-25 19:00:00	AAPL	Stock	12.4464	12.4643	12.4464	12.4643	249788.0
2011-02-25 07:00:00	MSFT	Stock	26.9	26.95	26.87	26.88	4000.0
2011-02-25 08:00:00	MSFT	Stock	26.88	26.97	26.86	26.95	28078.0
2011-02-25 09:00:00	MSFT	Stock	26.92	26.97	26.65	26.925	5871681.0
2011-02-25 10:00:00	MSFT	Stock	26.92	26.95	26.795	26.822	6209696.0
2011-02-25 11:00:00	MSFT	Stock	26.83	26.83	26.65	26.68	6677054.0
2011-02-25 12:00:00	MSFT	Stock	26.68	26.74	26.66	26.71	4994387.0
2011-02-25 13:00:00	MSFT	Stock	26.7	26.73	26.65	26.719	5086253.0
2011-02-25 14:00:00	MSFT	Stock	26.72	26.72	26.65	26.68	5471473.0
2011-02-25 15:00:00	MSFT	Stock	26.68	26.69	26.5	26.546	14350548.0
2011-02-25 16:00:00	MSFT	Stock	26.55	26.711	26.45	26.54	3447203.0
2011-02-25 17:00:00	MSFT	Stock	26.54	26.55	26.53	26.55	73685.0
2011-02-25 18:00:00	MSFT	Stock	26.55	26.59	26.54	26.54	20610.0
2011-02-25 19:00:00	MSFT	Stock	26.54	26.57	26.53	26.55	8450.0
2011-02-25 07:00:00	NVDA	Stock	0.5802	0.5802	0.5752	0.5788	214400.0
2011-02-25 08:00:00	NVDA	Stock	0.5752	0.5812	0.5732	0.58	2853800.0
2011-02-25 09:00:00	NVDA	Stock	0.5792	0.5875	0.5735	0.5758	164193080.0
2011-02-25 10:00:00	NVDA	Stock	0.5758	0.5845	0.575	0.5835	161063400.0
2011-02-25 11:00:00	NVDA	Stock	0.5838	0.5838	0.5788	0.5812	116817680.0
2011-02-25 12:00:00	NVDA	Stock	0.581	0.581	0.5792	0.5802	54773400.0
2011-02-25 13:00:00	NVDA	Stock	0.5802	0.582	0.5775	0.5785	58125040.0
2011-02-25 14:00:00	NVDA	Stock	0.5785	0.58	0.577	0.578	52015800.0
2011-02-25 15:00:00	NVDA	Stock	0.578	0.5785	0.575	0.578	138786360.0
2011-02-25 16:00:00	NVDA	Stock	0.578	0.5796	0.5662	0.5788	25422520.0
2011-02-25 17:00:00	NVDA	Stock	0.5788	0.5788	0.5768	0.577	630080.0
2011-02-25 18:00:00	NVDA	Stock	0.5775	0.5782	0.5775	0.5775	68000.0
2011-02-25 19:00:00	NVDA	Stock	0.5772	0.5782	0.5772	0.5775	129000.0
2011-02-25 05:00:00	AMZN	Stock	8.8965	8.8965	8.8965	8.8965	4000.0
2011-02-25 06:00:00	AMZN	Stock	8.91	8.91	8.91	8.91	2000.0
2011-02-25 07:00:00	AMZN	Stock	8.9415	8.965	8.9415	8.965	18000.0
2011-02-25 08:00:00	AMZN	Stock	8.95	8.9725	8.9255	8.9625	215940.0
2011-02-25 09:00:00	AMZN	Stock	8.9525	9.0375	8.9255	9.0035	11671780.0
2011-02-25 10:00:00	AMZN	Stock	9.003	9.02	8.96	8.983	11472300.0
2011-02-25 11:00:00	AMZN	Stock	8.985	9.0	8.9015	8.921	11174160.0
2011-02-25 12:00:00	AMZN	Stock	8.9195	8.956	8.918	8.9498	3913540.0

> showing 50 of 46,189 rows — these rows as CSV

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