PREVIEW / stock_1min / 2012-08-01

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-08-01.parquet
  size:    12.6 MB
  rows:    935,002
  symbols: 2,788

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-01 04:00:00	AAPL	Stock	21.8571	21.8571	21.8571	21.8571	2800.0
2012-08-01 04:01:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	8400.0
2012-08-01 04:06:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	2800.0
2012-08-01 04:07:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	5600.0
2012-08-01 04:11:00	AAPL	Stock	21.9286	21.9286	21.9286	21.9286	2800.0
2012-08-01 04:14:00	AAPL	Stock	21.9286	21.9286	21.9286	21.9286	8400.0
2012-08-01 04:16:00	AAPL	Stock	21.9286	21.9286	21.9286	21.9286	14000.0
2012-08-01 04:35:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-08-01 04:44:00	AAPL	Stock	21.8839	21.8839	21.8839	21.8839	5600.0
2012-08-01 04:46:00	AAPL	Stock	21.8839	21.8839	21.8839	21.8839	5600.0
2012-08-01 05:15:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	25200.0
2012-08-01 05:40:00	AAPL	Stock	21.875	21.875	21.875	21.875	5600.0
2012-08-01 06:26:00	AAPL	Stock	21.875	21.875	21.875	21.875	7980.0
2012-08-01 06:28:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	6636.0
2012-08-01 06:29:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-08-01 06:33:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	8400.0
2012-08-01 06:39:00	AAPL	Stock	21.9018	21.9036	21.9018	21.9036	8316.0
2012-08-01 06:41:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-08-01 07:00:00	AAPL	Stock	21.8786	21.8786	21.8786	21.8786	2800.0
2012-08-01 07:01:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	22400.0
2012-08-01 07:02:00	AAPL	Stock	21.8925	21.8929	21.8925	21.8929	27104.0
2012-08-01 07:03:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	48860.0
2012-08-01 07:04:00	AAPL	Stock	21.8932	21.9071	21.8929	21.9025	77756.0
2012-08-01 07:05:00	AAPL	Stock	21.9039	21.9143	21.9036	21.9143	15344.0
2012-08-01 07:06:00	AAPL	Stock	21.9125	21.9286	21.9125	21.9286	46200.0
2012-08-01 07:07:00	AAPL	Stock	21.9232	21.9232	21.9179	21.9196	28000.0
2012-08-01 07:08:00	AAPL	Stock	21.9179	21.9196	21.9143	21.9196	74312.0
2012-08-01 07:09:00	AAPL	Stock	21.92	21.92	21.9143	21.9143	58800.0
2012-08-01 07:10:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	11116.0
2012-08-01 07:11:00	AAPL	Stock	21.9143	21.9143	21.9143	21.9143	5600.0
2012-08-01 07:13:00	AAPL	Stock	21.9171	21.9232	21.9171	21.9196	102900.0
2012-08-01 07:14:00	AAPL	Stock	21.9111	21.9111	21.9111	21.9111	2800.0
2012-08-01 07:15:00	AAPL	Stock	21.9129	21.9129	21.9129	21.9129	2800.0
2012-08-01 07:16:00	AAPL	Stock	21.9211	21.9389	21.9211	21.9339	97020.0
2012-08-01 07:18:00	AAPL	Stock	21.9421	21.9421	21.9421	21.9421	2800.0
2012-08-01 07:19:00	AAPL	Stock	21.9461	21.9518	21.9461	21.95	20328.0
2012-08-01 07:20:00	AAPL	Stock	21.9525	21.9604	21.9464	21.9464	80612.0
2012-08-01 07:22:00	AAPL	Stock	21.9464	21.9464	21.9339	21.9339	54012.0
2012-08-01 07:23:00	AAPL	Stock	21.955	21.955	21.955	21.955	2800.0
2012-08-01 07:24:00	AAPL	Stock	21.9329	21.9329	21.9307	21.9307	14000.0
2012-08-01 07:25:00	AAPL	Stock	21.9332	21.9332	21.9286	21.9286	42000.0
2012-08-01 07:26:00	AAPL	Stock	21.9436	21.9454	21.9436	21.9454	6636.0
2012-08-01 07:27:00	AAPL	Stock	21.9332	21.9375	21.9286	21.9375	56700.0
2012-08-01 07:28:00	AAPL	Stock	21.9321	21.9321	21.9286	21.9286	11956.0
2012-08-01 07:29:00	AAPL	Stock	21.9293	21.9293	21.9286	21.9286	44800.0
2012-08-01 07:30:00	AAPL	Stock	21.9289	21.9343	21.9286	21.9343	24360.0
2012-08-01 07:36:00	AAPL	Stock	21.9361	21.9411	21.9361	21.9411	14000.0
2012-08-01 07:39:00	AAPL	Stock	21.9411	21.9464	21.9411	21.9464	19740.0
2012-08-01 07:40:00	AAPL	Stock	21.9546	21.9554	21.9546	21.9554	11200.0
2012-08-01 07:43:00	AAPL	Stock	21.9482	21.9482	21.9464	21.9464	8400.0

> showing 50 of 935,002 rows — these rows as CSV

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