PREVIEW / stock_1min / 2011-06-27

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-27.parquet
  size:    13.5 MB
  rows:    1,028,837
  symbols: 2,865

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
2011-06-27 04:47:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	2800.0
2011-06-27 04:48:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	2800.0
2011-06-27 04:49:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	2800.0
2011-06-27 05:01:00	AAPL	Stock	11.7046	11.7046	11.7046	11.7046	2800.0
2011-06-27 05:05:00	AAPL	Stock	11.6839	11.6839	11.6839	11.6839	2800.0
2011-06-27 06:21:00	AAPL	Stock	11.7104	11.7111	11.7104	11.7111	22400.0
2011-06-27 06:22:00	AAPL	Stock	11.7146	11.7146	11.7146	11.7146	2800.0
2011-06-27 06:57:00	AAPL	Stock	11.7232	11.7232	11.7232	11.7232	5600.0
2011-06-27 06:58:00	AAPL	Stock	11.7232	11.7232	11.7143	11.7143	5600.0
2011-06-27 07:03:00	AAPL	Stock	11.7082	11.7082	11.7082	11.7082	2800.0
2011-06-27 07:07:00	AAPL	Stock	11.7214	11.7214	11.7214	11.7214	12600.0
2011-06-27 07:11:00	AAPL	Stock	11.7143	11.7232	11.7139	11.7143	44800.0
2011-06-27 07:12:00	AAPL	Stock	11.7193	11.7193	11.7193	11.7193	2800.0
2011-06-27 07:14:00	AAPL	Stock	11.7143	11.7143	11.7143	11.7143	2800.0
2011-06-27 07:17:00	AAPL	Stock	11.7214	11.7286	11.7214	11.7275	14000.0
2011-06-27 07:18:00	AAPL	Stock	11.7286	11.7286	11.7286	11.7286	16520.0
2011-06-27 07:21:00	AAPL	Stock	11.7311	11.7321	11.7311	11.7321	8400.0
2011-06-27 07:22:00	AAPL	Stock	11.7407	11.7468	11.7407	11.7468	50400.0
2011-06-27 07:23:00	AAPL	Stock	11.7468	11.7471	11.7421	11.7421	19600.0
2011-06-27 07:24:00	AAPL	Stock	11.7429	11.7511	11.7429	11.7511	60480.0
2011-06-27 07:25:00	AAPL	Stock	11.75	11.75	11.7407	11.7407	34300.0
2011-06-27 07:27:00	AAPL	Stock	11.7407	11.7407	11.7396	11.74	14000.0
2011-06-27 07:28:00	AAPL	Stock	11.7425	11.7425	11.7425	11.7425	2800.0
2011-06-27 07:30:00	AAPL	Stock	11.7496	11.75	11.7464	11.7464	60200.0
2011-06-27 07:31:00	AAPL	Stock	11.76	11.7611	11.7582	11.7607	100800.0
2011-06-27 07:32:00	AAPL	Stock	11.7614	11.7661	11.7607	11.7661	33600.0
2011-06-27 07:33:00	AAPL	Stock	11.7607	11.7607	11.75	11.75	30800.0
2011-06-27 07:34:00	AAPL	Stock	11.7554	11.7554	11.7554	11.7554	5600.0
2011-06-27 07:38:00	AAPL	Stock	11.7511	11.7561	11.7511	11.7561	33600.0
2011-06-27 07:39:00	AAPL	Stock	11.7554	11.7554	11.7554	11.7554	2800.0
2011-06-27 07:42:00	AAPL	Stock	11.7454	11.7454	11.7454	11.7454	2800.0
2011-06-27 07:44:00	AAPL	Stock	11.75	11.75	11.75	11.75	2800.0
2011-06-27 07:47:00	AAPL	Stock	11.7504	11.7504	11.7504	11.7504	2800.0
2011-06-27 07:48:00	AAPL	Stock	11.75	11.7504	11.75	11.7504	14000.0
2011-06-27 07:50:00	AAPL	Stock	11.7536	11.7536	11.7536	11.7536	5600.0
2011-06-27 07:51:00	AAPL	Stock	11.7539	11.7539	11.7539	11.7539	2800.0
2011-06-27 07:53:00	AAPL	Stock	11.7593	11.7607	11.7593	11.7607	11060.0
2011-06-27 07:54:00	AAPL	Stock	11.7536	11.7539	11.7468	11.7471	40600.0
2011-06-27 07:55:00	AAPL	Stock	11.7475	11.75	11.7475	11.75	16800.0
2011-06-27 07:57:00	AAPL	Stock	11.7454	11.7454	11.7454	11.7454	5600.0
2011-06-27 07:58:00	AAPL	Stock	11.745	11.7461	11.745	11.7461	33460.0
2011-06-27 07:59:00	AAPL	Stock	11.7414	11.7457	11.7414	11.7446	8400.0
2011-06-27 08:00:00	AAPL	Stock	11.7457	11.7457	11.7261	11.7321	179592.0
2011-06-27 08:01:00	AAPL	Stock	11.7318	11.7436	11.7318	11.7436	42896.0
2011-06-27 08:02:00	AAPL	Stock	11.7436	11.7436	11.7361	11.7364	11200.0
2011-06-27 08:03:00	AAPL	Stock	11.7354	11.7354	11.7318	11.7318	95032.0
2011-06-27 08:05:00	AAPL	Stock	11.7321	11.7339	11.7321	11.7339	11620.0
2011-06-27 08:06:00	AAPL	Stock	11.7279	11.7279	11.7279	11.7279	7980.0
2011-06-27 08:07:00	AAPL	Stock	11.7279	11.7279	11.7254	11.7257	25200.0
2011-06-27 08:09:00	AAPL	Stock	11.7279	11.7321	11.7279	11.7321	44520.0

> showing 50 of 1,028,837 rows — these rows as CSV

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