PREVIEW / stock_1min / 2014-03-31

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-03-31.parquet
  size:    15.1 MB
  rows:    1,096,574
  symbols: 2,892

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-31 04:30:00	AAPL	Stock	19.2586	19.2586	19.2586	19.2586	2800.0
2014-03-31 04:39:00	AAPL	Stock	19.275	19.275	19.2729	19.2729	5600.0
2014-03-31 04:40:00	AAPL	Stock	19.2729	19.2729	19.2729	19.2729	2800.0
2014-03-31 04:41:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	2800.0
2014-03-31 05:15:00	AAPL	Stock	19.2807	19.2807	19.2807	19.2807	2800.0
2014-03-31 05:18:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	2800.0
2014-03-31 07:00:00	AAPL	Stock	19.2875	19.2875	19.2875	19.2875	2800.0
2014-03-31 07:01:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	6972.0
2014-03-31 07:20:00	AAPL	Stock	19.2789	19.2789	19.2789	19.2789	2800.0
2014-03-31 07:28:00	AAPL	Stock	19.2593	19.2593	19.255	19.255	8400.0
2014-03-31 07:29:00	AAPL	Stock	19.2696	19.2714	19.2696	19.2714	34160.0
2014-03-31 07:33:00	AAPL	Stock	19.2811	19.2857	19.2811	19.2857	13300.0
2014-03-31 07:36:00	AAPL	Stock	19.2846	19.2857	19.2846	19.2857	22932.0
2014-03-31 07:38:00	AAPL	Stock	19.2861	19.2861	19.2768	19.2857	40488.0
2014-03-31 07:45:00	AAPL	Stock	19.2804	19.2804	19.2804	19.2804	5320.0
2014-03-31 07:50:00	AAPL	Stock	19.2821	19.2857	19.2821	19.2857	48972.0
2014-03-31 07:51:00	AAPL	Stock	19.2821	19.2893	19.2821	19.2893	31332.0
2014-03-31 07:52:00	AAPL	Stock	19.2911	19.2929	19.2911	19.2929	14000.0
2014-03-31 07:56:00	AAPL	Stock	19.2982	19.2982	19.2982	19.2982	5600.0
2014-03-31 07:59:00	AAPL	Stock	19.2836	19.2836	19.2836	19.2836	5600.0
2014-03-31 08:00:00	AAPL	Stock	19.2839	19.2893	19.2614	19.2679	71708.0
2014-03-31 08:01:00	AAPL	Stock	19.2807	19.2818	19.2807	19.2818	8400.0
2014-03-31 08:03:00	AAPL	Stock	19.2679	19.2679	19.2679	19.2679	2800.0
2014-03-31 08:04:00	AAPL	Stock	19.2714	19.2714	19.2714	19.2714	5600.0
2014-03-31 08:05:00	AAPL	Stock	19.2679	19.2714	19.2679	19.2714	25340.0
2014-03-31 08:06:00	AAPL	Stock	19.2679	19.2711	19.2679	19.2711	8400.0
2014-03-31 08:07:00	AAPL	Stock	19.2657	19.2657	19.2657	19.2657	5600.0
2014-03-31 08:08:00	AAPL	Stock	19.2575	19.2579	19.255	19.255	33600.0
2014-03-31 08:09:00	AAPL	Stock	19.2543	19.2543	19.2421	19.2421	30968.0
2014-03-31 08:10:00	AAPL	Stock	19.2386	19.2543	19.2386	19.2411	22232.0
2014-03-31 08:17:00	AAPL	Stock	19.2411	19.2411	19.2411	19.2411	14000.0
2014-03-31 08:21:00	AAPL	Stock	19.2464	19.2464	19.2446	19.2446	16800.0
2014-03-31 08:24:00	AAPL	Stock	19.2464	19.2621	19.2464	19.25	25620.0
2014-03-31 08:26:00	AAPL	Stock	19.2475	19.2475	19.24	19.24	8400.0
2014-03-31 08:30:00	AAPL	Stock	19.2379	19.2379	19.2379	19.2379	2800.0
2014-03-31 08:33:00	AAPL	Stock	19.2496	19.2507	19.2475	19.2507	52920.0
2014-03-31 08:34:00	AAPL	Stock	19.2507	19.2668	19.2507	19.2668	8400.0
2014-03-31 08:35:00	AAPL	Stock	19.2554	19.2554	19.2521	19.2521	11200.0
2014-03-31 08:36:00	AAPL	Stock	19.2539	19.2539	19.2457	19.2457	36512.0
2014-03-31 08:40:00	AAPL	Stock	19.255	19.255	19.25	19.25	11200.0
2014-03-31 08:42:00	AAPL	Stock	19.2579	19.2582	19.2557	19.2557	8400.0
2014-03-31 08:46:00	AAPL	Stock	19.2564	19.2564	19.2564	19.2564	2800.0
2014-03-31 08:47:00	AAPL	Stock	19.2507	19.2507	19.2443	19.2443	42784.0
2014-03-31 08:49:00	AAPL	Stock	19.25	19.2514	19.25	19.25	8820.0
2014-03-31 08:50:00	AAPL	Stock	19.2468	19.2468	19.2429	19.2429	25200.0
2014-03-31 08:51:00	AAPL	Stock	19.2489	19.2489	19.2489	19.2489	2800.0
2014-03-31 08:52:00	AAPL	Stock	19.2554	19.2554	19.2554	19.2554	2800.0
2014-03-31 08:54:00	AAPL	Stock	19.2571	19.2571	19.2571	19.2571	5600.0
2014-03-31 08:56:00	AAPL	Stock	19.2557	19.2629	19.2557	19.2629	19320.0
2014-03-31 08:57:00	AAPL	Stock	19.2661	19.2732	19.2661	19.2686	114884.0

> showing 50 of 1,096,574 rows — these rows as CSV

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