PREVIEW / stock_5min / 2018-07-25

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-25.parquet
  size:    5.5 MB
  rows:    353,789
  symbols: 2,808

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
2018-07-25 06:15:00	AAPL	Stock	48.2525	48.2525	48.2525	48.2525	536.0
2018-07-25 06:30:00	AAPL	Stock	48.2225	48.2225	48.2225	48.2225	624.0
2018-07-25 07:00:00	AAPL	Stock	48.225	48.225	48.225	48.225	1200.0
2018-07-25 07:20:00	AAPL	Stock	48.225	48.225	48.225	48.225	4000.0
2018-07-25 07:30:00	AAPL	Stock	48.2125	48.2125	48.1275	48.1275	13924.0
2018-07-25 07:35:00	AAPL	Stock	48.15	48.225	48.15	48.225	10452.0
2018-07-25 07:40:00	AAPL	Stock	48.1775	48.1775	48.1775	48.1775	1124.0
2018-07-25 08:00:00	AAPL	Stock	48.25	48.2975	48.1475	48.1875	13000.0
2018-07-25 08:05:00	AAPL	Stock	48.2125	48.2125	48.175	48.175	4800.0
2018-07-25 08:15:00	AAPL	Stock	48.1675	48.1675	48.16	48.1625	6400.0
2018-07-25 08:20:00	AAPL	Stock	48.175	48.175	48.175	48.175	400.0
2018-07-25 08:25:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	400.0
2018-07-25 08:30:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	1200.0
2018-07-25 08:35:00	AAPL	Stock	48.195	48.2	48.175	48.175	2440.0
2018-07-25 08:40:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	400.0
2018-07-25 08:45:00	AAPL	Stock	48.2	48.205	48.18	48.185	3140.0
2018-07-25 08:50:00	AAPL	Stock	48.2	48.2075	48.1875	48.2075	8000.0
2018-07-25 08:55:00	AAPL	Stock	48.19	48.2125	48.19	48.2125	2676.0
2018-07-25 09:00:00	AAPL	Stock	48.2025	48.2025	48.1925	48.1925	1600.0
2018-07-25 09:05:00	AAPL	Stock	48.2	48.2	48.19	48.19	10000.0
2018-07-25 09:10:00	AAPL	Stock	48.19	48.2275	48.19	48.2275	7440.0
2018-07-25 09:15:00	AAPL	Stock	48.2	48.2275	48.2	48.22	6208.0
2018-07-25 09:20:00	AAPL	Stock	48.22	48.225	48.22	48.225	6800.0
2018-07-25 09:25:00	AAPL	Stock	48.2275	48.2325	48.2275	48.2325	3600.0
2018-07-25 09:30:00	AAPL	Stock	48.265	48.38	48.215	48.3775	2440200.0
2018-07-25 09:35:00	AAPL	Stock	48.38	48.4125	48.275	48.2825	1366272.0
2018-07-25 09:40:00	AAPL	Stock	48.2825	48.325	48.24	48.3025	812000.0
2018-07-25 09:45:00	AAPL	Stock	48.2975	48.32	48.2575	48.275	723580.0
2018-07-25 09:50:00	AAPL	Stock	48.2775	48.375	48.2775	48.3675	753300.0
2018-07-25 09:55:00	AAPL	Stock	48.37	48.37	48.3	48.3125	567604.0
2018-07-25 10:00:00	AAPL	Stock	48.3075	48.325	48.214	48.235	813800.0
2018-07-25 10:05:00	AAPL	Stock	48.235	48.2375	48.1625	48.2125	885100.0
2018-07-25 10:10:00	AAPL	Stock	48.2125	48.245	48.1975	48.2225	519820.0
2018-07-25 10:15:00	AAPL	Stock	48.22	48.285	48.2125	48.27	483940.0
2018-07-25 10:20:00	AAPL	Stock	48.2725	48.305	48.2475	48.265	506632.0
2018-07-25 10:25:00	AAPL	Stock	48.265	48.2775	48.19	48.2275	545608.0
2018-07-25 10:30:00	AAPL	Stock	48.23	48.2975	48.2225	48.29	517104.0
2018-07-25 10:35:00	AAPL	Stock	48.2875	48.2875	48.24	48.275	320864.0
2018-07-25 10:40:00	AAPL	Stock	48.2762	48.2875	48.175	48.19	916068.0
2018-07-25 10:45:00	AAPL	Stock	48.1875	48.2325	48.1325	48.1375	493128.0
2018-07-25 10:50:00	AAPL	Stock	48.1375	48.1575	48.1075	48.155	657976.0
2018-07-25 10:55:00	AAPL	Stock	48.155	48.2075	48.1325	48.185	528712.0
2018-07-25 11:00:00	AAPL	Stock	48.1825	48.2275	48.1425	48.2275	496584.0
2018-07-25 11:05:00	AAPL	Stock	48.2275	48.2325	48.1695	48.18	400340.0
2018-07-25 11:10:00	AAPL	Stock	48.1825	48.215	48.155	48.2062	287236.0
2018-07-25 11:15:00	AAPL	Stock	48.2075	48.2475	48.2075	48.2412	463452.0
2018-07-25 11:20:00	AAPL	Stock	48.24	48.2475	48.2125	48.2325	396920.0
2018-07-25 11:25:00	AAPL	Stock	48.235	48.265	48.235	48.2625	388168.0
2018-07-25 11:30:00	AAPL	Stock	48.2625	48.3025	48.2475	48.3025	678780.0
2018-07-25 11:35:00	AAPL	Stock	48.305	48.3225	48.285	48.3088	768552.0

> showing 50 of 353,789 rows — these rows as CSV

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