PREVIEW / stock_1hour / 2011-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-08.parquet
  size:    1.0 MB
  rows:    49,622
  symbols: 3,592

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-08-08 04:00:00	AAPL	Stock	13.2932	13.2932	13.0357	13.045	604240.0
2011-08-08 05:00:00	AAPL	Stock	13.0368	13.0536	12.975	13.0007	362264.0
2011-08-08 06:00:00	AAPL	Stock	13.0086	13.0429	13.0043	13.0357	334180.0
2011-08-08 07:00:00	AAPL	Stock	13.0289	13.1468	13.0054	13.0714	3386880.0
2011-08-08 08:00:00	AAPL	Stock	13.0539	13.0954	12.9286	13.0068	9508380.0
2011-08-08 09:00:00	AAPL	Stock	13.005	13.1346	12.8643	13.0704	177698724.0
2011-08-08 10:00:00	AAPL	Stock	13.0671	13.085	12.8143	12.8873	210965496.0
2011-08-08 11:00:00	AAPL	Stock	12.8871	13.0736	12.8793	12.9986	130262496.0
2011-08-08 12:00:00	AAPL	Stock	12.9982	13.0179	12.9025	12.9768	80850812.0
2011-08-08 13:00:00	AAPL	Stock	12.9778	13.0414	12.8904	12.8972	99816864.0
2011-08-08 14:00:00	AAPL	Stock	12.8939	12.9618	12.6864	12.7221	175236432.0
2011-08-08 15:00:00	AAPL	Stock	12.7218	12.9086	12.6079	12.6196	214962132.0
2011-08-08 16:00:00	AAPL	Stock	12.6257	12.9329	12.5	12.5536	31580920.0
2011-08-08 17:00:00	AAPL	Stock	12.5536	12.565	12.5	12.535	1582812.0
2011-08-08 18:00:00	AAPL	Stock	12.535	12.6146	12.4339	12.4554	2269736.0
2011-08-08 19:00:00	AAPL	Stock	12.4643	12.5329	12.4643	12.5107	698572.0
2011-08-08 04:00:00	MSFT	Stock	25.2	25.2	25.05	25.05	500.0
2011-08-08 05:00:00	MSFT	Stock	24.93	24.93	24.78	24.78	1200.0
2011-08-08 06:00:00	MSFT	Stock	24.88	25.0	24.88	24.99	5250.0
2011-08-08 07:00:00	MSFT	Stock	24.99	25.17	24.99	25.1	59768.0
2011-08-08 08:00:00	MSFT	Stock	25.1	25.16	25.0	25.1	124737.0
2011-08-08 09:00:00	MSFT	Stock	25.08	25.6	24.97	25.32	12648092.0
2011-08-08 10:00:00	MSFT	Stock	25.32	25.35	24.78	24.97	22283720.0
2011-08-08 11:00:00	MSFT	Stock	24.96	25.3	24.872	25.05	14785800.0
2011-08-08 12:00:00	MSFT	Stock	25.04	25.09	24.9	25.001	9071681.0
2011-08-08 13:00:00	MSFT	Stock	25.0	25.09	24.69	24.715	12938324.0
2011-08-08 14:00:00	MSFT	Stock	24.71	24.965	24.43	24.58	19437798.0
2011-08-08 15:00:00	MSFT	Stock	24.575	24.96	24.39	24.48	34158486.0
2011-08-08 16:00:00	MSFT	Stock	24.48	24.88	24.39	24.48	7261811.0
2011-08-08 17:00:00	MSFT	Stock	24.48	24.49	24.38	24.45	11265.0
2011-08-08 18:00:00	MSFT	Stock	24.48	24.48	24.2	24.2	166320.0
2011-08-08 19:00:00	MSFT	Stock	24.3	24.48	24.3	24.48	7167.0
2011-08-08 05:00:00	NVDA	Stock	0.3133	0.3133	0.3133	0.3133	20000.0
2011-08-08 06:00:00	NVDA	Stock	0.3113	0.3155	0.3113	0.3155	36000.0
2011-08-08 07:00:00	NVDA	Stock	0.3153	0.3153	0.3045	0.3052	84000.0
2011-08-08 08:00:00	NVDA	Stock	0.3075	0.3105	0.304	0.3093	1203080.0
2011-08-08 09:00:00	NVDA	Stock	0.3098	0.319	0.3061	0.312	106300320.0
2011-08-08 10:00:00	NVDA	Stock	0.3123	0.3143	0.3045	0.3095	167609120.0
2011-08-08 11:00:00	NVDA	Stock	0.3093	0.3163	0.3085	0.3145	125780640.0
2011-08-08 12:00:00	NVDA	Stock	0.3145	0.3148	0.3088	0.309	84260840.0
2011-08-08 13:00:00	NVDA	Stock	0.309	0.3105	0.3028	0.3032	117403000.0
2011-08-08 14:00:00	NVDA	Stock	0.303	0.3059	0.2962	0.3	177458480.0
2011-08-08 15:00:00	NVDA	Stock	0.3	0.3095	0.2978	0.2982	264452320.0
2011-08-08 16:00:00	NVDA	Stock	0.2982	0.3071	0.295	0.2968	37822000.0
2011-08-08 17:00:00	NVDA	Stock	0.2965	0.2982	0.2965	0.2982	47600.0
2011-08-08 18:00:00	NVDA	Stock	0.2982	0.2998	0.2978	0.2998	540120.0
2011-08-08 04:00:00	AMZN	Stock	9.918	9.918	9.868	9.868	4000.0
2011-08-08 05:00:00	AMZN	Stock	9.868	9.868	9.85	9.85	6000.0
2011-08-08 07:00:00	AMZN	Stock	9.81	9.855	9.8055	9.8055	70560.0
2011-08-08 08:00:00	AMZN	Stock	9.8055	9.836	9.779	9.779	598900.0

> showing 50 of 49,622 rows — these rows as CSV

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