PREVIEW / stock_5min / 2018-02-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-02-09.parquet
  size:    6.1 MB
  rows:    387,543
  symbols: 2,906

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-02-09 04:00:00	AAPL	Stock	39.1275	39.185	39.1275	39.185	14400.0
2018-02-09 04:05:00	AAPL	Stock	39.185	39.185	39.185	39.185	400.0
2018-02-09 04:10:00	AAPL	Stock	39.185	39.225	39.185	39.2125	25500.0
2018-02-09 04:30:00	AAPL	Stock	39.1225	39.1225	39.07	39.07	3992.0
2018-02-09 04:40:00	AAPL	Stock	39.105	39.1175	39.0975	39.1175	4384.0
2018-02-09 05:10:00	AAPL	Stock	39.1025	39.1025	39.0025	39.0025	8628.0
2018-02-09 05:35:00	AAPL	Stock	39.1175	39.2125	39.1175	39.2125	22000.0
2018-02-09 05:40:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	800.0
2018-02-09 05:50:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2018-02-09 05:55:00	AAPL	Stock	39.175	39.175	39.1675	39.1675	4000.0
2018-02-09 06:00:00	AAPL	Stock	39.1675	39.1675	39.1	39.1	8800.0
2018-02-09 06:05:00	AAPL	Stock	39.0975	39.0975	39.0625	39.0625	800.0
2018-02-09 06:10:00	AAPL	Stock	39.08	39.08	39.08	39.08	400.0
2018-02-09 06:15:00	AAPL	Stock	39.0725	39.075	39.0725	39.0725	8152.0
2018-02-09 06:20:00	AAPL	Stock	39.0725	39.0725	39.0	39.0025	19560.0
2018-02-09 06:25:00	AAPL	Stock	39.0475	39.0475	38.9825	38.9825	16868.0
2018-02-09 06:30:00	AAPL	Stock	38.9825	39.06	38.965	39.0	10056.0
2018-02-09 06:35:00	AAPL	Stock	38.98	39.0	38.965	38.9875	14152.0
2018-02-09 06:40:00	AAPL	Stock	38.9575	39.0	38.8825	38.9625	31316.0
2018-02-09 06:45:00	AAPL	Stock	38.9575	38.9975	38.8875	38.8925	24632.0
2018-02-09 06:50:00	AAPL	Stock	38.925	38.96	38.925	38.96	13400.0
2018-02-09 06:55:00	AAPL	Stock	38.935	39.025	38.93	39.025	7428.0
2018-02-09 07:00:00	AAPL	Stock	39.03	39.1025	39.025	39.08	30420.0
2018-02-09 07:05:00	AAPL	Stock	39.05	39.075	39.0175	39.0175	14648.0
2018-02-09 07:10:00	AAPL	Stock	39.0175	39.05	39.0	39.0	55152.0
2018-02-09 07:15:00	AAPL	Stock	39.0	39.0	38.9	38.98	20352.0
2018-02-09 07:20:00	AAPL	Stock	38.9725	39.02	38.9625	38.975	16208.0
2018-02-09 07:25:00	AAPL	Stock	38.9375	38.95	38.8625	38.8625	18336.0
2018-02-09 07:30:00	AAPL	Stock	38.8675	38.8725	38.8375	38.8725	9560.0
2018-02-09 07:35:00	AAPL	Stock	38.9125	38.93	38.9125	38.9125	10188.0
2018-02-09 07:40:00	AAPL	Stock	38.9125	38.9125	38.8325	38.85	16768.0
2018-02-09 07:45:00	AAPL	Stock	38.8725	38.9825	38.8625	38.9825	17280.0
2018-02-09 07:50:00	AAPL	Stock	38.975	38.975	38.9	38.9375	10520.0
2018-02-09 07:55:00	AAPL	Stock	38.93	38.9375	38.85	38.86	21696.0
2018-02-09 08:00:00	AAPL	Stock	38.885	39.1	38.8525	38.975	73076.0
2018-02-09 08:05:00	AAPL	Stock	38.9575	39.0	38.95	39.0	34788.0
2018-02-09 08:10:00	AAPL	Stock	39.025	39.0475	39.015	39.0225	22984.0
2018-02-09 08:15:00	AAPL	Stock	39.0375	39.05	38.9775	39.0125	37384.0
2018-02-09 08:20:00	AAPL	Stock	39.005	39.0375	39.0	39.0	31232.0
2018-02-09 08:25:00	AAPL	Stock	39.0025	39.0625	39.0	39.0625	26968.0
2018-02-09 08:30:00	AAPL	Stock	39.0625	39.0875	39.03	39.0725	70472.0
2018-02-09 08:35:00	AAPL	Stock	39.0725	39.215	39.0725	39.19	33884.0
2018-02-09 08:40:00	AAPL	Stock	39.19	39.2125	39.085	39.1225	108648.0
2018-02-09 08:45:00	AAPL	Stock	39.1175	39.1975	39.1125	39.1975	17716.0
2018-02-09 08:50:00	AAPL	Stock	39.2	39.2225	39.14	39.2225	34140.0
2018-02-09 08:55:00	AAPL	Stock	39.21	39.2925	39.175	39.25	81696.0
2018-02-09 09:00:00	AAPL	Stock	39.2525	39.275	39.14	39.2625	84236.0
2018-02-09 09:05:00	AAPL	Stock	39.2625	39.3	39.2	39.29	40092.0
2018-02-09 09:10:00	AAPL	Stock	39.2975	39.35	39.2975	39.3225	55468.0
2018-02-09 09:15:00	AAPL	Stock	39.325	39.3425	39.25	39.25	93996.0

> showing 50 of 387,543 rows — these rows as CSV

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