PREVIEW / stock_5min / 2017-01-30

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-30.parquet
  size:    5.4 MB
  rows:    350,346
  symbols: 3,134

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-01-30 04:05:00	AAPL	Stock	30.2575	30.2575	30.2575	30.2575	6288.0
2017-01-30 04:10:00	AAPL	Stock	30.25	30.25	30.25	30.25	656.0
2017-01-30 04:15:00	AAPL	Stock	30.245	30.245	30.245	30.245	2100.0
2017-01-30 04:30:00	AAPL	Stock	30.25	30.2575	30.2375	30.2375	2932.0
2017-01-30 04:35:00	AAPL	Stock	30.2375	30.2375	30.2375	30.2375	532.0
2017-01-30 04:40:00	AAPL	Stock	30.2375	30.2375	30.2375	30.2375	6340.0
2017-01-30 04:45:00	AAPL	Stock	30.2325	30.2375	30.2325	30.2375	1892.0
2017-01-30 04:55:00	AAPL	Stock	30.2375	30.2375	30.2375	30.2375	2000.0
2017-01-30 05:35:00	AAPL	Stock	30.25	30.25	30.25	30.25	600.0
2017-01-30 05:45:00	AAPL	Stock	30.2575	30.2575	30.2575	30.2575	5180.0
2017-01-30 06:00:00	AAPL	Stock	30.2625	30.2625	30.2625	30.2625	4000.0
2017-01-30 06:05:00	AAPL	Stock	30.2675	30.295	30.2675	30.295	6020.0
2017-01-30 06:25:00	AAPL	Stock	30.27	30.27	30.27	30.27	1320.0
2017-01-30 06:35:00	AAPL	Stock	30.27	30.3	30.27	30.3	2748.0
2017-01-30 06:45:00	AAPL	Stock	30.27	30.27	30.2675	30.2675	1200.0
2017-01-30 07:00:00	AAPL	Stock	30.29	30.3	30.29	30.3	8104.0
2017-01-30 07:05:00	AAPL	Stock	30.2775	30.2875	30.2775	30.28	3292.0
2017-01-30 07:10:00	AAPL	Stock	30.28	30.28	30.275	30.275	2600.0
2017-01-30 07:15:00	AAPL	Stock	30.285	30.285	30.2625	30.2675	30028.0
2017-01-30 07:25:00	AAPL	Stock	30.2675	30.2875	30.2675	30.2875	1456.0
2017-01-30 07:30:00	AAPL	Stock	30.27	30.275	30.27	30.275	1904.0
2017-01-30 07:35:00	AAPL	Stock	30.275	30.275	30.275	30.275	400.0
2017-01-30 07:40:00	AAPL	Stock	30.275	30.275	30.2625	30.2625	6200.0
2017-01-30 07:45:00	AAPL	Stock	30.2625	30.2675	30.2625	30.2675	1000.0
2017-01-30 07:50:00	AAPL	Stock	30.2675	30.2825	30.2675	30.27	3560.0
2017-01-30 07:55:00	AAPL	Stock	30.2925	30.2975	30.2925	30.2975	1652.0
2017-01-30 08:00:00	AAPL	Stock	30.2775	30.425	30.25	30.2825	53520.0
2017-01-30 08:05:00	AAPL	Stock	30.28	30.305	30.28	30.305	5600.0
2017-01-30 08:10:00	AAPL	Stock	30.2875	30.2875	30.2775	30.28	19448.0
2017-01-30 08:15:00	AAPL	Stock	30.2775	30.2775	30.275	30.275	10640.0
2017-01-30 08:20:00	AAPL	Stock	30.2875	30.2875	30.265	30.265	20352.0
2017-01-30 08:25:00	AAPL	Stock	30.27	30.27	30.2275	30.23	76432.0
2017-01-30 08:30:00	AAPL	Stock	30.23	30.255	30.23	30.23	30172.0
2017-01-30 08:35:00	AAPL	Stock	30.23	30.275	30.23	30.275	15232.0
2017-01-30 08:40:00	AAPL	Stock	30.275	30.275	30.2575	30.27	2692.0
2017-01-30 08:45:00	AAPL	Stock	30.265	30.2875	30.265	30.2875	23800.0
2017-01-30 08:50:00	AAPL	Stock	30.275	30.275	30.265	30.265	12032.0
2017-01-30 08:55:00	AAPL	Stock	30.2775	30.2875	30.265	30.265	13588.0
2017-01-30 09:00:00	AAPL	Stock	30.265	30.2875	30.265	30.27	6364.0
2017-01-30 09:05:00	AAPL	Stock	30.265	30.275	30.26	30.2725	8632.0
2017-01-30 09:10:00	AAPL	Stock	30.27	30.2725	30.2638	30.27	17368.0
2017-01-30 09:15:00	AAPL	Stock	30.27	30.27	30.2625	30.27	29972.0
2017-01-30 09:20:00	AAPL	Stock	30.2625	30.2625	30.25	30.2575	26968.0
2017-01-30 09:25:00	AAPL	Stock	30.25	30.2725	30.225	30.2725	167340.0
2017-01-30 09:30:00	AAPL	Stock	30.2325	30.3022	30.165	30.2948	8165800.0
2017-01-30 09:35:00	AAPL	Stock	30.295	30.3375	30.235	30.3238	4842096.0
2017-01-30 09:40:00	AAPL	Stock	30.3225	30.34	30.2588	30.2588	3110284.0
2017-01-30 09:45:00	AAPL	Stock	30.26	30.2875	30.2275	30.2375	3181232.0
2017-01-30 09:50:00	AAPL	Stock	30.2375	30.2525	30.1825	30.246	3056376.0
2017-01-30 09:55:00	AAPL	Stock	30.2475	30.2625	30.215	30.2425	1913080.0

> showing 50 of 350,346 rows — these rows as CSV

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