PREVIEW / stock_1hour / 2014-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-06.parquet
  size:    1.0 MB
  rows:    48,100
  symbols: 3,556

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-06 04:00:00	AAPL	Stock	18.2311	18.3214	18.2311	18.2679	22680.0
2014-02-06 05:00:00	AAPL	Stock	18.2857	18.2914	18.2754	18.2821	44800.0
2014-02-06 06:00:00	AAPL	Stock	18.2718	18.2732	18.2129	18.2321	102536.0
2014-02-06 07:00:00	AAPL	Stock	18.2321	18.2732	18.1825	18.2071	435960.0
2014-02-06 08:00:00	AAPL	Stock	18.1982	18.2657	18.1846	18.2229	1609216.0
2014-02-06 09:00:00	AAPL	Stock	18.2239	18.2996	18.1525	18.165	40382496.0
2014-02-06 10:00:00	AAPL	Stock	18.165	18.3393	18.1361	18.3175	45073336.0
2014-02-06 11:00:00	AAPL	Stock	18.3175	18.3321	18.2786	18.2955	20980764.0
2014-02-06 12:00:00	AAPL	Stock	18.2954	18.3196	18.2682	18.2932	14965468.0
2014-02-06 13:00:00	AAPL	Stock	18.2966	18.3286	18.2929	18.3186	13338220.0
2014-02-06 14:00:00	AAPL	Stock	18.3193	18.3393	18.3082	18.33	18280444.0
2014-02-06 15:00:00	AAPL	Stock	18.3289	18.3321	18.2871	18.3021	41687184.0
2014-02-06 16:00:00	AAPL	Stock	18.3039	18.3268	18.2757	18.2893	9581852.0
2014-02-06 17:00:00	AAPL	Stock	18.2768	18.3039	18.2682	18.2857	269024.0
2014-02-06 18:00:00	AAPL	Stock	18.2825	18.2857	18.2796	18.2818	28392.0
2014-02-06 19:00:00	AAPL	Stock	18.2857	18.2925	18.2796	18.2825	103292.0
2014-02-06 05:00:00	MSFT	Stock	36.05	36.05	36.05	36.05	600.0
2014-02-06 06:00:00	MSFT	Stock	36.02	36.05	36.02	36.05	1400.0
2014-02-06 07:00:00	MSFT	Stock	36.05	36.6	35.93	35.93	13850.0
2014-02-06 08:00:00	MSFT	Stock	35.98	36.06	35.95	35.96	12954.0
2014-02-06 09:00:00	MSFT	Stock	35.9	36.05	35.69	35.925	5652569.0
2014-02-06 10:00:00	MSFT	Stock	35.929	36.24	35.9	36.19	4929460.0
2014-02-06 11:00:00	MSFT	Stock	36.19	36.25	36.09	36.12	3478114.0
2014-02-06 12:00:00	MSFT	Stock	36.12	36.16	36.07	36.074	2486596.0
2014-02-06 13:00:00	MSFT	Stock	36.08	36.12	35.97	36.12	3645214.0
2014-02-06 14:00:00	MSFT	Stock	36.114	36.24	36.09	36.22	5067588.0
2014-02-06 15:00:00	MSFT	Stock	36.225	36.24	36.16	36.18	6209659.0
2014-02-06 16:00:00	MSFT	Stock	36.18	36.229	36.099	36.173	2294784.0
2014-02-06 17:00:00	MSFT	Stock	35.82	36.3	35.82	36.094	33412.0
2014-02-06 18:00:00	MSFT	Stock	36.28	36.29	36.18	36.18	14659.0
2014-02-06 19:00:00	MSFT	Stock	36.22	36.25	36.22	36.24	9900.0
2014-02-06 09:00:00	NVDA	Stock	0.386	0.3896	0.3858	0.388	14076560.0
2014-02-06 10:00:00	NVDA	Stock	0.3882	0.392	0.388	0.3902	26848040.0
2014-02-06 11:00:00	NVDA	Stock	0.3905	0.3914	0.3902	0.3905	14208480.0
2014-02-06 12:00:00	NVDA	Stock	0.3905	0.392	0.3905	0.3918	9120280.0
2014-02-06 13:00:00	NVDA	Stock	0.3918	0.392	0.3908	0.391	7277800.0
2014-02-06 14:00:00	NVDA	Stock	0.391	0.392	0.391	0.3915	11543400.0
2014-02-06 15:00:00	NVDA	Stock	0.3915	0.392	0.3908	0.391	42520720.0
2014-02-06 16:00:00	NVDA	Stock	0.391	0.3912	0.391	0.3911	32613680.0
2014-02-06 17:00:00	NVDA	Stock	0.391	0.391	0.391	0.391	46240.0
2014-02-06 06:00:00	AMZN	Stock	17.379	17.3875	17.356	17.3795	16240.0
2014-02-06 07:00:00	AMZN	Stock	17.3745	17.3875	17.289	17.3545	46520.0
2014-02-06 08:00:00	AMZN	Stock	17.328	17.3845	17.3145	17.345	91920.0
2014-02-06 09:00:00	AMZN	Stock	17.35	17.573	17.3305	17.534	9183140.0
2014-02-06 10:00:00	AMZN	Stock	17.5375	17.6035	17.513	17.5505	9431920.0
2014-02-06 11:00:00	AMZN	Stock	17.55	17.69	17.543	17.6375	11290220.0
2014-02-06 12:00:00	AMZN	Stock	17.6385	17.6831	17.625	17.64	6742700.0
2014-02-06 13:00:00	AMZN	Stock	17.639	17.669	17.603	17.6285	3873320.0
2014-02-06 14:00:00	AMZN	Stock	17.6285	17.717	17.6285	17.6862	6361860.0
2014-02-06 15:00:00	AMZN	Stock	17.6845	17.741	17.65	17.724	11580740.0

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

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