PREVIEW / stock_5min / 2013-07-17

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-17.parquet
  size:    5.0 MB
  rows:    333,045
  symbols: 3,497

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-07-17 05:00:00	AAPL	Stock	15.335	15.335	15.335	15.335	10612.0
2013-07-17 05:05:00	AAPL	Stock	15.3225	15.3225	15.3225	15.3225	3976.0
2013-07-17 05:25:00	AAPL	Stock	15.3193	15.3193	15.3186	15.3186	14616.0
2013-07-17 05:35:00	AAPL	Stock	15.3221	15.3221	15.3221	15.3221	2800.0
2013-07-17 06:30:00	AAPL	Stock	15.3218	15.3218	15.3214	15.3214	11200.0
2013-07-17 06:35:00	AAPL	Stock	15.3221	15.3221	15.3161	15.3161	28280.0
2013-07-17 06:50:00	AAPL	Stock	15.3161	15.3161	15.3161	15.3161	27160.0
2013-07-17 07:05:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	35476.0
2013-07-17 07:10:00	AAPL	Stock	15.3229	15.3229	15.3214	15.3218	20244.0
2013-07-17 07:20:00	AAPL	Stock	15.3314	15.3329	15.3314	15.3329	6244.0
2013-07-17 07:25:00	AAPL	Stock	15.325	15.3414	15.3229	15.3414	20188.0
2013-07-17 07:30:00	AAPL	Stock	15.3329	15.3375	15.3036	15.3036	126000.0
2013-07-17 07:35:00	AAPL	Stock	15.3075	15.3075	15.2518	15.2668	289184.0
2013-07-17 07:40:00	AAPL	Stock	15.2668	15.2679	15.2593	15.2679	40656.0
2013-07-17 07:45:00	AAPL	Stock	15.2861	15.2861	15.275	15.2821	71764.0
2013-07-17 07:50:00	AAPL	Stock	15.2821	15.2857	15.2704	15.2704	107968.0
2013-07-17 07:55:00	AAPL	Stock	15.2761	15.2786	15.2761	15.2786	42000.0
2013-07-17 08:00:00	AAPL	Stock	15.2893	15.3571	15.2893	15.3125	67200.0
2013-07-17 08:05:00	AAPL	Stock	15.3214	15.3286	15.3054	15.3054	45920.0
2013-07-17 08:10:00	AAPL	Stock	15.315	15.3261	15.3136	15.3196	117516.0
2013-07-17 08:20:00	AAPL	Stock	15.3182	15.3182	15.3125	15.3125	103600.0
2013-07-17 08:25:00	AAPL	Stock	15.3161	15.3264	15.3161	15.3264	16800.0
2013-07-17 08:30:00	AAPL	Stock	15.3214	15.3354	15.3125	15.3207	199640.0
2013-07-17 08:35:00	AAPL	Stock	15.3189	15.3311	15.3179	15.3289	89600.0
2013-07-17 08:40:00	AAPL	Stock	15.3321	15.3336	15.325	15.3307	122108.0
2013-07-17 08:45:00	AAPL	Stock	15.3307	15.3336	15.3218	15.3286	151200.0
2013-07-17 08:50:00	AAPL	Stock	15.3268	15.3336	15.3232	15.3325	226800.0
2013-07-17 08:55:00	AAPL	Stock	15.3307	15.3554	15.3286	15.3375	181720.0
2013-07-17 09:00:00	AAPL	Stock	15.3446	15.3446	15.3421	15.3432	51660.0
2013-07-17 09:05:00	AAPL	Stock	15.3411	15.3571	15.34	15.3468	220080.0
2013-07-17 09:10:00	AAPL	Stock	15.3507	15.3529	15.3407	15.3507	154028.0
2013-07-17 09:15:00	AAPL	Stock	15.3425	15.3471	15.3243	15.3471	88144.0
2013-07-17 09:20:00	AAPL	Stock	15.3464	15.3518	15.3464	15.3464	211260.0
2013-07-17 09:25:00	AAPL	Stock	15.3468	15.3525	15.3186	15.35	359688.0
2013-07-17 09:30:00	AAPL	Stock	15.35	15.35	15.3129	15.3214	10432352.0
2013-07-17 09:35:00	AAPL	Stock	15.3207	15.3743	15.2936	15.3704	7835044.0
2013-07-17 09:40:00	AAPL	Stock	15.372	15.4079	15.367	15.3964	7169820.0
2013-07-17 09:45:00	AAPL	Stock	15.3918	15.4364	15.3821	15.4093	7748328.0
2013-07-17 09:50:00	AAPL	Stock	15.4129	15.4136	15.3614	15.3725	4915904.0
2013-07-17 09:55:00	AAPL	Stock	15.3771	15.3964	15.3643	15.385	2545368.0
2013-07-17 10:00:00	AAPL	Stock	15.3914	15.4146	15.3846	15.3936	3140340.0
2013-07-17 10:05:00	AAPL	Stock	15.392	15.4214	15.3861	15.4139	3668504.0
2013-07-17 10:10:00	AAPL	Stock	15.4111	15.4321	15.4071	15.4136	3750432.0
2013-07-17 10:15:00	AAPL	Stock	15.4186	15.4321	15.4054	15.4147	3709468.0
2013-07-17 10:20:00	AAPL	Stock	15.4175	15.4279	15.4146	15.4246	1411816.0
2013-07-17 10:25:00	AAPL	Stock	15.4246	15.4357	15.4068	15.4196	2492868.0
2013-07-17 10:30:00	AAPL	Stock	15.4189	15.4207	15.3893	15.4025	3271744.0
2013-07-17 10:35:00	AAPL	Stock	15.4054	15.4279	15.3929	15.3939	2370620.0
2013-07-17 10:40:00	AAPL	Stock	15.3946	15.4043	15.3757	15.3811	2885512.0
2013-07-17 10:45:00	AAPL	Stock	15.3811	15.385	15.3268	15.3618	5485900.0

> showing 50 of 333,045 rows — these rows as CSV

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