PREVIEW / stock_30min / 2014-04-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-10.parquet
  size:    1.6 MB
  rows:    83,240
  symbols: 3,553

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-10 04:00:00	AAPL	Stock	19.0368	19.05	19.0357	19.05	32200.0
2014-04-10 04:30:00	AAPL	Stock	19.0357	19.0357	19.0254	19.0254	11200.0
2014-04-10 05:00:00	AAPL	Stock	19.0357	19.0357	18.9482	18.9846	30800.0
2014-04-10 05:30:00	AAPL	Stock	18.9554	18.9554	18.9464	18.9464	8400.0
2014-04-10 06:30:00	AAPL	Stock	18.9446	18.975	18.9293	18.975	65184.0
2014-04-10 07:00:00	AAPL	Stock	18.975	19.0	18.9643	18.9964	193480.0
2014-04-10 07:30:00	AAPL	Stock	19.0107	19.0464	19.0043	19.0179	396704.0
2014-04-10 08:00:00	AAPL	Stock	19.0036	19.0357	18.9646	18.9907	449540.0
2014-04-10 08:30:00	AAPL	Stock	18.9793	18.9929	18.9525	18.9554	401688.0
2014-04-10 09:00:00	AAPL	Stock	18.9618	18.9639	18.9468	18.9607	321608.0
2014-04-10 09:30:00	AAPL	Stock	18.9529	18.9636	18.8354	18.8746	25180512.0
2014-04-10 10:00:00	AAPL	Stock	18.8746	19.0075	18.8536	18.9952	19560940.0
2014-04-10 10:30:00	AAPL	Stock	18.9971	19.0086	18.8989	18.9064	19094936.0
2014-04-10 11:00:00	AAPL	Stock	18.9046	18.9064	18.7964	18.7993	17727808.0
2014-04-10 11:30:00	AAPL	Stock	18.7997	18.8657	18.7961	18.825	9236472.0
2014-04-10 12:00:00	AAPL	Stock	18.8246	18.8261	18.7593	18.7857	12447876.0
2014-04-10 12:30:00	AAPL	Stock	18.7857	18.8081	18.7654	18.7654	6095656.0
2014-04-10 13:00:00	AAPL	Stock	18.7693	18.7879	18.7393	18.7557	11006184.0
2014-04-10 13:30:00	AAPL	Stock	18.7564	18.8214	18.7532	18.8143	8934492.0
2014-04-10 14:00:00	AAPL	Stock	18.8129	18.8221	18.7668	18.7671	6874812.0
2014-04-10 14:30:00	AAPL	Stock	18.7679	18.7755	18.7311	18.7511	9395596.0
2014-04-10 15:00:00	AAPL	Stock	18.7554	18.7554	18.6932	18.7011	14204456.0
2014-04-10 15:30:00	AAPL	Stock	18.7011	18.7464	18.6846	18.6957	22181768.0
2014-04-10 16:00:00	AAPL	Stock	18.6957	18.9175	18.675	18.6786	8770608.0
2014-04-10 16:30:00	AAPL	Stock	18.6793	18.8206	18.675	18.6957	788396.0
2014-04-10 17:00:00	AAPL	Stock	18.6786	18.7	18.6786	18.68	100240.0
2014-04-10 17:30:00	AAPL	Stock	18.6954	18.6954	18.6732	18.6732	43400.0
2014-04-10 18:00:00	AAPL	Stock	18.6679	18.675	18.6493	18.6686	64960.0
2014-04-10 18:30:00	AAPL	Stock	18.6454	18.6957	18.6339	18.6393	439824.0
2014-04-10 19:00:00	AAPL	Stock	18.6071	18.6339	18.6021	18.6339	102760.0
2014-04-10 19:30:00	AAPL	Stock	18.6268	18.6429	18.6204	18.6429	54684.0
2014-04-10 07:00:00	MSFT	Stock	40.52	40.52	40.5	40.5	300.0
2014-04-10 07:30:00	MSFT	Stock	40.53	40.54	40.53	40.53	1277.0
2014-04-10 08:00:00	MSFT	Stock	40.53	40.53	40.5	40.5	2200.0
2014-04-10 08:30:00	MSFT	Stock	40.51	40.55	40.5	40.55	3400.0
2014-04-10 09:00:00	MSFT	Stock	40.51	40.54	40.42	40.44	9706.0
2014-04-10 09:30:00	MSFT	Stock	40.44	40.69	40.27	40.295	3968040.0
2014-04-10 10:00:00	MSFT	Stock	40.3	40.63	40.18	40.605	3010991.0
2014-04-10 10:30:00	MSFT	Stock	40.605	40.65	40.23	40.29	2425671.0
2014-04-10 11:00:00	MSFT	Stock	40.29	40.29	39.88	39.9	2859726.0
2014-04-10 11:30:00	MSFT	Stock	39.9	40.05	39.9	39.95	1658398.0
2014-04-10 12:00:00	MSFT	Stock	39.955	40.015	39.56	39.71	3323670.0
2014-04-10 12:30:00	MSFT	Stock	39.71	39.78	39.59	39.61	1638651.0
2014-04-10 13:00:00	MSFT	Stock	39.62	39.76	39.51	39.59	2229876.0
2014-04-10 13:30:00	MSFT	Stock	39.6	39.66	39.48	39.61	2647961.0
2014-04-10 14:00:00	MSFT	Stock	39.605	39.64	39.48	39.58	2205517.0
2014-04-10 14:30:00	MSFT	Stock	39.58	39.588	39.26	39.336	3480683.0
2014-04-10 15:00:00	MSFT	Stock	39.34	39.4	39.09	39.31	5727826.0
2014-04-10 15:30:00	MSFT	Stock	39.3	39.53	39.27	39.38	6341730.0
2014-04-10 16:00:00	MSFT	Stock	39.36	40.39	39.32	39.36	2861350.0

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

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