PREVIEW / stock_1min / 2014-04-23

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-23.parquet
  size:    14.0 MB
  rows:    1,038,239
  symbols: 2,878

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-04-23 05:17:00	AAPL	Stock	18.975	18.975	18.975	18.975	3948.0
2014-04-23 07:01:00	AAPL	Stock	18.9804	18.9804	18.9804	18.9804	14000.0
2014-04-23 07:02:00	AAPL	Stock	18.9786	18.9786	18.9786	18.9786	5600.0
2014-04-23 07:05:00	AAPL	Stock	18.9875	18.9875	18.9875	18.9875	2800.0
2014-04-23 07:06:00	AAPL	Stock	18.9786	18.9836	18.9786	18.9836	5600.0
2014-04-23 07:07:00	AAPL	Stock	18.9839	18.9839	18.9839	18.9839	2800.0
2014-04-23 07:15:00	AAPL	Stock	18.9839	18.9839	18.9821	18.9821	8400.0
2014-04-23 07:20:00	AAPL	Stock	18.9679	18.9679	18.9679	18.9679	2800.0
2014-04-23 07:22:00	AAPL	Stock	18.9764	18.9764	18.9764	18.9764	2800.0
2014-04-23 07:25:00	AAPL	Stock	18.9804	18.9804	18.9804	18.9804	5600.0
2014-04-23 07:30:00	AAPL	Stock	18.9732	18.9732	18.9732	18.9732	2800.0
2014-04-23 07:36:00	AAPL	Stock	18.9643	18.9643	18.9643	18.9643	2800.0
2014-04-23 07:48:00	AAPL	Stock	18.975	18.975	18.975	18.975	18312.0
2014-04-23 07:59:00	AAPL	Stock	18.9454	18.9454	18.9204	18.9214	39200.0
2014-04-23 08:00:00	AAPL	Stock	18.9196	18.9821	18.9196	18.9764	73080.0
2014-04-23 08:05:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	8400.0
2014-04-23 08:07:00	AAPL	Stock	18.9321	18.9321	18.9321	18.9321	2800.0
2014-04-23 08:10:00	AAPL	Stock	18.9411	18.9411	18.9411	18.9411	2800.0
2014-04-23 08:11:00	AAPL	Stock	18.9464	18.9493	18.9464	18.9493	14000.0
2014-04-23 08:16:00	AAPL	Stock	18.9357	18.9357	18.9286	18.9286	16800.0
2014-04-23 08:17:00	AAPL	Stock	18.9286	18.9286	18.9279	18.9286	22848.0
2014-04-23 08:19:00	AAPL	Stock	18.9286	18.9286	18.9214	18.9286	74760.0
2014-04-23 08:20:00	AAPL	Stock	18.9286	18.9286	18.925	18.925	17640.0
2014-04-23 08:21:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	2800.0
2014-04-23 08:22:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	27468.0
2014-04-23 08:23:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	2800.0
2014-04-23 08:25:00	AAPL	Stock	18.925	18.9286	18.9207	18.9214	22204.0
2014-04-23 08:27:00	AAPL	Stock	18.9196	18.9196	18.9196	18.9196	2800.0
2014-04-23 08:28:00	AAPL	Stock	18.9161	18.9161	18.9107	18.9107	14000.0
2014-04-23 08:29:00	AAPL	Stock	18.9107	18.9196	18.9107	18.9196	26320.0
2014-04-23 08:30:00	AAPL	Stock	18.9125	18.9125	18.9107	18.9107	19600.0
2014-04-23 08:31:00	AAPL	Stock	18.9125	18.9125	18.9125	18.9125	2800.0
2014-04-23 08:32:00	AAPL	Stock	18.9179	18.9179	18.9179	18.9179	7056.0
2014-04-23 08:33:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	4200.0
2014-04-23 08:34:00	AAPL	Stock	18.9286	18.9286	18.9229	18.9264	12040.0
2014-04-23 08:42:00	AAPL	Stock	18.9532	18.9532	18.9532	18.9532	7000.0
2014-04-23 08:49:00	AAPL	Stock	18.9375	18.9464	18.9375	18.9464	28504.0
2014-04-23 08:54:00	AAPL	Stock	18.9379	18.9379	18.9379	18.9379	2800.0
2014-04-23 09:00:00	AAPL	Stock	18.9364	18.9364	18.9357	18.9357	5600.0
2014-04-23 09:01:00	AAPL	Stock	18.9361	18.9361	18.9357	18.9357	8092.0
2014-04-23 09:04:00	AAPL	Stock	18.9336	18.9357	18.9307	18.9307	28000.0
2014-04-23 09:10:00	AAPL	Stock	18.935	18.935	18.9343	18.9343	7280.0
2014-04-23 09:11:00	AAPL	Stock	18.9286	18.9357	18.9286	18.9357	11480.0
2014-04-23 09:13:00	AAPL	Stock	18.9296	18.9296	18.9296	18.9296	2800.0
2014-04-23 09:17:00	AAPL	Stock	18.9289	18.9289	18.9289	18.9289	2800.0
2014-04-23 09:19:00	AAPL	Stock	18.9307	18.9307	18.9307	18.9307	2800.0
2014-04-23 09:21:00	AAPL	Stock	18.9307	18.9307	18.9286	18.9293	35168.0
2014-04-23 09:23:00	AAPL	Stock	18.9307	18.9307	18.9307	18.9307	5320.0
2014-04-23 09:25:00	AAPL	Stock	18.9243	18.925	18.9161	18.925	42756.0
2014-04-23 09:27:00	AAPL	Stock	18.925	18.925	18.925	18.925	5180.0

> showing 50 of 1,038,239 rows — these rows as CSV

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