PREVIEW / stock_30min / 2014-06-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-24.parquet
  size:    1.6 MB
  rows:    83,335
  symbols: 3,573

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-06-24 04:00:00	AAPL	Stock	22.67	22.67	22.67	22.67	400.0
2014-06-24 05:00:00	AAPL	Stock	22.6925	22.695	22.67	22.67	8876.0
2014-06-24 05:30:00	AAPL	Stock	22.665	22.685	22.665	22.675	8800.0
2014-06-24 06:00:00	AAPL	Stock	22.685	22.69	22.6825	22.6825	2420.0
2014-06-24 06:30:00	AAPL	Stock	22.6925	22.695	22.6925	22.695	2220.0
2014-06-24 07:00:00	AAPL	Stock	22.7	22.72	22.7	22.72	6436.0
2014-06-24 07:30:00	AAPL	Stock	22.715	22.7425	22.7125	22.74	96984.0
2014-06-24 08:00:00	AAPL	Stock	22.7375	22.7425	22.6975	22.725	235992.0
2014-06-24 08:30:00	AAPL	Stock	22.725	22.7325	22.7125	22.73	132676.0
2014-06-24 09:00:00	AAPL	Stock	22.7275	22.7325	22.6875	22.6925	278244.0
2014-06-24 09:30:00	AAPL	Stock	22.695	22.8325	22.66	22.79	20539252.0
2014-06-24 10:00:00	AAPL	Stock	22.7875	22.885	22.7875	22.8812	16704776.0
2014-06-24 10:30:00	AAPL	Stock	22.8805	22.9122	22.8125	22.8725	10247212.0
2014-06-24 11:00:00	AAPL	Stock	22.8745	22.935	22.865	22.915	10820020.0
2014-06-24 11:30:00	AAPL	Stock	22.915	22.92	22.8525	22.8672	5625984.0
2014-06-24 12:00:00	AAPL	Stock	22.865	22.8925	22.8588	22.8925	4493004.0
2014-06-24 12:30:00	AAPL	Stock	22.89	22.92	22.86	22.8925	6441548.0
2014-06-24 13:00:00	AAPL	Stock	22.89	22.8925	22.8	22.8425	8626312.0
2014-06-24 13:30:00	AAPL	Stock	22.8425	22.885	22.8375	22.8525	5341544.0
2014-06-24 14:00:00	AAPL	Stock	22.855	22.855	22.795	22.8025	5400576.0
2014-06-24 14:30:00	AAPL	Stock	22.8012	22.815	22.775	22.78	5750816.0
2014-06-24 15:00:00	AAPL	Stock	22.78	22.78	22.64	22.6472	14376168.0
2014-06-24 15:30:00	AAPL	Stock	22.645	22.68	22.5475	22.5725	26052312.0
2014-06-24 16:00:00	AAPL	Stock	22.5725	22.782	22.54	22.5825	6468900.0
2014-06-24 16:30:00	AAPL	Stock	22.58	22.62	22.57	22.595	237968.0
2014-06-24 17:00:00	AAPL	Stock	22.5875	22.8175	22.57	22.5825	89648.0
2014-06-24 17:30:00	AAPL	Stock	22.595	22.6	22.585	22.595	17948.0
2014-06-24 18:00:00	AAPL	Stock	22.595	22.605	22.585	22.5925	34380.0
2014-06-24 18:30:00	AAPL	Stock	22.5925	22.6075	22.57	22.595	125744.0
2014-06-24 19:00:00	AAPL	Stock	22.595	22.5975	22.5825	22.5825	24712.0
2014-06-24 19:30:00	AAPL	Stock	22.5825	22.5975	22.5825	22.595	17708.0
2014-06-24 05:30:00	MSFT	Stock	41.94	41.94	41.94	41.94	1909.0
2014-06-24 08:00:00	MSFT	Stock	41.95	41.95	41.95	41.95	100.0
2014-06-24 08:30:00	MSFT	Stock	41.95	41.95	41.87	41.89	1411.0
2014-06-24 09:00:00	MSFT	Stock	41.9	41.92	41.8	41.84	16910.0
2014-06-24 09:30:00	MSFT	Stock	41.83	41.86	41.56	41.653	3245423.0
2014-06-24 10:00:00	MSFT	Stock	41.65	41.74	41.63	41.694	1584952.0
2014-06-24 10:30:00	MSFT	Stock	41.696	41.79	41.675	41.735	1659478.0
2014-06-24 11:00:00	MSFT	Stock	41.74	41.78	41.73	41.75	1156997.0
2014-06-24 11:30:00	MSFT	Stock	41.76	41.77	41.72	41.77	621389.0
2014-06-24 12:00:00	MSFT	Stock	41.765	41.82	41.76	41.79	485718.0
2014-06-24 12:30:00	MSFT	Stock	41.78	41.8	41.715	41.725	651682.0
2014-06-24 13:00:00	MSFT	Stock	41.73	41.73	41.565	41.68	1636380.0
2014-06-24 13:30:00	MSFT	Stock	41.67	41.78	41.66	41.775	1046473.0
2014-06-24 14:00:00	MSFT	Stock	41.78	41.94	41.77	41.82	2195028.0
2014-06-24 14:30:00	MSFT	Stock	41.818	41.85	41.76	41.805	1214139.0
2014-06-24 15:00:00	MSFT	Stock	41.805	41.805	41.59	41.66	2200663.0
2014-06-24 15:30:00	MSFT	Stock	41.66	41.77	41.62	41.745	3202069.0
2014-06-24 16:00:00	MSFT	Stock	41.74	41.78	41.615	41.74	4602236.0
2014-06-24 16:30:00	MSFT	Stock	41.74	41.76	41.74	41.74	23331.0

> showing 50 of 83,335 rows — these rows as CSV

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