PREVIEW / stock_30min / 2011-08-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-26.parquet
  size:    1.4 MB
  rows:    74,313
  symbols: 3,499

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
2011-08-26 04:30:00	AAPL	Stock	13.3882	13.3882	13.3882	13.3882	2800.0
2011-08-26 05:30:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	5600.0
2011-08-26 06:00:00	AAPL	Stock	13.3321	13.3321	13.3286	13.3286	9100.0
2011-08-26 06:30:00	AAPL	Stock	13.3286	13.3557	13.3214	13.3539	92960.0
2011-08-26 07:00:00	AAPL	Stock	13.3571	13.3746	13.2782	13.3114	289184.0
2011-08-26 07:30:00	AAPL	Stock	13.3043	13.3071	13.275	13.2975	154224.0
2011-08-26 08:00:00	AAPL	Stock	13.3154	13.3175	13.2746	13.2993	698012.0
2011-08-26 08:30:00	AAPL	Stock	13.2864	13.3214	13.2321	13.2568	1570156.0
2011-08-26 09:00:00	AAPL	Stock	13.2571	13.3	13.2507	13.2679	1625176.0
2011-08-26 09:30:00	AAPL	Stock	13.2561	13.3689	13.2429	13.2943	49927108.0
2011-08-26 10:00:00	AAPL	Stock	13.2968	13.535	13.2507	13.4904	101306436.0
2011-08-26 10:30:00	AAPL	Stock	13.4904	13.5714	13.4379	13.5254	79171512.0
2011-08-26 11:00:00	AAPL	Stock	13.525	13.655	13.5071	13.5887	68368104.0
2011-08-26 11:30:00	AAPL	Stock	13.5907	13.6318	13.5786	13.6162	34991404.0
2011-08-26 12:00:00	AAPL	Stock	13.6168	13.6589	13.6157	13.6564	35544320.0
2011-08-26 12:30:00	AAPL	Stock	13.6561	13.6571	13.6232	13.6339	23695504.0
2011-08-26 13:00:00	AAPL	Stock	13.6368	13.6493	13.6104	13.6411	21056140.0
2011-08-26 13:30:00	AAPL	Stock	13.6407	13.6868	13.6361	13.6655	34909756.0
2011-08-26 14:00:00	AAPL	Stock	13.6685	13.6821	13.65	13.6525	26145532.0
2011-08-26 14:30:00	AAPL	Stock	13.6516	13.7025	13.6429	13.7012	28893284.0
2011-08-26 15:00:00	AAPL	Stock	13.7011	13.7036	13.6125	13.6529	40810504.0
2011-08-26 15:30:00	AAPL	Stock	13.6529	13.7071	13.6454	13.7043	57979936.0
2011-08-26 16:00:00	AAPL	Stock	13.6989	13.7325	13.5544	13.6954	24553760.0
2011-08-26 16:30:00	AAPL	Stock	13.6932	13.6968	13.6793	13.6854	472472.0
2011-08-26 17:00:00	AAPL	Stock	13.6875	13.6993	13.6846	13.6864	754824.0
2011-08-26 17:30:00	AAPL	Stock	13.6893	13.6921	13.6786	13.6886	220248.0
2011-08-26 18:00:00	AAPL	Stock	13.6857	13.6993	13.6786	13.6839	154420.0
2011-08-26 18:30:00	AAPL	Stock	13.685	13.6979	13.6814	13.6918	155288.0
2011-08-26 19:00:00	AAPL	Stock	13.6964	13.6993	13.6804	13.6907	133952.0
2011-08-26 19:30:00	AAPL	Stock	13.6911	13.6964	13.6843	13.6843	168168.0
2011-08-26 07:30:00	MSFT	Stock	24.55	24.55	24.55	24.55	300.0
2011-08-26 08:00:00	MSFT	Stock	24.5	24.59	24.5	24.59	3438.0
2011-08-26 08:30:00	MSFT	Stock	24.52	24.52	24.45	24.45	8456.0
2011-08-26 09:00:00	MSFT	Stock	24.45	24.49	24.3	24.49	57011.0
2011-08-26 09:30:00	MSFT	Stock	24.51	24.73	24.47	24.64	4658004.0
2011-08-26 10:00:00	MSFT	Stock	24.65	24.94	24.42	24.79	7131393.0
2011-08-26 10:30:00	MSFT	Stock	24.79	25.09	24.66	24.9	4467741.0
2011-08-26 11:00:00	MSFT	Stock	24.905	25.18	24.87	25.11	4462087.0
2011-08-26 11:30:00	MSFT	Stock	25.11	25.22	25.105	25.175	4308061.0
2011-08-26 12:00:00	MSFT	Stock	25.18	25.34	25.171	25.32	3035110.0
2011-08-26 12:30:00	MSFT	Stock	25.32	25.33	25.19	25.221	2389832.0
2011-08-26 13:00:00	MSFT	Stock	25.23	25.29	25.19	25.285	2057327.0
2011-08-26 13:30:00	MSFT	Stock	25.28	25.32	25.24	25.32	2026883.0
2011-08-26 14:00:00	MSFT	Stock	25.32	25.335	25.23	25.24	2496020.0
2011-08-26 14:30:00	MSFT	Stock	25.24	25.32	25.2	25.28	2279432.0
2011-08-26 15:00:00	MSFT	Stock	25.28	25.29	25.14	25.21	3137549.0
2011-08-26 15:30:00	MSFT	Stock	25.21	25.28	25.19	25.24	9676481.0
2011-08-26 16:00:00	MSFT	Stock	25.25	25.34	25.02	25.02	17299822.0
2011-08-26 16:30:00	MSFT	Stock	25.32	25.32	25.082	25.082	1730400.0
2011-08-26 17:00:00	MSFT	Stock	25.32	25.32	25.25	25.25	212450.0

> showing 50 of 74,313 rows — these rows as CSV

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