PREVIEW / stock_5min / 2017-09-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-13.parquet
  size:    5.4 MB
  rows:    354,517
  symbols: 2,965

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-09-13 04:00:00	AAPL	Stock	40.1025	40.125	40.0625	40.07	3100.0
2017-09-13 04:05:00	AAPL	Stock	40.0725	40.0725	40.025	40.025	2756.0
2017-09-13 04:10:00	AAPL	Stock	40.05	40.0725	40.0475	40.0725	2248.0
2017-09-13 04:15:00	AAPL	Stock	40.0725	40.1175	40.0725	40.1125	7732.0
2017-09-13 04:20:00	AAPL	Stock	40.15	40.15	40.125	40.125	12436.0
2017-09-13 04:25:00	AAPL	Stock	40.125	40.125	40.125	40.125	400.0
2017-09-13 04:30:00	AAPL	Stock	40.15	40.15	40.125	40.1325	2344.0
2017-09-13 04:35:00	AAPL	Stock	40.15	40.15	40.125	40.125	12928.0
2017-09-13 04:45:00	AAPL	Stock	40.025	40.075	40.025	40.075	5900.0
2017-09-13 04:50:00	AAPL	Stock	40.05	40.05	40.045	40.045	3252.0
2017-09-13 05:00:00	AAPL	Stock	40.045	40.045	40.045	40.045	640.0
2017-09-13 05:05:00	AAPL	Stock	40.0875	40.1	40.0875	40.1	5724.0
2017-09-13 05:10:00	AAPL	Stock	40.12	40.125	40.1	40.1	11688.0
2017-09-13 05:15:00	AAPL	Stock	40.1	40.1	40.1	40.1	2396.0
2017-09-13 05:20:00	AAPL	Stock	40.07	40.07	40.07	40.07	3196.0
2017-09-13 05:25:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	800.0
2017-09-13 05:35:00	AAPL	Stock	40.07	40.07	40.0625	40.0625	3352.0
2017-09-13 05:40:00	AAPL	Stock	40.0625	40.0625	40.05	40.05	2656.0
2017-09-13 05:45:00	AAPL	Stock	40.04	40.04	40.04	40.04	400.0
2017-09-13 05:50:00	AAPL	Stock	40.03	40.03	40.0	40.0	10000.0
2017-09-13 05:55:00	AAPL	Stock	39.9975	40.0025	39.975	39.975	10824.0
2017-09-13 06:05:00	AAPL	Stock	39.9975	39.9975	39.97	39.97	2400.0
2017-09-13 06:10:00	AAPL	Stock	39.95	39.95	39.925	39.9375	24436.0
2017-09-13 06:15:00	AAPL	Stock	39.935	39.95	39.935	39.95	25368.0
2017-09-13 06:20:00	AAPL	Stock	39.97	39.98	39.97	39.98	800.0
2017-09-13 06:25:00	AAPL	Stock	39.98	39.98	39.98	39.98	4200.0
2017-09-13 06:30:00	AAPL	Stock	39.97	39.97	39.925	39.925	12892.0
2017-09-13 06:35:00	AAPL	Stock	39.9475	39.9925	39.9475	39.9925	18820.0
2017-09-13 06:40:00	AAPL	Stock	39.975	39.9825	39.975	39.975	1600.0
2017-09-13 06:45:00	AAPL	Stock	39.9575	39.9575	39.9575	39.9575	800.0
2017-09-13 06:50:00	AAPL	Stock	39.975	39.975	39.96	39.96	3300.0
2017-09-13 06:55:00	AAPL	Stock	39.945	39.945	39.925	39.925	21920.0
2017-09-13 07:00:00	AAPL	Stock	39.925	39.965	39.925	39.94	28968.0
2017-09-13 07:05:00	AAPL	Stock	39.94	39.9825	39.94	39.9825	27800.0
2017-09-13 07:10:00	AAPL	Stock	39.975	40.0075	39.975	39.99	20988.0
2017-09-13 07:15:00	AAPL	Stock	40.0075	40.0075	39.975	39.9775	21704.0
2017-09-13 07:20:00	AAPL	Stock	39.9975	40.0525	39.9975	40.0375	41552.0
2017-09-13 07:25:00	AAPL	Stock	40.0275	40.0275	39.95	39.9575	58044.0
2017-09-13 07:30:00	AAPL	Stock	39.945	39.9775	39.935	39.975	37352.0
2017-09-13 07:35:00	AAPL	Stock	39.9825	39.995	39.975	39.995	25624.0
2017-09-13 07:40:00	AAPL	Stock	39.99	40.0075	39.97	39.9775	21224.0
2017-09-13 07:45:00	AAPL	Stock	39.9875	40.0075	39.9875	39.99	12144.0
2017-09-13 07:50:00	AAPL	Stock	39.9975	40.0125	39.9975	40.0025	26256.0
2017-09-13 07:55:00	AAPL	Stock	40.0025	40.0475	40.0	40.02	36252.0
2017-09-13 08:00:00	AAPL	Stock	39.9375	40.095	39.925	40.04	216236.0
2017-09-13 08:05:00	AAPL	Stock	40.05	40.0575	40.0325	40.0425	59572.0
2017-09-13 08:10:00	AAPL	Stock	40.05	40.0675	40.045	40.055	26256.0
2017-09-13 08:15:00	AAPL	Stock	40.055	40.0875	40.045	40.075	27380.0
2017-09-13 08:20:00	AAPL	Stock	40.085	40.1	40.075	40.08	55668.0
2017-09-13 08:25:00	AAPL	Stock	40.08	40.0875	40.05	40.07	80436.0

> showing 50 of 354,517 rows — these rows as CSV

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