PREVIEW / stock_30min / 2014-04-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-22.parquet
  size:    1.6 MB
  rows:    82,630
  symbols: 3,564

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-22 04:30:00	AAPL	Stock	18.9589	18.9589	18.9589	18.9589	5600.0
2014-04-22 05:00:00	AAPL	Stock	18.9036	18.9036	18.9036	18.9036	2800.0
2014-04-22 05:30:00	AAPL	Stock	18.9143	18.9179	18.9143	18.9179	34384.0
2014-04-22 06:00:00	AAPL	Stock	18.92	18.9529	18.92	18.9529	5740.0
2014-04-22 06:30:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	2800.0
2014-04-22 07:00:00	AAPL	Stock	18.9293	18.9321	18.9268	18.9286	43456.0
2014-04-22 07:30:00	AAPL	Stock	18.915	18.9286	18.8661	18.8707	271432.0
2014-04-22 08:00:00	AAPL	Stock	18.8796	18.9464	18.8786	18.8993	491512.0
2014-04-22 08:30:00	AAPL	Stock	18.9032	18.9393	18.9018	18.9318	703724.0
2014-04-22 09:00:00	AAPL	Stock	18.9214	18.9289	18.8546	18.8675	802704.0
2014-04-22 09:30:00	AAPL	Stock	18.8682	18.9036	18.8036	18.8696	26725104.0
2014-04-22 10:00:00	AAPL	Stock	18.8696	18.8925	18.8614	18.8886	13818644.0
2014-04-22 10:30:00	AAPL	Stock	18.8882	18.9104	18.8686	18.9061	10476340.0
2014-04-22 11:00:00	AAPL	Stock	18.9057	18.9579	18.8965	18.9401	10715516.0
2014-04-22 11:30:00	AAPL	Stock	18.9382	18.9507	18.8957	18.9216	8160908.0
2014-04-22 12:00:00	AAPL	Stock	18.9254	18.9339	18.9057	18.9232	5786228.0
2014-04-22 12:30:00	AAPL	Stock	18.9236	18.9339	18.905	18.9204	5165188.0
2014-04-22 13:00:00	AAPL	Stock	18.9214	18.9389	18.9154	18.9346	5419316.0
2014-04-22 13:30:00	AAPL	Stock	18.9375	18.9821	18.9307	18.9725	8198876.0
2014-04-22 14:00:00	AAPL	Stock	18.975	18.98	18.9375	18.9707	6979140.0
2014-04-22 14:30:00	AAPL	Stock	18.9707	18.9938	18.9661	18.9759	7753760.0
2014-04-22 15:00:00	AAPL	Stock	18.975	18.9821	18.9707	18.9726	8884120.0
2014-04-22 15:30:00	AAPL	Stock	18.9729	18.9911	18.9573	18.9889	17601808.0
2014-04-22 16:00:00	AAPL	Stock	18.9889	18.9957	18.9211	18.9929	15094296.0
2014-04-22 16:30:00	AAPL	Stock	18.9911	18.9964	18.9839	18.9839	172172.0
2014-04-22 17:00:00	AAPL	Stock	18.9889	18.9982	18.9889	18.9911	580048.0
2014-04-22 17:30:00	AAPL	Stock	18.9839	18.9875	18.9829	18.9829	26740.0
2014-04-22 18:00:00	AAPL	Stock	18.9829	18.9889	18.9829	18.9889	80416.0
2014-04-22 18:30:00	AAPL	Stock	18.9714	18.9864	18.9714	18.9864	20244.0
2014-04-22 19:00:00	AAPL	Stock	18.9775	18.9857	18.9775	18.9857	31220.0
2014-04-22 19:30:00	AAPL	Stock	18.9839	18.9839	18.9839	18.9839	8400.0
2014-04-22 07:00:00	MSFT	Stock	40.12	40.12	40.12	40.12	300.0
2014-04-22 07:30:00	MSFT	Stock	40.19	40.19	40.19	40.19	200.0
2014-04-22 08:00:00	MSFT	Stock	40.19	40.19	40.08	40.08	1750.0
2014-04-22 08:30:00	MSFT	Stock	40.02	40.02	40.0	40.0	1000.0
2014-04-22 09:00:00	MSFT	Stock	39.96	40.0	39.96	39.96	17170.0
2014-04-22 09:30:00	MSFT	Stock	39.95	40.07	39.83	39.988	3370315.0
2014-04-22 10:00:00	MSFT	Stock	39.99	40.14	39.96	40.05	3132702.0
2014-04-22 10:30:00	MSFT	Stock	40.05	40.07	39.885	39.985	1947840.0
2014-04-22 11:00:00	MSFT	Stock	39.989	40.0	39.92	39.97	1002436.0
2014-04-22 11:30:00	MSFT	Stock	39.98	40.005	39.88	39.94	1165659.0
2014-04-22 12:00:00	MSFT	Stock	39.94	40.0	39.93	39.984	904601.0
2014-04-22 12:30:00	MSFT	Stock	39.99	40.01	39.95	39.98	695815.0
2014-04-22 13:00:00	MSFT	Stock	39.98	39.985	39.895	39.916	770268.0
2014-04-22 13:30:00	MSFT	Stock	39.92	40.0	39.915	39.995	769175.0
2014-04-22 14:00:00	MSFT	Stock	40.0	40.0	39.96	39.985	661273.0
2014-04-22 14:30:00	MSFT	Stock	39.99	40.0	39.95	39.97	1030062.0
2014-04-22 15:00:00	MSFT	Stock	39.97	39.98	39.87	39.875	1154558.0
2014-04-22 15:30:00	MSFT	Stock	39.87	40.0	39.84	39.98	3465790.0
2014-04-22 16:00:00	MSFT	Stock	39.99	40.004	39.95	39.99	4953244.0

> showing 50 of 82,630 rows — these rows as CSV

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