PREVIEW / stock_1hour / 2011-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-31.parquet
  size:    946 KB
  rows:    45,563
  symbols: 3,542

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-31 04:00:00	AAPL	Stock	13.9461	13.9804	13.9461	13.9804	16800.0
2011-08-31 05:00:00	AAPL	Stock	14.0079	14.0079	14.0036	14.0039	11200.0
2011-08-31 06:00:00	AAPL	Stock	14.0039	14.0139	14.0039	14.0039	23380.0
2011-08-31 07:00:00	AAPL	Stock	14.0	14.0	13.9482	13.9579	628712.0
2011-08-31 08:00:00	AAPL	Stock	13.9586	13.9843	13.9282	13.9761	3840060.0
2011-08-31 09:00:00	AAPL	Stock	13.9764	14.0029	13.9007	13.9189	68168828.0
2011-08-31 10:00:00	AAPL	Stock	13.9193	13.9554	13.8747	13.8789	79373868.0
2011-08-31 11:00:00	AAPL	Stock	13.8791	13.9054	13.7143	13.7146	88220860.0
2011-08-31 12:00:00	AAPL	Stock	13.7143	13.8304	13.7143	13.8004	54468988.0
2011-08-31 13:00:00	AAPL	Stock	13.7996	13.8118	13.7189	13.72	36665832.0
2011-08-31 14:00:00	AAPL	Stock	13.719	13.7379	13.655	13.6911	63437836.0
2011-08-31 15:00:00	AAPL	Stock	13.6907	13.7482	13.6379	13.7432	99662696.0
2011-08-31 16:00:00	AAPL	Stock	13.7396	13.8864	13.7054	13.75	22993516.0
2011-08-31 17:00:00	AAPL	Stock	13.7518	13.7518	13.7286	13.7446	1651860.0
2011-08-31 18:00:00	AAPL	Stock	13.745	13.75	13.7396	13.7446	187740.0
2011-08-31 19:00:00	AAPL	Stock	13.7496	13.7625	13.7482	13.7525	107240.0
2011-08-31 05:00:00	MSFT	Stock	26.27	26.3	26.27	26.3	700.0
2011-08-31 07:00:00	MSFT	Stock	26.26	26.31	26.16	26.3	7220.0
2011-08-31 08:00:00	MSFT	Stock	26.27	26.38	26.23	26.37	73260.0
2011-08-31 09:00:00	MSFT	Stock	26.36	26.5	26.26	26.457	5897946.0
2011-08-31 10:00:00	MSFT	Stock	26.45	26.69	26.44	26.671	9085268.0
2011-08-31 11:00:00	MSFT	Stock	26.675	26.71	26.57	26.58	8963573.0
2011-08-31 12:00:00	MSFT	Stock	26.57	26.62	26.535	26.607	5112284.0
2011-08-31 13:00:00	MSFT	Stock	26.601	26.62	26.45	26.489	5184178.0
2011-08-31 14:00:00	MSFT	Stock	26.49	26.54	26.4	26.5	5599636.0
2011-08-31 15:00:00	MSFT	Stock	26.5	26.63	26.4	26.595	11980402.0
2011-08-31 16:00:00	MSFT	Stock	26.565	26.612	26.23	26.6	5933752.0
2011-08-31 17:00:00	MSFT	Stock	26.57	26.6	26.53	26.53	411107.0
2011-08-31 18:00:00	MSFT	Stock	26.6	26.6	26.55	26.55	4555.0
2011-08-31 19:00:00	MSFT	Stock	26.55	26.55	26.55	26.55	474.0
2011-08-31 08:00:00	NVDA	Stock	0.3448	0.345	0.344	0.3448	126000.0
2011-08-31 09:00:00	NVDA	Stock	0.345	0.348	0.34	0.3422	68136320.0
2011-08-31 10:00:00	NVDA	Stock	0.3422	0.346	0.3375	0.3378	97444240.0
2011-08-31 11:00:00	NVDA	Stock	0.3378	0.3398	0.3328	0.334	111063960.0
2011-08-31 12:00:00	NVDA	Stock	0.334	0.3375	0.334	0.3373	48566600.0
2011-08-31 13:00:00	NVDA	Stock	0.3375	0.3378	0.3342	0.3342	75215600.0
2011-08-31 14:00:00	NVDA	Stock	0.3342	0.3348	0.3303	0.3315	88421240.0
2011-08-31 15:00:00	NVDA	Stock	0.3313	0.3335	0.33	0.3324	161617240.0
2011-08-31 16:00:00	NVDA	Stock	0.332	0.3425	0.3313	0.3328	8509400.0
2011-08-31 17:00:00	NVDA	Stock	0.3328	0.3328	0.3325	0.3328	1723480.0
2011-08-31 18:00:00	NVDA	Stock	0.333	0.3335	0.333	0.3333	159520.0
2011-08-31 19:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	28000.0
2011-08-31 04:00:00	AMZN	Stock	10.501	10.5875	10.501	10.5875	14000.0
2011-08-31 06:00:00	AMZN	Stock	10.6075	10.639	10.6075	10.639	4000.0
2011-08-31 07:00:00	AMZN	Stock	10.63	10.63	10.61	10.615	30800.0
2011-08-31 08:00:00	AMZN	Stock	10.599	10.61	10.585	10.6045	435060.0
2011-08-31 09:00:00	AMZN	Stock	10.6025	10.6884	10.5675	10.6795	17321880.0
2011-08-31 10:00:00	AMZN	Stock	10.6675	10.75	10.666	10.7425	28479080.0
2011-08-31 11:00:00	AMZN	Stock	10.742	10.8085	10.6665	10.6665	25628260.0
2011-08-31 12:00:00	AMZN	Stock	10.665	10.7395	10.6515	10.7125	9401400.0

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

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