PREVIEW / stock_1hour / 2014-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-27.parquet
  size:    1.1 MB
  rows:    49,143
  symbols: 3,541

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
2014-02-27 04:00:00	AAPL	Stock	18.4964	18.5054	18.3764	18.3764	70140.0
2014-02-27 05:00:00	AAPL	Stock	18.3929	18.3929	18.3929	18.3929	2800.0
2014-02-27 06:00:00	AAPL	Stock	18.4196	18.4196	18.3629	18.375	39508.0
2014-02-27 07:00:00	AAPL	Stock	18.375	18.4546	18.375	18.4125	291032.0
2014-02-27 08:00:00	AAPL	Stock	18.4268	18.4639	18.375	18.4464	940100.0
2014-02-27 09:00:00	AAPL	Stock	18.4429	18.5857	18.4304	18.5756	40178012.0
2014-02-27 10:00:00	AAPL	Stock	18.5757	18.7443	18.5719	18.6989	45353196.0
2014-02-27 11:00:00	AAPL	Stock	18.7021	18.7086	18.6307	18.6664	23465568.0
2014-02-27 12:00:00	AAPL	Stock	18.6653	18.8179	18.655	18.8075	29146992.0
2014-02-27 13:00:00	AAPL	Stock	18.8082	18.8582	18.7593	18.8557	24389092.0
2014-02-27 14:00:00	AAPL	Stock	18.8561	18.885	18.7971	18.845	25452224.0
2014-02-27 15:00:00	AAPL	Stock	18.8438	18.8639	18.7904	18.8446	32232592.0
2014-02-27 16:00:00	AAPL	Stock	18.8454	18.8607	18.5082	18.85	22343944.0
2014-02-27 17:00:00	AAPL	Stock	18.8571	18.8607	18.8491	18.8521	319564.0
2014-02-27 18:00:00	AAPL	Stock	18.8518	18.8571	18.85	18.85	127512.0
2014-02-27 19:00:00	AAPL	Stock	18.8561	18.8611	18.8454	18.8607	133784.0
2014-02-27 06:00:00	MSFT	Stock	37.35	37.35	37.35	37.35	200.0
2014-02-27 07:00:00	MSFT	Stock	37.39	37.39	37.39	37.39	305.0
2014-02-27 08:00:00	MSFT	Stock	37.3	37.39	37.25	37.38	10999.0
2014-02-27 09:00:00	MSFT	Stock	37.39	37.45	37.23	37.279	3900930.0
2014-02-27 10:00:00	MSFT	Stock	37.28	37.54	37.23	37.495	5010242.0
2014-02-27 11:00:00	MSFT	Stock	37.495	37.6	37.46	37.53	4148990.0
2014-02-27 12:00:00	MSFT	Stock	37.525	37.63	37.49	37.605	2292387.0
2014-02-27 13:00:00	MSFT	Stock	37.61	37.8	37.59	37.8	2767955.0
2014-02-27 14:00:00	MSFT	Stock	37.8	37.815	37.62	37.755	2976872.0
2014-02-27 15:00:00	MSFT	Stock	37.76	37.89	37.69	37.87	8295316.0
2014-02-27 16:00:00	MSFT	Stock	37.88	37.88	37.524	37.8	2809310.0
2014-02-27 17:00:00	MSFT	Stock	37.868	37.88	37.79	37.88	19227.0
2014-02-27 18:00:00	MSFT	Stock	37.86	37.86	37.86	37.86	700.0
2014-02-27 19:00:00	MSFT	Stock	37.86	37.86	37.86	37.86	14755.0
2014-02-27 08:00:00	NVDA	Stock	0.4678	0.4683	0.465	0.465	262000.0
2014-02-27 09:00:00	NVDA	Stock	0.4708	0.4725	0.4678	0.4692	22135560.0
2014-02-27 10:00:00	NVDA	Stock	0.4692	0.4708	0.467	0.4675	28308680.0
2014-02-27 11:00:00	NVDA	Stock	0.4678	0.468	0.4665	0.467	21334600.0
2014-02-27 12:00:00	NVDA	Stock	0.467	0.4675	0.466	0.4661	20170880.0
2014-02-27 13:00:00	NVDA	Stock	0.4662	0.4662	0.464	0.4641	45359200.0
2014-02-27 14:00:00	NVDA	Stock	0.4641	0.4648	0.4618	0.4625	67537080.0
2014-02-27 15:00:00	NVDA	Stock	0.4622	0.4638	0.4612	0.4622	151362400.0
2014-02-27 16:00:00	NVDA	Stock	0.4625	0.4708	0.4622	0.4624	19811960.0
2014-02-27 17:00:00	NVDA	Stock	0.4626	0.463	0.4626	0.463	69840.0
2014-02-27 04:00:00	AMZN	Stock	18.025	18.025	17.975	17.975	6000.0
2014-02-27 05:00:00	AMZN	Stock	17.97	17.97	17.95	17.95	4000.0
2014-02-27 06:00:00	AMZN	Stock	17.85	17.85	17.85	17.85	2000.0
2014-02-27 07:00:00	AMZN	Stock	17.9	17.9	17.9	17.9	41200.0
2014-02-27 08:00:00	AMZN	Stock	17.925	17.925	17.875	17.9	283900.0
2014-02-27 09:00:00	AMZN	Stock	17.914	18.009	17.8325	17.955	7716240.0
2014-02-27 10:00:00	AMZN	Stock	17.969	17.9895	17.775	17.884	13711420.0
2014-02-27 11:00:00	AMZN	Stock	17.8835	17.9082	17.801	17.8194	8389380.0
2014-02-27 12:00:00	AMZN	Stock	17.826	17.92	17.8245	17.9114	3972620.0
2014-02-27 13:00:00	AMZN	Stock	17.9105	17.9925	17.8815	17.9738	4041440.0

> showing 50 of 49,143 rows — these rows as CSV

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