PREVIEW / stock_1hour / 2013-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-14.parquet
  size:    941 KB
  rows:    44,323
  symbols: 3,469

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
2013-01-14 04:00:00	AAPL	Stock	18.5857	18.5857	18.1789	18.1793	284648.0
2013-01-14 05:00:00	AAPL	Stock	18.1832	18.1875	17.9293	17.9571	742812.0
2013-01-14 06:00:00	AAPL	Stock	17.9786	17.9804	17.75	17.8929	1910440.0
2013-01-14 07:00:00	AAPL	Stock	17.9018	17.9818	17.8557	17.9471	4715956.0
2013-01-14 08:00:00	AAPL	Stock	17.9589	18.1571	17.875	18.06	18777584.0
2013-01-14 09:00:00	AAPL	Stock	18.0589	18.0832	17.8039	17.9021	204152116.0
2013-01-14 10:00:00	AAPL	Stock	17.8984	18.125	17.8804	18.0954	109255356.0
2013-01-14 11:00:00	AAPL	Stock	18.0971	18.1111	17.9714	18.0118	57824732.0
2013-01-14 12:00:00	AAPL	Stock	18.0109	18.0257	17.9318	17.9375	42098952.0
2013-01-14 13:00:00	AAPL	Stock	17.9375	17.9686	17.89	17.9043	57317176.0
2013-01-14 14:00:00	AAPL	Stock	17.9014	18.0575	17.8821	17.9607	68431020.0
2013-01-14 15:00:00	AAPL	Stock	17.9614	18.0157	17.8554	17.925	122879372.0
2013-01-14 16:00:00	AAPL	Stock	17.9196	17.9592	17.876	17.9393	27418944.0
2013-01-14 17:00:00	AAPL	Stock	17.9404	17.9554	17.9111	17.95	1513820.0
2013-01-14 18:00:00	AAPL	Stock	17.9536	17.9639	17.9293	17.9429	878948.0
2013-01-14 19:00:00	AAPL	Stock	17.9361	17.9821	17.9361	17.9811	511840.0
2013-01-14 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	200.0
2013-01-14 05:00:00	MSFT	Stock	26.94	26.94	26.94	26.94	115.0
2013-01-14 06:00:00	MSFT	Stock	26.95	26.97	26.95	26.95	1500.0
2013-01-14 07:00:00	MSFT	Stock	26.93	26.93	26.85	26.86	15400.0
2013-01-14 08:00:00	MSFT	Stock	26.88	26.93	26.83	26.89	34091.0
2013-01-14 09:00:00	MSFT	Stock	26.91	26.98	26.82	26.87	4446526.0
2013-01-14 10:00:00	MSFT	Stock	26.88	26.89	26.83	26.84	3846435.0
2013-01-14 11:00:00	MSFT	Stock	26.845	26.86	26.76	26.837	5192187.0
2013-01-14 12:00:00	MSFT	Stock	26.836	26.91	26.8	26.89	3508846.0
2013-01-14 13:00:00	MSFT	Stock	26.889	26.89	26.84	26.85	3094249.0
2013-01-14 14:00:00	MSFT	Stock	26.859	27.08	26.85	26.945	12152353.0
2013-01-14 15:00:00	MSFT	Stock	26.945	26.95	26.77	26.9	11563777.0
2013-01-14 16:00:00	MSFT	Stock	26.9	26.969	26.84	26.9	4076966.0
2013-01-14 17:00:00	MSFT	Stock	26.868	26.91	26.868	26.9	6301.0
2013-01-14 18:00:00	MSFT	Stock	26.85	26.92	26.85	26.89	3884.0
2013-01-14 19:00:00	MSFT	Stock	26.91	26.92	26.9	26.9	11064.0
2013-01-14 09:00:00	NVDA	Stock	0.3057	0.3073	0.3028	0.3028	48498160.0
2013-01-14 10:00:00	NVDA	Stock	0.303	0.3038	0.3015	0.3032	44551160.0
2013-01-14 11:00:00	NVDA	Stock	0.3031	0.3048	0.3028	0.3038	27960680.0
2013-01-14 12:00:00	NVDA	Stock	0.3038	0.3042	0.3022	0.3025	23781480.0
2013-01-14 13:00:00	NVDA	Stock	0.3025	0.3025	0.3015	0.3022	32352440.0
2013-01-14 14:00:00	NVDA	Stock	0.3022	0.3042	0.302	0.3041	51968400.0
2013-01-14 15:00:00	NVDA	Stock	0.3042	0.3058	0.3035	0.305	66837320.0
2013-01-14 16:00:00	NVDA	Stock	0.305	0.305	0.3037	0.304	1692880.0
2013-01-14 17:00:00	NVDA	Stock	0.304	0.304	0.304	0.304	64000.0
2013-01-14 19:00:00	NVDA	Stock	0.305	0.305	0.3042	0.3042	34480.0
2013-01-14 04:00:00	AMZN	Stock	13.443	13.45	13.4	13.438	10000.0
2013-01-14 05:00:00	AMZN	Stock	13.4315	13.4315	13.4225	13.4225	10000.0
2013-01-14 06:00:00	AMZN	Stock	13.4225	13.435	13.42	13.43	12000.0
2013-01-14 07:00:00	AMZN	Stock	13.4445	13.4445	13.35	13.3535	28000.0
2013-01-14 08:00:00	AMZN	Stock	13.3535	13.3995	13.3525	13.3688	43540.0
2013-01-14 09:00:00	AMZN	Stock	13.39	13.668	13.36	13.5875	17756700.0
2013-01-14 10:00:00	AMZN	Stock	13.5875	13.6235	13.495	13.61	13430620.0
2013-01-14 11:00:00	AMZN	Stock	13.605	13.713	13.5945	13.6845	13507400.0

> showing 50 of 44,323 rows — these rows as CSV

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