PREVIEW / stock_5min / 2013-03-20

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-03-20.parquet
  size:    4.9 MB
  rows:    325,445
  symbols: 3,458

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-03-20 04:25:00	AAPL	Stock	16.3036	16.3036	16.3036	16.3036	5600.0
2013-03-20 05:10:00	AAPL	Stock	16.31	16.31	16.31	16.31	2800.0
2013-03-20 05:35:00	AAPL	Stock	16.3107	16.3107	16.3107	16.3107	2800.0
2013-03-20 05:45:00	AAPL	Stock	16.3107	16.3107	16.3107	16.3107	9240.0
2013-03-20 06:00:00	AAPL	Stock	16.3143	16.3143	16.3143	16.3143	15260.0
2013-03-20 06:05:00	AAPL	Stock	16.3286	16.3286	16.3286	16.3286	2800.0
2013-03-20 06:45:00	AAPL	Stock	16.3018	16.3018	16.3018	16.3018	2800.0
2013-03-20 06:50:00	AAPL	Stock	16.3018	16.3036	16.3018	16.3036	5600.0
2013-03-20 06:55:00	AAPL	Stock	16.3211	16.3214	16.3125	16.3125	15484.0
2013-03-20 07:00:00	AAPL	Stock	16.3179	16.3179	16.2857	16.3036	107828.0
2013-03-20 07:05:00	AAPL	Stock	16.3157	16.3157	16.2882	16.2882	5600.0
2013-03-20 07:10:00	AAPL	Stock	16.3036	16.3093	16.3	16.3036	22848.0
2013-03-20 07:15:00	AAPL	Stock	16.3032	16.3064	16.2964	16.2964	41244.0
2013-03-20 07:20:00	AAPL	Stock	16.3036	16.3039	16.3032	16.3032	30128.0
2013-03-20 07:25:00	AAPL	Stock	16.31	16.31	16.31	16.31	2800.0
2013-03-20 07:30:00	AAPL	Stock	16.3036	16.3036	16.2721	16.2857	106372.0
2013-03-20 07:35:00	AAPL	Stock	16.2786	16.2857	16.2786	16.2857	43400.0
2013-03-20 07:40:00	AAPL	Stock	16.2843	16.2843	16.2839	16.2839	30800.0
2013-03-20 07:45:00	AAPL	Stock	16.2821	16.2857	16.2821	16.2857	11200.0
2013-03-20 07:50:00	AAPL	Stock	16.2911	16.2911	16.2857	16.2857	10500.0
2013-03-20 07:55:00	AAPL	Stock	16.2857	16.2857	16.2821	16.2839	17360.0
2013-03-20 08:00:00	AAPL	Stock	16.3118	16.3143	16.2732	16.3	268100.0
2013-03-20 08:05:00	AAPL	Stock	16.2964	16.3104	16.2857	16.2968	406000.0
2013-03-20 08:10:00	AAPL	Stock	16.3054	16.3107	16.2946	16.3075	239036.0
2013-03-20 08:15:00	AAPL	Stock	16.3089	16.3132	16.3036	16.3104	186200.0
2013-03-20 08:20:00	AAPL	Stock	16.31	16.3214	16.3036	16.3214	209832.0
2013-03-20 08:25:00	AAPL	Stock	16.325	16.3286	16.3036	16.305	180628.0
2013-03-20 08:30:00	AAPL	Stock	16.3	16.3036	16.2943	16.2975	128324.0
2013-03-20 08:35:00	AAPL	Stock	16.2979	16.3036	16.2979	16.3	105504.0
2013-03-20 08:40:00	AAPL	Stock	16.2982	16.3025	16.2979	16.3025	88200.0
2013-03-20 08:45:00	AAPL	Stock	16.3021	16.3043	16.2896	16.29	200060.0
2013-03-20 08:50:00	AAPL	Stock	16.2893	16.3018	16.2318	16.3018	197120.0
2013-03-20 08:55:00	AAPL	Stock	16.3018	16.3121	16.3018	16.3043	151760.0
2013-03-20 09:00:00	AAPL	Stock	16.3036	16.3118	16.3036	16.305	79912.0
2013-03-20 09:05:00	AAPL	Stock	16.3107	16.3107	16.3036	16.3036	35140.0
2013-03-20 09:10:00	AAPL	Stock	16.3036	16.3114	16.2996	16.3079	213360.0
2013-03-20 09:15:00	AAPL	Stock	16.3114	16.3189	16.3061	16.3118	173264.0
2013-03-20 09:20:00	AAPL	Stock	16.31	16.3193	16.3071	16.3146	96180.0
2013-03-20 09:25:00	AAPL	Stock	16.3129	16.3514	16.3129	16.3439	852936.0
2013-03-20 09:30:00	AAPL	Stock	16.3393	16.3439	16.2582	16.2648	14820512.0
2013-03-20 09:35:00	AAPL	Stock	16.2639	16.2904	16.2225	16.2346	10560956.0
2013-03-20 09:40:00	AAPL	Stock	16.2286	16.2346	16.1532	16.1946	11989600.0
2013-03-20 09:45:00	AAPL	Stock	16.1939	16.2286	16.1257	16.1421	9082248.0
2013-03-20 09:50:00	AAPL	Stock	16.1393	16.1453	16.1011	16.1194	11611348.0
2013-03-20 09:55:00	AAPL	Stock	16.1193	16.1496	16.084	16.0846	9356816.0
2013-03-20 10:00:00	AAPL	Stock	16.0851	16.1304	16.0849	16.1268	7210252.0
2013-03-20 10:05:00	AAPL	Stock	16.1271	16.1425	16.0954	16.14	7751156.0
2013-03-20 10:10:00	AAPL	Stock	16.1411	16.1607	16.1296	16.1382	6169100.0
2013-03-20 10:15:00	AAPL	Stock	16.1382	16.1425	16.1168	16.1232	4598468.0
2013-03-20 10:20:00	AAPL	Stock	16.125	16.1325	16.0921	16.1077	5104232.0

> showing 50 of 325,445 rows — these rows as CSV

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