PREVIEW / stock_5min / 2017-08-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-03.parquet
  size:    5.3 MB
  rows:    345,767
  symbols: 2,988

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-08-03 04:00:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	736.0
2017-08-03 04:05:00	AAPL	Stock	39.265	39.265	39.265	39.265	800.0
2017-08-03 04:35:00	AAPL	Stock	39.285	39.285	39.285	39.285	2000.0
2017-08-03 05:00:00	AAPL	Stock	39.285	39.285	39.285	39.285	496.0
2017-08-03 05:05:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	1200.0
2017-08-03 05:20:00	AAPL	Stock	39.37	39.37	39.37	39.37	800.0
2017-08-03 05:35:00	AAPL	Stock	39.35	39.35	39.35	39.35	3600.0
2017-08-03 05:45:00	AAPL	Stock	39.35	39.35	39.35	39.35	400.0
2017-08-03 05:55:00	AAPL	Stock	39.3375	39.35	39.3375	39.35	4052.0
2017-08-03 06:05:00	AAPL	Stock	39.35	39.35	39.3475	39.35	2800.0
2017-08-03 06:10:00	AAPL	Stock	39.35	39.35	39.35	39.35	1200.0
2017-08-03 06:25:00	AAPL	Stock	39.325	39.325	39.325	39.325	8340.0
2017-08-03 06:30:00	AAPL	Stock	39.325	39.325	39.3	39.3	5148.0
2017-08-03 06:35:00	AAPL	Stock	39.32	39.32	39.32	39.32	400.0
2017-08-03 06:40:00	AAPL	Stock	39.305	39.3175	39.305	39.3175	4264.0
2017-08-03 06:45:00	AAPL	Stock	39.32	39.32	39.29	39.29	2800.0
2017-08-03 06:50:00	AAPL	Stock	39.2925	39.325	39.2925	39.325	8020.0
2017-08-03 07:00:00	AAPL	Stock	39.3	39.35	39.29	39.325	13788.0
2017-08-03 07:05:00	AAPL	Stock	39.3	39.3	39.2625	39.2625	12404.0
2017-08-03 07:10:00	AAPL	Stock	39.255	39.2725	39.25	39.255	7740.0
2017-08-03 07:15:00	AAPL	Stock	39.255	39.255	39.255	39.255	1600.0
2017-08-03 07:20:00	AAPL	Stock	39.255	39.255	39.255	39.255	400.0
2017-08-03 07:25:00	AAPL	Stock	39.2725	39.295	39.2725	39.275	12356.0
2017-08-03 07:30:00	AAPL	Stock	39.275	39.275	39.26	39.26	2248.0
2017-08-03 07:35:00	AAPL	Stock	39.275	39.28	39.26	39.28	2060.0
2017-08-03 07:45:00	AAPL	Stock	39.2675	39.2675	39.2675	39.2675	4528.0
2017-08-03 07:50:00	AAPL	Stock	39.265	39.265	39.265	39.265	400.0
2017-08-03 07:55:00	AAPL	Stock	39.2625	39.275	39.2575	39.27	20656.0
2017-08-03 08:00:00	AAPL	Stock	39.2875	39.2875	39.2625	39.2625	20324.0
2017-08-03 08:05:00	AAPL	Stock	39.2625	39.2625	39.255	39.2575	6364.0
2017-08-03 08:10:00	AAPL	Stock	39.255	39.255	39.2225	39.2225	36756.0
2017-08-03 08:15:00	AAPL	Stock	39.2175	39.225	39.2	39.2175	28988.0
2017-08-03 08:20:00	AAPL	Stock	39.2125	39.2325	39.2025	39.225	34628.0
2017-08-03 08:25:00	AAPL	Stock	39.225	39.225	39.19	39.2	28600.0
2017-08-03 08:30:00	AAPL	Stock	39.22	39.2225	39.2025	39.2025	4584.0
2017-08-03 08:35:00	AAPL	Stock	39.2125	39.2275	39.2125	39.225	25800.0
2017-08-03 08:40:00	AAPL	Stock	39.225	39.2275	39.215	39.2275	13120.0
2017-08-03 08:45:00	AAPL	Stock	39.2275	39.2275	39.2075	39.2075	22152.0
2017-08-03 08:50:00	AAPL	Stock	39.2125	39.225	39.2125	39.225	3800.0
2017-08-03 08:55:00	AAPL	Stock	39.22	39.2275	39.2	39.2	66408.0
2017-08-03 09:00:00	AAPL	Stock	39.225	39.225	39.19	39.19	25160.0
2017-08-03 09:05:00	AAPL	Stock	39.2	39.2175	39.2	39.2025	25012.0
2017-08-03 09:10:00	AAPL	Stock	39.2175	39.235	39.2	39.2025	24540.0
2017-08-03 09:15:00	AAPL	Stock	39.205	39.2125	39.2	39.2	10224.0
2017-08-03 09:20:00	AAPL	Stock	39.19	39.2125	39.15	39.2125	67676.0
2017-08-03 09:25:00	AAPL	Stock	39.1875	39.2725	39.1875	39.26	72412.0
2017-08-03 09:30:00	AAPL	Stock	39.2625	39.3025	39.1575	39.1987	4843060.0
2017-08-03 09:35:00	AAPL	Stock	39.2025	39.2325	39.1025	39.175	2998884.0
2017-08-03 09:40:00	AAPL	Stock	39.1735	39.1975	39.1238	39.165	2409180.0
2017-08-03 09:45:00	AAPL	Stock	39.16	39.1625	39.0725	39.0988	2528796.0

> showing 50 of 345,767 rows — these rows as CSV

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