PREVIEW / stock_1min / 2014-03-27

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-03-27.parquet
  size:    15.2 MB
  rows:    1,101,157
  symbols: 2,861

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-03-27 05:42:00	AAPL	Stock	19.25	19.25	19.25	19.25	12600.0
2014-03-27 07:02:00	AAPL	Stock	19.3129	19.3129	19.28	19.28	11200.0
2014-03-27 07:04:00	AAPL	Stock	19.2875	19.2875	19.2875	19.2875	2800.0
2014-03-27 07:06:00	AAPL	Stock	19.2996	19.2996	19.2996	19.2996	4200.0
2014-03-27 07:10:00	AAPL	Stock	19.3136	19.3136	19.3121	19.3121	5600.0
2014-03-27 07:19:00	AAPL	Stock	19.3029	19.3029	19.2964	19.2964	11340.0
2014-03-27 07:21:00	AAPL	Stock	19.3	19.3	19.3	19.3	2800.0
2014-03-27 07:24:00	AAPL	Stock	19.3	19.3	19.3	19.3	10192.0
2014-03-27 07:28:00	AAPL	Stock	19.3054	19.3054	19.3054	19.3054	27300.0
2014-03-27 07:33:00	AAPL	Stock	19.31	19.31	19.31	19.31	2800.0
2014-03-27 07:34:00	AAPL	Stock	19.3111	19.3111	19.3111	19.3111	3080.0
2014-03-27 07:39:00	AAPL	Stock	19.3	19.3	19.3	19.3	2800.0
2014-03-27 07:46:00	AAPL	Stock	19.2868	19.2868	19.2857	19.2857	34300.0
2014-03-27 07:59:00	AAPL	Stock	19.2821	19.2821	19.2821	19.2821	3780.0
2014-03-27 08:00:00	AAPL	Stock	19.3146	19.3146	19.2857	19.2857	19600.0
2014-03-27 08:01:00	AAPL	Stock	19.2786	19.28	19.2786	19.28	8400.0
2014-03-27 08:03:00	AAPL	Stock	19.2804	19.2804	19.2804	19.2804	6720.0
2014-03-27 08:06:00	AAPL	Stock	19.2804	19.2804	19.2804	19.2804	5600.0
2014-03-27 08:07:00	AAPL	Stock	19.2825	19.2825	19.2825	19.2825	2800.0
2014-03-27 08:10:00	AAPL	Stock	19.2786	19.2786	19.2786	19.2786	2800.0
2014-03-27 08:11:00	AAPL	Stock	19.2764	19.2764	19.2679	19.2679	213808.0
2014-03-27 08:12:00	AAPL	Stock	19.2539	19.2539	19.2539	19.2539	2800.0
2014-03-27 08:13:00	AAPL	Stock	19.2475	19.2475	19.2464	19.2464	8400.0
2014-03-27 08:15:00	AAPL	Stock	19.2371	19.2371	19.2343	19.2343	8960.0
2014-03-27 08:16:00	AAPL	Stock	19.2264	19.2279	19.2264	19.2279	12040.0
2014-03-27 08:17:00	AAPL	Stock	19.2357	19.2357	19.2321	19.2321	16800.0
2014-03-27 08:18:00	AAPL	Stock	19.2318	19.2321	19.2282	19.2282	16800.0
2014-03-27 08:20:00	AAPL	Stock	19.2411	19.2414	19.2393	19.2414	13888.0
2014-03-27 08:21:00	AAPL	Stock	19.2332	19.2332	19.2321	19.2321	5600.0
2014-03-27 08:23:00	AAPL	Stock	19.2336	19.25	19.2336	19.25	7840.0
2014-03-27 08:25:00	AAPL	Stock	19.25	19.2589	19.25	19.2589	11200.0
2014-03-27 08:29:00	AAPL	Stock	19.2711	19.2782	19.2711	19.2782	42000.0
2014-03-27 08:30:00	AAPL	Stock	19.2775	19.2775	19.2611	19.2611	85372.0
2014-03-27 08:33:00	AAPL	Stock	19.2836	19.2839	19.2836	19.2839	5600.0
2014-03-27 08:35:00	AAPL	Stock	19.2754	19.2768	19.275	19.2768	25788.0
2014-03-27 08:36:00	AAPL	Stock	19.2679	19.2714	19.2679	19.2714	30520.0
2014-03-27 08:38:00	AAPL	Stock	19.2739	19.275	19.2739	19.275	11200.0
2014-03-27 08:40:00	AAPL	Stock	19.2711	19.2714	19.2711	19.2714	16800.0
2014-03-27 08:42:00	AAPL	Stock	19.2711	19.2736	19.2711	19.2736	7140.0
2014-03-27 08:43:00	AAPL	Stock	19.2696	19.2696	19.2696	19.2696	2800.0
2014-03-27 08:44:00	AAPL	Stock	19.2696	19.2696	19.2679	19.2679	28000.0
2014-03-27 08:45:00	AAPL	Stock	19.2679	19.2679	19.2589	19.2589	22400.0
2014-03-27 08:46:00	AAPL	Stock	19.2536	19.2536	19.2521	19.2536	14000.0
2014-03-27 08:47:00	AAPL	Stock	19.25	19.25	19.25	19.25	53200.0
2014-03-27 08:48:00	AAPL	Stock	19.2371	19.2371	19.2361	19.2361	28000.0
2014-03-27 08:49:00	AAPL	Stock	19.2493	19.25	19.2493	19.25	30800.0
2014-03-27 08:50:00	AAPL	Stock	19.2561	19.2589	19.2561	19.2589	19432.0
2014-03-27 08:53:00	AAPL	Stock	19.25	19.25	19.25	19.25	2800.0
2014-03-27 08:55:00	AAPL	Stock	19.2607	19.2607	19.2607	19.2607	2800.0
2014-03-27 08:57:00	AAPL	Stock	19.2571	19.2571	19.2571	19.2571	28000.0

> showing 50 of 1,101,157 rows — these rows as CSV

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