PREVIEW / stock_30min / 2013-01-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-18.parquet
  size:    1.4 MB
  rows:    76,164
  symbols: 3,441

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-01-18 04:00:00	AAPL	Stock	17.8625	17.8625	17.7589	17.8036	67760.0
2013-01-18 04:30:00	AAPL	Stock	17.8329	17.8868	17.8036	17.8571	95200.0
2013-01-18 05:00:00	AAPL	Stock	17.875	17.8914	17.875	17.8914	27160.0
2013-01-18 05:30:00	AAPL	Stock	17.875	17.9643	17.875	17.9643	64400.0
2013-01-18 06:00:00	AAPL	Stock	17.9821	17.9911	17.9814	17.9911	14000.0
2013-01-18 06:30:00	AAPL	Stock	17.9536	17.9596	17.9232	17.9232	181580.0
2013-01-18 07:00:00	AAPL	Stock	17.9232	17.9696	17.9	17.9643	473060.0
2013-01-18 07:30:00	AAPL	Stock	17.9632	18.0246	17.9446	17.9446	453460.0
2013-01-18 08:00:00	AAPL	Stock	17.9464	18.0268	17.8271	17.8332	1480724.0
2013-01-18 08:30:00	AAPL	Stock	17.8286	17.8482	17.7682	17.8143	2212364.0
2013-01-18 09:00:00	AAPL	Stock	17.8164	17.8393	17.7625	17.8143	2292556.0
2013-01-18 09:30:00	AAPL	Stock	17.7925	17.9364	17.7286	17.8564	110938044.0
2013-01-18 10:00:00	AAPL	Stock	17.8549	17.8889	17.8075	17.8396	36873760.0
2013-01-18 10:30:00	AAPL	Stock	17.8337	17.8589	17.8075	17.8314	23525516.0
2013-01-18 11:00:00	AAPL	Stock	17.8321	17.834	17.7679	17.7821	31432800.0
2013-01-18 11:30:00	AAPL	Stock	17.7807	17.7957	17.7529	17.7605	20371568.0
2013-01-18 12:00:00	AAPL	Stock	17.7597	17.8096	17.7536	17.797	18049556.0
2013-01-18 12:30:00	AAPL	Stock	17.7964	17.8446	17.7875	17.8376	17195808.0
2013-01-18 13:00:00	AAPL	Stock	17.8376	17.8596	17.8214	17.8361	16898644.0
2013-01-18 13:30:00	AAPL	Stock	17.8371	17.8561	17.8254	17.8436	10967880.0
2013-01-18 14:00:00	AAPL	Stock	17.8439	17.8475	17.7946	17.8089	18249168.0
2013-01-18 14:30:00	AAPL	Stock	17.81	17.8407	17.8036	17.8271	17621940.0
2013-01-18 15:00:00	AAPL	Stock	17.8271	17.8346	17.8036	17.8321	22440460.0
2013-01-18 15:30:00	AAPL	Stock	17.8311	17.8607	17.8275	17.8557	55612732.0
2013-01-18 16:00:00	AAPL	Stock	17.8561	17.9529	17.7964	17.8571	17225768.0
2013-01-18 16:30:00	AAPL	Stock	17.8579	17.8579	17.8181	17.8571	887796.0
2013-01-18 17:00:00	AAPL	Stock	17.8571	17.8607	17.8564	17.8607	352072.0
2013-01-18 17:30:00	AAPL	Stock	17.8571	17.8639	17.8571	17.8639	4589648.0
2013-01-18 18:00:00	AAPL	Stock	17.8607	17.8732	17.8607	17.8629	385420.0
2013-01-18 18:30:00	AAPL	Stock	17.8625	17.8707	17.8625	17.8704	40320.0
2013-01-18 19:00:00	AAPL	Stock	17.8679	17.8714	17.8643	17.8714	16800.0
2013-01-18 19:30:00	AAPL	Stock	17.8661	17.8714	17.8625	17.8682	155848.0
2013-01-18 05:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	300.0
2013-01-18 07:30:00	MSFT	Stock	27.07	27.07	27.07	27.07	1000.0
2013-01-18 08:00:00	MSFT	Stock	27.12	27.26	27.07	27.12	44434.0
2013-01-18 08:30:00	MSFT	Stock	27.12	27.15	27.09	27.09	17310.0
2013-01-18 09:00:00	MSFT	Stock	27.1	27.16	27.02	27.09	114389.0
2013-01-18 09:30:00	MSFT	Stock	27.1	27.27	27.04	27.2	15394246.0
2013-01-18 10:00:00	MSFT	Stock	27.19	27.21	27.1	27.17	2890407.0
2013-01-18 10:30:00	MSFT	Stock	27.175	27.23	27.16	27.195	2774589.0
2013-01-18 11:00:00	MSFT	Stock	27.195	27.22	27.1	27.18	3489676.0
2013-01-18 11:30:00	MSFT	Stock	27.18	27.24	27.16	27.165	2694041.0
2013-01-18 12:00:00	MSFT	Stock	27.16	27.2	27.13	27.16	1631266.0
2013-01-18 12:30:00	MSFT	Stock	27.15	27.25	27.14	27.24	1630681.0
2013-01-18 13:00:00	MSFT	Stock	27.235	27.29	27.23	27.27	2452558.0
2013-01-18 13:30:00	MSFT	Stock	27.265	27.28	27.24	27.25	1567078.0
2013-01-18 14:00:00	MSFT	Stock	27.24	27.29	27.21	27.21	2100783.0
2013-01-18 14:30:00	MSFT	Stock	27.21	27.24	27.18	27.188	1805124.0
2013-01-18 15:00:00	MSFT	Stock	27.18	27.21	27.16	27.21	2537482.0
2013-01-18 15:30:00	MSFT	Stock	27.21	27.25	27.2	27.25	6241489.0

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

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