PREVIEW / stock_30min / 2014-04-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-03.parquet
  size:    1.6 MB
  rows:    83,349
  symbols: 3,534

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-03 06:00:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	2800.0
2014-04-03 06:30:00	AAPL	Stock	19.3918	19.3918	19.3918	19.3918	2800.0
2014-04-03 07:00:00	AAPL	Stock	19.3779	19.3779	19.3779	19.3779	2800.0
2014-04-03 07:30:00	AAPL	Stock	19.3682	19.3682	19.295	19.3568	66948.0
2014-04-03 08:00:00	AAPL	Stock	19.3464	19.375	19.3214	19.3214	851956.0
2014-04-03 08:30:00	AAPL	Stock	19.3168	19.3411	19.3143	19.32	161924.0
2014-04-03 09:00:00	AAPL	Stock	19.3246	19.3482	19.3207	19.3304	239428.0
2014-04-03 09:30:00	AAPL	Stock	19.3354	19.375	19.3075	19.3668	19835284.0
2014-04-03 10:00:00	AAPL	Stock	19.3657	19.3661	19.2796	19.2904	13788544.0
2014-04-03 10:30:00	AAPL	Stock	19.2929	19.3214	19.275	19.2846	14294000.0
2014-04-03 11:00:00	AAPL	Stock	19.2814	19.3011	19.2786	19.2811	7833336.0
2014-04-03 11:30:00	AAPL	Stock	19.2818	19.2818	19.2504	19.2632	8701868.0
2014-04-03 12:00:00	AAPL	Stock	19.2625	19.2821	19.2261	19.2436	6684468.0
2014-04-03 12:30:00	AAPL	Stock	19.2418	19.2521	19.2014	19.2293	10782856.0
2014-04-03 13:00:00	AAPL	Stock	19.2286	19.2729	19.225	19.2618	6973036.0
2014-04-03 13:30:00	AAPL	Stock	19.26	19.2804	19.2571	19.2618	4277308.0
2014-04-03 14:00:00	AAPL	Stock	19.2607	19.2639	19.2279	19.2279	5741960.0
2014-04-03 14:30:00	AAPL	Stock	19.2261	19.2586	19.2123	19.2586	7751632.0
2014-04-03 15:00:00	AAPL	Stock	19.2561	19.2632	19.2325	19.2586	5322800.0
2014-04-03 15:30:00	AAPL	Stock	19.2596	19.2786	19.2411	19.2437	13206452.0
2014-04-03 16:00:00	AAPL	Stock	19.2425	19.2776	19.2414	19.2425	5097428.0
2014-04-03 16:30:00	AAPL	Stock	19.2536	19.2604	19.2386	19.2571	176820.0
2014-04-03 17:00:00	AAPL	Stock	19.2521	19.2554	19.2425	19.2425	435960.0
2014-04-03 17:30:00	AAPL	Stock	19.3777	19.4087	19.2518	19.255	24780.0
2014-04-03 18:00:00	AAPL	Stock	19.2518	19.2518	19.2425	19.2482	163156.0
2014-04-03 18:30:00	AAPL	Stock	19.2468	19.2554	19.2429	19.25	30996.0
2014-04-03 19:00:00	AAPL	Stock	19.2554	19.2554	19.2554	19.2554	2800.0
2014-04-03 19:30:00	AAPL	Stock	19.2557	19.2604	19.2504	19.2604	13160.0
2014-04-03 05:00:00	MSFT	Stock	41.31	41.31	41.31	41.31	100.0
2014-04-03 05:30:00	MSFT	Stock	41.39	41.39	41.39	41.39	100.0
2014-04-03 06:30:00	MSFT	Stock	41.35	41.35	41.35	41.35	500.0
2014-04-03 07:00:00	MSFT	Stock	41.36	41.36	41.35	41.35	600.0
2014-04-03 08:00:00	MSFT	Stock	41.38	41.4	41.29	41.39	2908.0
2014-04-03 08:30:00	MSFT	Stock	41.37	41.4	41.37	41.4	3157.0
2014-04-03 09:00:00	MSFT	Stock	41.39	41.43	41.2	41.25	29296.0
2014-04-03 09:30:00	MSFT	Stock	41.29	41.29	40.85	41.09	5129206.0
2014-04-03 10:00:00	MSFT	Stock	41.08	41.09	40.87	40.915	2072331.0
2014-04-03 10:30:00	MSFT	Stock	40.919	41.03	40.87	41.03	2238492.0
2014-04-03 11:00:00	MSFT	Stock	41.03	41.1	40.99	41.04	1172130.0
2014-04-03 11:30:00	MSFT	Stock	41.05	41.06	40.86	40.895	1435875.0
2014-04-03 12:00:00	MSFT	Stock	40.895	40.91	40.76	40.79	1126294.0
2014-04-03 12:30:00	MSFT	Stock	40.79	40.83	40.71	40.8	1108227.0
2014-04-03 13:00:00	MSFT	Stock	40.79	40.98	40.79	40.97	1540047.0
2014-04-03 13:30:00	MSFT	Stock	40.966	41.04	40.93	40.99	1180947.0
2014-04-03 14:00:00	MSFT	Stock	40.995	41.01	40.95	40.973	894699.0
2014-04-03 14:30:00	MSFT	Stock	40.975	40.98	40.845	40.939	1445463.0
2014-04-03 15:00:00	MSFT	Stock	40.945	40.99	40.91	40.97	1411811.0
2014-04-03 15:30:00	MSFT	Stock	40.975	41.03	40.935	41.01	4591020.0
2014-04-03 16:00:00	MSFT	Stock	41.0	41.02	40.966	40.99	1006424.0
2014-04-03 16:30:00	MSFT	Stock	40.99	41.01	40.95	40.99	10461.0

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

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