PREVIEW / stock_5min / 2017-02-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-28.parquet
  size:    5.5 MB
  rows:    361,516
  symbols: 3,103

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
2017-02-28 04:00:00	AAPL	Stock	34.2675	34.2675	34.21	34.21	2000.0
2017-02-28 05:10:00	AAPL	Stock	34.2875	34.2875	34.2875	34.2875	400.0
2017-02-28 05:15:00	AAPL	Stock	34.3	34.325	34.2875	34.3125	21336.0
2017-02-28 05:20:00	AAPL	Stock	34.285	34.285	34.285	34.285	8000.0
2017-02-28 05:55:00	AAPL	Stock	34.3125	34.3175	34.3125	34.3175	3596.0
2017-02-28 06:00:00	AAPL	Stock	34.3175	34.325	34.3175	34.325	8916.0
2017-02-28 06:05:00	AAPL	Stock	34.325	34.325	34.325	34.325	4000.0
2017-02-28 06:40:00	AAPL	Stock	34.3	34.3	34.2875	34.2875	4740.0
2017-02-28 06:45:00	AAPL	Stock	34.3	34.3075	34.3	34.3075	1200.0
2017-02-28 07:00:00	AAPL	Stock	34.3	34.3	34.285	34.2875	17992.0
2017-02-28 07:05:00	AAPL	Stock	34.285	34.295	34.285	34.295	3332.0
2017-02-28 07:10:00	AAPL	Stock	34.3	34.3	34.285	34.2875	18712.0
2017-02-28 07:20:00	AAPL	Stock	34.285	34.285	34.285	34.285	400.0
2017-02-28 07:25:00	AAPL	Stock	34.29	34.29	34.29	34.29	400.0
2017-02-28 07:30:00	AAPL	Stock	34.29	34.2975	34.2875	34.2975	7952.0
2017-02-28 07:35:00	AAPL	Stock	34.3	34.3	34.2975	34.3	9864.0
2017-02-28 07:40:00	AAPL	Stock	34.3025	34.3025	34.275	34.275	10100.0
2017-02-28 07:50:00	AAPL	Stock	34.2975	34.2975	34.2975	34.2975	400.0
2017-02-28 08:00:00	AAPL	Stock	34.305	34.3075	34.2775	34.28	96200.0
2017-02-28 08:05:00	AAPL	Stock	34.2875	34.3075	34.2825	34.2825	54024.0
2017-02-28 08:10:00	AAPL	Stock	34.2925	34.2925	34.2925	34.2925	12520.0
2017-02-28 08:15:00	AAPL	Stock	34.28	34.28	34.2375	34.25	52732.0
2017-02-28 08:20:00	AAPL	Stock	34.25	34.275	34.25	34.2525	42844.0
2017-02-28 08:25:00	AAPL	Stock	34.2725	34.2725	34.2725	34.2725	1800.0
2017-02-28 08:35:00	AAPL	Stock	34.265	34.265	34.2525	34.2625	6440.0
2017-02-28 08:40:00	AAPL	Stock	34.2625	34.2625	34.25	34.2525	27800.0
2017-02-28 08:45:00	AAPL	Stock	34.2625	34.2625	34.2475	34.25	2832.0
2017-02-28 08:50:00	AAPL	Stock	34.2575	34.26	34.2375	34.245	32020.0
2017-02-28 08:55:00	AAPL	Stock	34.245	34.25	34.24	34.25	93600.0
2017-02-28 09:00:00	AAPL	Stock	34.24	34.2475	34.2375	34.2375	15888.0
2017-02-28 09:05:00	AAPL	Stock	34.2375	34.2725	34.2375	34.255	17680.0
2017-02-28 09:10:00	AAPL	Stock	34.2525	34.27	34.25	34.25	8568.0
2017-02-28 09:15:00	AAPL	Stock	34.2675	34.27	34.2625	34.27	26892.0
2017-02-28 09:20:00	AAPL	Stock	34.2675	34.2975	34.2675	34.29	37624.0
2017-02-28 09:25:00	AAPL	Stock	34.2825	34.3	34.27	34.2725	124956.0
2017-02-28 09:30:00	AAPL	Stock	34.275	34.35	34.235	34.315	4095020.0
2017-02-28 09:35:00	AAPL	Stock	34.3125	34.3525	34.3	34.316	1768676.0
2017-02-28 09:40:00	AAPL	Stock	34.3175	34.3248	34.24	34.2552	1811236.0
2017-02-28 09:45:00	AAPL	Stock	34.255	34.2775	34.22	34.2422	1581384.0
2017-02-28 09:50:00	AAPL	Stock	34.2425	34.25	34.2075	34.22	1378980.0
2017-02-28 09:55:00	AAPL	Stock	34.2122	34.245	34.2122	34.2375	933500.0
2017-02-28 10:00:00	AAPL	Stock	34.2375	34.3025	34.225	34.2925	1351016.0
2017-02-28 10:05:00	AAPL	Stock	34.29	34.3125	34.275	34.2832	835824.0
2017-02-28 10:10:00	AAPL	Stock	34.285	34.32	34.285	34.3175	992068.0
2017-02-28 10:15:00	AAPL	Stock	34.3175	34.3422	34.305	34.3355	907564.0
2017-02-28 10:20:00	AAPL	Stock	34.336	34.345	34.2975	34.3175	971984.0
2017-02-28 10:25:00	AAPL	Stock	34.3152	34.3375	34.3152	34.3225	792116.0
2017-02-28 10:30:00	AAPL	Stock	34.325	34.3575	34.325	34.3362	1439096.0
2017-02-28 10:35:00	AAPL	Stock	34.3362	34.3588	34.3125	34.3225	828964.0
2017-02-28 10:40:00	AAPL	Stock	34.32	34.3288	34.2975	34.3075	631728.0

> showing 50 of 361,516 rows — these rows as CSV

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