PREVIEW / stock_1hour / 2011-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-07.parquet
  size:    936 KB
  rows:    45,002
  symbols: 3,513

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-09-07 04:00:00	AAPL	Stock	13.6496	13.6964	13.6429	13.6607	67480.0
2011-09-07 05:00:00	AAPL	Stock	13.6679	13.6679	13.6432	13.6436	39200.0
2011-09-07 06:00:00	AAPL	Stock	13.6429	13.6614	13.6429	13.6607	52136.0
2011-09-07 07:00:00	AAPL	Stock	13.675	13.71	13.6739	13.6825	923944.0
2011-09-07 08:00:00	AAPL	Stock	13.6868	13.7664	13.6696	13.7536	4055212.0
2011-09-07 09:00:00	AAPL	Stock	13.7507	13.7768	13.6804	13.6989	68745628.0
2011-09-07 10:00:00	AAPL	Stock	13.7	13.71	13.6429	13.6696	69402648.0
2011-09-07 11:00:00	AAPL	Stock	13.6718	13.7186	13.6593	13.6975	36479212.0
2011-09-07 12:00:00	AAPL	Stock	13.6984	13.7096	13.6757	13.7032	20361656.0
2011-09-07 13:00:00	AAPL	Stock	13.7021	13.7393	13.6889	13.7157	30760772.0
2011-09-07 14:00:00	AAPL	Stock	13.7168	13.7486	13.7146	13.7243	37245740.0
2011-09-07 15:00:00	AAPL	Stock	13.7243	13.7393	13.6946	13.7114	56105644.0
2011-09-07 16:00:00	AAPL	Stock	13.7114	13.7731	13.7044	13.7104	18818044.0
2011-09-07 17:00:00	AAPL	Stock	13.7107	13.7175	13.7089	13.715	353108.0
2011-09-07 18:00:00	AAPL	Stock	13.715	13.7282	13.7118	13.725	504728.0
2011-09-07 19:00:00	AAPL	Stock	13.7236	13.7321	13.7232	13.7236	401268.0
2011-09-07 04:00:00	MSFT	Stock	25.64	25.64	25.64	25.64	100.0
2011-09-07 05:00:00	MSFT	Stock	25.64	25.64	25.64	25.64	100.0
2011-09-07 06:00:00	MSFT	Stock	25.65	25.8	25.65	25.8	3700.0
2011-09-07 07:00:00	MSFT	Stock	25.8	25.8	25.68	25.68	5200.0
2011-09-07 08:00:00	MSFT	Stock	25.7	25.77	25.68	25.76	15790.0
2011-09-07 09:00:00	MSFT	Stock	25.75	25.86	25.57	25.86	3639751.0
2011-09-07 10:00:00	MSFT	Stock	25.86	25.87	25.69	25.784	5954672.0
2011-09-07 11:00:00	MSFT	Stock	25.785	25.93	25.76	25.912	4628487.0
2011-09-07 12:00:00	MSFT	Stock	25.918	25.93	25.78	25.88	3545215.0
2011-09-07 13:00:00	MSFT	Stock	25.88	25.95	25.86	25.91	2905792.0
2011-09-07 14:00:00	MSFT	Stock	25.91	26.0	25.88	26.0	3780711.0
2011-09-07 15:00:00	MSFT	Stock	26.0	26.0	25.85	26.0	10082429.0
2011-09-07 16:00:00	MSFT	Stock	26.0	26.09	25.787	26.03	5932910.0
2011-09-07 17:00:00	MSFT	Stock	26.02	26.03	25.845	26.02	203660.0
2011-09-07 18:00:00	MSFT	Stock	26.02	26.05	26.0	26.05	51568.0
2011-09-07 19:00:00	MSFT	Stock	26.05	26.05	26.03	26.03	2917.0
2011-09-07 04:00:00	NVDA	Stock	0.3493	0.3493	0.3493	0.3493	4000.0
2011-09-07 05:00:00	NVDA	Stock	0.345	0.3482	0.345	0.3475	98000.0
2011-09-07 07:00:00	NVDA	Stock	0.349	0.3505	0.3462	0.3462	1273880.0
2011-09-07 08:00:00	NVDA	Stock	0.3498	0.353	0.3475	0.35	11318320.0
2011-09-07 09:00:00	NVDA	Stock	0.3518	0.366	0.3502	0.3542	399906400.0
2011-09-07 10:00:00	NVDA	Stock	0.3542	0.3568	0.3465	0.3482	393541880.0
2011-09-07 11:00:00	NVDA	Stock	0.3482	0.3585	0.3482	0.3572	122045640.0
2011-09-07 12:00:00	NVDA	Stock	0.3572	0.3578	0.354	0.3565	83424200.0
2011-09-07 13:00:00	NVDA	Stock	0.3563	0.3618	0.356	0.3618	131805560.0
2011-09-07 14:00:00	NVDA	Stock	0.3616	0.3622	0.356	0.3575	150795560.0
2011-09-07 15:00:00	NVDA	Stock	0.3575	0.3575	0.3515	0.3562	273163960.0
2011-09-07 16:00:00	NVDA	Stock	0.3561	0.3575	0.3538	0.3562	33118960.0
2011-09-07 17:00:00	NVDA	Stock	0.3562	0.3565	0.3548	0.3548	701600.0
2011-09-07 18:00:00	NVDA	Stock	0.3545	0.3562	0.3535	0.3535	545440.0
2011-09-07 19:00:00	NVDA	Stock	0.3535	0.3562	0.3535	0.3562	548320.0
2011-09-07 04:00:00	AMZN	Stock	10.8605	10.89	10.8395	10.89	14000.0
2011-09-07 07:00:00	AMZN	Stock	10.938	10.938	10.9	10.9	72700.0
2011-09-07 08:00:00	AMZN	Stock	10.8975	10.915	10.88	10.91	470720.0

> showing 50 of 45,002 rows — these rows as CSV

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