PREVIEW / stock_30min / 2014-05-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-06.parquet
  size:    1.6 MB
  rows:    82,360
  symbols: 3,530

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-05-06 04:00:00	AAPL	Stock	21.5354	21.5821	21.4911	21.4911	84560.0
2014-05-06 04:30:00	AAPL	Stock	21.5289	21.5289	21.5289	21.5289	5600.0
2014-05-06 05:00:00	AAPL	Stock	21.5286	21.5286	21.5286	21.5286	12880.0
2014-05-06 06:00:00	AAPL	Stock	21.5357	21.5357	21.5179	21.5318	60396.0
2014-05-06 06:30:00	AAPL	Stock	21.5286	21.5286	21.5	21.5	37884.0
2014-05-06 07:00:00	AAPL	Stock	21.5	21.5243	21.5	21.5193	179424.0
2014-05-06 07:30:00	AAPL	Stock	21.5039	21.5179	21.4904	21.4964	233212.0
2014-05-06 08:00:00	AAPL	Stock	21.4982	21.5304	21.4539	21.4807	811440.0
2014-05-06 08:30:00	AAPL	Stock	21.48	21.4814	21.4357	21.4604	547596.0
2014-05-06 09:00:00	AAPL	Stock	21.4643	21.5143	21.4643	21.4943	1235612.0
2014-05-06 09:30:00	AAPL	Stock	21.4929	21.5786	21.4175	21.5779	56037380.0
2014-05-06 10:00:00	AAPL	Stock	21.5793	21.5861	21.4554	21.4825	30258984.0
2014-05-06 10:30:00	AAPL	Stock	21.4832	21.4902	21.3429	21.3471	32076352.0
2014-05-06 11:00:00	AAPL	Stock	21.3436	21.4482	21.3304	21.4275	16781940.0
2014-05-06 11:30:00	AAPL	Stock	21.4257	21.4796	21.4186	21.4657	12168464.0
2014-05-06 12:00:00	AAPL	Stock	21.4639	21.4721	21.41	21.4232	10101560.0
2014-05-06 12:30:00	AAPL	Stock	21.4257	21.4464	21.395	21.417	6882484.0
2014-05-06 13:00:00	AAPL	Stock	21.415	21.42	21.3796	21.3895	5982116.0
2014-05-06 13:30:00	AAPL	Stock	21.3921	21.4057	21.3071	21.3091	14850724.0
2014-05-06 14:00:00	AAPL	Stock	21.3093	21.3246	21.2804	21.2821	11510884.0
2014-05-06 14:30:00	AAPL	Stock	21.2811	21.3321	21.2629	21.3018	13962648.0
2014-05-06 15:00:00	AAPL	Stock	21.3018	21.3018	21.2661	21.2679	11857160.0
2014-05-06 15:30:00	AAPL	Stock	21.2689	21.2857	21.2289	21.2296	27492724.0
2014-05-06 16:00:00	AAPL	Stock	21.23	21.4629	21.1429	21.1429	16995104.0
2014-05-06 16:30:00	AAPL	Stock	21.1857	21.4297	21.1429	21.1961	1785868.0
2014-05-06 17:00:00	AAPL	Stock	21.1964	21.2649	21.1964	21.2143	2211944.0
2014-05-06 17:30:00	AAPL	Stock	21.2143	21.2232	21.2143	21.2214	26124.0
2014-05-06 18:00:00	AAPL	Stock	21.225	21.2321	21.2232	21.2286	345352.0
2014-05-06 18:30:00	AAPL	Stock	21.2232	21.2232	21.2107	21.2171	78204.0
2014-05-06 19:00:00	AAPL	Stock	21.2171	21.2232	21.2171	21.2232	15120.0
2014-05-06 19:30:00	AAPL	Stock	21.2196	21.2321	21.2171	21.2286	88648.0
2014-05-06 08:00:00	MSFT	Stock	39.4	39.4	39.24	39.24	2536.0
2014-05-06 08:30:00	MSFT	Stock	39.29	39.3	39.25	39.29	3490.0
2014-05-06 09:00:00	MSFT	Stock	39.29	39.33	39.29	39.31	600.0
2014-05-06 09:30:00	MSFT	Stock	39.29	39.35	39.14	39.23	3036299.0
2014-05-06 10:00:00	MSFT	Stock	39.23	39.25	39.175	39.2	2028067.0
2014-05-06 10:30:00	MSFT	Stock	39.195	39.25	39.16	39.18	2104149.0
2014-05-06 11:00:00	MSFT	Stock	39.18	39.225	39.08	39.08	2470434.0
2014-05-06 11:30:00	MSFT	Stock	39.08	39.21	39.05	39.2	1301673.0
2014-05-06 12:00:00	MSFT	Stock	39.21	39.27	39.15	39.215	805095.0
2014-05-06 12:30:00	MSFT	Stock	39.215	39.26	39.205	39.245	988501.0
2014-05-06 13:00:00	MSFT	Stock	39.245	39.25	39.115	39.115	839899.0
2014-05-06 13:30:00	MSFT	Stock	39.115	39.16	38.95	39.0	1805846.0
2014-05-06 14:00:00	MSFT	Stock	39.005	39.07	38.97	39.01	1355214.0
2014-05-06 14:30:00	MSFT	Stock	39.01	39.06	39.0	39.02	1260440.0
2014-05-06 15:00:00	MSFT	Stock	39.01	39.15	38.98	39.13	1944379.0
2014-05-06 15:30:00	MSFT	Stock	39.13	39.17	39.04	39.07	3358035.0
2014-05-06 16:00:00	MSFT	Stock	39.06	39.2	39.03	39.06	1880027.0
2014-05-06 16:30:00	MSFT	Stock	39.06	39.177	39.06	39.07	520143.0
2014-05-06 17:00:00	MSFT	Stock	39.109	39.109	39.06	39.06	646943.0

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

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