PREVIEW / stock_1hour / 2012-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-04.parquet
  size:    939 KB
  rows:    44,352
  symbols: 3,531

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-05-04 04:00:00	AAPL	Stock	20.75	20.75	20.75	20.75	5600.0
2012-05-04 05:00:00	AAPL	Stock	20.7146	20.7146	20.7146	20.7146	2800.0
2012-05-04 06:00:00	AAPL	Stock	20.7182	20.75	20.7182	20.75	8400.0
2012-05-04 07:00:00	AAPL	Stock	20.7571	20.7857	20.6964	20.7304	319144.0
2012-05-04 08:00:00	AAPL	Stock	20.7307	20.8164	20.6229	20.6246	5155052.0
2012-05-04 09:00:00	AAPL	Stock	20.6311	20.6557	20.4325	20.4718	94707900.0
2012-05-04 10:00:00	AAPL	Stock	20.4707	20.4932	20.2954	20.3925	125819148.0
2012-05-04 11:00:00	AAPL	Stock	20.3929	20.3982	20.3157	20.3779	58639784.0
2012-05-04 12:00:00	AAPL	Stock	20.3779	20.4282	20.3286	20.3586	40879748.0
2012-05-04 13:00:00	AAPL	Stock	20.3593	20.3668	20.2732	20.3171	49640640.0
2012-05-04 14:00:00	AAPL	Stock	20.3107	20.3125	20.2057	20.2396	54625424.0
2012-05-04 15:00:00	AAPL	Stock	20.2414	20.2771	20.1846	20.1886	83875624.0
2012-05-04 16:00:00	AAPL	Stock	20.1868	20.2719	20.1761	20.1929	9765280.0
2012-05-04 17:00:00	AAPL	Stock	20.1964	20.1968	20.1821	20.1821	928424.0
2012-05-04 18:00:00	AAPL	Stock	20.1829	20.1854	20.1786	20.1786	305564.0
2012-05-04 19:00:00	AAPL	Stock	20.1761	20.1882	20.1761	20.1786	238280.0
2012-05-04 08:00:00	MSFT	Stock	31.7	31.7	31.52	31.55	44766.0
2012-05-04 09:00:00	MSFT	Stock	31.55	31.57	31.34	31.38	6436118.0
2012-05-04 10:00:00	MSFT	Stock	31.38	31.41	31.3	31.321	8460211.0
2012-05-04 11:00:00	MSFT	Stock	31.32	31.34	31.12	31.19	7721487.0
2012-05-04 12:00:00	MSFT	Stock	31.19	31.2	30.92	31.079	10360437.0
2012-05-04 13:00:00	MSFT	Stock	31.08	31.17	30.995	31.061	6575375.0
2012-05-04 14:00:00	MSFT	Stock	31.068	31.08	30.97	31.005	5519977.0
2012-05-04 15:00:00	MSFT	Stock	31.005	31.13	30.97	30.97	9594426.0
2012-05-04 16:00:00	MSFT	Stock	30.98	31.307	30.93	30.98	2236159.0
2012-05-04 17:00:00	MSFT	Stock	30.98	30.98	30.9	30.95	146516.0
2012-05-04 18:00:00	MSFT	Stock	30.95	30.95	30.92	30.92	1318.0
2012-05-04 19:00:00	MSFT	Stock	30.93	30.93	30.93	30.93	100.0
2012-05-04 08:00:00	NVDA	Stock	0.316	0.316	0.3155	0.3155	80000.0
2012-05-04 09:00:00	NVDA	Stock	0.3163	0.3163	0.3125	0.3125	40247160.0
2012-05-04 10:00:00	NVDA	Stock	0.3128	0.3135	0.31	0.3123	88413240.0
2012-05-04 11:00:00	NVDA	Stock	0.312	0.3123	0.309	0.3103	54956880.0
2012-05-04 12:00:00	NVDA	Stock	0.31	0.3115	0.3068	0.3083	74561160.0
2012-05-04 13:00:00	NVDA	Stock	0.3083	0.3105	0.3078	0.3085	51135000.0
2012-05-04 14:00:00	NVDA	Stock	0.3085	0.3088	0.3068	0.3074	52999760.0
2012-05-04 15:00:00	NVDA	Stock	0.3073	0.3083	0.3065	0.3065	150545960.0
2012-05-04 16:00:00	NVDA	Stock	0.3068	0.3102	0.3058	0.3065	3818200.0
2012-05-04 17:00:00	NVDA	Stock	0.3065	0.3065	0.3065	0.3065	450400.0
2012-05-04 18:00:00	NVDA	Stock	0.3062	0.3062	0.3058	0.3058	28600.0
2012-05-04 19:00:00	NVDA	Stock	0.305	0.3065	0.305	0.3065	124600.0
2012-05-04 07:00:00	AMZN	Stock	11.45	11.45	11.425	11.425	11800.0
2012-05-04 08:00:00	AMZN	Stock	11.4065	11.511	11.354	11.426	271580.0
2012-05-04 09:00:00	AMZN	Stock	11.4275	11.474	11.3735	11.438	12872500.0
2012-05-04 10:00:00	AMZN	Stock	11.4454	11.486	11.3975	11.486	15061960.0
2012-05-04 11:00:00	AMZN	Stock	11.4815	11.485	11.291	11.301	16114820.0
2012-05-04 12:00:00	AMZN	Stock	11.3029	11.325	11.2535	11.27	9152960.0
2012-05-04 13:00:00	AMZN	Stock	11.27	11.2865	11.225	11.249	8572640.0
2012-05-04 14:00:00	AMZN	Stock	11.245	11.25	11.211	11.232	8597500.0
2012-05-04 15:00:00	AMZN	Stock	11.2325	11.2615	11.187	11.1955	17315960.0
2012-05-04 16:00:00	AMZN	Stock	11.1995	11.3877	11.1725	11.1995	2498180.0

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

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