PREVIEW / stock_5min / 2013-04-02

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-02.parquet
  size:    5.1 MB
  rows:    338,167
  symbols: 3,473

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-04-02 04:00:00	AAPL	Stock	15.295	15.295	15.2107	15.2143	36400.0
2013-04-02 04:05:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	2800.0
2013-04-02 04:10:00	AAPL	Stock	15.25	15.25	15.2143	15.2143	7280.0
2013-04-02 04:40:00	AAPL	Stock	15.25	15.25	15.25	15.25	2940.0
2013-04-02 04:50:00	AAPL	Stock	15.2429	15.25	15.2429	15.2429	16800.0
2013-04-02 05:05:00	AAPL	Stock	15.2504	15.2504	15.2504	15.2504	5600.0
2013-04-02 05:20:00	AAPL	Stock	15.2511	15.2821	15.2511	15.2821	8400.0
2013-04-02 05:40:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	4144.0
2013-04-02 05:45:00	AAPL	Stock	15.3154	15.3154	15.3154	15.3154	5600.0
2013-04-02 06:05:00	AAPL	Stock	15.2911	15.2911	15.2911	15.2911	2800.0
2013-04-02 06:10:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	14000.0
2013-04-02 06:20:00	AAPL	Stock	15.2946	15.2946	15.2946	15.2946	8400.0
2013-04-02 06:30:00	AAPL	Stock	15.2804	15.2929	15.2804	15.2929	52696.0
2013-04-02 06:40:00	AAPL	Stock	15.2946	15.2946	15.2946	15.2946	13720.0
2013-04-02 06:45:00	AAPL	Stock	15.2946	15.2946	15.2946	15.2946	5600.0
2013-04-02 06:50:00	AAPL	Stock	15.3018	15.3036	15.3018	15.3036	14084.0
2013-04-02 06:55:00	AAPL	Stock	15.3143	15.3143	15.3143	15.3143	2800.0
2013-04-02 07:00:00	AAPL	Stock	15.3143	15.3571	15.3143	15.3571	26124.0
2013-04-02 07:05:00	AAPL	Stock	15.3579	15.375	15.3571	15.3586	44800.0
2013-04-02 07:10:00	AAPL	Stock	15.3571	15.3571	15.3486	15.3571	80024.0
2013-04-02 07:15:00	AAPL	Stock	15.35	15.3571	15.35	15.3571	62552.0
2013-04-02 07:20:00	AAPL	Stock	15.365	15.3693	15.3643	15.3693	37632.0
2013-04-02 07:25:00	AAPL	Stock	15.3714	15.3943	15.3714	15.3929	99848.0
2013-04-02 07:30:00	AAPL	Stock	15.405	15.4196	15.3857	15.4036	217476.0
2013-04-02 07:35:00	AAPL	Stock	15.4036	15.4071	15.4036	15.4046	19600.0
2013-04-02 07:40:00	AAPL	Stock	15.4007	15.4007	15.3879	15.3929	79212.0
2013-04-02 07:45:00	AAPL	Stock	15.3925	15.3929	15.3857	15.3857	71792.0
2013-04-02 07:50:00	AAPL	Stock	15.3796	15.3946	15.3779	15.3789	112000.0
2013-04-02 07:55:00	AAPL	Stock	15.3786	15.3811	15.345	15.3554	291760.0
2013-04-02 08:00:00	AAPL	Stock	15.3454	15.4143	15.3268	15.3596	683788.0
2013-04-02 08:05:00	AAPL	Stock	15.3632	15.3671	15.3214	15.3221	332248.0
2013-04-02 08:10:00	AAPL	Stock	15.3157	15.3304	15.2807	15.3196	396956.0
2013-04-02 08:15:00	AAPL	Stock	15.3214	15.3546	15.2857	15.3475	352716.0
2013-04-02 08:20:00	AAPL	Stock	15.3554	15.3554	15.3339	15.3393	98000.0
2013-04-02 08:25:00	AAPL	Stock	15.3393	15.3393	15.3179	15.3179	124376.0
2013-04-02 08:30:00	AAPL	Stock	15.3214	15.3214	15.295	15.295	51940.0
2013-04-02 08:35:00	AAPL	Stock	15.2968	15.2968	15.2696	15.2732	370328.0
2013-04-02 08:40:00	AAPL	Stock	15.2786	15.2786	15.2536	15.2679	447412.0
2013-04-02 08:45:00	AAPL	Stock	15.2679	15.2818	15.2357	15.2543	399952.0
2013-04-02 08:50:00	AAPL	Stock	15.2589	15.2857	15.2429	15.2836	491204.0
2013-04-02 08:55:00	AAPL	Stock	15.2786	15.2825	15.2704	15.2789	324212.0
2013-04-02 09:00:00	AAPL	Stock	15.2768	15.2839	15.2643	15.2643	249900.0
2013-04-02 09:05:00	AAPL	Stock	15.2714	15.2775	15.2536	15.2536	367332.0
2013-04-02 09:10:00	AAPL	Stock	15.25	15.25	15.2332	15.2379	399868.0
2013-04-02 09:15:00	AAPL	Stock	15.2361	15.2411	15.2243	15.2357	442652.0
2013-04-02 09:20:00	AAPL	Stock	15.2357	15.2429	15.2232	15.2307	969724.0
2013-04-02 09:25:00	AAPL	Stock	15.2314	15.2711	15.2307	15.2689	753368.0
2013-04-02 09:30:00	AAPL	Stock	15.2729	15.3543	15.2286	15.3248	23898308.0
2013-04-02 09:35:00	AAPL	Stock	15.3246	15.4875	15.3143	15.4695	24885224.0
2013-04-02 09:40:00	AAPL	Stock	15.4646	15.5182	15.4361	15.5164	17129784.0

> showing 50 of 338,167 rows — these rows as CSV

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