PREVIEW / stock_1min / 2012-08-07

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-08-07.parquet
  size:    12.6 MB
  rows:    937,062
  symbols: 2,826

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
2012-08-07 04:00:00	AAPL	Stock	22.3029	22.3214	22.3029	22.3214	5600.0
2012-08-07 04:07:00	AAPL	Stock	22.3246	22.3246	22.3246	22.3246	2800.0
2012-08-07 04:38:00	AAPL	Stock	22.3214	22.3214	22.3214	22.3214	2800.0
2012-08-07 04:49:00	AAPL	Stock	22.3214	22.3214	22.3125	22.3125	10724.0
2012-08-07 04:55:00	AAPL	Stock	22.3125	22.3125	22.3125	22.3125	8260.0
2012-08-07 05:08:00	AAPL	Stock	22.3071	22.3071	22.3071	22.3071	3416.0
2012-08-07 05:19:00	AAPL	Stock	22.3	22.3	22.3	22.3	7000.0
2012-08-07 06:08:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	2800.0
2012-08-07 06:10:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	4200.0
2012-08-07 06:17:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	2800.0
2012-08-07 06:38:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	5600.0
2012-08-07 07:02:00	AAPL	Stock	22.2786	22.2786	22.2786	22.2786	5600.0
2012-08-07 07:03:00	AAPL	Stock	22.2857	22.3032	22.2857	22.3032	40460.0
2012-08-07 07:04:00	AAPL	Stock	22.3	22.3036	22.3	22.3	28000.0
2012-08-07 07:05:00	AAPL	Stock	22.3	22.3036	22.2871	22.3036	21000.0
2012-08-07 07:06:00	AAPL	Stock	22.2964	22.3036	22.2946	22.3029	33600.0
2012-08-07 07:07:00	AAPL	Stock	22.3125	22.3125	22.3125	22.3125	5600.0
2012-08-07 07:08:00	AAPL	Stock	22.3036	22.3089	22.3036	22.3089	16800.0
2012-08-07 07:09:00	AAPL	Stock	22.3068	22.3071	22.3061	22.3061	12488.0
2012-08-07 07:10:00	AAPL	Stock	22.3061	22.3061	22.3039	22.3039	11200.0
2012-08-07 07:11:00	AAPL	Stock	22.3039	22.3039	22.295	22.295	10080.0
2012-08-07 07:13:00	AAPL	Stock	22.3036	22.3036	22.3036	22.3036	2800.0
2012-08-07 07:17:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	2800.0
2012-08-07 07:23:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	2800.0
2012-08-07 07:26:00	AAPL	Stock	22.2961	22.2964	22.2961	22.2964	68684.0
2012-08-07 07:29:00	AAPL	Stock	22.2886	22.2886	22.2875	22.2875	5600.0
2012-08-07 07:32:00	AAPL	Stock	22.2875	22.2875	22.2875	22.2875	2800.0
2012-08-07 07:33:00	AAPL	Stock	22.2875	22.2875	22.2875	22.2875	24640.0
2012-08-07 07:36:00	AAPL	Stock	22.2946	22.2964	22.2929	22.2964	64120.0
2012-08-07 07:37:00	AAPL	Stock	22.2964	22.3089	22.2964	22.3089	42000.0
2012-08-07 07:38:00	AAPL	Stock	22.3036	22.3036	22.3036	22.3036	19600.0
2012-08-07 07:41:00	AAPL	Stock	22.3	22.3	22.3	22.3	5600.0
2012-08-07 07:42:00	AAPL	Stock	22.2964	22.3	22.2964	22.3	8400.0
2012-08-07 07:49:00	AAPL	Stock	22.2982	22.2982	22.2982	22.2982	2800.0
2012-08-07 07:53:00	AAPL	Stock	22.2911	22.2911	22.2893	22.2893	12880.0
2012-08-07 07:55:00	AAPL	Stock	22.2896	22.2896	22.2625	22.2625	24892.0
2012-08-07 07:58:00	AAPL	Stock	22.2639	22.2639	22.2639	22.2639	10920.0
2012-08-07 08:00:00	AAPL	Stock	22.2786	22.2857	22.2764	22.2764	128380.0
2012-08-07 08:01:00	AAPL	Stock	22.2768	22.2857	22.2718	22.2718	58408.0
2012-08-07 08:02:00	AAPL	Stock	22.2857	22.2893	22.2721	22.2754	55944.0
2012-08-07 08:03:00	AAPL	Stock	22.2754	22.2754	22.2736	22.2736	13524.0
2012-08-07 08:04:00	AAPL	Stock	22.2789	22.285	22.2786	22.285	24360.0
2012-08-07 08:05:00	AAPL	Stock	22.2846	22.2957	22.2843	22.2957	93996.0
2012-08-07 08:06:00	AAPL	Stock	22.2857	22.2929	22.2768	22.285	72184.0
2012-08-07 08:07:00	AAPL	Stock	22.2857	22.2857	22.2736	22.2736	25956.0
2012-08-07 08:08:00	AAPL	Stock	22.2736	22.2804	22.2736	22.2804	34160.0
2012-08-07 08:09:00	AAPL	Stock	22.275	22.2857	22.2725	22.2857	44800.0
2012-08-07 08:10:00	AAPL	Stock	22.2854	22.2879	22.2854	22.2879	44520.0
2012-08-07 08:11:00	AAPL	Stock	22.2861	22.2907	22.2857	22.2857	19600.0
2012-08-07 08:12:00	AAPL	Stock	22.2875	22.2929	22.2875	22.2929	19600.0

> showing 50 of 937,062 rows — these rows as CSV

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