PREVIEW / stock_1hour / 2013-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-02.parquet
  size:    1.0 MB
  rows:    48,081
  symbols: 3,538

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-12-02 04:00:00	AAPL	Stock	19.8854	19.9111	19.8643	19.9111	26600.0
2013-12-02 05:00:00	AAPL	Stock	19.9236	19.9407	19.9196	19.9389	79324.0
2013-12-02 06:00:00	AAPL	Stock	19.9446	20.0714	19.9446	20.0229	329588.0
2013-12-02 07:00:00	AAPL	Stock	20.0064	20.0275	19.9336	19.9529	1161440.0
2013-12-02 08:00:00	AAPL	Stock	19.9525	20.0318	19.8393	19.9525	3489584.0
2013-12-02 09:00:00	AAPL	Stock	19.9554	20.1546	19.845	19.8546	129012100.0
2013-12-02 10:00:00	AAPL	Stock	19.8532	20.0211	19.8004	19.9217	108181864.0
2013-12-02 11:00:00	AAPL	Stock	19.9243	19.9357	19.7196	19.7539	61486460.0
2013-12-02 12:00:00	AAPL	Stock	19.7539	19.8661	19.7429	19.8293	37532236.0
2013-12-02 13:00:00	AAPL	Stock	19.8286	19.835	19.75	19.7571	26816692.0
2013-12-02 14:00:00	AAPL	Stock	19.7527	19.7785	19.6721	19.7686	41657616.0
2013-12-02 15:00:00	AAPL	Stock	19.7679	19.7811	19.6786	19.6893	42811720.0
2013-12-02 16:00:00	AAPL	Stock	19.6868	19.8771	19.6843	19.6911	12361468.0
2013-12-02 17:00:00	AAPL	Stock	19.6946	19.7014	19.6868	19.6964	620452.0
2013-12-02 18:00:00	AAPL	Stock	19.6964	19.7043	19.69	19.6964	358120.0
2013-12-02 19:00:00	AAPL	Stock	19.6946	19.7043	19.6904	19.7043	136276.0
2013-12-02 07:00:00	MSFT	Stock	38.2	38.2	38.0	38.04	7000.0
2013-12-02 08:00:00	MSFT	Stock	38.1	38.18	38.1	38.17	3795.0
2013-12-02 09:00:00	MSFT	Stock	38.15	38.49	38.06	38.37	5404696.0
2013-12-02 10:00:00	MSFT	Stock	38.37	38.49	38.15	38.37	8409401.0
2013-12-02 11:00:00	MSFT	Stock	38.37	38.54	38.36	38.533	4315538.0
2013-12-02 12:00:00	MSFT	Stock	38.535	38.78	38.51	38.515	5275371.0
2013-12-02 13:00:00	MSFT	Stock	38.51	38.556	38.44	38.494	3227565.0
2013-12-02 14:00:00	MSFT	Stock	38.495	38.53	38.44	38.508	3587291.0
2013-12-02 15:00:00	MSFT	Stock	38.505	38.51	38.34	38.455	8152338.0
2013-12-02 16:00:00	MSFT	Stock	38.46	38.659	38.28	38.34	3512844.0
2013-12-02 17:00:00	MSFT	Stock	38.34	38.45	38.34	38.39	19570.0
2013-12-02 18:00:00	MSFT	Stock	38.39	38.4	38.36	38.4	2580.0
2013-12-02 19:00:00	MSFT	Stock	38.4	38.4	38.4	38.4	600.0
2013-12-02 09:00:00	NVDA	Stock	0.3885	0.392	0.3878	0.3913	22264400.0
2013-12-02 10:00:00	NVDA	Stock	0.3913	0.3948	0.3895	0.3948	47849360.0
2013-12-02 11:00:00	NVDA	Stock	0.3948	0.3965	0.3933	0.3938	51655400.0
2013-12-02 12:00:00	NVDA	Stock	0.3939	0.3953	0.3936	0.394	21813480.0
2013-12-02 13:00:00	NVDA	Stock	0.394	0.3953	0.394	0.3948	62859080.0
2013-12-02 14:00:00	NVDA	Stock	0.3947	0.3948	0.3935	0.3948	18733480.0
2013-12-02 15:00:00	NVDA	Stock	0.3948	0.395	0.3922	0.3938	72348760.0
2013-12-02 16:00:00	NVDA	Stock	0.3938	0.3938	0.3936	0.3938	51963360.0
2013-12-02 05:00:00	AMZN	Stock	19.831	19.831	19.825	19.825	4000.0
2013-12-02 06:00:00	AMZN	Stock	19.855	19.855	19.78	19.8125	57120.0
2013-12-02 07:00:00	AMZN	Stock	19.808	19.825	19.779	19.81	183540.0
2013-12-02 08:00:00	AMZN	Stock	19.8	19.9315	19.775	19.9	1258900.0
2013-12-02 09:00:00	AMZN	Stock	19.9015	19.98	19.614	19.638	25842620.0
2013-12-02 10:00:00	AMZN	Stock	19.643	19.748	19.455	19.59	24744820.0
2013-12-02 11:00:00	AMZN	Stock	19.59	19.619	19.465	19.554	8656820.0
2013-12-02 12:00:00	AMZN	Stock	19.5575	19.7045	19.543	19.685	6700300.0
2013-12-02 13:00:00	AMZN	Stock	19.677	19.7025	19.5785	19.6255	5595660.0
2013-12-02 14:00:00	AMZN	Stock	19.6275	19.6864	19.5575	19.675	5001520.0
2013-12-02 15:00:00	AMZN	Stock	19.6783	19.6995	19.561	19.615	10815540.0
2013-12-02 16:00:00	AMZN	Stock	19.615	19.6931	19.564	19.6	976440.0
2013-12-02 18:00:00	AMZN	Stock	19.6	19.6465	19.6	19.6465	77540.0

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

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