PREVIEW / stock_1hour / 2012-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-06.parquet
  size:    931 KB
  rows:    44,167
  symbols: 3,494

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-12-06 04:00:00	AAPL	Stock	19.1786	19.2143	19.1643	19.2107	154056.0
2012-12-06 05:00:00	AAPL	Stock	19.1975	19.2107	19.1875	19.1875	48608.0
2012-12-06 06:00:00	AAPL	Stock	19.2032	19.2143	19.1429	19.15	195888.0
2012-12-06 07:00:00	AAPL	Stock	19.1518	19.1875	19.1464	19.1875	779240.0
2012-12-06 08:00:00	AAPL	Stock	19.1786	19.1857	18.9514	19.005	10493168.0
2012-12-06 09:00:00	AAPL	Stock	19.0039	19.2289	18.5225	19.0375	307821892.0
2012-12-06 10:00:00	AAPL	Stock	19.0432	19.5957	19.0293	19.5467	248704904.0
2012-12-06 11:00:00	AAPL	Stock	19.5479	19.7611	19.4682	19.7009	126883484.0
2012-12-06 12:00:00	AAPL	Stock	19.7039	19.7589	19.4439	19.4782	104787508.0
2012-12-06 13:00:00	AAPL	Stock	19.48	19.625	19.3329	19.6239	88502736.0
2012-12-06 14:00:00	AAPL	Stock	19.625	19.6429	19.3446	19.413	94326456.0
2012-12-06 15:00:00	AAPL	Stock	19.4189	19.5854	19.3107	19.5443	127985788.0
2012-12-06 16:00:00	AAPL	Stock	19.5446	19.6772	19.288	19.5357	46647944.0
2012-12-06 17:00:00	AAPL	Stock	19.5357	19.5532	19.5321	19.5393	531888.0
2012-12-06 18:00:00	AAPL	Stock	19.5489	19.5496	19.5361	19.5429	187824.0
2012-12-06 19:00:00	AAPL	Stock	19.5418	19.5893	19.5418	19.5854	553084.0
2012-12-06 06:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	1500.0
2012-12-06 07:00:00	MSFT	Stock	26.74	26.75	26.74	26.75	888.0
2012-12-06 08:00:00	MSFT	Stock	26.79	26.84	26.68	26.76	56539.0
2012-12-06 09:00:00	MSFT	Stock	26.72	26.98	26.7	26.75	6500311.0
2012-12-06 10:00:00	MSFT	Stock	26.75	26.88	26.71	26.845	5493099.0
2012-12-06 11:00:00	MSFT	Stock	26.84	26.85	26.74	26.76	3977635.0
2012-12-06 12:00:00	MSFT	Stock	26.755	26.84	26.62	26.72	4328897.0
2012-12-06 13:00:00	MSFT	Stock	26.715	26.79	26.7	26.78	2688988.0
2012-12-06 14:00:00	MSFT	Stock	26.78	26.79	26.66	26.69	4394034.0
2012-12-06 15:00:00	MSFT	Stock	26.7	26.755	26.61	26.73	8697590.0
2012-12-06 16:00:00	MSFT	Stock	26.73	26.774	26.64	26.774	2716886.0
2012-12-06 17:00:00	MSFT	Stock	26.76	26.77	26.74	26.77	40844.0
2012-12-06 18:00:00	MSFT	Stock	26.77	26.79	26.76	26.78	8498.0
2012-12-06 19:00:00	MSFT	Stock	26.78	26.78	26.76	26.76	200.0
2012-12-06 09:00:00	NVDA	Stock	0.2975	0.3005	0.2971	0.2995	47197440.0
2012-12-06 10:00:00	NVDA	Stock	0.2995	0.3009	0.298	0.3002	75799920.0
2012-12-06 11:00:00	NVDA	Stock	0.3005	0.3012	0.2985	0.2996	66593120.0
2012-12-06 12:00:00	NVDA	Stock	0.2995	0.3008	0.298	0.2995	35226520.0
2012-12-06 13:00:00	NVDA	Stock	0.2992	0.3015	0.2992	0.3006	35356840.0
2012-12-06 14:00:00	NVDA	Stock	0.3008	0.301	0.2988	0.2994	57209000.0
2012-12-06 15:00:00	NVDA	Stock	0.2995	0.3002	0.2982	0.2995	84247280.0
2012-12-06 16:00:00	NVDA	Stock	0.299	0.2998	0.299	0.2998	2750680.0
2012-12-06 17:00:00	NVDA	Stock	0.2998	0.2998	0.2998	0.2998	53600.0
2012-12-06 18:00:00	NVDA	Stock	0.299	0.299	0.299	0.299	40000.0
2012-12-06 04:00:00	AMZN	Stock	12.7005	12.7005	12.7005	12.7005	2200.0
2012-12-06 05:00:00	AMZN	Stock	12.6965	12.6965	12.6965	12.6965	2000.0
2012-12-06 06:00:00	AMZN	Stock	12.7125	12.7125	12.632	12.632	6000.0
2012-12-06 08:00:00	AMZN	Stock	12.585	12.6435	12.585	12.586	268200.0
2012-12-06 09:00:00	AMZN	Stock	12.586	12.7005	12.5755	12.661	8814100.0
2012-12-06 10:00:00	AMZN	Stock	12.6604	12.721	12.5815	12.713	13476320.0
2012-12-06 11:00:00	AMZN	Stock	12.7155	12.7585	12.687	12.705	10046280.0
2012-12-06 12:00:00	AMZN	Stock	12.707	12.72	12.6565	12.676	6560300.0
2012-12-06 13:00:00	AMZN	Stock	12.678	12.708	12.655	12.7075	5316680.0
2012-12-06 14:00:00	AMZN	Stock	12.708	12.7215	12.6705	12.68	6907660.0

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

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