PREVIEW / stock_1hour / 2012-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-06.parquet
  size:    899 KB
  rows:    42,904
  symbols: 3,477

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-06 04:00:00	AAPL	Stock	21.6825	21.6825	21.6471	21.6471	62300.0
2012-07-06 05:00:00	AAPL	Stock	21.6471	21.6471	21.6071	21.6071	44212.0
2012-07-06 06:00:00	AAPL	Stock	21.6336	21.6679	21.6336	21.6679	40600.0
2012-07-06 07:00:00	AAPL	Stock	21.6696	21.7679	21.6689	21.7257	492968.0
2012-07-06 08:00:00	AAPL	Stock	21.7314	21.75	21.6279	21.6571	4829384.0
2012-07-06 09:00:00	AAPL	Stock	21.6571	21.73	21.4879	21.59	81886532.0
2012-07-06 10:00:00	AAPL	Stock	21.5904	21.6218	21.5257	21.5632	68128844.0
2012-07-06 11:00:00	AAPL	Stock	21.5611	21.5779	21.485	21.5321	48304984.0
2012-07-06 12:00:00	AAPL	Stock	21.5305	21.5993	21.5011	21.5982	35605304.0
2012-07-06 13:00:00	AAPL	Stock	21.5993	21.625	21.5429	21.5566	32862788.0
2012-07-06 14:00:00	AAPL	Stock	21.5589	21.6096	21.5036	21.5964	37619344.0
2012-07-06 15:00:00	AAPL	Stock	21.5939	21.7243	21.5639	21.6507	97210456.0
2012-07-06 16:00:00	AAPL	Stock	21.65	21.69	21.5173	21.6579	6132616.0
2012-07-06 17:00:00	AAPL	Stock	21.6568	21.6593	21.6464	21.6464	219940.0
2012-07-06 18:00:00	AAPL	Stock	21.6454	21.6482	21.6454	21.6482	40012.0
2012-07-06 19:00:00	AAPL	Stock	21.6482	21.6611	21.6468	21.6611	88060.0
2012-07-06 08:00:00	MSFT	Stock	30.64	30.64	30.43	30.46	7880.0
2012-07-06 09:00:00	MSFT	Stock	30.43	30.7	30.27	30.32	4623931.0
2012-07-06 10:00:00	MSFT	Stock	30.325	30.35	30.05	30.075	7159238.0
2012-07-06 11:00:00	MSFT	Stock	30.08	30.1	30.0	30.065	4328939.0
2012-07-06 12:00:00	MSFT	Stock	30.07	30.08	29.95	30.0	3402403.0
2012-07-06 13:00:00	MSFT	Stock	30.005	30.11	29.99	30.058	3936222.0
2012-07-06 14:00:00	MSFT	Stock	30.06	30.1	30.02	30.1	2616309.0
2012-07-06 15:00:00	MSFT	Stock	30.095	30.21	30.06	30.19	9623705.0
2012-07-06 16:00:00	MSFT	Stock	30.2	30.25	30.081	30.2	1700047.0
2012-07-06 17:00:00	MSFT	Stock	30.25	30.25	30.2	30.2	1857.0
2012-07-06 18:00:00	MSFT	Stock	30.2	30.2	30.18	30.18	200.0
2012-07-06 19:00:00	MSFT	Stock	30.18	30.2	30.18	30.2	2689.0
2012-07-06 08:00:00	NVDA	Stock	0.3415	0.3415	0.3388	0.3388	587200.0
2012-07-06 09:00:00	NVDA	Stock	0.3382	0.3405	0.3355	0.3362	51473800.0
2012-07-06 10:00:00	NVDA	Stock	0.3362	0.3375	0.3333	0.3355	72702560.0
2012-07-06 11:00:00	NVDA	Stock	0.3356	0.336	0.3333	0.3335	38314880.0
2012-07-06 12:00:00	NVDA	Stock	0.3335	0.3335	0.3313	0.3333	35582600.0
2012-07-06 13:00:00	NVDA	Stock	0.3333	0.3333	0.3315	0.3322	28244840.0
2012-07-06 14:00:00	NVDA	Stock	0.332	0.3325	0.3313	0.332	32385400.0
2012-07-06 15:00:00	NVDA	Stock	0.3321	0.3355	0.3318	0.3348	77074120.0
2012-07-06 16:00:00	NVDA	Stock	0.335	0.3353	0.3336	0.3348	41674080.0
2012-07-06 17:00:00	NVDA	Stock	0.3345	0.3345	0.3333	0.3333	39600.0
2012-07-06 18:00:00	NVDA	Stock	0.335	0.335	0.335	0.335	28000.0
2012-07-06 07:00:00	AMZN	Stock	11.4	11.4	11.369	11.369	20000.0
2012-07-06 08:00:00	AMZN	Stock	11.3825	11.385	11.2785	11.3065	265840.0
2012-07-06 09:00:00	AMZN	Stock	11.2855	11.445	11.2855	11.345	13043900.0
2012-07-06 10:00:00	AMZN	Stock	11.3475	11.3898	11.313	11.3775	8216420.0
2012-07-06 11:00:00	AMZN	Stock	11.377	11.3925	11.2893	11.2945	9416900.0
2012-07-06 12:00:00	AMZN	Stock	11.294	11.2955	11.2595	11.2625	8808400.0
2012-07-06 13:00:00	AMZN	Stock	11.2645	11.2715	11.2155	11.224	4929540.0
2012-07-06 14:00:00	AMZN	Stock	11.224	11.229	11.209	11.217	4372400.0
2012-07-06 15:00:00	AMZN	Stock	11.216	11.267	11.21	11.2525	12139300.0
2012-07-06 16:00:00	AMZN	Stock	11.2525	11.3599	11.2435	11.3599	2535600.0
2012-07-06 17:00:00	AMZN	Stock	11.2505	11.2545	11.25	11.2545	20000.0

> showing 50 of 42,904 rows — these rows as CSV

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