PREVIEW / stock_30min / 2013-05-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-24.parquet
  size:    1.5 MB
  rows:    76,049
  symbols: 3,514

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
2013-05-24 05:00:00	AAPL	Stock	15.8246	15.8246	15.8246	15.8246	3864.0
2013-05-24 06:00:00	AAPL	Stock	15.7907	15.7907	15.7714	15.7714	20664.0
2013-05-24 06:30:00	AAPL	Stock	15.7714	15.7714	15.7714	15.7714	2800.0
2013-05-24 07:00:00	AAPL	Stock	15.7857	15.7857	15.75	15.7857	38416.0
2013-05-24 07:30:00	AAPL	Stock	15.7857	15.8929	15.7857	15.8929	206556.0
2013-05-24 08:00:00	AAPL	Stock	15.8593	15.8929	15.7411	15.8132	1141476.0
2013-05-24 08:30:00	AAPL	Stock	15.825	15.8536	15.7857	15.7918	889448.0
2013-05-24 09:00:00	AAPL	Stock	15.7875	15.8071	15.7421	15.75	969892.0
2013-05-24 09:30:00	AAPL	Stock	15.7446	15.9164	15.7271	15.8414	54348112.0
2013-05-24 10:00:00	AAPL	Stock	15.8386	15.9039	15.8011	15.882	32111072.0
2013-05-24 10:30:00	AAPL	Stock	15.8825	15.8929	15.8396	15.8929	25563552.0
2013-05-24 11:00:00	AAPL	Stock	15.8929	15.905	15.8468	15.8554	23134692.0
2013-05-24 11:30:00	AAPL	Stock	15.8561	15.8893	15.8407	15.8801	16429616.0
2013-05-24 12:00:00	AAPL	Stock	15.8814	15.8939	15.8571	15.8657	9243052.0
2013-05-24 12:30:00	AAPL	Stock	15.8678	15.8722	15.8296	15.8382	10985492.0
2013-05-24 13:00:00	AAPL	Stock	15.8389	15.8614	15.8307	15.8389	9327864.0
2013-05-24 13:30:00	AAPL	Stock	15.8391	15.8425	15.8179	15.8375	9224208.0
2013-05-24 14:00:00	AAPL	Stock	15.8375	15.8671	15.8246	15.8564	9246608.0
2013-05-24 14:30:00	AAPL	Stock	15.8571	15.8668	15.845	15.8539	9411500.0
2013-05-24 15:00:00	AAPL	Stock	15.8571	15.8704	15.8521	15.8575	9577092.0
2013-05-24 15:30:00	AAPL	Stock	15.8586	15.8996	15.8398	15.8982	30629508.0
2013-05-24 16:00:00	AAPL	Stock	15.8982	15.8982	15.8601	15.8936	14793436.0
2013-05-24 16:30:00	AAPL	Stock	15.8936	15.8982	15.8599	15.8943	2479652.0
2013-05-24 17:00:00	AAPL	Stock	15.8936	15.8968	15.8929	15.8961	471940.0
2013-05-24 17:30:00	AAPL	Stock	15.8943	15.8961	15.8943	15.8954	103824.0
2013-05-24 18:00:00	AAPL	Stock	15.8961	15.8982	15.8961	15.8982	20916.0
2013-05-24 18:30:00	AAPL	Stock	15.8964	15.8971	15.8929	15.8961	45164.0
2013-05-24 19:00:00	AAPL	Stock	15.8961	15.8961	15.8946	15.8961	90916.0
2013-05-24 19:30:00	AAPL	Stock	15.8961	15.8979	15.8929	15.8979	122696.0
2013-05-24 05:30:00	MSFT	Stock	34.21	34.21	34.21	34.21	100.0
2013-05-24 07:30:00	MSFT	Stock	34.01	34.01	33.94	34.0	5200.0
2013-05-24 08:00:00	MSFT	Stock	34.08	34.08	34.01	34.04	8900.0
2013-05-24 08:30:00	MSFT	Stock	34.06	34.07	34.0	34.0	6050.0
2013-05-24 09:00:00	MSFT	Stock	34.0	34.07	33.9	33.98	56395.0
2013-05-24 09:30:00	MSFT	Stock	34.0	34.12	33.9	34.05	4701272.0
2013-05-24 10:00:00	MSFT	Stock	34.055	34.07	34.01	34.052	3480940.0
2013-05-24 10:30:00	MSFT	Stock	34.06	34.18	34.02	34.17	2573605.0
2013-05-24 11:00:00	MSFT	Stock	34.17	34.19	34.06	34.075	2119456.0
2013-05-24 11:30:00	MSFT	Stock	34.08	34.26	34.06	34.21	2397527.0
2013-05-24 12:00:00	MSFT	Stock	34.21	34.22	34.15	34.191	1180198.0
2013-05-24 12:30:00	MSFT	Stock	34.195	34.22	34.145	34.16	1272470.0
2013-05-24 13:00:00	MSFT	Stock	34.165	34.24	34.15	34.22	1388509.0
2013-05-24 13:30:00	MSFT	Stock	34.215	34.25	34.17	34.186	927586.0
2013-05-24 14:00:00	MSFT	Stock	34.185	34.25	34.16	34.242	1784005.0
2013-05-24 14:30:00	MSFT	Stock	34.245	34.25	34.14	34.16	1345304.0
2013-05-24 15:00:00	MSFT	Stock	34.17	34.18	34.1	34.112	1277601.0
2013-05-24 15:30:00	MSFT	Stock	34.115	34.28	34.06	34.27	4488553.0
2013-05-24 16:00:00	MSFT	Stock	34.27	34.29	34.13	34.28	2052447.0
2013-05-24 16:30:00	MSFT	Stock	34.27	34.27	34.161	34.161	18340.0
2013-05-24 17:00:00	MSFT	Stock	34.15	34.24	34.15	34.24	1200.0

> showing 50 of 76,049 rows — these rows as CSV

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