PREVIEW / stock_1hour / 2013-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-04.parquet
  size:    961 KB
  rows:    44,999
  symbols: 3,480

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
2013-02-04 04:00:00	AAPL	Stock	16.2218	16.2218	16.2218	16.2218	5600.0
2013-02-04 05:00:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	30660.0
2013-02-04 06:00:00	AAPL	Stock	16.2071	16.2264	16.1879	16.1879	50316.0
2013-02-04 07:00:00	AAPL	Stock	16.2036	16.2214	16.1407	16.1679	532392.0
2013-02-04 08:00:00	AAPL	Stock	16.1879	16.2	16.0268	16.1257	2590336.0
2013-02-04 09:00:00	AAPL	Stock	16.1329	16.2836	16.0825	16.0865	67644780.0
2013-02-04 10:00:00	AAPL	Stock	16.0843	16.1561	16.0446	16.1227	76652352.0
2013-02-04 11:00:00	AAPL	Stock	16.1168	16.1346	15.9232	15.9329	80717644.0
2013-02-04 12:00:00	AAPL	Stock	15.9371	15.9707	15.845	15.8659	65075556.0
2013-02-04 13:00:00	AAPL	Stock	15.8636	15.9204	15.815	15.8479	43315048.0
2013-02-04 14:00:00	AAPL	Stock	15.8477	15.9279	15.8321	15.8764	43036392.0
2013-02-04 15:00:00	AAPL	Stock	15.8782	15.8907	15.7857	15.7936	71485512.0
2013-02-04 16:00:00	AAPL	Stock	15.7932	16.2215	15.7524	16.2215	13784708.0
2013-02-04 17:00:00	AAPL	Stock	15.7964	16.2007	15.7643	15.775	514164.0
2013-02-04 18:00:00	AAPL	Stock	15.7714	15.8007	15.7696	15.7943	281876.0
2013-02-04 19:00:00	AAPL	Stock	15.7964	15.8029	15.7875	15.7946	275436.0
2013-02-04 08:00:00	MSFT	Stock	27.92	27.92	27.7	27.72	31022.0
2013-02-04 09:00:00	MSFT	Stock	27.72	28.02	27.51	27.86	6942767.0
2013-02-04 10:00:00	MSFT	Stock	27.855	27.87	27.74	27.762	5186076.0
2013-02-04 11:00:00	MSFT	Stock	27.765	27.84	27.6	27.64	8175724.0
2013-02-04 12:00:00	MSFT	Stock	27.64	27.675	27.55	27.579	5976422.0
2013-02-04 13:00:00	MSFT	Stock	27.57	27.6	27.49	27.53	4855463.0
2013-02-04 14:00:00	MSFT	Stock	27.54	27.61	27.51	27.59	5208599.0
2013-02-04 15:00:00	MSFT	Stock	27.59	27.6	27.42	27.425	8578101.0
2013-02-04 16:00:00	MSFT	Stock	27.43	27.665	27.424	27.47	5310646.0
2013-02-04 17:00:00	MSFT	Stock	27.48	27.93	27.47	27.54	17924.0
2013-02-04 18:00:00	MSFT	Stock	27.49	27.53	27.48	27.5	5902.0
2013-02-04 19:00:00	MSFT	Stock	27.49	27.53	27.48	27.48	16090.0
2013-02-04 08:00:00	NVDA	Stock	0.31	0.31	0.3078	0.3078	40000.0
2013-02-04 09:00:00	NVDA	Stock	0.307	0.3115	0.3052	0.3108	46654120.0
2013-02-04 10:00:00	NVDA	Stock	0.3108	0.3138	0.31	0.3118	91704480.0
2013-02-04 11:00:00	NVDA	Stock	0.3119	0.3123	0.3058	0.3058	95100440.0
2013-02-04 12:00:00	NVDA	Stock	0.3059	0.3073	0.3052	0.3062	48065880.0
2013-02-04 13:00:00	NVDA	Stock	0.3062	0.3062	0.3045	0.3052	40840480.0
2013-02-04 14:00:00	NVDA	Stock	0.3052	0.306	0.3045	0.3058	57656680.0
2013-02-04 15:00:00	NVDA	Stock	0.3055	0.3062	0.3038	0.3039	108707720.0
2013-02-04 16:00:00	NVDA	Stock	0.304	0.3074	0.304	0.304	9246400.0
2013-02-04 17:00:00	NVDA	Stock	0.305	0.305	0.305	0.305	128000.0
2013-02-04 19:00:00	NVDA	Stock	0.3058	0.3058	0.3058	0.3058	20000.0
2013-02-04 04:00:00	AMZN	Stock	13.225	13.2805	13.225	13.255	10000.0
2013-02-04 05:00:00	AMZN	Stock	13.299	13.299	13.29	13.29	4000.0
2013-02-04 06:00:00	AMZN	Stock	13.2945	13.2945	13.25	13.25	19380.0
2013-02-04 07:00:00	AMZN	Stock	13.25	13.25	13.2	13.22	23000.0
2013-02-04 08:00:00	AMZN	Stock	13.2255	13.2255	13.14	13.15	374680.0
2013-02-04 09:00:00	AMZN	Stock	13.15	13.2342	13.0705	13.121	10330080.0
2013-02-04 10:00:00	AMZN	Stock	13.1195	13.1945	13.0565	13.1065	13351300.0
2013-02-04 11:00:00	AMZN	Stock	13.104	13.12	12.98	12.995	13037940.0
2013-02-04 12:00:00	AMZN	Stock	12.9935	13.036	12.971	13.0	6770280.0
2013-02-04 13:00:00	AMZN	Stock	12.9965	13.038	12.9535	12.9875	6406780.0
2013-02-04 14:00:00	AMZN	Stock	12.9905	13.009	12.9545	12.999	8184460.0

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

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