PREVIEW / stock_5min / 2014-08-14

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-08-14.parquet
  size:    5.2 MB
  rows:    348,438
  symbols: 3,580

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-08-14 04:15:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1900.0
2014-08-14 04:35:00	AAPL	Stock	24.335	24.3375	24.335	24.3375	10160.0
2014-08-14 05:00:00	AAPL	Stock	24.33	24.3425	24.33	24.3425	2320.0
2014-08-14 05:15:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	400.0
2014-08-14 05:25:00	AAPL	Stock	24.33	24.33	24.33	24.33	6968.0
2014-08-14 05:30:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	400.0
2014-08-14 05:35:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	1200.0
2014-08-14 05:50:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	800.0
2014-08-14 06:00:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	896.0
2014-08-14 06:05:00	AAPL	Stock	24.3425	24.3425	24.32	24.32	2184.0
2014-08-14 06:15:00	AAPL	Stock	24.3325	24.3325	24.3325	24.3325	1200.0
2014-08-14 06:20:00	AAPL	Stock	24.3375	24.3425	24.3375	24.3425	5280.0
2014-08-14 06:25:00	AAPL	Stock	24.355	24.3725	24.355	24.3725	2516.0
2014-08-14 06:50:00	AAPL	Stock	24.355	24.355	24.355	24.355	400.0
2014-08-14 07:00:00	AAPL	Stock	24.3575	24.365	24.3575	24.365	2100.0
2014-08-14 07:05:00	AAPL	Stock	24.37	24.37	24.37	24.37	1852.0
2014-08-14 07:10:00	AAPL	Stock	24.37	24.37	24.35	24.35	2420.0
2014-08-14 07:15:00	AAPL	Stock	24.35	24.3525	24.35	24.35	2400.0
2014-08-14 07:20:00	AAPL	Stock	24.35	24.35	24.35	24.35	400.0
2014-08-14 07:25:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	400.0
2014-08-14 07:30:00	AAPL	Stock	24.345	24.345	24.345	24.345	1600.0
2014-08-14 07:40:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	800.0
2014-08-14 07:50:00	AAPL	Stock	24.3375	24.35	24.32	24.32	25416.0
2014-08-14 07:55:00	AAPL	Stock	24.33	24.3375	24.3275	24.3275	13108.0
2014-08-14 08:00:00	AAPL	Stock	24.3325	24.37	24.31	24.3375	72496.0
2014-08-14 08:05:00	AAPL	Stock	24.345	24.355	24.3375	24.355	93484.0
2014-08-14 08:10:00	AAPL	Stock	24.3575	24.3675	24.3575	24.365	48468.0
2014-08-14 08:15:00	AAPL	Stock	24.3675	24.37	24.35	24.35	58644.0
2014-08-14 08:20:00	AAPL	Stock	24.35	24.3575	24.345	24.3575	21452.0
2014-08-14 08:25:00	AAPL	Stock	24.3575	24.3575	24.345	24.345	30000.0
2014-08-14 08:30:00	AAPL	Stock	24.3425	24.3425	24.3275	24.3325	64800.0
2014-08-14 08:35:00	AAPL	Stock	24.3325	24.3325	24.305	24.3175	46152.0
2014-08-14 08:40:00	AAPL	Stock	24.3125	24.3225	24.31	24.3125	72356.0
2014-08-14 08:45:00	AAPL	Stock	24.315	24.3175	24.295	24.3	147528.0
2014-08-14 08:50:00	AAPL	Stock	24.31	24.31	24.305	24.305	13560.0
2014-08-14 08:55:00	AAPL	Stock	24.3	24.3075	24.3	24.3	20800.0
2014-08-14 09:00:00	AAPL	Stock	24.2975	24.31	24.29	24.3	46268.0
2014-08-14 09:05:00	AAPL	Stock	24.2925	24.3075	24.2925	24.3075	16836.0
2014-08-14 09:10:00	AAPL	Stock	24.3075	24.32	24.3075	24.3125	83704.0
2014-08-14 09:15:00	AAPL	Stock	24.3125	24.32	24.305	24.31	13144.0
2014-08-14 09:20:00	AAPL	Stock	24.31	24.31	24.31	24.31	6400.0
2014-08-14 09:25:00	AAPL	Stock	24.3075	24.35	24.2975	24.33	300204.0
2014-08-14 09:30:00	AAPL	Stock	24.325	24.3625	24.3025	24.3275	5909372.0
2014-08-14 09:35:00	AAPL	Stock	24.3275	24.36	24.3125	24.3148	3015460.0
2014-08-14 09:40:00	AAPL	Stock	24.3125	24.325	24.2775	24.3038	3384796.0
2014-08-14 09:45:00	AAPL	Stock	24.3025	24.3075	24.23	24.2425	3051900.0
2014-08-14 09:50:00	AAPL	Stock	24.2438	24.245	24.2	24.2248	3043500.0
2014-08-14 09:55:00	AAPL	Stock	24.2235	24.2975	24.2228	24.2775	2939492.0
2014-08-14 10:00:00	AAPL	Stock	24.28	24.3025	24.25	24.2998	2212316.0
2014-08-14 10:05:00	AAPL	Stock	24.2975	24.33	24.2725	24.2825	2409180.0

> showing 50 of 348,438 rows — these rows as CSV

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