PREVIEW / stock_30min / 2013-10-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-21.parquet
  size:    1.6 MB
  rows:    83,194
  symbols: 3,546

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-10-21 04:00:00	AAPL	Stock	18.2143	18.275	18.2143	18.2482	94500.0
2013-10-21 04:30:00	AAPL	Stock	18.2479	18.25	18.2479	18.25	8400.0
2013-10-21 05:00:00	AAPL	Stock	18.25	18.3164	18.25	18.3161	102116.0
2013-10-21 05:30:00	AAPL	Stock	18.3161	18.3211	18.29	18.2964	97860.0
2013-10-21 06:00:00	AAPL	Stock	18.2957	18.2957	18.2857	18.2896	43120.0
2013-10-21 06:30:00	AAPL	Stock	18.3032	18.3036	18.2821	18.2821	96040.0
2013-10-21 07:00:00	AAPL	Stock	18.2804	18.3018	18.2589	18.2921	623196.0
2013-10-21 07:30:00	AAPL	Stock	18.2896	18.3036	18.2796	18.2857	352744.0
2013-10-21 08:00:00	AAPL	Stock	18.2943	18.3354	18.2539	18.3214	1788444.0
2013-10-21 08:30:00	AAPL	Stock	18.3211	18.3393	18.2857	18.3018	1143744.0
2013-10-21 09:00:00	AAPL	Stock	18.3036	18.3196	18.2536	18.2771	1296680.0
2013-10-21 09:30:00	AAPL	Stock	18.2782	18.5946	18.2686	18.5843	97689172.0
2013-10-21 10:00:00	AAPL	Stock	18.5843	18.6175	18.5418	18.5943	46090968.0
2013-10-21 10:30:00	AAPL	Stock	18.5879	18.6107	18.5593	18.5721	20932800.0
2013-10-21 11:00:00	AAPL	Stock	18.5743	18.625	18.5454	18.6109	25618180.0
2013-10-21 11:30:00	AAPL	Stock	18.6107	18.7143	18.6071	18.705	30761164.0
2013-10-21 12:00:00	AAPL	Stock	18.705	18.7211	18.6539	18.685	20280736.0
2013-10-21 12:30:00	AAPL	Stock	18.685	18.7168	18.6796	18.7116	11656820.0
2013-10-21 13:00:00	AAPL	Stock	18.7118	18.725	18.6732	18.6964	16727732.0
2013-10-21 13:30:00	AAPL	Stock	18.6986	18.7071	18.6811	18.7043	10107776.0
2013-10-21 14:00:00	AAPL	Stock	18.7043	18.706	18.555	18.5865	24574088.0
2013-10-21 14:30:00	AAPL	Stock	18.5875	18.6364	18.5679	18.6311	14522536.0
2013-10-21 15:00:00	AAPL	Stock	18.6289	18.6775	18.5957	18.6066	16520560.0
2013-10-21 15:30:00	AAPL	Stock	18.6	18.6566	18.5636	18.6209	32209744.0
2013-10-21 16:00:00	AAPL	Stock	18.6179	18.6507	18.5857	18.6429	14389424.0
2013-10-21 16:30:00	AAPL	Stock	18.6418	18.6696	18.4867	18.6671	735896.0
2013-10-21 17:00:00	AAPL	Stock	18.6607	18.7029	18.5994	18.6629	383936.0
2013-10-21 17:30:00	AAPL	Stock	18.6679	18.6879	18.6179	18.6879	483812.0
2013-10-21 18:00:00	AAPL	Stock	18.6954	18.7464	18.2686	18.7418	605220.0
2013-10-21 18:30:00	AAPL	Stock	18.7457	18.7482	18.6179	18.7425	225176.0
2013-10-21 19:00:00	AAPL	Stock	18.7429	18.8139	18.7429	18.7768	1248940.0
2013-10-21 19:30:00	AAPL	Stock	18.7746	18.8086	18.7539	18.7946	714280.0
2013-10-21 06:30:00	MSFT	Stock	35.0	35.01	35.0	35.01	500.0
2013-10-21 07:00:00	MSFT	Stock	35.05	35.05	35.0	35.0	700.0
2013-10-21 07:30:00	MSFT	Stock	35.01	35.01	35.01	35.01	400.0
2013-10-21 08:00:00	MSFT	Stock	35.0	35.14	35.0	35.14	21333.0
2013-10-21 08:30:00	MSFT	Stock	35.14	35.14	35.08	35.08	3500.0
2013-10-21 09:00:00	MSFT	Stock	35.05	35.09	34.97	34.97	61059.0
2013-10-21 09:30:00	MSFT	Stock	34.98	35.2	34.97	35.2	6307248.0
2013-10-21 10:00:00	MSFT	Stock	35.195	35.2	35.05	35.065	2773243.0
2013-10-21 10:30:00	MSFT	Stock	35.065	35.115	34.97	35.013	2281427.0
2013-10-21 11:00:00	MSFT	Stock	35.015	35.1	35.01	35.035	1502127.0
2013-10-21 11:30:00	MSFT	Stock	35.035	35.06	34.965	35.03	1714677.0
2013-10-21 12:00:00	MSFT	Stock	35.033	35.1	35.015	35.09	807027.0
2013-10-21 12:30:00	MSFT	Stock	35.09	35.12	35.05	35.105	1087684.0
2013-10-21 13:00:00	MSFT	Stock	35.102	35.15	35.08	35.115	889957.0
2013-10-21 13:30:00	MSFT	Stock	35.115	35.14	35.07	35.095	732825.0
2013-10-21 14:00:00	MSFT	Stock	35.095	35.1	34.96	34.99	1199428.0
2013-10-21 14:30:00	MSFT	Stock	34.99	35.03	34.98	35.0	912851.0
2013-10-21 15:00:00	MSFT	Stock	35.01	35.027	34.97	34.985	1492303.0

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

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