PREVIEW / stock_1hour / 2012-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-20.parquet
  size:    958 KB
  rows:    45,197
  symbols: 3,498

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-20 05:00:00	AAPL	Stock	18.8393	18.875	18.8393	18.8661	64400.0
2012-12-20 06:00:00	AAPL	Stock	18.8821	18.8914	18.8821	18.8914	5600.0
2012-12-20 07:00:00	AAPL	Stock	18.9232	18.9261	18.7932	18.8214	550592.0
2012-12-20 08:00:00	AAPL	Stock	18.9107	18.9161	18.7668	18.9121	2510872.0
2012-12-20 09:00:00	AAPL	Stock	18.9139	18.9568	18.6493	18.7136	71981056.0
2012-12-20 10:00:00	AAPL	Stock	18.7107	18.8536	18.6679	18.6879	79304092.0
2012-12-20 11:00:00	AAPL	Stock	18.6871	18.725	18.6004	18.6429	58743524.0
2012-12-20 12:00:00	AAPL	Stock	18.6471	18.6682	18.5875	18.6156	40570460.0
2012-12-20 13:00:00	AAPL	Stock	18.6161	18.685	18.5314	18.6621	63451752.0
2012-12-20 14:00:00	AAPL	Stock	18.6657	18.7654	18.6121	18.7441	55841240.0
2012-12-20 15:00:00	AAPL	Stock	18.7404	18.7475	18.6143	18.6395	70463316.0
2012-12-20 16:00:00	AAPL	Stock	18.6279	18.6894	18.5921	18.5946	11612384.0
2012-12-20 17:00:00	AAPL	Stock	18.5968	18.6421	18.5929	18.5929	1667680.0
2012-12-20 18:00:00	AAPL	Stock	18.5929	18.6046	18.5929	18.5982	150780.0
2012-12-20 19:00:00	AAPL	Stock	18.5961	18.6036	18.5775	18.5775	533736.0
2012-12-20 05:00:00	MSFT	Stock	27.32	27.32	27.32	27.32	100.0
2012-12-20 07:00:00	MSFT	Stock	27.41	27.41	27.41	27.41	100.0
2012-12-20 08:00:00	MSFT	Stock	27.39	27.64	27.32	27.4	8594.0
2012-12-20 09:00:00	MSFT	Stock	27.39	27.4	27.15	27.27	5485372.0
2012-12-20 10:00:00	MSFT	Stock	27.27	27.48	27.27	27.48	6660108.0
2012-12-20 11:00:00	MSFT	Stock	27.475	27.53	27.4	27.45	6277261.0
2012-12-20 12:00:00	MSFT	Stock	27.45	27.48	27.36	27.48	4878800.0
2012-12-20 13:00:00	MSFT	Stock	27.475	27.66	27.41	27.62	6320856.0
2012-12-20 14:00:00	MSFT	Stock	27.63	27.65	27.53	27.634	6488670.0
2012-12-20 15:00:00	MSFT	Stock	27.63	27.68	27.55	27.67	9587411.0
2012-12-20 16:00:00	MSFT	Stock	27.67	27.7	27.484	27.7	5100855.0
2012-12-20 17:00:00	MSFT	Stock	27.69	27.69	27.46	27.68	469387.0
2012-12-20 18:00:00	MSFT	Stock	27.66	27.68	27.51	27.64	15033.0
2012-12-20 19:00:00	MSFT	Stock	27.64	27.64	27.59	27.6	1300.0
2012-12-20 07:00:00	NVDA	Stock	0.3188	0.3188	0.3188	0.3188	4000.0
2012-12-20 08:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	24000.0
2012-12-20 09:00:00	NVDA	Stock	0.3163	0.3175	0.3133	0.3148	53743280.0
2012-12-20 10:00:00	NVDA	Stock	0.315	0.3178	0.3125	0.3133	74081600.0
2012-12-20 11:00:00	NVDA	Stock	0.3133	0.315	0.313	0.315	32944440.0
2012-12-20 12:00:00	NVDA	Stock	0.315	0.315	0.3138	0.3143	14325560.0
2012-12-20 13:00:00	NVDA	Stock	0.3141	0.315	0.3135	0.315	18832040.0
2012-12-20 14:00:00	NVDA	Stock	0.315	0.3163	0.3148	0.3153	35133520.0
2012-12-20 15:00:00	NVDA	Stock	0.3155	0.3163	0.3143	0.316	71123160.0
2012-12-20 16:00:00	NVDA	Stock	0.316	0.3168	0.3149	0.3155	9271400.0
2012-12-20 17:00:00	NVDA	Stock	0.316	0.316	0.316	0.316	1104000.0
2012-12-20 06:00:00	AMZN	Stock	12.944	12.944	12.933	12.933	4000.0
2012-12-20 07:00:00	AMZN	Stock	12.933	12.933	12.933	12.933	2000.0
2012-12-20 08:00:00	AMZN	Stock	12.927	12.927	12.885	12.9	119040.0
2012-12-20 09:00:00	AMZN	Stock	12.917	12.9505	12.827	12.887	6720860.0
2012-12-20 10:00:00	AMZN	Stock	12.887	12.958	12.882	12.9562	6572860.0
2012-12-20 11:00:00	AMZN	Stock	12.955	13.003	12.9375	12.978	5600020.0
2012-12-20 12:00:00	AMZN	Stock	12.9745	12.9845	12.948	12.975	3803580.0
2012-12-20 13:00:00	AMZN	Stock	12.9702	13.0455	12.9505	13.03	4655260.0
2012-12-20 14:00:00	AMZN	Stock	13.035	13.1205	13.0114	13.105	6521180.0
2012-12-20 15:00:00	AMZN	Stock	13.1007	13.1045	13.0475	13.073	10332600.0

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

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