PREVIEW / stock_1hour / 2012-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-24.parquet
  size:    912 KB
  rows:    43,200
  symbols: 3,462

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
2012-10-24 04:00:00	AAPL	Stock	21.9732	22.0536	21.9732	22.04	11200.0
2012-10-24 06:00:00	AAPL	Stock	22.0357	22.0379	22.0286	22.0379	25200.0
2012-10-24 07:00:00	AAPL	Stock	22.0357	22.0857	21.9464	22.0189	780108.0
2012-10-24 08:00:00	AAPL	Stock	22.0189	22.0982	21.9536	22.0539	2689064.0
2012-10-24 09:00:00	AAPL	Stock	22.0575	22.3768	22.0536	22.3157	100494492.0
2012-10-24 10:00:00	AAPL	Stock	22.3096	22.3207	21.9407	21.9536	103805044.0
2012-10-24 11:00:00	AAPL	Stock	21.9568	22.0439	21.8518	21.8796	73441536.0
2012-10-24 12:00:00	AAPL	Stock	21.8797	22.0782	21.8086	22.0161	61728044.0
2012-10-24 13:00:00	AAPL	Stock	22.0051	22.0789	21.9214	22.0325	37912028.0
2012-10-24 14:00:00	AAPL	Stock	22.0375	22.2054	21.9464	22.1004	77597716.0
2012-10-24 15:00:00	AAPL	Stock	22.0911	22.1071	21.9557	22.0175	78501864.0
2012-10-24 16:00:00	AAPL	Stock	22.0189	22.0856	21.9221	22.0357	11978848.0
2012-10-24 17:00:00	AAPL	Stock	22.0429	22.0439	21.9471	21.9821	1128484.0
2012-10-24 18:00:00	AAPL	Stock	21.9786	22.0121	21.9689	21.9721	346108.0
2012-10-24 19:00:00	AAPL	Stock	21.9736	21.9768	21.9536	21.965	492660.0
2012-10-24 05:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	1300.0
2012-10-24 06:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	10600.0
2012-10-24 07:00:00	MSFT	Stock	28.1	28.1	27.94	28.0	5515.0
2012-10-24 08:00:00	MSFT	Stock	28.0	28.23	28.0	28.23	69802.0
2012-10-24 09:00:00	MSFT	Stock	28.21	28.23	27.93	28.052	7653710.0
2012-10-24 10:00:00	MSFT	Stock	28.05	28.11	27.98	28.05	6759644.0
2012-10-24 11:00:00	MSFT	Stock	28.055	28.07	27.92	27.956	6458745.0
2012-10-24 12:00:00	MSFT	Stock	27.96	28.06	27.94	27.967	3850391.0
2012-10-24 13:00:00	MSFT	Stock	27.97	28.15	27.955	28.08	8349869.0
2012-10-24 14:00:00	MSFT	Stock	28.08	28.14	28.0	28.04	6522138.0
2012-10-24 15:00:00	MSFT	Stock	28.04	28.05	27.87	27.89	9980231.0
2012-10-24 16:00:00	MSFT	Stock	27.89	28.077	27.867	27.93	3207314.0
2012-10-24 17:00:00	MSFT	Stock	27.91	27.98	27.91	27.97	7905.0
2012-10-24 18:00:00	MSFT	Stock	27.97	27.98	27.95	27.98	13565.0
2012-10-24 19:00:00	MSFT	Stock	27.98	27.99	27.95	27.99	3332.0
2012-10-24 08:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	13680.0
2012-10-24 09:00:00	NVDA	Stock	0.308	0.3115	0.3048	0.3048	54071640.0
2012-10-24 10:00:00	NVDA	Stock	0.305	0.3055	0.303	0.3035	56503760.0
2012-10-24 11:00:00	NVDA	Stock	0.3035	0.3038	0.3012	0.3022	33442040.0
2012-10-24 12:00:00	NVDA	Stock	0.3024	0.3062	0.3015	0.3052	35675960.0
2012-10-24 13:00:00	NVDA	Stock	0.3055	0.3055	0.3042	0.305	17794160.0
2012-10-24 14:00:00	NVDA	Stock	0.305	0.305	0.3022	0.3028	44885520.0
2012-10-24 15:00:00	NVDA	Stock	0.3028	0.3045	0.3025	0.3045	73651400.0
2012-10-24 16:00:00	NVDA	Stock	0.3042	0.308	0.3033	0.3038	15745400.0
2012-10-24 17:00:00	NVDA	Stock	0.3042	0.3048	0.3042	0.3048	739840.0
2012-10-24 08:00:00	AMZN	Stock	11.794	11.7975	11.762	11.7975	50600.0
2012-10-24 09:00:00	AMZN	Stock	11.815	11.817	11.5325	11.5513	12804000.0
2012-10-24 10:00:00	AMZN	Stock	11.55	11.582	11.4785	11.5275	15127600.0
2012-10-24 11:00:00	AMZN	Stock	11.5305	11.548	11.492	11.496	5854100.0
2012-10-24 12:00:00	AMZN	Stock	11.495	11.55	11.469	11.5395	4895760.0
2012-10-24 13:00:00	AMZN	Stock	11.542	11.55	11.4635	11.5125	8168660.0
2012-10-24 14:00:00	AMZN	Stock	11.5103	11.575	11.4555	11.4565	6052560.0
2012-10-24 15:00:00	AMZN	Stock	11.456	11.4735	11.3975	11.42	16422560.0
2012-10-24 16:00:00	AMZN	Stock	11.4225	11.726	11.4125	11.5309	679780.0
2012-10-24 17:00:00	AMZN	Stock	11.4245	11.44	11.4245	11.43	257780.0

> showing 50 of 43,200 rows — these rows as CSV

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