PREVIEW / stock_1min / 2014-05-12

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-05-12.parquet
  size:    14.8 MB
  rows:    1,088,248
  symbols: 2,882

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-05-12 04:00:00	AAPL	Stock	20.9525	20.9643	20.9525	20.9643	11200.0
2014-05-12 04:12:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	8400.0
2014-05-12 04:13:00	AAPL	Stock	20.9214	20.9214	20.9214	20.9214	5600.0
2014-05-12 04:27:00	AAPL	Stock	20.9521	20.9521	20.9521	20.9521	5600.0
2014-05-12 05:10:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	2800.0
2014-05-12 05:20:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	2800.0
2014-05-12 05:37:00	AAPL	Stock	20.9625	20.9643	20.9625	20.9643	8400.0
2014-05-12 06:30:00	AAPL	Stock	20.9632	20.9632	20.9632	20.9632	2800.0
2014-05-12 06:33:00	AAPL	Stock	20.9664	20.9664	20.9664	20.9664	2800.0
2014-05-12 06:37:00	AAPL	Stock	20.9775	20.9796	20.9775	20.9796	5600.0
2014-05-12 06:39:00	AAPL	Stock	20.9946	20.9946	20.9946	20.9946	8400.0
2014-05-12 06:45:00	AAPL	Stock	20.975	20.975	20.975	20.975	2800.0
2014-05-12 07:00:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2014-05-12 07:02:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2014-05-12 07:03:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	9800.0
2014-05-12 07:08:00	AAPL	Stock	20.9911	20.9911	20.9911	20.9911	3920.0
2014-05-12 07:09:00	AAPL	Stock	20.9946	20.9946	20.9946	20.9946	11200.0
2014-05-12 07:14:00	AAPL	Stock	20.9961	21.0089	20.9961	21.0089	31976.0
2014-05-12 07:16:00	AAPL	Stock	21.0321	21.0321	21.0321	21.0321	7924.0
2014-05-12 07:24:00	AAPL	Stock	21.0089	21.0089	21.0089	21.0089	2800.0
2014-05-12 07:30:00	AAPL	Stock	21.0204	21.0204	21.0204	21.0204	5600.0
2014-05-12 07:32:00	AAPL	Stock	21.0204	21.0204	21.0204	21.0204	13104.0
2014-05-12 07:34:00	AAPL	Stock	21.0204	21.0204	21.0204	21.0204	2800.0
2014-05-12 07:35:00	AAPL	Stock	21.0179	21.0179	21.0179	21.0179	8400.0
2014-05-12 07:46:00	AAPL	Stock	21.0107	21.0107	21.0	21.0061	38248.0
2014-05-12 07:52:00	AAPL	Stock	21.0157	21.0179	21.0157	21.0179	11200.0
2014-05-12 07:53:00	AAPL	Stock	21.0168	21.0168	21.0168	21.0168	2800.0
2014-05-12 07:57:00	AAPL	Stock	21.0054	21.0204	21.0014	21.0204	19600.0
2014-05-12 07:58:00	AAPL	Stock	21.0146	21.0204	21.0143	21.0143	16800.0
2014-05-12 08:00:00	AAPL	Stock	21.0004	21.0304	20.9821	21.0004	86100.0
2014-05-12 08:01:00	AAPL	Stock	20.9893	21.0	20.9893	21.0	14000.0
2014-05-12 08:02:00	AAPL	Stock	21.0004	21.0171	20.9993	21.0171	28000.0
2014-05-12 08:03:00	AAPL	Stock	20.9993	20.9993	20.9993	20.9993	14000.0
2014-05-12 08:05:00	AAPL	Stock	20.9964	20.9986	20.9964	20.9986	22736.0
2014-05-12 08:06:00	AAPL	Stock	20.9979	21.0	20.9979	21.0	27888.0
2014-05-12 08:07:00	AAPL	Stock	20.9993	21.0086	20.9989	21.0086	50400.0
2014-05-12 08:08:00	AAPL	Stock	20.9904	20.9993	20.9879	20.9979	70000.0
2014-05-12 08:09:00	AAPL	Stock	20.9871	20.9879	20.9821	20.9821	14000.0
2014-05-12 08:10:00	AAPL	Stock	20.9825	20.9825	20.975	20.975	9800.0
2014-05-12 08:11:00	AAPL	Stock	20.9943	20.9943	20.9757	20.9757	5600.0
2014-05-12 08:12:00	AAPL	Stock	20.9682	20.9682	20.9675	20.9675	10640.0
2014-05-12 08:14:00	AAPL	Stock	20.9679	20.975	20.9643	20.9657	54040.0
2014-05-12 08:15:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	14000.0
2014-05-12 08:18:00	AAPL	Stock	20.9525	20.9554	20.9507	20.9507	16800.0
2014-05-12 08:20:00	AAPL	Stock	20.9536	20.9536	20.9479	20.9536	14476.0
2014-05-12 08:21:00	AAPL	Stock	20.9536	20.9536	20.9368	20.9368	22400.0
2014-05-12 08:22:00	AAPL	Stock	20.9411	20.9411	20.9411	20.9411	2800.0
2014-05-12 08:23:00	AAPL	Stock	20.945	20.9464	20.945	20.9464	36652.0
2014-05-12 08:24:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	14000.0
2014-05-12 08:25:00	AAPL	Stock	20.9464	20.9464	20.9418	20.9464	22400.0

> showing 50 of 1,088,248 rows — these rows as CSV

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