PREVIEW / stock_1hour / 2013-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-25.parquet
  size:    1.0 MB
  rows:    48,004
  symbols: 3,554

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-11-25 04:00:00	AAPL	Stock	18.6068	18.6068	18.6054	18.6061	16800.0
2013-11-25 05:00:00	AAPL	Stock	18.6218	18.6218	18.6218	18.6218	5740.0
2013-11-25 06:00:00	AAPL	Stock	18.6071	18.6071	18.5721	18.6071	44800.0
2013-11-25 07:00:00	AAPL	Stock	18.625	18.6782	18.6071	18.6621	449596.0
2013-11-25 08:00:00	AAPL	Stock	18.6568	18.66	18.6071	18.6429	1483440.0
2013-11-25 09:00:00	AAPL	Stock	18.6393	18.7536	18.6071	18.6899	51357880.0
2013-11-25 10:00:00	AAPL	Stock	18.6907	18.7673	18.6829	18.71	54547976.0
2013-11-25 11:00:00	AAPL	Stock	18.7104	18.7568	18.7102	18.75	27371736.0
2013-11-25 12:00:00	AAPL	Stock	18.7507	18.7743	18.7321	18.7346	18556216.0
2013-11-25 13:00:00	AAPL	Stock	18.7375	18.7643	18.7339	18.7639	11726596.0
2013-11-25 14:00:00	AAPL	Stock	18.7632	18.7811	18.75	18.7668	17634540.0
2013-11-25 15:00:00	AAPL	Stock	18.7665	18.7711	18.6889	18.7054	34626340.0
2013-11-25 16:00:00	AAPL	Stock	18.705	18.7335	18.6893	18.6957	8059464.0
2013-11-25 17:00:00	AAPL	Stock	18.6911	18.705	18.6911	18.7018	272160.0
2013-11-25 18:00:00	AAPL	Stock	18.7025	18.7132	18.7	18.7054	44800.0
2013-11-25 19:00:00	AAPL	Stock	18.7054	18.7175	18.7054	18.7143	63756.0
2013-11-25 06:00:00	MSFT	Stock	37.79	37.83	37.79	37.83	700.0
2013-11-25 07:00:00	MSFT	Stock	37.82	37.82	37.78	37.81	3000.0
2013-11-25 08:00:00	MSFT	Stock	37.77	37.83	37.7	37.76	10833.0
2013-11-25 09:00:00	MSFT	Stock	37.75	38.01	37.705	37.78	4199423.0
2013-11-25 10:00:00	MSFT	Stock	37.78	37.85	37.715	37.75	4573368.0
2013-11-25 11:00:00	MSFT	Stock	37.75	37.77	37.625	37.68	3452293.0
2013-11-25 12:00:00	MSFT	Stock	37.68	37.69	37.57	37.66	3314843.0
2013-11-25 13:00:00	MSFT	Stock	37.669	37.72	37.62	37.685	2860130.0
2013-11-25 14:00:00	MSFT	Stock	37.685	37.745	37.68	37.71	2556967.0
2013-11-25 15:00:00	MSFT	Stock	37.71	37.72	37.61	37.645	4986429.0
2013-11-25 16:00:00	MSFT	Stock	37.64	37.757	37.63	37.757	4349084.0
2013-11-25 17:00:00	MSFT	Stock	37.63	37.63	37.6	37.6	4200.0
2013-11-25 19:00:00	MSFT	Stock	37.63	37.63	37.63	37.63	1300.0
2013-11-25 08:00:00	NVDA	Stock	0.3793	0.3793	0.3788	0.3788	133160.0
2013-11-25 09:00:00	NVDA	Stock	0.379	0.3862	0.3788	0.384	31759200.0
2013-11-25 10:00:00	NVDA	Stock	0.384	0.3845	0.3822	0.384	33287480.0
2013-11-25 11:00:00	NVDA	Stock	0.384	0.385	0.3835	0.3848	14308360.0
2013-11-25 12:00:00	NVDA	Stock	0.3848	0.385	0.3833	0.3845	15129000.0
2013-11-25 13:00:00	NVDA	Stock	0.3845	0.387	0.3842	0.3862	22850680.0
2013-11-25 14:00:00	NVDA	Stock	0.3865	0.3882	0.3862	0.3878	21907960.0
2013-11-25 15:00:00	NVDA	Stock	0.3878	0.3879	0.3862	0.3875	62231120.0
2013-11-25 16:00:00	NVDA	Stock	0.3878	0.3888	0.3854	0.3888	46112440.0
2013-11-25 18:00:00	NVDA	Stock	0.3878	0.3878	0.3878	0.3878	111160.0
2013-11-25 05:00:00	AMZN	Stock	18.6655	18.6655	18.6655	18.6655	2000.0
2013-11-25 06:00:00	AMZN	Stock	18.657	18.657	18.644	18.6475	12000.0
2013-11-25 07:00:00	AMZN	Stock	18.692	18.75	18.669	18.749	123800.0
2013-11-25 08:00:00	AMZN	Stock	18.7265	18.7635	18.6825	18.7115	372120.0
2013-11-25 09:00:00	AMZN	Stock	18.7105	18.876	18.6495	18.8405	15755280.0
2013-11-25 10:00:00	AMZN	Stock	18.837	18.85	18.69	18.7145	10682840.0
2013-11-25 11:00:00	AMZN	Stock	18.7175	18.771	18.6837	18.707	5134140.0
2013-11-25 12:00:00	AMZN	Stock	18.705	18.715	18.66	18.66	2722640.0
2013-11-25 13:00:00	AMZN	Stock	18.659	18.796	18.659	18.7845	3530300.0
2013-11-25 14:00:00	AMZN	Stock	18.7845	18.8895	18.7745	18.83	6434520.0
2013-11-25 15:00:00	AMZN	Stock	18.8325	18.845	18.761	18.8345	8799320.0

> showing 50 of 48,004 rows — these rows as CSV

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