PREVIEW / stock_5min / 2017-08-04

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-04.parquet
  size:    5.3 MB
  rows:    341,905
  symbols: 2,987

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-04 04:00:00	AAPL	Stock	38.925	38.9725	38.925	38.9725	2272.0
2017-08-04 06:00:00	AAPL	Stock	38.9725	38.975	38.9625	38.9625	5644.0
2017-08-04 06:25:00	AAPL	Stock	38.945	38.945	38.945	38.945	1200.0
2017-08-04 06:30:00	AAPL	Stock	38.945	38.96	38.945	38.96	2800.0
2017-08-04 06:40:00	AAPL	Stock	38.9575	38.9575	38.9575	38.9575	1600.0
2017-08-04 06:45:00	AAPL	Stock	38.955	38.955	38.955	38.955	400.0
2017-08-04 07:00:00	AAPL	Stock	38.9375	38.9375	38.93	38.93	2412.0
2017-08-04 07:05:00	AAPL	Stock	38.955	38.955	38.955	38.955	2400.0
2017-08-04 07:10:00	AAPL	Stock	38.95	38.95	38.95	38.95	2400.0
2017-08-04 07:20:00	AAPL	Stock	38.955	38.955	38.95	38.955	4820.0
2017-08-04 07:30:00	AAPL	Stock	38.9625	38.9625	38.945	38.95	8040.0
2017-08-04 07:35:00	AAPL	Stock	38.9625	38.9675	38.955	38.955	1200.0
2017-08-04 07:45:00	AAPL	Stock	38.955	38.955	38.955	38.955	1660.0
2017-08-04 07:50:00	AAPL	Stock	38.95	38.95	38.95	38.95	2152.0
2017-08-04 07:55:00	AAPL	Stock	38.95	38.955	38.95	38.955	800.0
2017-08-04 08:00:00	AAPL	Stock	38.95	38.975	38.945	38.955	14672.0
2017-08-04 08:05:00	AAPL	Stock	38.9625	38.9675	38.95	38.9675	3100.0
2017-08-04 08:10:00	AAPL	Stock	38.9625	38.965	38.9625	38.965	4000.0
2017-08-04 08:15:00	AAPL	Stock	38.965	38.965	38.955	38.955	2040.0
2017-08-04 08:20:00	AAPL	Stock	38.96	38.9675	38.95	38.9675	3820.0
2017-08-04 08:25:00	AAPL	Stock	38.9675	38.9675	38.96	38.96	2200.0
2017-08-04 08:30:00	AAPL	Stock	38.9675	39.0375	38.9675	39.0375	63036.0
2017-08-04 08:35:00	AAPL	Stock	39.0375	39.0625	39.015	39.0625	77636.0
2017-08-04 08:40:00	AAPL	Stock	39.05	39.05	38.9475	38.9975	72312.0
2017-08-04 08:45:00	AAPL	Stock	38.9825	39.0075	38.975	39.0	28056.0
2017-08-04 08:50:00	AAPL	Stock	38.9975	39.0	38.9875	38.9875	12356.0
2017-08-04 08:55:00	AAPL	Stock	38.9575	38.975	38.9525	38.9525	14000.0
2017-08-04 09:00:00	AAPL	Stock	38.955	38.975	38.9525	38.9675	29804.0
2017-08-04 09:05:00	AAPL	Stock	38.985	38.9875	38.97	38.9825	15048.0
2017-08-04 09:10:00	AAPL	Stock	38.985	39.0	38.985	39.0	18648.0
2017-08-04 09:15:00	AAPL	Stock	38.995	38.9975	38.8925	38.9975	72160.0
2017-08-04 09:20:00	AAPL	Stock	38.99	39.02	38.99	39.0	9260.0
2017-08-04 09:25:00	AAPL	Stock	39.01	39.05	39.0	39.0175	73844.0
2017-08-04 09:30:00	AAPL	Stock	39.0175	39.0375	38.9225	38.97	2917828.0
2017-08-04 09:35:00	AAPL	Stock	38.9775	39.1848	38.9448	39.175	3140188.0
2017-08-04 09:40:00	AAPL	Stock	39.18	39.3	39.12	39.2738	3263532.0
2017-08-04 09:45:00	AAPL	Stock	39.2738	39.35	39.23	39.2812	2866520.0
2017-08-04 09:50:00	AAPL	Stock	39.2825	39.3365	39.2775	39.3225	1588132.0
2017-08-04 09:55:00	AAPL	Stock	39.3212	39.33	39.165	39.1775	2048192.0
2017-08-04 10:00:00	AAPL	Stock	39.1825	39.2175	39.1175	39.1225	1874888.0
2017-08-04 10:05:00	AAPL	Stock	39.125	39.1625	39.04	39.065	1931428.0
2017-08-04 10:10:00	AAPL	Stock	39.0665	39.1375	39.0425	39.1347	1532544.0
2017-08-04 10:15:00	AAPL	Stock	39.1325	39.255	39.1075	39.255	1803968.0
2017-08-04 10:20:00	AAPL	Stock	39.255	39.2575	39.21	39.2275	796852.0
2017-08-04 10:25:00	AAPL	Stock	39.23	39.295	39.23	39.2775	916376.0
2017-08-04 10:30:00	AAPL	Stock	39.275	39.3125	39.275	39.3025	1180812.0
2017-08-04 10:35:00	AAPL	Stock	39.3025	39.3075	39.24	39.2412	1237472.0
2017-08-04 10:40:00	AAPL	Stock	39.24	39.2425	39.1575	39.1675	1334348.0
2017-08-04 10:45:00	AAPL	Stock	39.164	39.2075	39.164	39.1825	1004832.0
2017-08-04 10:50:00	AAPL	Stock	39.1805	39.21	39.0125	39.07	2639800.0

> showing 50 of 341,905 rows — these rows as CSV

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