PREVIEW / stock_1hour / 2012-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-09.parquet
  size:    917 KB
  rows:    43,774
  symbols: 3,475

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-07-09 04:00:00	AAPL	Stock	21.7321	21.7321	21.6071	21.6071	8400.0
2012-07-09 05:00:00	AAPL	Stock	21.5539	21.5893	21.5536	21.5893	77000.0
2012-07-09 06:00:00	AAPL	Stock	21.6321	21.6429	21.6321	21.635	16800.0
2012-07-09 07:00:00	AAPL	Stock	21.6354	21.655	21.6214	21.6389	185584.0
2012-07-09 08:00:00	AAPL	Stock	21.6568	21.6786	21.6	21.6354	1963612.0
2012-07-09 09:00:00	AAPL	Stock	21.6464	21.8382	21.5754	21.7774	78376480.0
2012-07-09 10:00:00	AAPL	Stock	21.7698	21.8892	21.7111	21.8857	75017068.0
2012-07-09 11:00:00	AAPL	Stock	21.8829	21.8875	21.7736	21.7868	39553500.0
2012-07-09 12:00:00	AAPL	Stock	21.785	21.8571	21.7818	21.8507	35136360.0
2012-07-09 13:00:00	AAPL	Stock	21.8518	21.9193	21.8371	21.8986	33933200.0
2012-07-09 14:00:00	AAPL	Stock	21.8961	21.9125	21.7896	21.827	38143028.0
2012-07-09 15:00:00	AAPL	Stock	21.8243	21.925	21.8214	21.9246	57420972.0
2012-07-09 16:00:00	AAPL	Stock	21.9246	21.9464	21.82	21.9346	12429536.0
2012-07-09 17:00:00	AAPL	Stock	21.9321	21.9418	21.9246	21.9407	153776.0
2012-07-09 18:00:00	AAPL	Stock	21.9393	21.9404	21.9314	21.9375	208516.0
2012-07-09 19:00:00	AAPL	Stock	21.9375	21.9464	21.9289	21.9464	325248.0
2012-07-09 07:00:00	MSFT	Stock	30.08	30.08	30.08	30.08	100.0
2012-07-09 08:00:00	MSFT	Stock	30.13	30.2	30.11	30.15	11755.0
2012-07-09 09:00:00	MSFT	Stock	30.15	30.23	30.02	30.05	2999328.0
2012-07-09 10:00:00	MSFT	Stock	30.05	30.1	29.83	29.94	4821517.0
2012-07-09 11:00:00	MSFT	Stock	29.945	30.02	29.79	29.79	4864535.0
2012-07-09 12:00:00	MSFT	Stock	29.79	29.92	29.78	29.89	1841450.0
2012-07-09 13:00:00	MSFT	Stock	29.88	30.03	29.85	29.99	3431519.0
2012-07-09 14:00:00	MSFT	Stock	29.99	30.0	29.85	29.913	2960004.0
2012-07-09 15:00:00	MSFT	Stock	29.92	30.01	29.89	30.01	6664362.0
2012-07-09 16:00:00	MSFT	Stock	30.01	30.055	29.925	29.99	2001761.0
2012-07-09 17:00:00	MSFT	Stock	29.98	29.98	29.96	29.96	3700.0
2012-07-09 18:00:00	MSFT	Stock	30.02	30.02	29.91	29.92	2145.0
2012-07-09 08:00:00	NVDA	Stock	0.3375	0.3375	0.335	0.335	33400.0
2012-07-09 09:00:00	NVDA	Stock	0.333	0.3345	0.3292	0.33	29745720.0
2012-07-09 10:00:00	NVDA	Stock	0.3298	0.3319	0.329	0.3299	58140120.0
2012-07-09 11:00:00	NVDA	Stock	0.33	0.3305	0.3278	0.328	41704360.0
2012-07-09 12:00:00	NVDA	Stock	0.328	0.3293	0.3278	0.3283	34574880.0
2012-07-09 13:00:00	NVDA	Stock	0.3284	0.3318	0.3283	0.331	28794640.0
2012-07-09 14:00:00	NVDA	Stock	0.3308	0.331	0.3285	0.3293	25670160.0
2012-07-09 15:00:00	NVDA	Stock	0.329	0.3305	0.3283	0.3303	70057880.0
2012-07-09 16:00:00	NVDA	Stock	0.3303	0.3315	0.3265	0.3275	3268040.0
2012-07-09 17:00:00	NVDA	Stock	0.3273	0.3305	0.3258	0.326	913600.0
2012-07-09 18:00:00	NVDA	Stock	0.3273	0.3273	0.3273	0.3273	48000.0
2012-07-09 19:00:00	NVDA	Stock	0.3273	0.3273	0.3273	0.3273	8000.0
2012-07-09 07:00:00	AMZN	Stock	11.245	11.245	11.245	11.245	18400.0
2012-07-09 08:00:00	AMZN	Stock	11.2415	11.242	11.225	11.2395	47800.0
2012-07-09 09:00:00	AMZN	Stock	11.235	11.3	11.18	11.197	5604300.0
2012-07-09 10:00:00	AMZN	Stock	11.196	11.243	11.1725	11.2365	7868440.0
2012-07-09 11:00:00	AMZN	Stock	11.2405	11.287	11.224	11.226	5054720.0
2012-07-09 12:00:00	AMZN	Stock	11.2255	11.2295	11.1855	11.2085	3981420.0
2012-07-09 13:00:00	AMZN	Stock	11.211	11.2665	11.2105	11.2575	3269560.0
2012-07-09 14:00:00	AMZN	Stock	11.258	11.2665	11.189	11.2105	3109080.0
2012-07-09 15:00:00	AMZN	Stock	11.211	11.2565	11.19	11.2515	7238660.0
2012-07-09 16:00:00	AMZN	Stock	11.2525	11.275	11.2169	11.2525	2078180.0

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

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