PREVIEW / stock_5min / 2017-06-01

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-01.parquet
  size:    5.5 MB
  rows:    358,144
  symbols: 3,042

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-06-01 04:00:00	AAPL	Stock	38.25	38.25	38.25	38.25	2800.0
2017-06-01 04:10:00	AAPL	Stock	38.2875	38.3	38.2875	38.3	4400.0
2017-06-01 04:25:00	AAPL	Stock	38.3225	38.325	38.3225	38.325	2400.0
2017-06-01 04:35:00	AAPL	Stock	38.375	38.425	38.375	38.425	4400.0
2017-06-01 05:40:00	AAPL	Stock	38.35	38.35	38.35	38.35	5380.0
2017-06-01 07:00:00	AAPL	Stock	38.345	38.345	38.345	38.345	1200.0
2017-06-01 07:05:00	AAPL	Stock	38.335	38.345	38.335	38.3425	8584.0
2017-06-01 07:10:00	AAPL	Stock	38.3375	38.3375	38.3375	38.3375	800.0
2017-06-01 07:15:00	AAPL	Stock	38.325	38.325	38.3225	38.3225	1484.0
2017-06-01 07:20:00	AAPL	Stock	38.3125	38.3125	38.3125	38.3125	400.0
2017-06-01 07:45:00	AAPL	Stock	38.29	38.31	38.29	38.31	2120.0
2017-06-01 07:50:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	400.0
2017-06-01 08:00:00	AAPL	Stock	38.3225	38.3225	38.19	38.19	158928.0
2017-06-01 08:05:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	8400.0
2017-06-01 08:10:00	AAPL	Stock	38.31	38.31	38.31	38.31	9840.0
2017-06-01 08:15:00	AAPL	Stock	38.31	38.335	38.31	38.335	21416.0
2017-06-01 08:20:00	AAPL	Stock	38.335	38.3375	38.335	38.3375	8436.0
2017-06-01 08:25:00	AAPL	Stock	38.3375	38.3475	38.3375	38.3475	6232.0
2017-06-01 08:30:00	AAPL	Stock	38.3475	38.3475	38.33	38.33	2400.0
2017-06-01 08:35:00	AAPL	Stock	38.3325	38.3475	38.325	38.325	3600.0
2017-06-01 08:40:00	AAPL	Stock	38.315	38.315	38.3125	38.3125	13460.0
2017-06-01 08:45:00	AAPL	Stock	38.3125	38.3125	38.3	38.3	6008.0
2017-06-01 08:55:00	AAPL	Stock	38.3025	38.3125	38.2675	38.2675	34204.0
2017-06-01 09:00:00	AAPL	Stock	38.315	38.3175	38.315	38.315	1200.0
2017-06-01 09:05:00	AAPL	Stock	38.3075	38.3075	38.3075	38.3075	480.0
2017-06-01 09:10:00	AAPL	Stock	38.3075	38.3075	38.3	38.3025	2944.0
2017-06-01 09:15:00	AAPL	Stock	38.2925	38.2975	38.2875	38.2925	3200.0
2017-06-01 09:20:00	AAPL	Stock	38.2925	38.2975	38.2925	38.2975	5440.0
2017-06-01 09:25:00	AAPL	Stock	38.2975	38.3	38.2875	38.2925	6244.0
2017-06-01 09:30:00	AAPL	Stock	38.2925	38.3325	38.2225	38.275	2650152.0
2017-06-01 09:35:00	AAPL	Stock	38.2725	38.285	38.2225	38.2725	1131620.0
2017-06-01 09:40:00	AAPL	Stock	38.27	38.2975	38.2275	38.265	1171024.0
2017-06-01 09:45:00	AAPL	Stock	38.265	38.3025	38.2575	38.2962	784196.0
2017-06-01 09:50:00	AAPL	Stock	38.2975	38.305	38.2	38.2202	1214452.0
2017-06-01 09:55:00	AAPL	Stock	38.22	38.2325	38.19	38.21	1007356.0
2017-06-01 10:00:00	AAPL	Stock	38.21	38.25	38.1825	38.2275	1511892.0
2017-06-01 10:05:00	AAPL	Stock	38.225	38.2325	38.1575	38.1705	1079752.0
2017-06-01 10:10:00	AAPL	Stock	38.1712	38.185	38.1425	38.1625	1167060.0
2017-06-01 10:15:00	AAPL	Stock	38.16	38.1675	38.1	38.1388	1133896.0
2017-06-01 10:20:00	AAPL	Stock	38.14	38.1525	38.055	38.08	1348272.0
2017-06-01 10:25:00	AAPL	Stock	38.08	38.1062	38.0638	38.095	701920.0
2017-06-01 10:30:00	AAPL	Stock	38.095	38.1175	38.0862	38.1	688488.0
2017-06-01 10:35:00	AAPL	Stock	38.1	38.16	38.1	38.1572	722196.0
2017-06-01 10:40:00	AAPL	Stock	38.155	38.1675	38.1225	38.14	581228.0
2017-06-01 10:45:00	AAPL	Stock	38.1412	38.155	38.1225	38.1375	414200.0
2017-06-01 10:50:00	AAPL	Stock	38.14	38.16	38.1225	38.155	416708.0
2017-06-01 10:55:00	AAPL	Stock	38.1525	38.16	38.145	38.1488	530256.0
2017-06-01 11:00:00	AAPL	Stock	38.1525	38.18	38.1425	38.1675	640376.0
2017-06-01 11:05:00	AAPL	Stock	38.1675	38.205	38.165	38.1938	792424.0
2017-06-01 11:10:00	AAPL	Stock	38.195	38.23	38.1925	38.2212	578728.0

> showing 50 of 358,144 rows — these rows as CSV

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