PREVIEW / stock_5min / 2018-04-26

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-26.parquet
  size:    5.5 MB
  rows:    352,300
  symbols: 2,878

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-04-26 04:05:00	AAPL	Stock	41.125	41.125	41.125	41.125	2860.0
2018-04-26 04:15:00	AAPL	Stock	41.15	41.15	41.15	41.15	400.0
2018-04-26 04:35:00	AAPL	Stock	41.1175	41.1175	41.07	41.07	3600.0
2018-04-26 04:40:00	AAPL	Stock	41.0675	41.105	41.0675	41.105	5200.0
2018-04-26 05:00:00	AAPL	Stock	41.0375	41.0375	41.0375	41.0375	1920.0
2018-04-26 05:10:00	AAPL	Stock	41.0775	41.0775	41.0775	41.0775	800.0
2018-04-26 05:25:00	AAPL	Stock	41.1225	41.125	41.1225	41.125	1200.0
2018-04-26 06:15:00	AAPL	Stock	41.1775	41.1775	41.1775	41.1775	400.0
2018-04-26 06:20:00	AAPL	Stock	41.205	41.2225	41.205	41.2225	2204.0
2018-04-26 06:25:00	AAPL	Stock	41.1625	41.1625	41.1625	41.1625	5404.0
2018-04-26 06:45:00	AAPL	Stock	41.1125	41.1125	41.1	41.1	9496.0
2018-04-26 06:50:00	AAPL	Stock	41.1	41.1	41.1	41.1	25600.0
2018-04-26 07:00:00	AAPL	Stock	41.195	41.195	41.1	41.1	800.0
2018-04-26 07:05:00	AAPL	Stock	41.105	41.1375	41.1	41.1225	18280.0
2018-04-26 07:10:00	AAPL	Stock	41.1125	41.1125	41.0875	41.0875	8236.0
2018-04-26 07:15:00	AAPL	Stock	41.085	41.085	41.025	41.025	14472.0
2018-04-26 07:20:00	AAPL	Stock	41.075	41.075	41.025	41.0475	11464.0
2018-04-26 07:25:00	AAPL	Stock	41.0475	41.0475	41.0375	41.0375	12400.0
2018-04-26 07:30:00	AAPL	Stock	41.015	41.015	40.97	41.0	17304.0
2018-04-26 07:35:00	AAPL	Stock	40.995	40.995	40.9625	40.9625	15292.0
2018-04-26 07:40:00	AAPL	Stock	40.9875	41.0	40.9875	41.0	5080.0
2018-04-26 07:45:00	AAPL	Stock	41.0	41.005	40.99	41.0	4972.0
2018-04-26 07:55:00	AAPL	Stock	41.01	41.0125	40.9625	40.9625	9924.0
2018-04-26 08:00:00	AAPL	Stock	41.0	41.1625	40.955	40.98	53312.0
2018-04-26 08:05:00	AAPL	Stock	40.98	41.0	40.9775	41.0	19760.0
2018-04-26 08:10:00	AAPL	Stock	40.975	41.0125	40.975	40.995	28588.0
2018-04-26 08:15:00	AAPL	Stock	41.0125	41.0125	41.0	41.0125	44640.0
2018-04-26 08:20:00	AAPL	Stock	41.0125	41.0125	40.995	41.0125	14292.0
2018-04-26 08:25:00	AAPL	Stock	41.0	41.01	40.995	41.01	14400.0
2018-04-26 08:30:00	AAPL	Stock	41.005	41.045	40.9875	41.0	98088.0
2018-04-26 08:35:00	AAPL	Stock	41.0025	41.0825	41.0	41.075	42688.0
2018-04-26 08:40:00	AAPL	Stock	41.0625	41.0825	41.055	41.055	29672.0
2018-04-26 08:45:00	AAPL	Stock	41.075	41.1	41.075	41.0975	44120.0
2018-04-26 08:50:00	AAPL	Stock	41.0875	41.095	41.0775	41.0875	34764.0
2018-04-26 08:55:00	AAPL	Stock	41.0875	41.0875	41.065	41.075	12420.0
2018-04-26 09:00:00	AAPL	Stock	41.075	41.0975	41.0725	41.095	21860.0
2018-04-26 09:05:00	AAPL	Stock	41.0925	41.0975	41.065	41.09	35404.0
2018-04-26 09:10:00	AAPL	Stock	41.075	41.075	41.0425	41.05	15008.0
2018-04-26 09:15:00	AAPL	Stock	41.07	41.07	41.0425	41.0625	29252.0
2018-04-26 09:20:00	AAPL	Stock	41.07	41.07	41.0425	41.0625	8172.0
2018-04-26 09:25:00	AAPL	Stock	41.075	41.075	41.0275	41.0325	15508.0
2018-04-26 09:30:00	AAPL	Stock	41.03	41.21	40.925	41.1375	3794328.0
2018-04-26 09:35:00	AAPL	Stock	41.1375	41.225	41.1225	41.225	2430168.0
2018-04-26 09:40:00	AAPL	Stock	41.225	41.2525	41.1725	41.2375	1726360.0
2018-04-26 09:45:00	AAPL	Stock	41.2385	41.265	41.1475	41.155	1728964.0
2018-04-26 09:50:00	AAPL	Stock	41.155	41.1875	41.115	41.165	1574988.0
2018-04-26 09:55:00	AAPL	Stock	41.1675	41.2262	41.1575	41.2225	1220484.0
2018-04-26 10:00:00	AAPL	Stock	41.2212	41.2225	41.1425	41.1428	1341120.0
2018-04-26 10:05:00	AAPL	Stock	41.1475	41.2375	41.1325	41.235	1692028.0
2018-04-26 10:10:00	AAPL	Stock	41.2325	41.3425	41.23	41.3138	2139868.0

> showing 50 of 352,300 rows — these rows as CSV

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